Re: How add other storage nodes? - Robert Heinzmann - com.mysql.lists.cluster

4 messages in com.mysql.lists.clusterRe: How add other storage nodes?

From	Sent On	Attachments
Fabricio Silva	16 Oct 2004 14:12
Robert Heinzmann	17 Oct 2004 09:35
Fabricio Silva	17 Oct 2004 09:54
Robert Heinzmann	17 Oct 2004 10:31

Subject:	Re: How add other storage nodes?
From:	Robert Heinzmann (Robe...@gmx.net)
Date:	10/17/2004 09:35:36 AM
List:	com.mysql.lists.cluster

Hello Fabricio,

I think first of all you have to configure the cluster management node that it accepts 2 Database nodes.

Simply add another [NDBD] entry to the config.ini.

After that you probably have to reconfigure the cluster. Just run "ndbd --initial --connect-string=MANAGEMENT_NODE:2200" on both database nodes. (Is that right? i'm not shure here, but I read that reconfiguring the cluster requires backup / restore procedure).

Important: This deletes all you current database content !

Remember: If you don't change the "NoOfReplicas" parameter you have no high availability.

Bye,

Robert Heinzmann

p.s. @ list : please correct me if I'm wrong :)

Fabricio Silva wrote:

Hello everybody,

I installed a MySQL cluster with one management one storage node and one mysql server on a single computer. I started my ndb_mgmd process ok, then I started my ndbd and my mysqld_safe process without problems too. Well, I created a config.ini file showed below:

[NDBD DEFAULT] NoOfReplicas: 1

[MYSQLD DEFAULT] [NDB_MGMD DEFAULT] [TCP DEFAULT]

[NDB_MGMD] HostName = host01.myDomain

[NDBD] HostName = host01.myDomain DataDir: /var/lib/mysql-cluster/

[MYSQLD] [MYSQLD] [MYSQLD]

And my "cluster" worked all ok!!

Now, I would like to know what I have to do to execute other storage nodes?? What files I have to configure to the new storage nodes come in in this cluster???

Thanks!!!