Failed to allocate nodeid, error: 'Error: Could not alloc node id at .. : Connection done from wrong host
I intend to build a 5 node cluster but have a slight issue I need assistance to have resolved;
All nodes are running Ubuntu 14.04 and MySQL 5.7.18 ndb 7.5..6
I start my single management node without any problem
Mgmt # ndb_mgm -e show
Connected to Management Server at: localhost:1186
Cluster Configuration
---------------------
[ndbd(NDB)] 2 node(s)
id=1 (not connected, accepting connect from 10.215.2.70)
id=2 (not connected, accepting connect from 10.215.2.71)
[ndb_mgmd(MGM)] 1 node(s)
id=5 @10.215.2.74 (mysql-5.7.18 ndb-7.5.6)
[mysqld(API)] 2 node(s)
id=3 (not connected, accepting connect from 10.215.2.72)
id=4 (not connected, accepting connect from 10.215.2.73)
Mgmt #
Next the two SQL-nodes join nicely
SQL1# sudo ndbd
2017-07-10 10:50:09 [ndbd] INFO -- Angel connected to '10.215.2.74:1186'
2017-07-10 10:50:24 [ndbd] INFO -- Angel allocated nodeid: 1
SQL1#
SQL2# ndb_mgm -e show
Connected to Management Server at: 10.215.2.74:1186
Cluster Configuration
---------------------
[ndbd(NDB)] 2 node(s)
id=1 @10.215.2.70 (mysql-5.7.18 ndb-7.5.6, Nodegroup: 0, *)
id=2 @10.215.2.71 (mysql-5.7.18 ndb-7.5.6, Nodegroup: 0)
[ndb_mgmd(MGM)] 1 node(s)
id=5 @10.215.2.74 (mysql-5.7.18 ndb-7.5.6)
[mysqld(API)] 2 node(s)
id=3 (not connected, accepting connect from 10.215.2.72)
id=4 (not connected, accepting connect from 10.215.2.73)
SQL2#
Issue
-----
But my two remaining does not join.
Data1 # sudo ndbd
2017-07-10 10:54:04 [ndbd] INFO -- Angel connected to '10.215.2.74:1186'
2017-07-10 10:54:04 [ndbd] ERROR -- Failed to allocate nodeid, error: 'Error: Could not alloc node id at 10.215.2.74 port 1186: Connection done from wrong host ip 10.215.2.72.'
Data1 #
Data1 #
Following is my config.ini file that are identical on all 5 nodes
----------------------------------------------------------------
Data1 #
Data1 # cat /var/lib/mysql-cluster/config.ini
[ndbd default]
# Options affecting ndbd processes on all data nodes:
NoOfReplicas=2 # Number of replicas
DataMemory=80M # How much memory to allocate for data storage
IndexMemory=18M # How much memory to allocate for index storage
# For DataMemory and IndexMemory, we have used the
# default values. Since the "world" database takes up
# only about 500KB, this should be more than enough for
# this example NDB Cluster setup.
ServerPort=2202 # This the default value; however, you can use any
# port that is free for all the hosts in the cluster
# Note1: It is recommended that you do not specify the port
# number at all and simply allow the default value to be used
# instead
# Note2: The port was formerly specified using the PortNumber
# TCP parameter; this parameter is no longer available in NDB
# Cluster 7.5.
[ndb_mgmd]
# Management process options:
HostName=10.215.2.74 # Hostname or IP address of MGM node
DataDir=/var/lib/mysql-cluster # Directory for MGM node log files
[ndbd]
# Options for data node "A":
# (one [ndbd] section per data node)
HostName=10.215.2.72 # Hostname or IP address
NodeId=2 # Node ID for this data node
DataDir=/usr/local/mysql/data # Directory for this data node's data files
[ndbd]
# Options for data node "B":
HostName=10.215.2.73 # Hostname or IP address
NodeId=3 # Node ID for this data node
DataDir=/usr/local/mysql/data # Directory for this data node's data files
[mysqld]
# SQL node options:
HostName=10.215.2.70 # Hostname or IP address
# (additional mysqld connections can be
# specified for this node for various
# purposes such as running ndb_restore)
[mysqld]
# SQL node options:
HostName=10.215.2.71 # Hostname or IP address
# (additional mysqld connections can be
# specified for this node for various
# purposes such as running ndb_restore)
[mysqld]
[mysqld]
Data1 #
All assistance is appreciated.