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连接测试
推荐阅读: