我尝试用 mysql Cluster集群,进行配置后一启动就出了问题:
先看配置吧:Management (MGMD) node
192.168.3.27
MySQL server (SQL) node “A”
192.168.3.28
MySQL server (SQL) node “B”
192.168.3.29
Data (NDBD) node "A"
192.168.3.28
Data (NDBD) node "B"
192.168.3.29
config.ini的配置如下:
[ndbd default]
# Options affecting ndbd processes on all data nodes:
NoOfReplicas=2
DataDir=D:/Program Files/mysqlcluster/datanode/mysql/bin/cluster-data
DataMemory=80M
IndexMemory=18M[tcp default]
SendBufferMemory=2M
ReceiveBufferMemory=2M[NDB_MGMD DEFAULT]
PortNumber=1186
Datadir=C:\mysql\mysql-cluster[ndb_mgmd]
# Management process options:
nodeid=1
HostName=192.168.3.27
DataDir=C:\mysql\bin\cluster-logs
[ndbd]
# Options for data node "A":
DataDir=D:/Program Files/mysqlcluster/datanode/mysql/bin/cluster-data
HostName=192.168.3.28[ndbd]
# Options for data node "B":
DataDir=D:/Program Files/mysqlcluster/datanode/mysql/bin/cluster-data
HostName=192.168.3.29[mysqld]
# SQL node options:
HostName=192.168.3.28[mysqld]
# SQL node options:
HostName=192.168.3.29启动Management node:进入bin目录后,用命令:ndb_mgmd -f config.ini
C:\mysql\bin>ndb_mgmd -f config.ini
MySQL Cluster Management Server mysql-5.1.51 ndb-7.1.9
2010-12-07 09:40:30 [MgmtSrvr] ERROR -- Could not determine which nodeid to u
se for this node. Specify it with --ndb-nodeid=<nodeid> on command line应该是缺少了nodeid这一项,我就在下面位置添加了nodeid:
[ndb_mgmd]
nodeid=1[ndbd]
nodeid=2[ndbd]
nodeid=3[mysqld]
nodeid=4[mysqld]
nodeid=5然后用启动:C:\mysql\bin>ndb_mgmd -f config.ini --ndb-nodeid=1
MySQL Cluster Management Server mysql-5.1.51 ndb-7.1.9
2010-12-07 09:49:20 [MgmtSrvr] ERROR -- The hostname this node should have ac
cording to the configuration does not match a local interface. Attempt to bind '
192.168.3.27' failed with error: 34 'Result too large'这才刚开始呢,后面就走不下去了,虚心请教!
先看配置吧:Management (MGMD) node
192.168.3.27
MySQL server (SQL) node “A”
192.168.3.28
MySQL server (SQL) node “B”
192.168.3.29
Data (NDBD) node "A"
192.168.3.28
Data (NDBD) node "B"
192.168.3.29
config.ini的配置如下:
[ndbd default]
# Options affecting ndbd processes on all data nodes:
NoOfReplicas=2
DataDir=D:/Program Files/mysqlcluster/datanode/mysql/bin/cluster-data
DataMemory=80M
IndexMemory=18M[tcp default]
SendBufferMemory=2M
ReceiveBufferMemory=2M[NDB_MGMD DEFAULT]
PortNumber=1186
Datadir=C:\mysql\mysql-cluster[ndb_mgmd]
# Management process options:
nodeid=1
HostName=192.168.3.27
DataDir=C:\mysql\bin\cluster-logs
[ndbd]
# Options for data node "A":
DataDir=D:/Program Files/mysqlcluster/datanode/mysql/bin/cluster-data
HostName=192.168.3.28[ndbd]
# Options for data node "B":
DataDir=D:/Program Files/mysqlcluster/datanode/mysql/bin/cluster-data
HostName=192.168.3.29[mysqld]
# SQL node options:
HostName=192.168.3.28[mysqld]
# SQL node options:
HostName=192.168.3.29启动Management node:进入bin目录后,用命令:ndb_mgmd -f config.ini
C:\mysql\bin>ndb_mgmd -f config.ini
MySQL Cluster Management Server mysql-5.1.51 ndb-7.1.9
2010-12-07 09:40:30 [MgmtSrvr] ERROR -- Could not determine which nodeid to u
se for this node. Specify it with --ndb-nodeid=<nodeid> on command line应该是缺少了nodeid这一项,我就在下面位置添加了nodeid:
[ndb_mgmd]
nodeid=1[ndbd]
nodeid=2[ndbd]
nodeid=3[mysqld]
nodeid=4[mysqld]
nodeid=5然后用启动:C:\mysql\bin>ndb_mgmd -f config.ini --ndb-nodeid=1
MySQL Cluster Management Server mysql-5.1.51 ndb-7.1.9
2010-12-07 09:49:20 [MgmtSrvr] ERROR -- The hostname this node should have ac
cording to the configuration does not match a local interface. Attempt to bind '
192.168.3.27' failed with error: 34 'Result too large'这才刚开始呢,后面就走不下去了,虚心请教!
节点:172.16.3.28 172.16.3.30我重新配置了一遍conf.ini
[ndbd default]
NoOfReplicas=2
DataMemory=200M
IndexMemory=100M[NDB_MGMD]
nodeid=1
hostname=172.16.3.27
datadir=D:\Program Files\mysqlcluster\datanode\mysql\bin\cluster-data[NDBD]
nodeid=2
hostname=172.16.3.28
datadir=C:\mysql\mysql-cluster[NDBD]
nodeid=3
hostname=172.16.3.30
datadir=C:\mysql\mysql-cluster[MySQLD]
nodeid=4
hostname=172.16.3.28[MySQLD]
nodeid=5
hostname=172.16.3.30[MySQLD]
nodeid=6然后启动:
c:\mysql\bin> ndb_mgmd -f config.ini (显示如下:)MySQL Cluster Management Server mysql-5.1.51 ndb-7.1.9c:\mysql\bin>ndb_mgm (显示如下:)-- NDB Cluster -- Management Client --ndb_mgm> show
Cluster Configuration
---------------------
[ndbd(NDB)] 2 node(s)
id=2 (not connected, accepting connect from 172.16.3.28)
id=3 (not connected, accepting connect from 172.16.3.30)[ndb_mgmd(MGM)] 1 node(s)
id=1 @172.16.3.27 (mysql-5.1.51 ndb-7.1.9)[mysqld(API)] 3 node(s)
id=4 (not connected, accepting connect from 172.16.3.28)
id=5 (not connected, accepting connect from 172.16.3.30)
id=6 (not connected, accepting connect from any host)到此为止,我再配置节点的 my.ini,内容为:
[mysqld]
ndbcluster
ndb-connectstring=172.16.3.27[mysqld]
#option for mysqld process:
ndbcluster
ndb-connectstring=172.16.3.27然后启动节点:
bin> ndbd --initial
Unable to connect with connect string: nodeid=0,localhost:1186
Retrying every 5 seconds. Attempts left: 12 11 10 9 8 7 6 5 4 3 2 1, failed.
2010-12-07 17:04:22 [ndbd] ERROR -- Could not connect to management server, e
rror: ''走到这里就连接不上了,所有主机在终端是ping得通的,防火墙也关了。望高手继续不吝指教!
[mysqld]
ndbcluster
ndb-connectstring=172.16.3.27[mysql_cluster]
ndb_connectstring=172.16.3.27