Centos7 Amoeba 实现 MySQL 读写分离

实验环境：

amoeba：192.168.200.116
MySQL-master:192.168.200.111
MySQL-slave1:192.168.200.112
MySQL-slave2:192.168.200.113
client:192.168.200.100

先实现MySQL数据库的主从复制，方法见上一篇。

1.安装Amoeba上安装java环境（推荐jdk1.5或1.6）

jdk安装不在叙述

[root@localhost ~]# java -version
java version "1.6.0_14"
Java(TM) SE Runtime Environment (build 1.6.0_14-b08)
Java HotSpot(TM) 64-Bit Server VM (build 14.0-b16, mixed mode)

2.安装配置Amoeba

tar文件可以自行去官网下载

[root@localhost ~]# mkdir /usr/local/amoeba
[root@localhost ~]# tar xf amoeba-mysql-binary-2.2.0.tar.gz -C /usr/local/amoeba/
[root@localhost ~]# chmod -R 755 /usr/local/amoeba/
[root@localhost ~]# /usr/local/amoeba/bin/amoeba
amoeba start|stop    //出现此行，证明配置无误

3.配置amoeba实现mysql-slave1，slave2读负载均衡

在三台MySQL服务器上对amoeba授权

MariaDB [(none)]> grant all on *.* to 'admin'@'192.168.200.%' identified by '123456';
Query OK, 0 rows affected (0.00 sec)

MariaDB [(none)]> flush privileges;
Query OK, 0 rows affected (0.00 sec)

编写amoeba.xml配置文件，设置读写分离

[root@localhost ~]# cd /usr/local/amoeba/conf/
[root@localhost conf]# cp amoeba.xml amoeba.