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
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
[mysql_cluster]
ndb_connectstring=192.168.1.11
[root@ndb02 mysql]# /usr/local/mysql/bin/ndbd --initial
2013-11-05 00:02:18 [ndbd] INFO -- Configuration fetched from '192.168.1.11:1186', generation: 1
[root@ndb02 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, Nodegroup: 0, Master)
id=3 @192.168.1.15 (mysql-5.1.44 ndb-7.1.4, Nodegroup: 0)
[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)
4.7 SQL节点搭建
第一步，sql01添加mysql组和用户
[root@sql01 ~]# groupadd -g 27 mysql
[root@sql01 ~]# useradd -u 27 -g 27 -r -M -s /sbin/nologin mysql
[root@sql01 ~]# id mysql
uid=27(mysql) gid=27(mysql) groups=27(mysql)
[root@sql01 ~]# cd /opt/
第二步，sql01解压二进制包
[root@sql01 opt]# tar -xvf mysql-cluster-gpl-7.1.4b-linux-x86_64-glibc23.tar.gz -C /usr/local/
第三步，sql01重命名安装目录，修改所有者和所属组
[root@sql01 opt]# cd /usr/local/
[root@sql01 local]# mv mysql-cluster-gpl-7.1.4b-linux-x86_64-glibc23/ mysql
[root@sql01 local]# chown mysql. mysql/ -R
[root@sql01 local]# ll -d mysql/
drwxr-xr-x 13 mysql mysql 4096 Jun 11 2010 mysql/
[root@sql01 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
第四步，sql01拷贝配置文件，并修改，如下
[root@sql01 local]# cd mysql/
[root@sql01 mysql]# cp support-files/my-medium.cnf /etc/my.cnf
cp: overwrite `/etc/my.cnf' y
[root@sql01 mysql]# vim /etc/my.cnf
[root@sql01 mysql]# grep "^#\|^$" !$ -v
grep "^#\|^$" /etc/my.cnf -v
[client]
port = 3306
socket = /tmp/mysql.sock
[mysqld]
datadir=/var/lib/mysql-cluster
ndbcluster
default-storage-engine=ndbcluster
port = 3306
socket = /tmp/mysql.sock
skip-locking
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
log-bi