Differences
This shows you the differences between two versions of the page.
|
myisam_to_galera [2012/07/18 18:58] root created |
myisam_to_galera [2012/07/19 09:52] (current) root |
||
|---|---|---|---|
| Line 4: | Line 4: | ||
| - Create a Galera cluster (it may be a single node cluster). | - Create a Galera cluster (it may be a single node cluster). | ||
| - | - Stop all load on the master. | + | - Stop all load on MyISAM master. |
| - | - Initialize the Galera cluster by performing mysqdump with --skip-create-options - then by default it will create InnoDB tables on the cluster. | + | - Initialize the Galera cluster by performing mysqdump with ''--skip-create-options'' - then by default it will create InnoDB tables on the cluster. |
| - | - Resume the load to one of the Galera cluster nodes. | + | - Resume the load to one of the cluster nodes. |
| - Upgrade mysqld on the former master to Galera cluster software (MySQL-wsrep or Percona XtraDB cluster). | - Upgrade mysqld on the former master to Galera cluster software (MySQL-wsrep or Percona XtraDB cluster). | ||
| - Convert the tables to InnoDB on the former master node. | - Convert the tables to InnoDB on the former master node. | ||
| - | - Copy grastate.dat file from one of the cluster nodes, and change seqno from -1 to 0 there. | + | - Copy grastate.dat file from one of the cluster nodes to the former master, and change seqno from -1 to 0 there. |
| - Join the former master to Galera cluster. | - Join the former master to Galera cluster. | ||
| + | |||
| + | The downtime will be the time it takes to perform step 3. | ||
