第五步，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