Chinaunix

标题: 在线求助 mysql cluster mysql节点报错 [打印本页]

作者: fancy1921 时间: 2012-11-27 10:06
标题: 在线求助 mysql cluster mysql节点报错
各位大侠，在线求助mysql cluster mysql节点启动正常，但是在管理节点show时出现问题：

一个节点一会儿能连上，一会儿不能连上出现id=22 (not connected, accepting connect from 192.168.1.202)

一个节点正常，另外一个节点一直无法连上

管理节点：192.168.1.201

NDB节点：192.168.1.200 192.168.1.202 192.168.1.203

SQL 节点：192.168.1.200 192.168.1.202 192.168.1.203

config.ini[ndbd default]
NoOfReplicas= 3
MaxNoOfConcurrentOperations= 10000
DataMemory= 80M
IndexMemory= 24M
TimeBetweenWatchDogCheck= 30000
DataDir= /var/lib/mysql-cluster
MaxNoOfOrderedIndexes= 512

[ndb_mgmd default]
DataDir= /var/lib/mysql-cluster

[ndb_mgmd]
Id=1
HostName= 192.168.1.201

[ndbd]
Id= 11
HostName= 192.168.1.200
DataDir=/var/lib/mysql/ndbdata

[ndbd]
Id= 12
HostName= 192.168.1.202
DataDir=/var/lib/mysql/ndbdata

[ndbd]
Id= 13
HostName= 192.168.1.203
DataDir=/var/lib/mysql/ndbdata

[mysqld]
Id=21
HostName= 192.168.1.200

[mysqld]
Id=22
HostName= 192.168.1.202

[mysqld]
Id=23
HostName= 192.168.1.203

# choose an unused port number
# in this configuration 63132, 63133, and 63134
# will be used
[tcp default]
PortNumber= 63132

my,cnf

[client]
#password    = your_password
port          = 3306
socket       = /var/lib/mysql/mysql.sock

[mysqld]
port          = 3306
socket       = /var/lib/mysql/mysql.sock
ndbcluster
ndb-connectstring=192.168.1.201

#For NDB data node
[mysql_cluster]
ndb-connectstring=192.168.1.201

欢迎光临 Chinaunix (http://bbs.chinaunix.net/)