谁在或做过mysql cluster NDB 7.2集群？

ifeelstupid · 发表于 2013-1-18 08:53

mchdba 发表于 2013-1-17 23:29
帖一下你的config.ini配置，大家再帮你看看。

sql节点加了如下配置：
[mysql_cluster]
# Options for ndbd process:
ndb-connectstring=192.168.1.10
# Here follows entries for some specific programs

# The MySQL server
[mysqld]
ndb-connectstring=192.168.1.10
ndbcluster

mchdba · 发表于 2013-1-18 10:26

ifeelstupid 发表于 2013-1-18 08:53
sql节点加了如下配置：
[mysql_cluster]
# Options for ndbd process:

看下管理节点上面以及数据节点上面的报错日志信息是啥呢？

ifeelstupid · 发表于 2013-1-18 11:11

mchdba 发表于 2013-1-18 10:26
看下管理节点上面以及数据节点上面的报错日志信息是啥呢？

sql节点上的错误日志很少：
130117 16:49:57 [Warning] NDB: Could not acquire global schema lock (4009)Cluster Failure
130117 16:50:09 [Warning] NDB: Could not acquire global schema lock (4009)Cluster Failure
这还是我在建一个ndb表的时候报的错。
而数据节点可以正常连接，没有报错。

mchdba · 发表于 2013-1-18 20:24

ifeelstupid 发表于 2013-1-18 11:11
sql节点上的错误日志很少：
130117 16:49:57 [Warning] NDB: Could not acquire global schema lock (40 ...

管理节点有报错信息没有呢？

ifeelstupid · 发表于 2013-1-19 09:08

mchdba 发表于 2013-1-18 20:24
管理节点有报错信息没有呢？

有这样的错误：
2013-01-17 19:20:39 [MgmtSrvr] WARNING  -- Failed to allocate nodeid for API at 192.168.1.10. Returned eror: 'No free node id found for mysqld(API).'
2013-01-17 19:20:45 [MgmtSrvr] WARNING  -- Failed to allocate nodeid for API at 192.168.1.10. Returned eror: 'No free node id found for mysqld(API).'
2013-01-17 19:20:50 [MgmtSrvr] WARNING  -- Failed to allocate nodeid for API at 192.168.1.10. Returned eror: 'No free node id found for mysqld(API).'
2013-01-17 19:20:55 [MgmtSrvr] WARNING  -- Failed to allocate nodeid for API at 192.168.1.10. Returned eror: 'No free node id found for mysqld(API).'
2013-01-17 19:21:00 [MgmtSrvr] WARNING  -- Failed to allocate nodeid for API at 192.168.1.10. Returned eror: 'No free node id found for mysqld(API).'
2013-01-17 19:21:05 [MgmtSrvr] WARNING  -- Failed to allocate nodeid for API at 192.168.1.10. Returned eror: 'No free node id found for mysqld(API).'