Bug #30112 Multiple management servers do not list all management servers as connected.
Submitted: 28 Jul 2007 4:35 Modified: 20 Aug 2007 5:13
Reporter: Dylan Redding Email Updates:
Status: Won't fix Impact on me:
None 
Category:MySQL Cluster: Cluster (NDB) storage engine Severity:S3 (Non-critical)
Version:5.0.45, 5.1.20 OS:Linux (RedHat EL4)
Assigned to: CPU Architecture:Any
Tags: ndb_mgmd

[28 Jul 2007 4:35] Dylan Redding
Description:
This is the same bug as reported in closed Bug #13070.

When bringing up management nodes, ndb_mgm will only report that one management node is connected. Upon startup, it will list that only one of the two nodes is connected on both nodes. You can force ndb_mgm to connect to the inactive node, but it will only report that node as connected.

When data nodes connect, ndb_mgm shows all of the management nodes as connected.

According to documentation, this was apparently corrected in 5.0.14 and above. 

Details:

config.ini

[NDBD DEFAULT]

NoOfReplicas=2

[TCP DEFAULT]

[NDB_MGMD]
Id=1
HostName=192.168.0.17
[NDB_MGMD]
Id=2
HostName=192.168.0.18

[NDBD]
Id=3
HostName=192.168.0.19
DataDir= /var/lib/mysql-cluster
[NDBD]
Id=4
HostName=192.168.0.20
DataDir=/var/lib/mysql-cluster

[MYSQLD]
Id=5
HostName=192.168.0.17
[MYSQLD]
Id=6
HostName=192.168.0.18

##############################################################

my.cnf:

[MYSQLD]

ndbcluster

# the IPs of the MANAGMENT SERVERS

ndb-connectstring=192.168.0.17,192.168.0.18

 
[MYSQL_CLUSTER]

# the IPs of the MANAGMENT SERVERS

ndb-connectstring=192.168.0.17,192.168.0.18

 

[MYSQL.SERVER]

user=mysql

[MYSQLD_SAFE]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

##############################################################
##############################################################
Results:

ndb_mgm> show

Cluster Configuration
---------------------
[ndbd(NDB)]     2 node(s)
id=3 (not connected, accepting connect from 192.168.0.19)
id=4 (not connected, accepting connect from 192.168.0.20)

[ndb_mgmd(MGM)] 2 node(s)
id=1    @192.168.0.17  (Version: 5.0.45)
id=2 (not connected, accepting connect from 192.168.0.18)

[mysqld(API)]   2 node(s)
id=5 (not connected, accepting connect from 192.168.0.17)
id=6 (not connected, accepting connect from 192.168.0.18)

##############################################################
ndb_mgm> show

Cluster Configuration
---------------------
[ndbd(NDB)]     2 node(s)
id=3    @192.168.0.19  (Version: 5.0.45, Nodegroup: 0, Master)
id=4    @192.168.0.20  (Version: 5.0.45, Nodegroup: 0)

[ndb_mgmd(MGM)] 2 node(s)
id=1    @192.168.0.17  (Version: 5.0.45)
id=2    @192.168.0.18  (Version: 5.0.45)

[mysqld(API)]   2 node(s)
id=5 (not connected, accepting connect from 192.168.0.17)
id=6 (not connected, accepting connect from 192.168.0.18)

How to repeat:
Start cluster management nodes without starting data nodes.
[20 Aug 2007 5:13] Stewart Smith
by design/won't fix for a long time yet.