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: Lars Holmström
Date: July 11, 2017 03:31AM

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.

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
36
July 11, 2017 03:31AM


Sorry, only registered users may post in this forum.

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.