mysql cluster 部署

1.准备5台机器，ip分别为：

192.168.77.46(mgm)

192.168.77.48(data)

192.168.77.54(data)

192.168.77.55(sql)

192.168.77.56(sql)

2.首先安装192.168.77.55

shell> groupadd mysql
shell> useradd -g mysql mysql
shell> cd /var/tmp
shell> tar -C /usr/local -xzvf mysql-cluster-gpl-7.2.14-linux2.6.tar.gz
shell> ln -s /usr/local/mysql-cluster-gpl-7.2.14-linux2.6-i686 /usr/local/mysql
shell> cd mysql
shell> scripts/mysql_install_db --user=mysql
shell> chown -R root .
shell> chown -R mysql data
shell> chgrp -R mysql .
执行scripts/mysql_install_db --user=mysql如果出现错误，注意要把以下包装上：

yum install perl

yum install libaio

配置文件内容如下：vi /etc/my.cnf

[mysqld]
ndbcluster

[mysql_cluster]
ndb-connectstring=192.168.77.46

3.192.168.77.56安装同2

 

4.安装192.168.77.48

解压安装包，拷两个文件就行

shell> cd /var/tmp
shell> tar -zxvf mysql-5.5.31-ndb-7.2.14-linux-i686-glibc23.tar.gz
shell> cd mysql-5.5.31-ndb-7.2.14-linux-i686-glibc23
shell> cp bin/ndbd /usr/local/bin/ndbd
shell> cp bin/ndbmtd /usr/local/bin/ndbmtd
shell> cd /usr/local/bin
shell> chmod +x ndb*
配置文件内容如下，vi /etc/my.cnf

[mysqld]
ndbcluster

[mysql_cluster]
ndb-connectstring=192.168.77.46

5.安装192.168.77.54,同4

 

6.安装192.168.77.46(mgm)

解压安装包，拷文件到指定目录

shell> cd /var/tmp
shell> tar -zxvf mysql-5.5.31-ndb-7.2.14-linux2.6-i686.tar.gz
shell> cd mysql-5.5.31-ndb-7.2.14-linux2.6-i686
shell> cp bin/ndb_mgm* /usr/local/bin
shell> cd /usr/local/bin
shell> chmod +x ndb_mgm*
新建配置文件

shell> mkdir /var/lib/mysql-cluster
shell> cd /var/lib/mysql-cluster
shell> vi config.ini
配置文件config.ini内容如下：

[ndbd default]
NoOfReplicas=2
DataMemory=800M
IndexMemory=180M

[tcp default]
#portnumber=1186

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

[ndbd]
hostname=192.168.77.48
datadir=/usr/local/mysql/data
NodeId=8

[ndbd]
hostname=192.168.77.54
datadir=/usr/local/mysql/data
NodeId=4

[mysqld]
hostname=192.168.77.55

[mysqld]
hostname=192.168.77.56

7.启动顺序为: mgm->data->sql

启动mgm，在/usr/local/bin目录下执行：./ndb_mgmd -f /var/lib/mysql-cluster/config.ini --initial

启动data，在/usr/local/bin目录下执行：./ndbd

启动sql，在/usr/local/mysql/bin目录下执行： ./mysqld_safe --user=mysql &

 

8.停止：在/usr/local/bin目录下执行：./ndb_mgm -e shutdown

执行命令后，会依次关闭各节点