mysql cluster安装部署

一台服务器上部署mysql集群（用于测试）。IP为192.168.7.221，端口分配如下：

3311 管理节点3312 数据节点3313 数据节点3314 sql节点3315 sql节点

下载：http://pan.baidu.com/s/1sjuYRDV

1、创建组和用户、目录

groupadd mysqluseradd -g mysql mysqlmkdir -p /home/mysql/product/7.4/mysql-clustermkdir /home/mysql/mnode    #管理节点目录mkdir /home/mysql/d1node   #数据节点目录mkdir /home/mysql/d2node   #mkdir /home/mysql/s1node   #sql节点目录mkdir /home/mysql/s2node   #

2、解压并授权

tar zxvf mysql-cluster-gpl-7.4.6-linux-glibc2.5-x86_64.tar.gzcd mysql-cluster-gpl-7.4.6-linux-glibc2.5-x86_64cp -r * /home/mysql/product/cluster/7.4/mysql-clusterchown -R root:mysql /home/mysql/product/7.4/chown -R mysql:mysql /home/mysql/*node  

3、配置环境变量

vi /root/.bash_profile#MySQL Cluster Envexport MYSQL_BASE=/home/mysqlexport MYSQL_CLUSTER=$MYSQL_BASE/product/7.4/mysql-clusterexport LD_LIBRARY_PATH=$MYSQL_CLUSTER/lib:/lib:/usr/lib:/usr/local/libexport TMPDIR=/tmpexport PATH=$MYSQL_CLUSTER/bin:$PATH

添加后使之生效重连或

source /root/.bash_profile

4、开始配置集群

1）配置管理节点

cd /home/mysql/mnodevi mgm.cnf[NDBD DEFAULT]      NoOfReplicas=1DataMemory=100MIndexMemory=20M[TCP DEFAULT]portnumber=2222 #Management process options[NDB_MGMD]hostname=192.168.7.221datadir=/home/mysql/mnodePortNumber=3311[NDBD]hostname=192.168.7.221datadir=/home/mysql/d1node[NDBD]hostname=192.168.7.221datadir=/home/mysql/d2node[MYSQLD]hostname=192.168.7.221[MYSQLD]

开启管理节点（第一次启动时添加initial）

ndb_mgmd -f mgm.cnf --configdir=/home/mysql/product/7.4/mysql-cluster --initialMySQL Cluster Management Server mysql-5.6.24 ndb-7.4.6

可以查看进程或端口，是否开启

ps -ef|grep mysqlroot      3243     1  1 00:33 ?        00:00:14 ndb_mgmd -f mgm.cnf --configdir=/home/mysql/product/7.4/mysql-cluster --initialnetstat -nultap|grep 331tcp        0      0 0.0.0.0:3311                0.0.0.0:*                   LISTEN      3243/ndb_mgmd       tcp        0      0 127.0.0.1:3311              127.0.0.1:49979             ESTABLISHED 3243/ndb_mgmd       tcp        0      0 127.0.0.1:49979             127.0.0.1:3311              ESTABLISHED 3243/ndb_mgmd  

可以连接到管理节点控制台，查看所有对应节点情况（除管理节点，其它均未开启，所以是not connected）

ndb_mgm 192.168.7.221 3311-- NDB Cluster -- Management Client --ndb_mgm> showConnected to Management Server at: 192.168.7.221:3311Cluster Configuration---------------------[ndbd(NDB)]     2 node(s)id=2 (not connected, accepting connect from 192.168.7.221)id=3 (not connected, accepting connect from 192.168.7.221)[ndb_mgmd(MGM)] 1 node(s)id=1    @192.168.7.221  (mysql-5.6.24 ndb-7.4.6)[mysqld(API)]   2 node(s)id=4 (not connected, accepting connect from 192.168.7.221)id=5 (not connected, accepting connect from any host)

2）配置数据节点

more /home/mysql/d1node/data.cnf[mysqld]  port=3312skip-lockingndbclusterndb-connectstring=192.168.7.221:3311[mysql_cluster]ndb-connectstring=192.168.7.221:3311

开启服务（只有在第一次启动数据节点时使用initial）

ndbd --defaults-file=/home/mysql/d1node/data.cnf --initial2015-08-31 17:41:11 [ndbd] INFO     -- Angel connected to '192.168.7.221:3311'2015-08-31 17:41:11 [ndbd] INFO     -- Angel allocated nodeid: 2

同上配置另外一个数据节点（只需修改端口号）后开启，在管理节点控制台可以看到已启动的服务

ndb_mgm> showCluster Configuration---------------------[ndbd(NDB)]     2 node(s)id=2    @192.168.7.221  (mysql-5.6.24 ndb-7.4.6, Nodegroup: 0, *)id=3    @192.168.7.221  (mysql-5.6.24 ndb-7.4.6, Nodegroup: 1)[ndb_mgmd(MGM)] 1 node(s)id=1    @192.168.7.221  (mysql-5.6.24 ndb-7.4.6)[mysqld(API)]   2 node(s)id=4 (not connected, accepting connect from 192.168.7.221)id=5 (not connected, accepting connect from any host)

3）配置sql节点（同普通mysql）

<pre name="code" class="sql">cat /home/mysql/s1node/my.cnf[client]default-character-set=utf8[mysqld]port=3314basedir=/home/mysql/product/7.4/mysql-clusterdatadir= /home/mysql/s1nodesocket=/home/mysql/run/mysql3314.sockpid-file=/home/mysql/run/mysqld3314.pidlog-error=/var/log/mysqld3314.logcharacter-set-server=utf8ndbclusterndb-connectstring=192.168.7.221:3311

初始化

/home/mysql/product/7.4/mysql-cluster/scripts/mysql_install_db  \--basedir=/home/mysql/product/7.4/mysql-cluster --datadir=/home/mysql/s1node --port=3314 --user=mysql

启动sql服务

/home/mysql/product/7.4/mysql-cluster/bin/mysqld \--defaults-file=/home/mysql/s1node/my.cnf --user=mysql &

同样方式配置第二个sql节点，开启后查看管理节点控制台，显示所有服务器都已启动，如下：

ndb_mgm> showCluster Configuration---------------------[ndbd(NDB)]     2 node(s)id=2    @192.168.7.221  (mysql-5.6.24 ndb-7.4.6, Nodegroup: 0, *)id=3    @192.168.7.221  (mysql-5.6.24 ndb-7.4.6, Nodegroup: 1)[ndb_mgmd(MGM)] 1 node(s)id=1    @192.168.7.221  (mysql-5.6.24 ndb-7.4.6)[mysqld(API)]   2 node(s)id=4    @192.168.7.221  (mysql-5.6.24 ndb-7.4.6)id=5    @192.168.7.221  (mysql-5.6.24 ndb-7.4.6)

显而易见，mysql集群的开启顺序：管理节点--->数据节点--->sql节点