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.