数据库读写分离
三台服务器:
大体不说了,请参考网址:
http://www.cnblogs.com/gaizai/archive/2012/11/21/2780816.html
sudo mysql-proxy \
--proxy-read-only-backend-addresses=192.168.13.220:3306 \
--proxy-backend-addresses=192.168.13.95:3306 \
--proxy-lua-script=/usr/share/mysql-proxy/rw-splitting.lua \
--admin-username=root \
--admin-password=123456 \
--admin-lua-script=/usr/share/mysql-proxy/admin.lua \
> /var/log/mysql-proxy/mysql-proxy.log &