Re: Does a Cluster restart drop empty tables ? - Geert Vanderkelen - com.mysql.lists.cluster

8 messages in com.mysql.lists.clusterRe: Does a Cluster restart drop empty...

From	Sent On	Attachments
Sebastien LELIEVRE	04 May 2007 02:38
Philipp Taprogge	04 May 2007 02:44
Geert Vanderkelen	04 May 2007 02:46
Sebastien LELIEVRE	04 May 2007 02:55
Geert Vanderkelen	04 May 2007 03:08
Philipp Taprogge	04 May 2007 03:27
Sebastien LELIEVRE	04 May 2007 03:31
Jon Stephens	04 May 2007 07:03

Subject:	Re: Does a Cluster restart drop empty tables ?
From:	Geert Vanderkelen (gee...@mysql.com)
Date:	05/04/2007 03:08:52 AM
List:	com.mysql.lists.cluster

On May 4, 2007, at 11:56, Sebastien LELIEVRE wrote: ..

Moreover, I misread the "official" tutorial (http://dev.mysql.com/tech-resources/articles/mysql-cluster-for-two- servers.html) that said "If you ever change config.ini you must stop the whole cluster and restart it to re-read the config file". I thought only "--initial" parmater made the ndbd re-read the config file.

lol.. oh dear, that is indeed wrong in the article or at least not entirely correct and confusing! Thanks for pointing it out!

When you change for example the number of data nodes, then you will need to do an --initial after making backups so you can reload it. Or you can simply remove the ndb filesystem directories, as this is what --initial basically does.

Oh, I want so to rename that option to --whipe-fs-Trust-me-I-know- what-I-am-doing

Cheers,

Geert