maria-discuss team mailing list archive

[Peter Mclarty <peter.mclarty@xxxxxxxxxxxxxxxxxxxxxxx>]

Hi All
Running Mariadb 10.0.16 and need to add a timestamp column to a table with
has around 60m rows

Testing on lesser hardware instances suggest around 40 minutes to make this
change on the production system.

To reduce the down time I was planning to alter the slave and role swap the
slave to become the master

I have added the column to a test slave and notice it alway populates as
Unix_epoch 0 ie no current timestamp
date           |  timestamp
2016-01-29 | 0000-00-00 00:00:00

This sounds about right, but to confirm it's not a bug.


Other than the timestamp value not being correct up to that time of making
any changes, which is acceptable for why it is being added, like the role
swap, is there any things to be concerned about if I follow that as an
approach? The role swap was needing to be done soon anyway so that in
itself isn't a stumpling block

I know Percona has their tools that allow online schema changes, I have
never used it in anger to achieve this sort of change. Would I be better
off using that.

Cheers


-- 
*Peter McLarty*
* DBA*

-- 


Compare The Market is a brand and trading name of Compare The Market (Pty) Ltd (CTM). This email is for the intended addressee and is confidential and subject to copyright.
If you are not the intended addressee, confidentiality has not been waived and any use, interference with, or disclosure of this email is unauthorised. 
If you are not the intended addressee please immediately notify CTM and then delete the email. CTM does not warrant that this email is error or virus free.