MySQL 中文网MySQL Proxy快速实现读写分离以及负载均衡1. 安装下载已经编译好的安装包，或者预编译安装包均可，在这里，使用预编译版本。[@s1.yejr.com ~]# tar zxf mysql-proxy-0.6.0-linux-rhas4-x86.tar.gz[@s1.yejr.com ~]# cd mysql-proxy-0.6.0-linux-rhas4-x86#可以看到有2个目录[@s1.yejr.com mysql-proxy-0.6.0-linux-rhas4-x86]# lssbin share[@s1.yejr.com mysql-proxy-0.6.0-linux-rhas4-x86]# mv sbin/mysql-proxy /usr/local/sbin/[@s1.yejr.com mysql-proxy-0.6.0-linux-rhas4-x86]# ls sharemysql-proxy tutorial-constants.lua tutorial-packets.lua tutorial-rewrite.lua tutorial-warnings.lua tutorial-basic.lua tutorial-inject.lua tutorial-query-time.lua tutorial-states.lua#将lua脚本放到/usr/local/share下，以备他用[@s1.yejr.com mysql-proxy-0.6.0-linux-rhas4-x86]# mv share/mysql-proxy /usr/local/share/#删除符号连接等垃圾代码[@s1.yejr.com mysql-proxy-0.6.0-linux-rhas4-x86]# strip /usr/local/sbin/mysql-proxy2. 启动编译一下启动管理脚本：[@s1.yejr.com ~]# vi /etc/init.d/mysql-proxy#!/bin/shexport LUA_PATH=/usr/local/share/mysql-proxy/?.luamode=$1if [ -z "$mode" ] ; thenmode="start"ficase $mode in'start')mysql-proxy --daemon \--admin-address=:4401 \--proxy-address=:3307 \--proxy-backend-addresses=:3306 \--proxy-read-only-backend-addresses=192.168.133.232:3306 \--proxy-read-only-backend-addresses=10.10.74.61:3306 \--proxy-lua-script=/usr/local/share/mysql-proxy/rw-splitting.lua;;'stop')killall mysql-proxy

MySQL Proxy快速实现读写分离以及负载均衡