16.3.6. Safe Shutdown and Restart
To shut down the cluster, enter the following command in a shell
on the machine hosting the MGM node:
shell> ndb_mgm -e shutdown
The -e option here is used to pass a command to
the ndb_mgm client from the shell. See
Section 4.3.1, “Using Options on the Command Line”. The command causes the
ndb_mgm, ndb_mgmd, and any
ndbd processes to terminate gracefully. Any
SQL nodes can be terminated using mysqladmin
shutdown and other means.
To restart the cluster, run these commands:
-
On the management host (192.168.0.10 in
our example setup):
shell> ndb_mgmd -f /var/lib/mysql-cluster/config.ini
-
On each of the data node hosts
(192.168.0.30 and
192.168.0.40):
shell> ndbd
Remember not to invoke this command
with the --initial option when restarting
an NDBD node normally.
-
On the SQL host (192.168.0.20):
shell> mysqld &
For information on making Cluster backups, see
Section 16.6.5.2, “Using The Management Server to Create a Backup”.
To restore the cluster from backup requires the use of the
ndb_restore command. This is covered in
Section 16.6.5.3, “How to Restore a Cluster Backup”.
More information on configuring MySQL Cluster can be found in
Section 16.4, “MySQL Cluster Configuration”.
