MySQL Forums
Forum List  »  NDB clusters

Re: Failed to allocate nodeid, error: 'Error: Could not alloc node id at .. : Connection done from wrong host
Posted by: Mikael Ronström
Date: July 12, 2017 04:07AM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Failed to allocate nodeid, error: 'Error: Could not alloc node id at .. : Connection done from wrong host
111
July 12, 2017 04:07AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.