Use pt-online-schema-change.

Best regards
GL

Le mar. 14 mars 2017 à 08:35, Suresh Rajagopal <sureshr7@gmail.com> a écrit :
Hi,

What is the fastest approach to partition a huge table with 2 additional columns? How safe its to alter table on slave and promote slave as master? It takes 25 hours to alter the table for now on slave.

MariaDB Version : 10.1.18
OS              : Centos 6

Thanks
Suresh
_______________________________________________
Mailing list: https://launchpad.net/~maria-discuss
Post to     : maria-discuss@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria-discuss
More help   : https://help.launchpad.net/ListHelp