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