mysql-proxy 重启_mysql基于mysql-proxy的读写分离

mysql-proxy：192.168.20.109

master: 192.168.20.135

slave；192.168.20.137

useradd -g mysql-proxy -s /sbin/nologin

tar zxvf mysql-proxy-0.8.2-linux-glibc2.3-x86-64bit.tar.gz -C /usr/local

mv /usr/local/mysql-proxy-0.8.2-linux-glibc2.3-x86-64bit /usr/local/mysql-proxy

export PATH=$PATH:/usr/local/mysql-proxy/bin/

echo"PATH=$PATH:/usr/local/mysql-proxy/bin" >> /etc/profile

3.查看mysql-proxy --help

4.在master数据库

mysql> grant all on *.* to root@'%' identified by'密码';

5.在代理服务器上

mysql-proxy --daemon --log-level=debug --user=mysql-proxy --keepalive --log-file=/var/log/mysql-proxy.log --plugins="proxy" --proxy-backend-addresses="192.168.182.135:3306" --proxy-read-only-backend-addresses="192.168.182.137:3306" --proxy-lua-script="/usr/local/mysql-pr