Thanks John,
This does shed some light to my problem and give a better understanding of the --initial
option.
Best regards
-----Oprindelig meddelelse-----
Fra: Johan Andersson [mailto:johan@stripped]
Sendt: 1. december 2010 07:57
Til: Peter Sørensen
Cc: cluster@stripped
Emne: Re: Question concerning ndbd --initial
Hi,
Here is the procedure in the ref manual for what you want to do:
http://dev.mysql.com/doc/refman/5.0/en/mysql-cluster-rolling-restart.html
Some config changes (redo log, datadir) requires that you restart the data node with
--initial.
If you run the --initial on one data node at the time you are safe, it will only clears
its local filesystem to recreate redo log files e.g
if you run --initial on all data nodes at the same time, you will clear the data.
BR
johan
1 dec 2010 kl. 07.26 skrev Peter Sørensen:
> 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
>
> --
> MySQL Cluster Mailing List
> For list archives: http://lists.mysql.com/cluster
> To unsubscribe: http://lists.mysql.com/cluster?unsub=1
>
>
