Re: Failed to allocate nodeid, error: 'Error: Could not alloc node id at .. : Connection done from wrong host

[Lars Holmström]

I can easily define 4 [ndb] sections. But when I also define 2 SQL/API nodes with identical IP as node 3 and 4 I run in to trouble.

In my particular case I need 2 API/SQL nodes and 2 data nodes. All four need obviously an [ndb] section. But how do you configure a node to have both an [ndb] section but also having a [mysql(API)] section?

The following does not work;
[ndb_mgmd]
HostName=10.215.2.74 # Hostname or IP address of MGM node
NodeId=5
DataDir=/var/lib/mysql-cluster # Directory for MGM node log files

[ndbd]
HostName=10.215.2.70 #
NodeId=1 # Node ID for this data node
DataDir=/usr/local/mysql/data # Directory for this data node's data files

[ndbd]
HostName=10.215.2.71 #
NodeId=2 # Node ID for this data node
DataDir=/usr/local/mysql/data # Directory for this data node's data files

[mysqld]
HostName=10.215.2.72 #
NodeId=6

[mysqld]
HostName=10.215.2.73 #
NodeId=7

[ndbd]
HostName=10.215.2.72 #
NodeId=3

[ndbd]
HostName=10.215.2.73 #
NodeId=4



Edited 2 time(s). Last edit at 07/11/2017 03:33AM by Lars Holmström.