mysql-proxy 实现读写分离

mkdir -p /usr/local/mysql-proxy
#rm -rf /usr/local/mysql-proxy
cd /chenenhui/mysql-proxy
wget http://downloads.mysql.com/archives/get/file/mysql-proxy-0.8.5-linux-glibc2.3-x86-64bit.tar.gz

yum -y install gcc* gcc-c++* autoconf* automake* zlib* libxml* ncurses-devel* libmc rypt* libtool* flex* 

#pkgconfig*
tar xf sql-proxy-0.8.5-linux-el6-x86-64bit.tar.gz -C /usr/local/mysql-proxy/
cd /usr/local/mysql-proxy
#授权
chmod -R 775 /usr/local/mysql-proxy
chown -R mysql:mysql /usr/local/mysql-proxy


echo '
LUA_PATH="/usr/local/mysql-proxy/share/doc/mysql-proxy/?.lua"    # lua环境变量的设置
export LUA_PATH
export PATH=$PATH:/usr/local/mysql-proxy/bin     # mysql proxy 环境变量的设置
' >> /etc/profile

source /etc/profile
 

#mysql-proxy.cnf
echo '
[mysql-proxy]
daemon = true
user = mysql

proxy-skip-profiling = true
keepalive = true
;max-open-files = 2048
event-threads = 50
pid-file = /var/run/mysql-proxy.pid
log-file = /var/log/mysql-proxy.log
log-level = debug
admin-address=:4401
admin-username=admin
admin-password=passw0rd
admin-lua-script=/usr/local/mysql-proxy/lib/mysql-proxy/lua/admin.lua
proxy-address = 0.0.0.0:4040
proxy-backend-addresses = 192.168.186.143:3306
proxy-read-only-backend-addresses=192.168.186.145:3306
proxy-lua-script=/usr/local/mysql-proxy/share/doc/mysql-proxy/rw-splitting.lua
' > /usr/local/mysql-proxy/mysql-proxy.cnf

 
 
 # 启动mysql-proxy  
 mysql-proxy --defaults-file=/usr/local/mysql-proxy/mysql-proxy.cnf