Movatterモバイル変換

This section describes backing up and restoring a MySQL NDB Cluster, with examples of complete and partial restore operations. Note that thebackup cluster andrestore cluster commands work withNDB tables only; tables using other MySQL storage engines (such asInnoDB orMyISAM) are ignored.

For purposes of example, we use a MySQL NDB Cluster namedmycluster whose processes and status can be seen here:

mcm> show status -r mycluster;+--------+----------+----------+---------+-----------+-----------+| NodeId | Process  | Host     | Status  | Nodegroup | Package   |+--------+----------+----------+---------+-----------+-----------+| 49     | ndb_mgmd | tonfisk  | running |           | mypackage || 1      | ndbd     | tonfisk  | running | 0         | mypackage || 2      | ndbd     | tonfisk  | running | 0         | mypackage || 50     | mysqld   | tonfisk  | running |           | mypackage || 51     | mysqld   | tonfisk  | running |           | mypackage || 52     | ndbapi   | *tonfisk | added   |           |           || 53     | ndbapi   | *tonfisk | added   |           |           |+--------+----------+----------+---------+-----------+-----------+7 rows in set (0.08 sec)

You can see whether there are any existing backups ofmycluster using thelist backups command, as shown here:

mcm> list backups mycluster;+----------+--------+---------+---------------------+-------+---------+| BackupId | NodeId | Host    | Timestamp           | Parts | Comment |+----------+--------+---------+---------------------+-------+---------+| 1        | 1      | tonfisk | 2020-12-04 12:03:52 | 1     |         || 1        | 2      | tonfisk | 2020-12-04 12:03:52 | 1     |         || 2        | 2      | tonfisk | 2020-12-04 12:04:15 | 1     |         || 3        | 1      | tonfisk | 2020-12-04 12:17:41 | 1     |         || 3        | 2      | tonfisk | 2020-12-04 12:17:41 | 1     |         |+----------+--------+---------+---------------------+-------+---------+6 rows in set (0.12 sec)