MySQL Cluster安装配置(二)

2014-11-24 17:51:01 · 作者: · 浏览: 1
d to Management Server at: localhost:1186
Cluster Configuration
---------------------
[ndbd(NDB)] 4 node(s)
id=2 (not connected, accepting connect from 192.168.10.155)
id=3 (not connected, accepting connect from 192.168.10.156)
id=4 (not connected, accepting connect from 192.168.10.166)
id=5 (not connected, accepting connect from 192.168.10.167)


[ndb_mgmd(MGM)] 1 node(s)
id=1 @192.168.10.151 (mysql-5.5.30 ndb-7.2.12)


[mysqld(API)] 3 node(s)
id=6 (not connected, accepting connect from 192.168.10.153)
id=7 (not connected, accepting connect from 192.168.10.152)
id=8 (not connected, accepting connect from 192.168.10.154)


启动NDBD节点
[root@os-6 mysql]# ndbd --initial #首次启动加initial进行初始化,其他情况就不加任何选项
2013-05-06 15:52:41 [ndbd] INFO -- Angel connected to '192.168.10.151:1186'
2013-05-06 15:52:41 [ndbd] INFO -- Angel allocated nodeid: 3
在OS-1上show
ndb_mgm> show
Cluster Configuration
---------------------
[ndbd(NDB)] 4 node(s)
id=2 @192.168.10.155 (mysql-5.5.30 ndb-7.2.12, Nodegroup: 0, Master)
id=3 @192.168.10.156 (mysql-5.5.30 ndb-7.2.12, Nodegroup: 0)
id=4 @192.168.10.166 (mysql-5.5.30 ndb-7.2.12, Nodegroup: 1)
id=5 @192.168.10.167 (mysql-5.5.30 ndb-7.2.12, Nodegroup: 1)


[ndb_mgmd(MGM)] 1 node(s)
id=1 @192.168.10.151 (mysql-5.5.30 ndb-7.2.12)


[mysqld(API)] 3 node(s)
id=6 (not connected, accepting connect from 192.168.10.153)
id=7 (not connected, accepting connect from 192.168.10.154)
id=8 (not connected, accepting connect from 192.168.10.154)


启动SQL节点
[root@os-3 mysql]# mysqld_safe --user=mysql &
[1] 2501
[root@os-3 mysql]# 130506 16:01:16 mysqld_safe Logging to '/home/mysql/os-3.err'.
130506 16:01:16 mysqld_safe Starting mysqld daemon with databases from /home/mysql
ndb_mgm> show
Cluster Configuration
---------------------
[ndbd(NDB)] 4 node(s)
id=2 @192.168.10.155 (mysql-5.5.30 ndb-7.2.12, Nodegroup: 0, Master)
id=3 @192.168.10.156 (mysql-5.5.30 ndb-7.2.12, Nodegroup: 0)
id=4 @192.168.10.166 (mysql-5.5.30 ndb-7.2.12, Nodegroup: 1)
id=5 @192.168.10.167 (mysql-5.5.30 ndb-7.2.12, Nodegroup: 1)


[ndb_mgmd(MGM)] 1 node(s)
id=1 @192.168.10.151 (mysql-5.5.30 ndb-7.2.12)


[mysqld(API)] 3 node(s)
id=6 @192.168.10.153 (mysql-5.5.30 ndb-7.2.12)
id=7 @192.168.10.152 (mysql-5.5.30 ndb-7.2.12)
id=8 @192.168.10.154 (mysql-5.5.30 ndb-7.2.12)


测试:
在sqlserver上进行mysql -uroot连接测试


推荐阅读: