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

[Mikael Ronström]

Lars Holmström Wrote:
-------------------------------------------------------
> 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

Apart from missing a DataDir definition for NodeId=3
and NodeId=4 it looks ok.

So not sure what isn't working.