From: Andrew Morgan Date: November 30 2010 1:16pm Subject: Re: Question concerning ndbd --initial List-Archive: http://lists.mysql.com/cluster/7903 Message-Id: MIME-Version: 1.0 (iPhone Mail 8C148) Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable Hi Peter, You are correct that using --initial for the data nodes would wipe out your= data. You should restart the ndb_mgmd with --initial but not the data nodes. You c= an also avoid shutting the whole cluster down if you want to. Restart the nd= b_mgmd and when it is back up, restart each of the data nodes in turn (wait f= or one to finish redrafting before moving on to the next). Andrew. On 30 Nov 2010, at 12:55, Peter S=C3=B8rensen wrote: > Hi, >=20 > I have found the following procedure to handle a change in the cluster con= figuration 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 oth= er reason. To do this, you use the ndb_mgm cluster management client on mxdb= -mgr.sdu.dk: > mxdb-mgr.sdu.dk: >=20 > # ndb_mgm > On the ndb_mgm console, you type shutdown;=20 > 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> >=20 > This means that the cluster data nodes mxdb1.sdu.dk and mxdb2.sdu.dk and a= lso the cluster management server have shut down. > Type quit; > to leave the ndb_mgm console.=20 >=20 > 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:=20 > 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=20 > show; > to see the current status of the cluster. It might take a few seconds afte= r a restart until all nodes are reported as connected.=20 > Type quit; > to leave the ndb_mgm console. =20 > --------------------------------------------------------------------------= --------- >=20 > I am uncertain on the ndbd --initial . Won't that reset all my clustered d= ata ?? >=20 > Regards >=20 > Peter S=C3=B8rensen/Univ. of Southern Denmark/email: maspsr@stripped > --=20 > MySQL Cluster Mailing List > For list archives: http://lists.mysql.com/cluster > To unsubscribe: http://lists.mysql.com/cluster?unsub=3Dandrew.morgan@or= acle.com >=20