大家好，我在搭建mysql cluster一直都没成功。
环境如下：
10.20.216.211 管理节点
10.20.216.209 数据节点和sql节点
10.20.216.210 数据节点和sql节点
10.20.216.211 管理节点安装软件是MySQL-Cluster-gpl-management-7.0.13-1.rhel4.x86_64.rpm和MySQL-Cluster-gpl-tools-7.0.13-1.rhel4.x86_64.rpm官网下的
10.20.216.209和10.20.216.210安装了mysql-5.1.41.tar.gz 源码安装，编译的时候已经加上ndb引安装后show engines能看到ndb引擎
10.20.216.211 管理节点config.ini配置如下：
[NDBD DEFAULT]
NoOfReplicas=2# Number of replicas
DataMemory=80M# How much memory to allocate for data storage
IndexMemory=18M # How much memory to allocate for index storage
[ndb_mgmd default]
DataDir=/usr/local/mysql/mysql-cluster
# TCP/IP options:
[TCP DEFAULT]
portnumber=2202 # This the default; however, you can use any
[NDB_MGMD]
hostname=10.20.216.211
# Hostname or IP address of MGM node
datadir=/usr/local/mysql/mysql-cluster # Directory for MGM node logfiles
[NDBD]
hostname=10.20.216.209
datadir=/data/db
[NDBD]
hostname=10.20.216.210
datadir=/data/db
[MYSQLD]
hostname=10.20.216.209
[MYSQLD]
hostname=10.20.216.210
# Hostname or IP address
[MYSQLD]
10.20.216.209和10.20.216.210配置文件my.cof配置一样添加了
[mysqld]
ndbcluster
ndb-connectstring = 10.20.216.211
[mysql_cluster]
ndb-connectstring = 10.20.216.211
数据库也启动了，启动时没报错。
查看10.20.216.211
ndb_mgm> show
Connected to Management Server at: localhost:1186
Cluster Configuration
---------------------
[ndbd(NDB)]
2 node(s)
id=2
@10.20.216.209(ndb-5.1.41, unknown state)
id=3
@10.20.216.210(ndb-5.1.41, unknown state, Nodegroup: 2)
[ndb_mgmd(MGM)]
1 node(s)
id=1
@10.20.216.211(mysql-5.1.41 ndb-7.0.13)
[mysqld(API)]
3 node(s)
id=4 (not connected, accepting connect from 10.20.216.209)
id=5 (not connected, accepting connect from 10.20.216.210)
id=6 (not connected, accepting connect from any host)
id5 和id6 一直是not connected
搞了好几天还是没解决。
|
