MySQL-proxy 实现读写分离

实验环境:
Server1:master
Server2:slave
Server3:mysql-proxy
Fondation7:client
在做实验之前配置好server1和server2的主从复制,不再演示
Proxy的配置：

[root@server3 ~]# tar zxf mysql-proxy-0.8.5-linux-el6-x86-64bit.tar.gz
[root@server3 ~]# mv mysql-proxy-0.8.5-linux-el6-x86-64bit /usr/local/mysql-proxy
[root@server3 ~]#cd /usr/local/mysql-proxy/
[root@server3 mysql-proxy]#mkdir conf
[root@server3 mysql-proxy]#mkdri logs
[root@server3 conf]# vim mysql-proxy.conf
[mysql-proxy]
user=root
proxy-address=0.0.0.0:3306
proxy-backend-addresses=172.25.7.1:3306
proxy-read-only-backend-addresses=172.25.7.2:3306
proxy-lua-script=/usr/local/mysql-proxy/share/doc/mysql-proxy/rw-splitting.lua
log-file=/usr/local/mysql-proxy/logs/mysql-proxy.log
log-level=debug
daemon=true
keepalive=true

添加环境变量:

[root@server3 conf]