Cluster doesn't work with more than 1 node..
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