API node unable toconnect to the cluster

[viju padman]

After setting up MYSQL cluster on three servers(Management Node on 10.5.254.97, DB and API node on 10.5.254.96, DB and API node on 10.5.254.99),
I get the following message when running the show command:

ndb_mgm> show
Cluster Configuration
---------------------
[ndbd(NDB)] 2 node(s)
id=2 @10.5.254.99 (Version: 4.1.8, Nodegroup: 0, Master)
id=3 @10.5.254.96 (Version: 4.1.8, Nodegroup: 0)

[ndb_mgmd(MGM)] 1 node(s)
id=1 @10.5.254.97 (Version: 4.1.8)

[mysqld(API)] 2 node(s)
id=4 (not connected, accepting connect from any host)
id=5 (not connected, accepting connect from any host)

Why are the mysqld API nodes unable to connect to the cluster ?


Here are the contents of config.ini

[NDBD DEFAULT]
NoOfReplicas=2
[MYSQLD DEFAULT]
[NDB_MGMD DEFAULT]
[TCP DEFAULT]
# Managment Server
[NDB_MGMD]
HostName=10.5.254.97 # the IP of THIS SERVER
# Storage Engines
[NDBD]
HostName=10.5.254.99 # the IP of the FIRST SERVER
DataDir= /var/lib/mysql-cluster
[NDBD]
HostName=10.5.254.96 # the IP of the SECOND SERVER
DataDir=/var/lib/mysql-cluster
# 2 MySQL Clients
# I personally leave this blank to allow rapid changes of the mysql clients;
# you can enter the hostnames of the above two servers here. I suggest you dont.
[MYSQLD]
[MYSQLD]