大家好,我在使用3台服务器搭建集群的时候遇到了一个问题
服务器如下
10.5.24.215 管理端
10.5.24.216 数据节点1/sql节点1
10.5.24.217 数据节点2/sql节点2
配置文件config.ini如下
[ndbd default]
NoOfReplicas=2
DataMemory=80M
IndexMemory=18M
[ndb_mgmd]
NodeId=1
hostname=10.5.24.215
datadir=/home/mysql/server
[ndbd]
NodeId=2
hostname=10.5.24.216
datadir=/home/mysql/server/data
[ndbd]
NodeId=3
hostname=10.5.24.217
datadir=/home/mysql/server/data
[MYSQLD]
[MYSQLD]
show内容如下:
ndb_mgm> show
Cluster Configuration
---------------------
[ndbd(NDB)] 2 node(s)
id=2 @10.5.24.216 (mysql-5.5.29 ndb-7.2.10, starting, Nodegroup: 0)
id=3 @10.5.24.217 (mysql-5.5.29 ndb-7.2.10, starting, Nodegroup: 0)
[ndb_mgmd(MGM)] 1 node(s)
id=1 @10.5.24.215 (mysql-5.5.29 ndb-7.2.10)
[mysqld(API)] 2 node(s)
id=4 (not connected, accepting connect from any host)
id=5 (not connected, accepting connect from any host)
日志中均有大量的警告错误,内容如下
2013-03-04 14:58:56 [MgmtSrvr] WARNING -- Failed to allocate nodeid for API at 10.5.24.217. Returned eror: 'No free node id found for mysqld(API).'
my.conf内容如下127
[client]
socket=/home/mysql/server/sock/mysql.sock
[mysqld]
ndbcluster
datadir=/home/mysql/server/data
socket=/home/mysql/server/sock/mysql.sock
ndb-connectstring=10.5.24.215
old_passwords=1
[mysql_cluster]
ndb-connectstring=10.5.24.215
请问有人知道是怎么回事么?
2013年3月05日 10:56