How To Set Up A Load-Balanced MySQL Cluster - Page 4

5 How To Restart The Cluster

Now let's asume you want to restart the MySQL cluster, for example because you have changed /var/lib/mysql-cluster/config.ini on or for some other reason. To do this, you use the ndb_mgm cluster management client on


On the ndb_mgm console, you type


You will then see something like this:

ndb_mgm> shutdown;
Node 3: Cluster shutdown initiated
Node 2: Node shutdown completed.
2 NDB Cluster node(s) have shutdown.
NDB Cluster management server shutdown.

This means that the cluster nodes and and also the cluster management server have shut down.



to leave the ndb_mgm console.

To start the cluster management server, do this on

ndb_mgmd -f /var/lib/mysql-cluster/config.ini

and on and you run /


or, if you have changed /var/lib/mysql-cluster/config.ini on

ndbd --initial

Afterwards, you can check on if the cluster has restarted:


On the ndb_mgm console, type


to see the current status of the cluster. It might take a few seconds after a restart until all nodes are reported as connected.



to leave the ndb_mgm console.

Falko Timme

About Falko Timme

Falko Timme is an experienced Linux administrator and founder of Timme Hosting, a leading nginx business hosting company in Germany. He is one of the most active authors on HowtoForge since 2005 and one of the core developers of ISPConfig since 2000. He has also contributed to the O'Reilly book "Linux System Administration".

Share this page:

Suggested articles

0 Comment(s)

Add comment


By: Falko Timme