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

Want to support HowtoForge? Become a subscriber!
Submitted by falko (Contact Author) (Forums) on Mon, 2006-03-27 11:11. ::

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.

Please do not use the comment function to ask for help! If you need help, please use our forum.
Comments will be published after administrator approval.