I have a mysql cluster consisting of the management node, two data nodes, and a mysql node. The two data nodes connect to the manager but when I try to connect the mysql node I get the following error:
ERROR -- Failed to allocate nodeid, error: 'Error: Could not alloc node id at 10.0.40.119 port 1186: Connection done from wrong host ip 10.0.40.115.'
I attempted to specify the mysql node's ip in the management config.ini under [mysqld] and got the same error. Below are the contents of the current 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
[tcp default]
# TCP/IP options:
[ndb_mgmd]
# Management process options:
hostname=10.0.40.119 # Hostname or IP address of MGM node
datadir=/var/lib/mysql-cluster # Directory for MGM node log files
NodeId=1
[ndbd]
# Options for data node-1:
# (one [ndbd] section per data node)
hostname=10.0.40.105 # Hostname or IP address
datadir=/usr/local/mysql/data # Directory for this data node's data files
NodeId=2
[ndbd]
# Options for data node-2:
hostname=10.0.40.100 # Hostname or IP address
datadir=/usr/local/mysql/data # Directory for this data node's data files
NodeId=3
#one [mysqld] per storage node
[mysqld]
[mysqld]