x_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
[mysql_cluster]
ndb_connectstring=192.168.1.11
#下划线或者横线都可以
#ndb-connectstring=192.168.1.11
第五步，ndb01创建数据目录，修改所有者和所属组
[root@ndb01 mysql]# mkdir /var/lib/mysql-cluster
[root@ndb01 mysql]# chown mysql.mysql !$ -R
chown mysql.mysql /var/lib/mysql-cluster -R
[root@ndb01 mysql]# ll -d /var/lib/mysql-cluster/
drwxr-xr-x 2 mysql mysql 4096 Nov 4 23:54 /var/lib/mysql-cluster/
第六步，ndb01初始化ndbd
[root@ndb01 mysql]# /usr/local/mysql/bin/ndbd --initial
2013-11-04 23:57:06 [ndbd] INFO -- Configuration fetched from '192.168.1.11:1186', generation: 1
#查看状态
[root@ndb01 mysql]# /usr/local/mysql/bin/ndb_mgm
-- NDB Cluster -- Management Client --
ndb_mgm> show
Connected to Management Server at: 192.168.1.11:1186
Cluster Configuration
---------------------
[ndbd(NDB)] 2 node(s)
id=2 @192.168.1.14 (mysql-5.1.44 ndb-7.1.4, starting, Nodegroup: 0)
id=3 (not connected, accepting connect from 192.168.1.15)
[ndb_mgmd(MGM)] 1 node(s)
id=1 @192.168.1.11 (mysql-5.1.44 ndb-7.1.4)
[mysqld(API)] 2 node(s)
id=4 (not connected, accepting connect from 192.168.1.12)
id=5 (not connected, accepting connect from 192.168.1.13)
第七步，ndb02和ndb01执行相同的操作，如下：
[root@ndb02 ~]# groupadd -g 27 mysql
[root@ndb02 ~]# useradd -u 27 -g 27 -r -M -s /sbin/nologin mysql
[root@ndb02 ~]# id mysql
uid=27(mysql) gid=27(mysql) groups=27(mysql)
[root@ndb02 opt]# tar -xvf mysql-cluster-gpl-7.1.4b-linux-x86_64-glibc23.tar.gz -C /usr/local/
[root@ndb02 opt]# cd /usr/local/
[root@ndb02 local]# mv mysql-cluster-gpl-7.1.4b-linux-x86_64-glibc23/ mysql
[root@ndb02 local]# chown mysql. mysql/ -R
[root@ndb02 local]# ll -d mysql/
drwxr-xr-x 13 mysql mysql 4096 Jun 11 2010 mysql/
[root@ndb02 local]# ll mysql/
total 244
drwxr-xr-x 2 mysql mysql 4096 Jun 11 2010 bin
-rw-r--r-- 1 mysql mysql 19071 Jun 11 2010 COPYING
drwxr-x--- 4 mysql mysql 4096 Jun 11 2010 data
drwxr-xr-x 2 mysql mysql 4096 Jun 11 2010 docs
-rw-r--r-- 1 mysql mysql 5139 Jun 11 2010 EXCEPTIONS-CLIENT
drwxr-xr-x 3 mysql mysql 4096 Jun 11 2010 include
-rw-r--r-- 1 mysql mysql 9748 Jun 11 2010 INSTALL-BINARY
drwxr-xr-x 3 mysql mysql 4096 Jun 11 2010 lib
drwxr-xr-x 4 mysql mysql 4096 Jun 11 2010 man
drwxr-xr-x 10 mysql mysql 4096 Jun 11 2010 mysql-test
-rw-r--r-- 1 mysql mysql 161295 Jun 11 2010 README
drwxr-xr-x 2 mysql mysql 4096 Jun 11 2010 scripts
drwxr-xr-x 28 mysql mysql 4096 Jun 11 2010 share
drwxr-xr-x 5 mysql mysql 4096 Jun 11 2010 sql-bench
drwxr-xr-x 2 mysql mysql 4096 Jun 11 2010 support-files
[root@ndb02 local]# mkdir /var/lib/mysql-cluster
[root@ndb02 local]# chown mysql. /var/lib/mysql-cluster/ -R
[root@ndb02 local]# ll -d /var/lib/mysql-cluster/
drwxr-xr-x 2 mysql mysql 4096 Nov 5 00:00 /var/lib/mysql-cluster/
[root@ndb02 local]# cd mysql/
[root@ndb02 mysql]# cp support-files/my-medium.cnf /etc/my.cnf
cp: overwrite `/etc/my.cnf' y
[root@ndb02 mysql]# vim /etc/my.cnf
[root@ndb02 mysql]# grep "^#\|^$" !$ -v
grep "^#\|^$" /etc/my.cnf -v
[client]
port = 3306
socket = /tmp/mysql.sock
[mysqld]
port = 3306
socket = /tmp/mysql.sock
skip-locking
key_buffer_size = 16M
max_allowed_packet = 1M