mysql-proxy读写分离配置

MySQL Proxy：是官方提供的MySQL中间件产品可以实现负载平衡、读写分离等

1. 下载
   地址：https://downloads.mysql.com/archives/proxy/
   

2. 解压

   tar -xzvf mysql-proxy-0.8.5-linux-el6-x86-64bit.tar.gz
   

3. 创建配置文件

   vim /etc/mysql-proxy.cnf
   

   写入：

   [mysql-proxy]
   user=root
   admin-username=root
   admin-password=123456
   proxy-address=192.168.200.130:4040
   proxy-backend-addresses=192.168.200.128:3306
   proxy-read-only-backend-addresses=192.168.200.129:3306
   proxy-lua-script=/usr/local/mysql/mysql-proxy-0.8.5-linux-el6-x86-64bit/share/doc/mysql-proxy/rw-splitting.lua
   log-file=/var/log/mysql-proxy.log
   log-level=debug
   daemon=true
   keepalive=true
   

   proxy-address：当前服务器IP
   proxy-backend-addresses：mysql主服务器IP
   proxy-read-only-backend-addresses: mysql从服务器IP
   proxy-lua-script：配置规则
   daemon：配置守护

4. 修改文件权限为可读写

   chmod 660 /etc/mysql-proxy.cnf
   

   验证，也便于后续测试，将rw-splitting.lua文件最小连接数改为1

   vi /usr/local/mysql/mysql-proxy-0.8.5-linux-el6-x86-64bit/share/doc/mysql-proxy/rw-splitting.lua
   

   

5. 启动

   cd /usr/local/mysql/mysql-proxy-0.8.5-linux-el6-x86-64bit/bin/
   ./mysql-proxy --defaults-file=/etc/mysql-proxy.cnf
   

6. 通过navicat建立连接，测试