0

I have 3 nodes PXC 5.6 master master cluster. I have few tables that are using MyISAM.

Total MyISAM table = 120 Total MyISAM table size = 80MB

I have also read few recommendations where it suggests not to run ALTER command on cluster.

How can I safely convert those tables to InnoDB without risking the cluster?

0

My comments on converting from MyISAM to InnoDB: http://mysql.rjweb.org/doc.php/myisam2innodb

My comments on Galera (PXC): http://mysql.rjweb.org/doc.php/galera

ALTER, on Galera/PXC, comes in two flavors;

⚈  Rolling Schema Upgrade = manually do one node (offline) at a time
⚈  Total Order Isolation = Galera synchronizes so that it is done at same time
     (in the replication sequence) on all nodes.

Further discussion (in addition to the manual, and my doc): http://www.codership.com/wiki/doku.php?id=rolling_schema_upgrade

  • Nice documentation. Can you also please look at my another question? My question here – Ted Khi Dec 20 '18 at 9:29

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.