3.5.2 Importing a Cluster Into MySQL Cluster Manager: Example

3.5.2.1 Creating and Configuring the Target Cluster
3.5.2.2 Preparing the Standalone Cluster for Migration
3.5.2.3 Verify All Cluster Process PID Files
3.5.2.4 Testing and Migrating the Standalone Cluster

As discussed previously (see Section 3.5.1, “Importing a Cluster Into MySQL Cluster Manager: Basic Procedure”), importing a standalone or wild cluster that was created without the use of MySQL Cluster Manager into the manager requires the completion of four major tasks: create a cluster in MySQL Cluster Manager and update its configuration such that this matches that of the wild cluster; prepare the wild cluster for MySQL Cluster Manager control; verify all PID files for cluster processes; and performing a dry run and then the actual import using the import cluster command. The example provided over the next few sections shows all steps required to perform the importation of a small, standalone MySQL Cluster into MySQL Cluster Manager.

Sample cluster used in example.  The wild cluster used in this example consists of four nodes—one management node, one SQL node, and two data nodes running ndbd. Each of these nodes resides on one of four hosts, all of which are running a recent server release of a typical Linux distribution. The host names for each of these hosts is shown in the following table:

Node type (executable)Host name
Management node (ndb_mgmd)alpha
Data node (ndbd)beta
Data node (ndbd)gamma
SQL node (mysqld)delta

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

[ndbd default]
DataMemory= 16G
IndexMemory= 12G
NoOfReplicas= 2

[ndb_mgmd]
HostName=alpha
NodeId=50

[ndbd]
NodeId=5
HostName=beta
DataDir=/var/lib/mysql-cluster

[ndbd]
NodeId=6
HostName=gamma
DataDir=/var/lib/mysql-cluster

[mysqld]
NodeId=100
HostName=delta

[ndbapi]
NodeId=101

The objective for this example is to bring this cluster, including all of its processes and data, under MySQL Cluster Manager control. Note that this configuration also provides for a free SQL node or NDB API application not bound to any particular host; we account for this in the example.