Starting the cluster is not very difficult after it has been
configured. Each cluster node process must be started
separately, and on the host where it resides. Although it is
possible to start the nodes in any order, it is recommended that
the management node be started first, followed by the storage
nodes, and then finally by any SQL nodes:
-
On the management host, issue the following command from the
system shell to start the MGM node process:
shell> ndb_mgmd -f /var/lib/mysql-cluster/config.ini
Note that ndb_mgmd must be told where to
find its configuration file, using the -f
or --config-file option. (See
Section 16.5.3, “ndb_mgmd, the Management Server Process”, for details.)
-
On each of the data node hosts, run this command to start
the ndbd process for the first time:
shell> ndbd --initial
Note that it is very important to use the
--initial parameter
only when starting
ndbd for the first time, or when
restarting after a backup/restore operation or a
configuration change. This is because the
--initial option causes the node to delete
any files created by earlier ndbd
instances that are needed for recovery, including the
recovery log files.
If you used RPM files to install MySQL on the cluster host
where the SQL node is to reside, you can (and should) use
the startup script installed in
/etc/init.d to start the MySQL server
process on the SQL node.
If all has gone well, and the cluster has been set up correctly,
the cluster should now be operational. You can test this by
invoking the ndb_mgm management node client.
The output should look like that shown here, although you might
see some slight differences in the output depending upon the
exact version of MySQL that you are using:
shell> ndb_mgm
-- NDB Cluster -- Management Client --
ndb_mgm> SHOW
Connected to Management Server at: localhost:1186
Cluster Configuration
---------------------
[ndbd(NDB)] 2 node(s)
id=2 @192.168.0.30 (Version: 5.1.7-beta, Nodegroup: 0, Master)
id=3 @192.168.0.40 (Version: 5.1.7-beta, Nodegroup: 0)
[ndb_mgmd(MGM)] 1 node(s)
id=1 @192.168.0.10 (Version: 5.1.7-beta)
[mysqld(SQL)] 1 node(s)
id=4 (Version: 5.1.7-beta)
Note: If you are using an older
version of MySQL, you may see the SQL node referenced as
[mysqld(API)]. This reflects an older usage
that is now deprecated.
You should now be ready to work with databases, tables, and data
in MySQL Cluster. See Section 16.3.5, “Loading Sample Data and Performing Queries”,
for a brief discussion.
