Pantek Library
Hosting Provided By
CybrHost
High Speed Hosting

Re: Clarification on --initial

From: Geert Vanderkelen <geert(at)mysql.com>
Date: Tue Aug 14 2007 - 03:55:01 EDT

On 14 Aug 2007, at 08:55, Sebastien LELIEVRE wrote:

> Jon Stephens a écrit :
>> 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.
>>
>
> OR when you bring a brand new data node (as a replacement for a
> crashed
> one for instance) in the cluster

You don't have to use --initial for that either. If the data is not there,
it will either resync from it's partner or make a new empty filesystem automatically.
The '--initial' option is not needed.

I never use it again, except when I want all data gone when testing, because I'm to lazy to delete/move the filesystems myself. This option is way to misleading and dangerous..

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
Received on Tue Aug 14 03:55:12 2007

This archive was generated by hypermail 2.1.8 : Sun Oct 07 2007 - 10:14:58 EDT


Contact Us  Legal Notices  Order Services Online 
Pantek Home  Privacy Policy  IT news  Site Map  Pantek Library