免费注册 查看新帖 |

Chinaunix

  平台 论坛 博客 文库
最近访问板块 发新帖
查看: 2490 | 回复: 2

为什么mysql cluster里只能打开2个SQL节点? [复制链接]

论坛徽章:
0
发表于 2012-06-12 11:21 |显示全部楼层
我的环境:
1台mgm、3台SQL、4台data node

在配置好以后,发现显示只有2个SQL节点是加入集群的,第三台怎么都加不进去,这是顺序启动后的查看结果:
[root@localhost mysql-cluster]# ndb_mgm -e show
Connected to Management Server at: localhost:1186
Cluster Configuration
---------------------
[ndbd(NDB)]     4 node(s)
id=2    @192.168.10.84  (mysql-5.5.22 ndb-7.2.6, Nodegroup: 0, Master)
id=3    @192.168.10.85  (mysql-5.5.22 ndb-7.2.6, Nodegroup: 0)
id=4    @192.168.10.86  (mysql-5.5.22 ndb-7.2.6, Nodegroup: 1)
id=5    @192.168.10.87  (mysql-5.5.22 ndb-7.2.6, Nodegroup: 1)

[ndb_mgmd(MGM)] 1 node(s)
id=1    @192.168.10.80  (mysql-5.5.22 ndb-7.2.6)

[mysqld(API)]   5 node(s)
id=6    @192.168.10.81  (mysql-5.5.22 ndb-7.2.6)
id=7    @192.168.10.82  (mysql-5.5.22 ndb-7.2.6)
id=8 (not connected, accepting connect from 192.168.10.83)
id=9 (not connected, accepting connect from any host)
id=10 (not connected, accepting connect from any host)

可是当我再次查看时,又变成这样了:

[root@localhost mysql-cluster]# ndb_mgm -e show
Connected to Management Server at: localhost:1186
Cluster Configuration
---------------------
[ndbd(NDB)]     4 node(s)
id=2    @192.168.10.84  (mysql-5.5.22 ndb-7.2.6, Nodegroup: 0, Master)
id=3    @192.168.10.85  (mysql-5.5.22 ndb-7.2.6, Nodegroup: 0)
id=4    @192.168.10.86  (mysql-5.5.22 ndb-7.2.6, Nodegroup: 1)
id=5    @192.168.10.87  (mysql-5.5.22 ndb-7.2.6, Nodegroup: 1)

[ndb_mgmd(MGM)] 1 node(s)
id=1    @192.168.10.80  (mysql-5.5.22 ndb-7.2.6)

[mysqld(API)]   5 node(s)
id=6 (not connected, accepting connect from 192.168.10.81)
id=7    @192.168.10.82  (mysql-5.5.22 ndb-7.2.6)
id=8    @192.168.10.83  (mysql-5.5.22 ndb-7.2.6)
id=9 (not connected, accepting connect from any host)
id=10 (not connected, accepting connect from any host)


请问,这是为什么?

论坛徽章:
0
发表于 2012-06-12 16:53 |显示全部楼层
我又仔细检查了配置,并重新测试,发现一个奇怪的现象:就是每次查看都会不一样,具体现象如下:
每次使用ndb_mgm -e show命令查看时,sql nodes都会不一样,到第四次时又全部显示正常了。
---------------------------------------------------------------------------------------
[root@localhost mysql-cluster]# ndb_mgm -e show
Connected to Management Server at: localhost:1186
Cluster Configuration
---------------------
[ndbd(NDB)]     4 node(s)
id=2    @192.168.10.84  (mysql-5.5.22 ndb-7.2.6, Nodegroup: 0, Master)
id=3    @192.168.10.85  (mysql-5.5.22 ndb-7.2.6, Nodegroup: 0)
id=4    @192.168.10.86  (mysql-5.5.22 ndb-7.2.6, Nodegroup: 1)
id=5    @192.168.10.87  (mysql-5.5.22 ndb-7.2.6, Nodegroup: 1)

[ndb_mgmd(MGM)] 1 node(s)
id=1    @192.168.10.80  (mysql-5.5.22 ndb-7.2.6)

[mysqld(API)]   4 node(s)
id=6 (not connected, accepting connect from 192.168.10.81)
id=7    @192.168.10.82  (mysql-5.5.22 ndb-7.2.6)
id=8    @192.168.10.83  (mysql-5.5.22 ndb-7.2.6)
id=9 (not connected, accepting connect from any host)

----------------------------------------------------------------------------------------
[root@localhost mysql-cluster]# ndb_mgm -e show
Connected to Management Server at: localhost:1186
Cluster Configuration
---------------------
[ndbd(NDB)]     4 node(s)
id=2    @192.168.10.84  (mysql-5.5.22 ndb-7.2.6, Nodegroup: 0, Master)
id=3    @192.168.10.85  (mysql-5.5.22 ndb-7.2.6, Nodegroup: 0)
id=4    @192.168.10.86  (mysql-5.5.22 ndb-7.2.6, Nodegroup: 1)
id=5    @192.168.10.87  (mysql-5.5.22 ndb-7.2.6, Nodegroup: 1)

[ndb_mgmd(MGM)] 1 node(s)
id=1    @192.168.10.80  (mysql-5.5.22 ndb-7.2.6)

[mysqld(API)]   4 node(s)
id=6    @192.168.10.81  (mysql-5.5.22 ndb-7.2.6)
id=7 (not connected, accepting connect from 192.168.10.82)
id=8    @192.168.10.83  (mysql-5.5.22 ndb-7.2.6)
id=9 (not connected, accepting connect from any host)

----------------------------------------------------------------------------------------
[root@localhost mysql-cluster]# ndb_mgm -e show
Connected to Management Server at: localhost:1186
Cluster Configuration
---------------------
[ndbd(NDB)]     4 node(s)
id=2    @192.168.10.84  (mysql-5.5.22 ndb-7.2.6, Nodegroup: 0, Master)
id=3    @192.168.10.85  (mysql-5.5.22 ndb-7.2.6, Nodegroup: 0)
id=4    @192.168.10.86  (mysql-5.5.22 ndb-7.2.6, Nodegroup: 1)
id=5    @192.168.10.87  (mysql-5.5.22 ndb-7.2.6, Nodegroup: 1)

[ndb_mgmd(MGM)] 1 node(s)
id=1    @192.168.10.80  (mysql-5.5.22 ndb-7.2.6)

[mysqld(API)]   4 node(s)
id=6    @192.168.10.81  (mysql-5.5.22 ndb-7.2.6)
id=7    @192.168.10.82  (mysql-5.5.22 ndb-7.2.6)
id=8 (not connected, accepting connect from 192.168.10.83)
id=9 (not connected, accepting connect from any host)

----------------------------------------------------------------------------------------
[root@localhost mysql-cluster]# ndb_mgm -e show
Connected to Management Server at: localhost:1186
Cluster Configuration
---------------------
[ndbd(NDB)]     4 node(s)
id=2    @192.168.10.84  (mysql-5.5.22 ndb-7.2.6, Nodegroup: 0, Master)
id=3    @192.168.10.85  (mysql-5.5.22 ndb-7.2.6, Nodegroup: 0)
id=4    @192.168.10.86  (mysql-5.5.22 ndb-7.2.6, Nodegroup: 1)
id=5    @192.168.10.87  (mysql-5.5.22 ndb-7.2.6, Nodegroup: 1)

[ndb_mgmd(MGM)] 1 node(s)
id=1    @192.168.10.80  (mysql-5.5.22 ndb-7.2.6)

[mysqld(API)]   4 node(s)
id=6    @192.168.10.81  (mysql-5.5.22 ndb-7.2.6)
id=7    @192.168.10.82  (mysql-5.5.22 ndb-7.2.6)
id=8    @192.168.10.83  (mysql-5.5.22 ndb-7.2.6)

id=9 (not connected, accepting connect from any host)

论坛徽章:
0
发表于 2012-06-13 09:25 |显示全部楼层
提示: 作者被禁止或删除 内容自动屏蔽
您需要登录后才可以回帖 登录 | 注册

本版积分规则 发表回复

  

北京盛拓优讯信息技术有限公司. 版权所有 京ICP备16024965号-6 北京市公安局海淀分局网监中心备案编号:11010802020122 niuxiaotong@pcpop.com 17352615567
未成年举报专区
中国互联网协会会员  联系我们:huangweiwei@itpub.net
感谢所有关心和支持过ChinaUnix的朋友们 转载本站内容请注明原作者名及出处

清除 Cookies - ChinaUnix - Archiver - WAP - TOP