MySQL Cluster安装

1. 准备环境
采用二进制包进行安装
安装包名称为：mysql-cluster-gpl-7.4.4-linux-glibc2.5-x86_64.tar.gz

关闭防火墙：
service iptables stop

关闭防火墙开机启动
chkconfig iptables off

2. 添加用户和组
groupadd mysql
useradd mysql mysql

3. 安装准备
(1) 解压：tar -C /usr/local -xzvf mysql-cluster-gpl-7.4.4-linux-glibc2.5-x86_64.tar.gz
(2) 为了方便，创建软连接： 
cd /usr/local
ln -s mysql-cluster-gpl-7.4.4-linux-glibc2.5-x86_64 mysql

4. SQL节点安装
(1) 修改文件夹权限
cd /usr/local/mysql
chown -R root .
chown -R mysql data
chgrp -R mysql .
(2) 创建数据库
cd /usr/local/mysql
scripts/mysql_install_db --user=mysql
(3) 创建启动脚本、增加开机启动服务
cp support-files/mysql.server /etc/rc.d/init.d/
chmod +x /etc/rc.d/init.d/mysql.server
chkconfig --add mysql.server

5. Data节点安装
cd /usr/local/mysql/bin
cp ndbd /usr/local/bin/ndbd
cp ndbmtd /usr/local/bin/mdbmtd
cd /usr/local/bin/
chmod +x ndb*

注意：
如果没有/usr/local/mysql/data目录，则需要创建

6. Management节点安装
cd /usr/local/mysql/bin
cp ndb_mgm* /usr/local/bin/
cd /usr/local/bin/
chmod +x ndb_mgm*

7. SQL节点和Data节点配置
vim /etc/my.cnf
-----------配置-----------------
[client]
socket=/var/lib/mysql/mysql.sock

[mysqld]
max_connections=1000
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
symbolic-links=0
ndbcluster

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

[mysql_cluster] 
ndb-connectstring=10.8.122.21
-----------配置-----------------

8. Management节点配置
mkdir /var/lib/mysql-cluster
cd /var/lib/mysql-cluster
vi config.ini
-----------配置-----------------
[ndbd default]
NoOfReplicas=2
DataMemory=8G
IndexMemory=2G

[tcp default]
portnumber=2202

[ndb_mgmd]
hostname=10.8.122.21
datadir=/var/lib/mysql-cluster

[ndbd]
hostname=10.8.122.24
datadir=/usr/local/mysql/data

[ndbd]
hostname=10.8.122.25
datadir=/usr/local/mysql/data

[mysqld]
hostname=10.8.122.22

[mysqld]
hostname=10.8.122.23
-----------配置-----------------

9. 启动MySQL Cluster
(1) 启动Management节点
ndb_mgmd -f /var/lib/mysql-cluster/config.ini
(2) 启动Data节点
ndbd
(3) 启动SQL节点
/etc/rc.d/init.d/mysql.server start

查看启动是否成功：
(1) Management节点
ndb_mgm
show

全部节点启动成功后，显示结果如下：
----------------------------------------------------------
ndb_mgm> show
Cluster Configuration
---------------------
[ndbd(NDB)] 2 node(s)
id=2 @10.8.122.24 (mysql-5.6.23 ndb-7.4.4, Nodegroup: 0, *)
id=3 @10.8.122.25 (mysql-5.6.23 ndb-7.4.4, Nodegroup: 0)

[ndb_mgmd(MGM)] 1 node(s)
id=1 @10.8.122.21 (mysql-5.6.23 ndb-7.4.4)

[mysqld(API)] 2 node(s)
id=4 @10.8.122.22 (mysql-5.6.23 ndb-7.4.4)
id=5 @10.8.122.23 (mysql-5.6.23 ndb-7.4.4)

ndb_mgm> 
----------------------------------------------------------
10. 维护命令
(1) 关闭节点
登录ndb_mgm
ID stop
(2) 重载管理节点配置文件

(3) 重启SQL节点
/etc/rc.d/init.d/mysql.server stop

/etc/rc.d/init.d/mysql.server start