mysqlbckrvry_ndbclstr [My wiki]

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
=====Overview=====
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:


  * [[mysqlndbInst|MySQL NDB Installation]]
  * [[mysqlndbmngm|MySQL NDB Cluster Management]]


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:

=====Online backup=====
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.

<sxh bash>
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>
</sxh>

The location of the backup is specified in the backupdaradir parameter, specified in the management node configuration file:

<sxh bash>
[root@mysqlndbmgm ~]# cat /var/lib/mysql-cluster/config.ini | grep Backup
BackupDataDir=/var/lib/mysql-cluster/
[root@mysqlndbmgm ~]#
</sxh>

=====Restore=====
To be done


https://sites.google.com/site/kjalleda/mysqlclusterbackupandrestore