Re: Clarification on --initial

On 13 Aug 2007, at 21:07, Jon Stephens wrote:

> Wilersh wrote:

..
>> Thanks for the quick and helpful reply Geert. Just one more point.
>> Is it the expected behavior that if I do a full shutdown of my
>> cluster, then restart the nodes with --initial that all my tables
>> and data are gone?
>
> Yes, that's *exactly* what initial does - it clears the cluster
> filesystem on the data node(s).
>
> And my understanding is that you *do* need to use it the very first
> time you start up a new cluster.

Nope, you don't.
It's a very misleading name, we discussed that before. The --initial should never be used except when you think that the NDB filesystem is corrupt and want to resync the data of the node with the still running partner.
However, in that last situation, I would actually move the NDB filesystem away rather than deleting it ( meaning using --initial), for further investigation later.

Geert

-- 
Geert Vanderkelen, Senior Support Engineer
MySQL GmbH, Germany, www.mysql.com





-- 
MySQL Cluster Mailing List
For list archives: 
http://lists.mysql.com/cluster
To unsubscribe:    
http://lists.mysql.com/cluster?unsub=lists@pantek.com