Taking an offline backup with MySQL Cluster
The MySQL client
RPM includes the binary
mysqldump, which produces
SQL statements from a MySQL database. In this recipe, we will explore the usage of this tool with MySQL Clusters.
Taking a backup with
mysqldump for MySQL Cluster (NDB) tables is identical to other table engines and has all of the same disadvantages—most importantly that it requires significant locking to take a consistent backup. However, it is simple, easy to verify, and trivial to restore from and also provides a way to restore the backup from a MySQL Cluster into a standalone server (for example, by using InnoDB) in the case that a cluster is not available for recovery.
How to do it...
mysqldump in the simplest way possible is ...