Linux下mysql集群(mysql cluster)安装配置手记

3 篇文章 0 订阅

由于公司网站流量的飞速增长,数据库负载急剧攀增,为了升级网站数据库架构,现在对MySQL Cluster(集群)进行安装测试。

 

1、准备服务器


现在,我们计划建立有6个节点的MySQL CLuster体系,两台机器复用数据节点和SQL节点,所以需要用到4台机器,分别做如下用途:

 

hostname      IP地址       应用服务
DB1         192.168.6.162     MGM
DB2         192.168.6.160     NDBD,MYSQLD
DB3         192.168.6.188     NDBD2, MYSQLD
DB4         192.168.6.191     MYSQLD

 

注意事项及其他


每个节点的操作系统都是Linux,下面的描述中将使用主机名,不再使用IP地址来表示。由于MySQL Cluster采用TCP/IP方式连接,并且节点之间的数据传输没有加密,因此这个体系最好只在单独的子网中运行,并且考虑到传输的速率,强烈建议不要跨越公网使用这个体系。所需的MySQL软件请事先在 http://dev.mysql.com/downloads 下载。实际上整个体系可以在一个单独的实体计算机上运行成功,当然了,必须设定不同的目录以及端口等,只能作为测试时使用。

 

2.安装配置管理节点(DB1)MGM

 

# groupadd mysql


# useradd -g mysql -d /usr/local/mysql/var -M mysql


# tar -zxvf mysql-cluster-gpl-7.1.3.tar.gz


# cd mysql-cluster-gpl-7.1.3

 

# ./configure --prefix=/usr/local/mysql/ --with-charset=utf8 --with-collation=utf8_general_ci --with-client-ldflags=-all-static -with-mysqld-ldflags=-all-static --enable-assembler --with-extra-charsets=complex --enable-thread-safe-client --with-big-tables --with-readline --with-ssl --with-embedded-server --enable-local-infile --with-unix-socket-path=/usr/local/mysql/tmp/mysql.sock --sysconfdir=/usr/local/mysql/etc --without-debug --with-mysqld-user=mysql --with-plugins=max

 

# make


# make install


# cd /usr/local/mysql


# mkdir mysql-cluster


# cd mysql-cluster


# vi config.ini

 

[NDBD DEFAULT]
NoOfReplicas= 2
[MYSQLD DEFAULT]
[NDB_MGMD DEFAULT]
DataDir= /usr/local/mysql/mysql-cluster
[NDB_MGMD]
HostName= 192.168.1.20
[NDBD]
HostName= 192.168.1.21
DataDir= /usr/local/mysql/mysql-cluster
[NDBD]
HostName= 192.168.1.22
DataDir= /usr/local/mysql/mysql-cluster
[MYSQLD]
HostName= 192.168.1.21
[MYSQLD]
HostName= 192.168.1.22
[MYSQLD]
HostName= 192.168.1.23

 

# ./libexec/ndb_mgmd -f /usr/local/mysql/mysql-cluster/config.ini

 

# ./bin/ndb_mgm


-- NDB Cluster -- Management Client --


ndb_mgm> show


Connected to Management Server at: localhost:1186
Cluster Configuration
---------------------
[ndbd(NDB)] 2 node(s)
id=2 (not connected, accepting connect from 192.168.1.21)
id=3 (not connected, accepting connect from 192.168.1.22)
[ndb_mgmd(MGM)] 1 node(s)
id=1 @192.168.1.20 (Version: 5.1.44)
[mysqld(API)] 3 node(s)
id=4 (not connected, accepting connect from 192.168.1.21)
id=5 (not connected, accepting connect from 192.168.1.22)
id=6 (not connected, accepting connect from 192.168.1.23)

 

可以看到ndb_mgmd 是 连上的,nbd 和 mysqld 还没有连上~

 

3.安装配置在两个数据SQL节点(DB2,DB3)ndbd mysql

 

# groupadd mysql


# useradd -g mysql -d /usr/local/mysql/var -M mysql


# tar -zxvf mysql-cluster-gpl-7.1.3.tar.gz


# cd mysql-cluster-gpl-7.1.3

 

# ./configure --prefix=/usr/local/mysql/ --with-charset=utf8 --with-collation=utf8_general_ci --with-client-ldflags=-all-static -with-mysqld-ldflags=-all-static --enable-assembler --with-extra-charsets=complex --enable-thread-safe-client --with-big-tables --with-readline --with-ssl --with-embedded-server --enable-local-infile --with-unix-socket-path=/usr/local/mysql/tmp/mysql.sock --sysconfdir=/usr/local/mysql/etc --without-debug --with-mysqld-user=mysql --with-plugins=max

 

# make

 

# make install

 

# cd /usr/local/mysql


# mkdir mysql-cluster etc


# chown root.mysql . -R


# ./bin/mysql_install_db --user=mysql

 

# vi ./etc/my.cnf

 

[mysqld]
basedir = /usr/local/mysql/
datadir = /usr/local/mysql/var
user = mysql
port = 3306
socket = /usr/local/mysql/tmp/mysql.sock
ndbcluster
ndb-connectstring=192.168.1.20
[mysql_cluster]
ndb-connectstring=192.168.1.20

 

./libexec/ndbd --initial ### 第一次启动需要 --initial 以后在启动不需要加

 

随后启动两台ndbd 节点上的 mysql 服务

 

./bin/mysqld_safe --user=mysql &

 

然后在 MGM 服务器上查看

 

./bin/ndb_mgm


-- NDB Cluster -- Management Client --


ndb_mgm> show


Cluster Configuration
---------------------
[ndbd(NDB)] 2 node(s)
id=2 @192.168.1.21 (Version: 5.1.44, Nodegroup: 0)
id=3 @192.168.1.22 (Version: 5.1.44, Nodegroup: 0, Master)
[ndb_mgmd(MGM)] 1 node(s)
id=1 @192.168.1.20 (Version: 5.1.44)
[mysqld(API)] 3 node(s)
id=4 @192.168.1.21 (Version: 5.1.44)
id=5 @192.168.1.22 (Version: 5.1.44)
id=6 (not connected, accepting connect from 192.168.1.23)

 

从上面可以看出 两个 ndbd 节点 和 ndbd 上的两个mysql 服务已经连接上了。

 

4、安装配置SQL节点(DB4)

 

# groupadd mysql


# useradd -g mysql -d /usr/local/mysql/var -M mysql


# tar -zxvf mysql-cluster-gpl-7.1.3.tar.gz


# cd mysql-cluster-gpl-7.1.3

 

# ./configure --prefix=/usr/local/mysql/ --with-charset=utf8 --with-collation=utf8_general_ci --with-client-ldflags=-all-static -with-mysqld-ldflags=-all-static --enable-assembler --with-extra-charsets=complex --enable-thread-safe-client --with-big-tables --with-readline --with-ssl --with-embedded-server --enable-local-infile --with-unix-socket-path=/usr/local/mysql/tmp/mysql.sock --sysconfdir=/usr/local/mysql/etc --without-debug --with-mysqld-user=mysql --with-plugins=max

 

# make

 

# make install

 

# cd /usr/local/mysql


# mkdir mysql-cluster etc

 


# chown root.mysql . -R


# ./bin/mysql_install_db --user=mysql

 

# vi ./etc/my.cnf

 

[mysqld]
basedir = /usr/local/mysql/
datadir = /usr/local/mysql/var
user = mysql
port = 3306
socket = /usr/local/mysql/tmp/mysql.sock
ndbcluster
ndb-connectstring=192.168.1.20
[mysql_cluster]
ndb-connectstring=192.168.1.20

 

启动 mysql 服务


# ./bin/mysqld_safe --user=mysql &

 

回到 MGM 上查看是否正常

 

./bin/ndb_mgm
-- NDB Cluster -- Management Client --
ndb_mgm> show
Cluster Configuration
---------------------
[ndbd(NDB)] 2 node(s)
id=2 @192.168.1.21 (Version: 5.1.44, Nodegroup: 0)
id=3 @192.168.1.22 (Version: 5.1.44, Nodegroup: 0, Master)
[ndb_mgmd(MGM)] 1 node(s)
id=1 @192.168.1.20 (Version: 5.1.44)
[mysqld(API)] 3 node(s)
id=4 @192.168.1.21 (Version: 5.1.44)
id=5 @192.168.1.22 (Version: 5.1.44)
id=6 @192.168.1.23 (Version: 5.1.44)

 

好了,一切正常了,现在回到 mysql 节点上 创建和删除数据看是否同步。


那么就登录 DB2 的 mysql

 

DB2 # > /usr/local/mysql/bin/mysql -uroot -p


mysql > show databases;


+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
+--------------------+
2 rows in set (0.00 sec)


mysql > create database wzzn;


Query OK, 1 row affected (0.39 sec)


mysql > show databases;


+--------------------+
| Database |
+--------------------+
| information_schema |
| wzzn |
| mysql |
+--------------------+

3 rows in set (0.01 sec)

 

好了,在看 DB3 DB4 上是否同步


DB3 # > /usr/local/mysql/bin/mysql -uroot -p


mysql > show databases;


+--------------------+
| Database |
+--------------------+
| information_schema |
| wzzn |
| mysql |
+--------------------+
2 rows in set (0.00 sec)

 

DB4 # > /usr/local/mysql/bin/mysql -uroot -p


mysql > show databases;


+--------------------+
| Database |
+--------------------+
| information_schema |
| wzzn |
| mysql |
+--------------------+
2 rows in set (0.00 sec)

 

都看到了 wzzn 数据库 安装配置完成。

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值