Hi,
I have found the following procedure to handle a change in the cluster configuration file:
-------------------------------------------------------
5 How To Restart The Cluster
Now let's asume you want to restart the MySQL cluster, for example because you have
changed /etc/mysql/ndb_mgmd.cnf on mxdb-mgr.sdu.dk or for some other reason. To do this,
you use the ndb_mgm cluster management client on mxdb-mgr.sdu.dk:
mxdb-mgr.sdu.dk:
# ndb_mgm
On the ndb_mgm console, you type shutdown;
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.
ndb_mgm>
This means that the cluster data nodes mxdb1.sdu.dk and mxdb2.sdu.dk and also the cluster
management server have shut down.
Type quit;
to leave the ndb_mgm console.
To start the cluster management server, do this on mxdb-mgr.sdu.dk:
mxdb-mgr.sdu.dk:
# rm /usr/mysql-cluster/ndb_1_config.bin.1 (nessacary to remove the cached config file)
# service mysql-ndb-mgm start
and on mxdb1.sdu.dk and mxdb2.sdu.dk you can run
mxdb1.sdu.dk / mxdb2.sdu.dk:
ndbd
or, if you have changed /etc/mysql/ndb_mgmd.cnf on mxdb-mgr.sdu.dk:
ndbd --initial
Afterwards, you can check on mxdb-mgr.sdu.dk if the cluster has restarted:
mxdb-mgr.sdu.dk:
# ndb_mgm
On the ndb_mgm console, type
show;
to see the current status of the cluster. It might take a few seconds after a restart
until all nodes are reported as connected.
Type quit;
to leave the ndb_mgm console.
-----------------------------------------------------------------------------------
I am uncertain on the ndbd --initial . Won't that reset all my clustered data ??
Regards
Peter Sørensen/Univ. of Southern Denmark/email: maspsr@stripped
