Re: Multiple instances setup in cluster environment ?

[Alex Davies]

Dear Peter,

I don't see the problem with not defining the HostName for the [mysqld] bits. I have the following config.ini working here:

[NDBD DEFAULT]
NoOfReplicas=2
DataDir=/var/lib/mysql-cluster
[NDB_MGMD]
HostName=192.168.254.12
[NDBD]
HostName=192.168.254.13
[NDBD]
HostName=192.168.254.11
[MYSQLD]
[MYSQLD]
[MYSQLD]
[MYSQLD]
[MYSQLD]

What version are you using? What happens if you remove the HostName from [mysqld] and try to start ndb_mgmd? Exactly what error does it throw?

You can see from my setup that it accepts connections from any host:

ndb_mgm> show;
Connected to Management Server at: 192.168.254.12:1186
Cluster Configuration
---------------------
[ndbd(NDB)] 2 node(s)
id=2 @192.168.254.13 (Version: 5.0.11, Nodegroup: 0)
id=3 @192.168.254.11 (Version: 5.0.11, Nodegroup: 0, Master)

[ndb_mgmd(MGM)] 1 node(s)
id=1 @192.168.254.12 (Version: 5.0.11)

[mysqld(API)] 5 node(s)
id=4 (Version: 5.0.11)
id=5 (Version: 5.0.11)
id=6 (Version: 5.0.11)
id=7 (not connected, accepting connect from any host)
id=8 (not connected, accepting connect from any host)

Alex

Alex Davies
http://www.davz.net | [e-mail]