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]