content_image/776182.jpg
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 

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). 

<img src='content_image/776182.jpg'>

## Note 

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: 

1. Start data nodes 3 and 4, invoking the data node process once for each new node: 

shell> ndbd -c 198.51.100.10 --initial 

2. Issue the appropriate CREATE NODEGROUP  command in the management client: 

ndb_mgm> CREATE NODEGROUP 3,4 

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.) 

## 23.5.8 Online Backup of NDB Cluster 

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 

