4.5.2 Importing a Cluster Into MySQL Cluster Manager: Example

4.5.2.1 Preparing the Standalone Cluster for Migration

4.5.2.2 Verify All Cluster Process PID Files

4.5.2.3 Creating and Configuring the Target Cluster

4.5.2.4 Testing and Migrating the Standalone Cluster

As discussed previously (see Section 4.5.1, “Importing a Cluster Into MySQL Cluster Manager: Basic Procedure”), importing a standalone or “wild” cluster that was not created with MySQL Cluster Manager into the manager requires the completion of four major tasks. The example provided over the next few sections shows all the steps required to perform those tasks.

Sample cluster used in example.  The “wild” cluster used in this example consists of four nodes—one management node, two data nodes, and one SQL node. Each of these nodes resides on one of three hosts, the IP address for each is shown in the following table:

Table 4.4 Nodes in the example cluster

Node type (executable)	Host name
Management node (ndb_mgmd)	198.51.100.102
Data node (ndbd)	198.51.100.103
Data node (ndbd)	198.51.100.104
SQL node (mysqld)	198.51.100.102

We assume that these hosts are on a dedicated network or subnet, and that each of them is running only the MySQL NDB Cluster binaries and applications providing required system and network services. We assume on each host that the MySQL NDB Cluster software has been installed from a release binary archive (see Installing an NDB Cluster Binary Release on Linux). We also assume that management node is using /home/ari/bin/cluster/wild-cluster/config.ini as the cluster's global configuration file, which is shown here:

[ndbd default]
NoOfReplicas= 2

[ndb_mgmd]
HostName= 198.51.100.102
DataDir= /home/ari/bin/cluster/wild-cluster/50/data
NodeId= 50


[ndbd]
HostName= 198.51.100.103
DataDir= /home/ari/bin/cluster/wild-cluster/2/data
NodeId=2

[ndbd]
HostName= 198.51.100.104
DataDir= /home/ari/bin/cluster/wild-cluster/3/data
NodeId=3

[mysqld]
HostName= 198.51.100.102
NodeId= 51

[api]
NodeId= 52

Notice that for the import into MySQL Cluster Manager to be successful, the following must be true for the cluster's configuration:

• NodeID must be explicitly assigned for every node.

• DataDir must be specified for each management and data node, and the data directories for different nodes cannot overlap with each other.

• A “free” API node not bounded to any host must be provisioned, through which the mcmd agent can communicate with the cluster.