MySQL Cluster 问题请教
两台机器192.168.10.249 和192.168.10.250 机器配置mySQL Cluster, 两台机器都安装windows Server 2003,
在网上搜到这位老兄的文章:http://blog.csdn.net/zhangking/article/details/5670070
按照他的思路一步步走下来,但走到:
ndb_mgmd.exe 时失败,如下:
-
SQL code
D:\mysql-cluster-gpl-noinstall-7.1.3-win32\bin>ndb_mgmd.exe -f d:\mysqlcluster\config.ini --configdir=d:\mysqlcluster --initial MySQL Cluster Management Server mysql-5.5.19 ndb-7.2.4 2012-02-21 04:19:17 [MgmtSrvr] WARNING -- at line 29: Cluster configuration warning: arbitrator with id 1 and db node with id 2 on same host 192.168.10.249 Running arbitrator on the same host as a database node may cause complete cluster shutdown in case of host failure.
如果不带–initial参数,机器夯在那里不动:
-
SQL code
D:\mysql-cluster-gpl-noinstall-7.1.3-win32\bin>ndb_mgmd.exe -f d:\mysqlcluster\config.ini --configdir=d:\mysqlcluster MySQL Cluster Management Server mysql-5.5.19 ndb-7.2.4
以下是我的配置文件(D:\mysqlcluster\config.ini)内容:
-
SQL code
[NDBD DEFAULT] NoOfReplicas=2 [MYSQLD DEFAULT] [NDB_MGMD DEFAULT] [TCP DEFAULT] # Managment Server [NDB_MGMD] hostname=192.168.10.249 # Storage Engines [NDBD] hostname=192.168.10.249 datadir= D:/data [NDBD] hostname=192.168.10.250 datadir= D:/data # SQL Engines [MYSQLD] hostname=192.168.10.249 [MYSQLD] hostname=192.168.10.250
请教各位问题出在那里?
ndb_mgmd 在Server 249上运行.谢谢!
意思是管理机必须另外弄台?
作为两台机器的集群,必须有第三台机器作为管理节点,也就是ndb_mgmd管理节点
要配置再第三台机器上。