MySQL Cluster Manager 8.0 Release Notes
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 copymcm> 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 copymcm> 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)