- 论坛徽章:
- 0
|
各位大侠,在线求助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
|
|