求助啊 谢谢了!!!用VMware10搭建的mysql cluster环境,3台虚拟机,网卡NAT模式
已经service iptables stop、setenforce 0。管理节点:192.168.182.129
数据节点:192.168.182.130 ,192.168.182.131
SQLser  :192.168.182.130,192.168.182.131管理节点:
[root@localhost etc]# ndb_mgmd -f /var/lib/mysql-cluster/config.ini
MySQL Cluster Management Server mysql-5.1.73 ndb-7.1.32
数据节点:
[root@localhost mysql]# /usr/local/mysql/bin/ndbd
2015-01-22 00:51:31 [ndbd] INFO     -- Angel connected to '192.168.182.129:1186'
2015-01-22 00:51:31 [ndbd] INFO     -- Angel allocated nodeid: 2
SQLser节点:
[root@localhost ~]# service mysqld start
Starting MySQL SUCCESS! 但是在管理节点上依然显示未连接!!!
管理节点:
ndb_mgm SHOW结果
[root@localhost mysql-cluster]# ndb_mgm
-- NDB Cluster -- Management Client --
ndb_mgm> show
Connected to Management Server at: 192.168.182.129:1186
Cluster Configuration
---------------------
[ndbd(NDB)]     2 node(s)
id=2 (not connected, accepting connect from 192.168.182.130)
id=3 (not connected, accepting connect from 192.168.182.131)
[ndb_mgmd(MGM)] 1 node(s)
id=1    @192.168.182.129  (mysql-5.1.73 ndb-7.1.32)[mysqld(API)]   3 node(s)
id=4 (not connected, accepting connect from any host)
id=5 (not connected, accepting connect from any host)
id=6 (not connected, accepting connect from any host)
 config.ini
[root@localhost mysql-cluster]# vi config.ini
[NDBD DEFAULT]
NoOfReplicas= 2
DataDir= /var/lib/mysql-cluster
MaxNoOfConcurrentOperations=11000000
MaxNoOfLocalOperations=10000000
DataMemory=80000M
IndexMemory=18000M[NDB_MGMD]
Hostname= 192.168.182.129
DataDir= /var/lib/mysql-cluster[NDBD]
Id=2
HostName= 192.168.182.130
datadir=/usr/local/mysql/data/[NDBD]
Id=3
HostName= 192.168.182.131
datadir=/usr/local/mysql/data/

[MYSQLD]
[MYSQLD]
[MYSQLD]

my.cnf
[root@localhost etc]# vi my.cnf 
[client]
#password       = your_password
port            = 3306
socket          = /tmp/mysql.sock# Here follows entries for some specific programs# The MySQL server
[mysqld]
port            = 3306
socket          = /tmp/mysql.sock
skip-locking
skip-name-resolve
key_buffer_size = 16M
max_allowed_packet = 1M
table_open_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M
max_heap_table_size=2048M
tmp_table_size=2048M
ndbcluster
ndb-connectstring=192.168.182.129

log-bin=mysql-bin
binlog_format=mixed
server-id       = 1
[mysqldump]
quick
max_allowed_packet = 16M[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates[myisamchk]
key_buffer_size = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M[mysqlhotcopy]
interactive-timeout[ndbd]
connect-string=192.168.182.129
[ndb_mgm]
connect-string=192.168.182.129
[ndb_mgmd]
config-file=/var/lib/mysql-cluster/config.ini
数据节点:
[root@localhost mysql]# vi /etc/my.cnf 
[client]
#password       = your_password
port            = 3306
socket          = /tmp/mysql.sock
# The MySQL server
[mysqld]
port            = 3306
socket          = /tmp/mysql.sock
skip-locking
skip-name-resolve
key_buffer_size = 16M
max_allowed_packet = 1M
table_open_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M
max_heap_table_size=2048M
tmp_table_size=2048M
ndbcluster
ndb-connectstring=192.168.182.129

log-bin=mysql-bin
binlog_format=mixed
server-id       = 1
[mysqldump]
quick
max_allowed_packet = 16M[mysql]
no-auto-rehash[myisamchk]
key_buffer_size = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M[mysqlhotcopy]
interactive-timeout[ndbd]
connect-string=192.168.182.129
[ndb_mgm]
connect-string=192.168.182.129
[ndb_mgmd]
config-file=/var/lib/mysql-cluster/config.ini
求助啊~~ 谢谢了!!!