Documentation Home
MySQL Cluster Manager 8.0 User Manual
Related Documentation Download this Manual
PDF (US Ltr) - 1.3Mb
PDF (A4) - 1.3Mb


MySQL Cluster Manager 8.0 User Manual  /  ...  /  Basic MySQL NDB Cluster Backup and Restore Using MySQL Cluster Manager

4.6.2 Basic MySQL NDB Cluster Backup and Restore Using MySQL Cluster Manager

This section describes backing up and restoring a MySQL NDB Cluster, with examples of complete and partial restore operations. Note that the backup cluster and restore cluster commands work with NDB tables only; tables using other MySQL storage engines (such as InnoDB or MyISAM) are ignored.

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

Press CTRL+C to copy
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 of mycluster using the list backups command, as shown here:

Press CTRL+C to copy
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)