源码安装MysqlProxy

OS：CentOS7
MysqlProxy：0.8.5
MysqlProxy IP：192.168.1.12
MysqlMaster IP：192.168.1.13
MysqlSlave IP：192.168.1.14
Master和Slave共同用户：test  123456

Master和Slave增加共同用户

# Master执行以下sql
grant all on *.* to test@'%' identified by '123456';

安装

wget https://cdn.mysql.com/archives/mysql-proxy/mysql-proxy-0.8.5-linux-el6-x86-64bit.tar.gz
tar -xvf mysql-proxy-0.8.5-linux-el6-x86-64bit.tar.gz -C /usr/local
mv /usr/local/mysql-proxy-0.8.5-linux-el6-x86-64bit /usr/local/mysql-proxy

配置

创建mysql-proxy.cnf

vi /usr/local/mysql-proxy/mysql-proxy.cnf

# 加入以下代码：（记得替换成自己的值）
[mysql-proxy]
user=root
admin-username=test
admin-password=123456
proxy-backend-addresses=192.168.1.13
proxy-read-only-backend-addresses=192.168.1.14
proxy-lua-script=/usr/local/mysql-proxy/share/doc/mysql-proxy/rw-splitting.lua
log-file=/usr/local/mysql-proxy/mysql-proxy.log
log-level=info
daemon=true

修改权限

chmod 660 /usr/local/mysql-proxy/mysql-proxy.cnf

启动

/usr/local/mysql-proxy/bin/mysql-proxy --defaults-file=/usr/local/mysql-proxy/mysql-proxy.cnf

停止

killall mysql-proxy

温馨提示：使用killall命令需要安装psmisc

yum install psmisc -y