Migrate from MyISAM to InnoDB + Galera cluster

This howto is applicable to both standalone MySQL server and stock MySQL master-slave cluster using MyISAM storage engine.

  1. Create a Galera cluster (it may be a single node cluster).
  2. Stop all load on MyISAM master.
  3. Initialize the Galera cluster by performing mysqdump with –skip-create-options - then by default it will create InnoDB tables on the cluster.
  4. Resume the load to one of the cluster nodes.
  5. Upgrade mysqld on the former master to Galera cluster software (MySQL-wsrep or Percona XtraDB cluster).
  6. Convert the tables to InnoDB on the former master node.
  7. Copy grastate.dat file from one of the cluster nodes to the former master, and change seqno from -1 to 0 there.
  8. Join the former master to Galera cluster.

The downtime will be the time it takes to perform step 3.

Trace: • myisam_to_galera

Login