实在没辙了,倒腾了很久,看了很多帖子都没有解决。
PS:国内程序员的习惯太不好,很多不结贴,而且就算自己解决了,也不说解决方案。诶。。。
背景:管理节点和数据节点已经成功启动,sql节点也运行了,sql节点的log没有错误日志,而且本机数据库能正常登陆
管理节点:Linux CentOS 6.2 IP:192.168.10.226
数据节点:Linux CentOS 6.2 IP:192.168.10.52
SQL节点1:Linux CentOS 6.2 IP:192.168.10.41
SQL节点2:Linux CentOS 6.2 IP:192.168.10.42
每台服务器的防火墙均已关闭。
管理节点配置:
datadir = /usr/local/mysql/ndbdata
[ndbd default]
NoOfReplicas = 1
DataMemory = 80M
IndexMemory = 18M
datadir = /usr/local/mysql/ndbdata
[ndb_mgmd]
NodeId = 1
HostName = 192.168.10.226
[ndbd]
NodeId = 2
HostName = 192.168.10.52
[mysqld]
NodeId = 3
HostName = 192.168.10.41
[mysqld]
NodeId = 4
HostName = 192.168.10.42
数据节点的配置文件
[root@test-socket2 bin]# cat /etc/my.cnf
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
ndbcluster
ndb-connectstring = 192.168.10.226
[mysql_cluster]
ndb-connectstring = 192.168.10.226
[root@test-socket2 bin]# cat /etc/my.cnf
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
ndbcluster
ndb-connectstring = 192.168.10.226
[mysql_cluster]
ndb-connectstring = 192.168.10.226
[root@test-socket2 bin]# vi /etc/my.cnf
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
ndbcluster
ndb-connectstring = 192.168.10.226
[mysql_cluster]
ndb-connectstring = 192.168.10.226
SQL 节点的配置文件:
[root@test-web1 data]# cat /etc/my.cnf
[mysqld]
#datadir=/var/lib/mysql
socket=/tmp/mysql.sock
user=mysql
port=3306
basedir=/usr/local/mysql/
datadir=/usr/local/mysql/ndbdata
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
ndbcluster
ndb-connectstring = 192.168.10.226
[ndbd]
connect-string=192.168.10.52
[ndbd_mgm]
connect-string=192.168.10.226
[ndbd_mgmd]
config-file=/etc/config.ini
[mysql_cluster]
ndb-connectstring = 192.168.10.226
管理节点链接状态:
ndb_mgm> show
Connected to Management Server at: localhost:1186
Cluster Configuration
---------------------
[ndbd(NDB)] 1 node(s)
id=2 @192.168.10.52 (mysql-5.6.27 ndb-7.4.8, Nodegroup: 0, *)
[ndb_mgmd(MGM)] 1 node(s)
id=1 @192.168.10.226 (mysql-5.6.27 ndb-7.4.8)
[mysqld(API)] 2 node(s)
id=3 (not connected, accepting connect from 192.168.10.41)
id=4 (not connected, accepting connect from 192.168.10.42)