Re: Clarification on --initial

Hi Eric,

On 13 Aug 2007, at 18:01, Wilersh wrote:

> Running MySQL cluster 5.0 on OS X 10.4.
>
> Just wanted a clarification on the function and use of --initial
> when running ndbd. The manual says:
>
> Note that it is very important to use the --initial parameter only
> when starting ndbd for the first time, or when restarting after a
> backup/restore operation or a configuration change. This is because
> the --initial option causes the node to delete any files created by
> earlier ndbd instances that are needed for recovery, including the
> recovery log files.

OK, I think we have to change that text. --initial is NOT important at all at first startup of the cluster. It just makes the bash history having it and it is easy to make errors pushing arrow up!

My rule of thumb: forget it exists!
We should really make work renaming it ones and for all..

> I took "configuration change" to mean a change to the config.ini
> file, but some digging around the forums and list archives seems
> that it may only be referring to configuration changes due to
> hardware additions or subtractions.

Yeah, tricky. But adding a SQL node you might not need to change anything if you have already added some free slots in the configuration too. So adding hardware in that sense is called.. mm.. scale out or something :)

>
> If a make a change to DataMemory or MaxNoOfTables, etc. is a
> rolling restart (not using --inital with ndbd) enough to get those
> kind of changes distributed?

Do you need help?

In addition to our free technical library, Pantek provides professional IT services to companies who utilize Open Source software: Learn more about Pantek's Technical Support offerings Place an order for 24/7/365 Technical Support here Learn more about Pantek, who we are, and what we do Chat with a Live Operator Related lists.mysql.com Links announce benchmarks bugs certification cluster commits dotnet gui-tools internals java maxdb myodbc mysql mysqldoc packagers perl plusplus replication win32 Request more information about Pantek

Yes, not using --initial.

> I was playing with a test setup today and was surprised to find
> that if I shutdown the cluster, then restarted each node with --
> initial my tables and data went missing from my DB. I didn't expect
> that, and still don't see how that is clearly described in the
> manual. Hence this request for clarification.

Glad you played with it ;)
Others did too in production and.. well.. just forget about it! ...

> Glad I was testing things first! ;)

.. And use it when really needed :)

Cheers,

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