Online Backup of NDB Cluster The data nodes to be brought online at a later time (nodes 3 and 4) can be configured with  NodeGroup = 65536 , in which case nodes 1 and 2 can each be started as shown here: shell>  ndbd -c 198.51.100.10 --initial The data nodes configured with  NodeGroup = 65536  are treated by the management server as though you had started nodes 1 and 2 using  --nowait-nodes=3,4  after waiting for a period of time determined by the setting for the  StartNoNodeGroupTimeout  data node configuration parameter. By default, this is 15 seconds (15000 milliseconds). StartNoNodegroupTimeout  must be the same for all data nodes in the cluster; for this reason, you should always set it in the  [ndbd default]  section of the config.ini  file, rather than for individual data nodes. When you are ready to add the second node group, you need only perform the following additional steps: ndb_mgm>  CREATE NODEGROUP 3,4 The next few sections describe how to prepare for and then to create an NDB Cluster backup using the functionality for this purpose found in the  ndb_mgm  management client. To distinguish this type of backup from a backup made using  mysqldump , we sometimes refer to it as a “native”  NDB Cluster backup. (For information about the creation of backups with  mysqldump , see Section 4.5.4, “mysqldump — A Database Backup Program” .) Restoration of NDB Cluster backups is done using the  ndb_restore  utility provided 4490 23.5.8 Online Backup of NDB Cluster Note 1. Start data nodes 3 and 4, invoking the data node process once for each new node: 2. Issue the appropriate  CREATE NODEGROUP  command in the management client: 3. In the  mysql  client, issue  ALTER TABLE ... REORGANIZE PARTITION  and  OPTIMIZE TABLE statements for each existing  NDBCLUSTER  table. (As noted elsewhere in this section, existing NDB Cluster tables cannot use the new nodes for data distribution until this has been done.) shell>  ndbd -c 198.51.100.10 --initial Id = 2 HostName = 198.51.100.2 [ndbd] Id = 3 HostName = 198.51.100.3 Nodegroup = 65536 [ndbd] Id = 4 HostName = 198.51.100.4 Nodegroup = 65536 [mgm] HostName = 198.51.100.10 Id = 10 [api] Id=20 HostName = 198.51.100.20 [api] Id=21 HostName = 198.51.100.21