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…
To run mysqldump in the simplest way possible is to ...
Get High Availability MySQL Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
