High Availability MySQL Cookbook

Importing SQL files to a MySQL server and converting them to MySQL Cluster

It will often be required to import data from an SQL file and then convert this freshly installed data to have a storage engine of NDB (MySQL Cluster's storage engine). This may be required for the following reasons:

• Importing mysqldump backup files in the case of a recovery
• Importing data from a non-clustered system into a cluster, for example, a mysqldump from an old system into a new cluster

In this recipe, we will follow an example that uses the world sample dataset provided by MySQL for testing use. We will import it to MySQL, convert it from the default table engine (in our case, MyISAM) to MySQL Cluster (NDBCLUSTER storage engine), and then check that it appears on ...