本篇文章主要介绍了"mysql cluster",主要涉及到方面的内容,对于其他数据库感兴趣的同学可以参考一下:
Mysql环境搭建Centos5[root@localhost ~]# uname -aLinux localhost.localdomain 2.6.32-4...
[root@localhost ~]# ndb_mgmd -f /var/lib/mysql-cluster/config.ini
若出现MgmtSrvr] ERROR -- Could not determine which nodeid to use for this node. Specify it with --ndb-nodeid= on command line
是ip地址设置不对
[root@localhost local]# ndb_mgmd -f /var/lib/mysql-cluster/config.ini
MySQL Cluster Management Server mysql-5.6.28 ndb-7.4.10
[root@localhost local]# ndb_mgm
-- NDB Cluster -- Management Client --
ndb_mgm>
ndb_mgm> show
Connected to Management Server at: localhost:1186
Cluster Configuration
---------------------
[ndbd(NDB)] 2 node(s)
id=2 (not connected, accepting connect from 192.168.88.200)
id=3 (not connected, accepting connect from 192.168.88.200)
[ndb_mgmd(MGM)] 1 node(s)
id=1 @192.168.88.199 (mysql-5.6.28 ndb-7.4.10)
[mysqld(API)] 2 node(s)
id=4 (not connected, accepting connect from 192.168.88.202)
id=5 (not connected, accepting connect from 192.168.88.203)
若出错stop 1停掉管理节点
root@localhost mysql-cluster]# cat ndb_1_cluster.log
2016-02-13 23:23:46 [MgmtSrvr] INFO -- Loaded config from '/usr/local/mysql/mysql-cluster/ndb_1_config.bin.2'
2016-02-13 23:23:46 [MgmtSrvr] INFO -- Node 1: Node 1 Connected
2016-02-13 23:23:50 [MgmtSrvr] ERROR -- Unable to bind management service port: *:1186!
Please check if the port is already used,
(perhaps a ndb_mgmd is already running),
and if you are executing on the correct computer