MySQL Forums
Forum List  »  NDB clusters

Could not determine which nodeid to use for this node
Posted by: d g
Date: June 01, 2016 05:05AM

Hi guys,

I got a problem with my mysql cluster Setup with 2 Management Nodes.

here my config.ini:

[ndbd default]
NoOfReplicas=2
DataMemory=12000M
IndexMemory=1024M
#DiskPageBufferMemory=1000M
NoOfFragmentLogFiles=32
FragmentLogFileSize=64M
MaxNoOfExecutionThreads=4
MaxDiskWriteSpeed=1000M
MinDiskWriteSpeed=100M
MaxNoOfConcurrentOperations=100000
RedoBuffer=32M
LockPagesInMainMemory=1
ODirect=1
datadir=/var/lib/mysql-cluster

[tcp default]
portnumber=2202
SendBufferMemory=2M
ReceiveBufferMemory=2M

[ndb_mgmd]
NodeId=1
hostname=192.168.0.19
datadir=/var/lib/mysql-cluster

[ndb_mgmd]
NodeId=2
hostname=192.168.0.20
datadir=/var/lib/mysql-cluster

[ndbd]
NodeId=10
hostname=192.168.0.17

[ndbd]
NodeId=11
hostname=192.168.0.18

[mysqld]
NodeId=20
hostname=192.168.0.17

[mysqld]
NodeId=21
hostname=192.168.0.18


If i try to start a management node i get the following error:
# ndb_mgmd -f /etc/my.cnf.d/config.ini --initial -vvvvv
MySQL Cluster Management Server mysql-5.6.29 ndb-7.4.11
2016-06-01 13:02:27 [MgmtSrvr] DEBUG -- Not alone on host 192.168.0.20, node 2 will also run here
2016-06-01 13:02:27 [MgmtSrvr] ERROR -- Could not determine which nodeid to use for this node. Specify it with --ndb-nodeid=<nodeid> on command line

if delete the management node section with id2 on node 1 and rhe section with id1 on node 2 bot node come up but ndb_mgm show shows only the mangement node.
from which i execute ndb_mgmcommand.

Regards
Denny

Options: ReplyQuote


Subject
Views
Written By
Posted
Could not determine which nodeid to use for this node
7632
d g
June 01, 2016 05:05AM


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.