I'm trying to set up two management nodes. My set-up is like this:

2x Application Servers (running JBoss and Apache/PHP, loadbalanced by
Ultramonkey/LVS) These servers have a mysqld process running on each (so the apps access them via
localhost) and now an ndb_mgmd process on each

2x storage nodes

when I do an 'show' in ndb_mgm, it looks like this:

Cluster Configuration

--------------------- [ndbd(NDB)] 2 node(s) id=2 @192.168.50.6 (Version: 4.1.10, Nodegroup: 0, Master) id=3 @192.168.50.7 (Version: 4.1.10, Nodegroup: 0)

[ndb_mgmd(MGM)] 2 node(s) id=1 @192.168.50.5 (Version: 4.1.10) id=8 @192.168.50.5 (Version: 4.1.10)

[mysqld(API)] 4 node(s) id=4 @192.168.50.4 (Version: 4.1.10) id=5 @192.168.50.5 (Version: 4.1.10)

The bit that's confusing me, is that the two MGM nodes appear as both being the
one on the second application server (192.168.50.5). Even when I only start ndb_mgmd on the first
application server (192.168.50.4), it appears as coming from 50.5

My config.ini looks like this:

[NDBD DEFAULT] NoOfReplicas= 2

[MYSQLD DEFAULT]

[NDB_MGMD DEFAULT]

[TCP DEFAULT]

# Management Server [NDB_MGMD] Id=1 HostName=192.168.50.4 DataDir= /var/lib/mysql-cluster

#Backup Management Server [NDB_MGMD] Id=8 HostName=192.168.50.5 DataDir= /var/lib/mysql-cluster

.... etc

Is this correct? I have a sneaking suspicion that if the 2nd management node
dissapears, everything is going to stop working... as this is a production setup, i'm a little
reluctant to expirment too much :-)

_________________________________________ http://www.digiweb.co.nz Webhosting, Dedicated Servers, E-commerce Phone: (64 3) 351 6713