MySQL Forums
Forum List  »  NDB clusters

Cluster doesn't work with more than 1 node..
Posted by: Leandro leo
Date: June 16, 2014 09:03AM

I'm trying to start a new cluster with 2 single nodes.. ndb_mgmd server starts normally, ndbd connections from 2 nodes starts normally too, but when I try to start mysqld engine I can't..
Looking into ndb_1_cluster.log, I see the error:

2014-06-16 11:40:59 [MgmtSrvr] WARNING -- Failed to allocate nodeid for API at 10.0.0.3. Returned error: 'No free node id found for mysqld(API).'
2014-06-16 11:40:59 [MgmtSrvr] WARNING -- Failed to allocate nodeid for API at 10.0.0.2. Returned error: 'No free node id found for mysqld(API).'

Configs:

ndb_mgmd -V
MySQL Cluster Management Server mysql-5.6.17 ndb-7.3.5
MySQL distrib mysql-5.6.17 ndb-7.3.5, for Linux (x86_64)


cat cluster.ini
[NDBD DEFAULT]
NoOfReplicas=2

[MYSQLD DEFAULT]

[NDB_MGMD DEFAULT]

[TCP DEFAULT]
# Managment Server

[NDB_MGMD]
NodeId=1
HostName=10.0.0.1

[NDBD]
NodeId=2
HostName=10.0.0.2
DataDir=/data/mysql

[NDBD]
NodeId=3
HostName=10.0.0.3
DataDir=/data/mysql

[MYSQLD]
[MYSQLD]
[MYSQLD]
[MYSQLD]
[MYSQLD]
[MYSQLD]
[MYSQLD]
[MYSQLD]
[MYSQLD]
[MYSQLD]


ndb_mgm --e show
Warning: Using unique option prefix e instead of execute is deprecated and will be removed in a future release. Please use the full name instead.
Connected to Management Server at: localhost:1186
Cluster Configuration
---------------------
[ndbd(NDB)] 2 node(s)
id=2 @10.0.0.2 (mysql-5.6.17 ndb-7.3.5, starting, Nodegroup: 0)
id=3 @10.0.0.3 (mysql-5.6.17 ndb-7.3.5, starting, Nodegroup: 0)

[ndb_mgmd(MGM)] 1 node(s)
id=1 @10.0.0.1 (mysql-5.6.17 ndb-7.3.5)

[mysqld(API)] 10 node(s)
id=4 (not connected, accepting connect from any host)
id=5 (not connected, accepting connect from any host)
id=6 (not connected, accepting connect from any host)
id=7 (not connected, accepting connect from any host)
id=8 (not connected, accepting connect from any host)
id=9 (not connected, accepting connect from any host)
id=10 (not connected, accepting connect from any host)
id=11 (not connected, accepting connect from any host)
id=12 (not connected, accepting connect from any host)
id=13 (not connected, accepting connect from any host)


cat /etc/my.cnf (FROM 2 NODES)

[mysqld]
ndbcluster
ndb-connectstring=10.0.0.1

[mysql_cluster]
ndb-connectstring=10.0.0.1

Options: ReplyQuote


Subject
Views
Written By
Posted
Cluster doesn't work with more than 1 node..
1875
June 16, 2014 09:03AM


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.