nizhishuai 发表于 2011-8-15 21:14:28

mysql-cluster问题,向高手求救

我在启动 mysql-cluster 的时候出现 mysql api连接不了,不知道是什么原因。
有一次连接成功了。没有更改什么。

   2 node(s)
id=2    @117.10.0.0(mysql-5.1.56 ndb-7.1.15, not started)
id=3    @211.10.0.0(mysql-5.1.56 ndb-7.1.15, starting, Nodegroup: 0)

1 node(s)
id=1    @109.10.0.0(mysql-5.1.56 ndb-7.1.15)

   2 node(s)
id=4 (not connected, accepting connect from any host)
id=5 (not connected, accepting connect from any host)

mysqld(API) 和 ndbd(NDB) 为同一台服务器。向高手求救。。
=====================
这块连接不上

   2 node(s)
id=4 (not connected, accepting connect from any host)
id=5 (not connected, accepting connect from any host)

kider 发表于 2011-8-16 09:46:55


看看网络,IP是否有变化。检查配置文件、/etc/hosts等
还有就是路径。
可以先都单独启动下试试。一步步检查吧

nizhishuai 发表于 2011-8-16 10:58:37

检查了 没有什么问题,有时候ok。有时候不ok了

nizhishuai 发表于 2011-8-16 13:28:20

kider 发表于 2011-8-16 09:46 static/image/common/back.gif
看看网络,IP是否有变化。检查配置文件、/etc/hosts等
还有就是路径。
可以先都单独启动下试试。一步步 ...

110816 05:17:45 mysqld_safe mysqld from pid file /var/mysqldb/wangju-sh.pid ended
110816 05:18:28 mysqld_safe Starting mysqld daemon with databases from /var/mysql/
1108165:18:28 Plugin 'FEDERATED' is disabled.
1108165:18:28InnoDB: Initializing buffer pool, size = 8.0M
1108165:18:28InnoDB: Completed initialization of buffer pool
1108165:18:28InnoDB: Started; log sequence number 0 44233
1108165:18:30 NDB: NodeID is 51, management server '10.0.0.2'
1108165:18:31 NDB: NodeID: 51, no storage nodes connected (timed out)
1108165:18:31 NDB: server id set to zero - changes logged to bin log with server id zero will be logged with another server id by slave mysqlds
1108165:18:31 Starting Cluster Binlog Thread
1108165:18:31 Event Scheduler: Loaded 0 events

这里有问题。但是selinux和iptables都已经关闭了
1108165:18:31 NDB: server id set to zero - changes logged to bin log with server id zero will be logged with another server id by slave mysqlds

kider 发表于 2011-8-16 15:06:43

参数文件中设置: server-id 应该都不一样才好

nizhishuai 发表于 2011-8-17 02:11:36

kider 发表于 2011-8-16 15:06 static/image/common/back.gif
参数文件中设置: server-id 应该都不一样才好

怎么说呢?server-id 好像都不一样哦。
看了mysql的日志
no storage nodes connected (timed out)
api连接超时。。
页: [1]
查看完整版本: mysql-cluster问题,向高手求救