mysql cluster 安装配置

wer2122121

Mysql Cluster安装：

软件版本：mysql-cluster-gpl-7.2.19-linux2.6-x86_64.tar.gz
mysql官方下载页面中会访问google的js，google不能访问的话，选择平台的下拉框就会失效。需要代理服务器下载。
安装环境：
Centos5.8  Linux 2.6.18-308.el5 x86_64  内存4G  非常消耗内存

10.0.12.150：管理节点
10.0.12.151：SQL节点
10.0.12.152：SQL节点
10.0.12.153：DATA节点
10.0.12.154：DATA节点

• 管理节点安装：
  
• ：管理节点
  
  

1 2 3 4 5 6 7 8 9 10 11 12

[iyunv@localhost ~]# groupadd mysql [iyunv@localhost ~]# useradd mysql-g mysql [iyunv@localhost ~]# cd /usr/local [iyunv@localhost ~]# tar –xf mysql-cluster-gpl-7.2.19-linux2.6-x86_64.tar.gz [iyunv@localhost ~]#mv mysql-cluster-gpl-7.2.19-linux2.6-x86_64  mysql [iyunv@localhost ~]#chown -Rmysql:mysql mysql [iyunv@localhost ~]# mkdir /usr/local/mysql/data [iyunv@localhost ~]# mkdir /usr/local/mysql/logs [iyunv@localhost ~]#mkdir/var/lib/mysql-cluster [iyunv@localhost ~]#cd mysql [iyunv@localhost ~]# scripts/mysql_install_db  --user=mysql --basedir=/usr/local/mysql  --datadir=/usr/local/mysql/data [iyunv@localhost ~]#vi /var/lib/mysql-cluster/config.ini

写入以下内容：

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23

[NDBD DEFAULT] NoOfReplicas=2 DataMemory=1024MB IndexMemory=1024MB MaxNoOfTables=300 MaxNoOfOrderedIndexes=500 MaxNoOfUniqueHashIndexes=500 MaxNoOfAttributes=20000 [TCP DEFAULT] portnumber=3306 [NDB_MGMD] hostname=10.0.12.150 datadir=/usr/local/mysql/data/ [NDBD] hostname=10.0.12.153 datadir=/usr/local/mysql/data/ [NDBD] hostname=10.0.12.154 datadir=/usr/local/mysql/data/ [MYSQLD] hostname=10.0.12.151 [MYSQLD] hostname=10.0.12.152

1	[iyunv@localhost ~]#

• DATA节点安装
  
• 10.0.12.153 Data节点
• 10.0.12.154 Data节点
  
  

1 2 3 4 5 6 7 8 9 10 11 12 13

[iyunv@localhost ~]# groupadd mysql [iyunv@localhost ~]# useradd mysql-g mysql [iyunv@localhost ~]# cd /usr/local [iyunv@localhost ~]# tar –xf mysql-cluster-gpl-7.2.19-linux2.6-x86_64.tar.gz [iyunv@localhost ~]#mv mysql-cluster-gpl-7.2.19-linux2.6-x86_64  mysql [iyunv@localhost ~]#chown -Rmysql:mysql mysql [iyunv@localhost ~]# mkdir /usr/local/mysql/data [iyunv@localhost ~]# mkdir /usr/local/mysql/logs [iyunv@localhost ~]#mkdir/var/lib/mysql-cluster [iyunv@localhost ~]#cd mysql [iyunv@localhost ~]# scripts/mysql_install_db  --user=mysql --basedir=/usr/local/mysql  --datadir=/usr/local/mysql/data [iyunv@localhost ~]# cpsupport-files/mysql.server /etc/init.d/mysqld [iyunv@localhost ~]#vi /etc/my.cnf

写入以下内容：

1 2 3 4 5 6 7 8 9 10 11 12

[mysqld] basedir         = /usr/local/mysql datadir         = /usr/local/mysql/data user            = mysql port            = 3306 socket          = /var/lib/mysql/mysql.sock ndbcluster ndb-connectstring=10.0.12.150 [mysql_cluster] ndb-connectstring=10.0.12.150 [NDB_MGM] connect-string=10.0.12.150

1 2 3

[iyunv@localhost ~]# chown -Rmysql:mysql /var/lib/mysql [iyunv@localhost ~]# [iyunv@localhost ~]#

• SQL节点安装
  
  

同Data节点安装

• 10.0.12.151 sql节点
• 10.0.12.152 sql节点
  
  

• Cluster启动
  
  

1、    启动管理节点

/usr/local/mysql/bin/ndb_mgmd -f/var/lib/mysql-cluster/config.ini --initial

首次启动后面加 –initial

关闭：/usr/local/mysql/bin/ndb_mgm -e shutdown

2、    启动data节点

/usr/local/mysql/bin/ndbd --initial

首次启动或者修改参数后启动需要加--initial

3、    启动sql节点

service mysqld start

关闭：service mysqld stop

启动完成后在管理节点执行/usr/local/mysql/bin/ndb_mgm

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16

ndb_mgm>show Connected toManagement Server at: localhost:1186 ClusterConfiguration --------------------- [ndbd(NDB)]     2 node(s) id=2    @10.0.12.153  (mysql-5.5.41 ndb-7.2.19, Nodegroup: 0, *) id=3    @10.0.12.154  (mysql-5.5.41 ndb-7.2.19, Nodegroup: 0) [ndb_mgmd(MGM)] 1node(s) id=1    @10.0.12.150  (mysql-5.5.41 ndb-7.2.19) [mysqld(API)]   2 node(s) id=4    @10.0.12.151  (mysql-5.5.41 ndb-7.2.19) id=5    @10.0.12.152  (mysql-5.5.41 ndb-7.2.19) ndb_mgm>

测试：在sql节点10.0.12.151进入mysql创建库testcluster，创建测试table，在10.0.12.152可以看见新建的表，mysqlcluster创建成功。