MySQL Cluster Manager 9.1 User Manual  /  ...  /  Importing a Cluster Into MySQL Cluster Manager: Example

4.5.2 Importing a Cluster Into MySQL Cluster Manager: Example

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:

Press CTRL+C to copy
[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.