NDB Cluster provides a lot of features and functions in conjunction with the replication. It is on par with Oracle RAC Database or DB2 HADR Configuration. Installation and Configuration of NDB Cluster can be seen below:
Furthermore, NDB Cluster is the only other database, except InnoDB, that can do Online Physical Backup. To Initiate a hot backup, simply run the following command on the management node:
Always do a backup from the management node, since the data nodes hold ONLY the data which they own. If you backup only one data node, YOU WILL NOT HAVE ALL DATA.
ndb_mgm> start backup Waiting for completed, this may take several minutes Node 2: Backup 1 started from node 1 ndb_mgm> Node 2: Backup 1 started from node 1 completed StartGCP: 52803 StopGCP: 52806 #Records: 2070 #LogRecords: 0 Data: 52944 bytes Log: 0 bytes ndb_mgm> ndb_mgm>
The location of the backup is specified in the backupdaradir parameter, specified in the management node configuration file:
[root@mysqlndbmgm ~]# cat /var/lib/mysql-cluster/config.ini | grep Backup BackupDataDir=/var/lib/mysql-cluster/ [root@mysqlndbmgm ~]#