mysql cluster部署_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

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