Mysql读写分离Mysql-Proxy配置

#tar –zxvf lua-5.2.0.tar.gz –C /usr/local

#cd /usr/local

#mv lualua-5.2.0 lua

#cd /usr/local/lua

#vi Makefile，修改INSTALL_TOP= /usr/local/lua

#在CFLAGS里加上-fPIC，因为我在64位机上编译出现了“relocations”错误

#make PLATFORM   

#makegeneric （如果编译不通过有可能是gcc编译器没安装）

#makeinstall

#重要：让pkg-config找到自己编译的库在哪里

#export PKG_CONFIG_PATH=$PKG_CONFIG_PATH:/usr/local/lib/pkgconfig

#tar –mysql-proxy-0.8.2.tar.gz –C /usr/local

#cd /usr/local

#mv mysql-proxy-0.8.2 mysql-proxy

#cd /usr/local/mysql-proxy

#./autogen.sh

#./configure

# make

# make install

# exportPATH=$PATH:/usr/local/mysql/mysql-proxy/sbin/

# tar –vxzf mysql-proxy-0.8.2-linux-rhel5-x86-64bit.tar.gz–C /usr/local

# cd /usr/local

# mv mysql-proxy-0.8.2-linux-rhel5-x86-64bit mysql-proxy

# cd /usr/local/mysql-proxy

# vim ~/.bash_profile  

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

export PATH

     # wget -c http://customcode.googlecode.com/files/mysql-proxy

      # cp mysql-proxy  /etc/init.d/mysql-proxy

# vim /etc/init.d/mysql-proxy

   PROXY_PATH=/usr/local/mysql-proxy/bin

   :set fileformat=unix

# exportPATH=$PATH:/usr/local/mysql/mysql-proxy/sbin/

# chmod 755 /etc/init.d/mysql-proxy   

# chkconfig mysql-proxy on

# vi /etc/sysconfig/mysql-proxy

     # options to mysql-proxy   

     # do not remove --daemon   

     PROXY_OPTIONS=

     "--proxy-read-only-backend-addresses=192.168.1.103:3306

     --proxy-backend-addresses=192.168.1.60:3306  

     --proxy-lua-script=/usr/local/mysql-proxy/share/doc/mysql-proxy/rw-splitting.lua&"

#cp /usr/local/mysql-proxy/bin/mysql-proxy/usr/local/sbin  

#/etc/init.d/mysql-proxy start

#/etc/init.d/iptables stop    (一定要关闭防火墙)

修改读写分离lua脚本

默认最小4个最大8个以上的客户端连接才会实现读写分离, 现改为最小1个最大2个:

# vi  /usr/local/Mysql Proxy/share/doc/MysqlProxy/rw-splitting.lua  

         connection pool  

        if not proxy.global.config.rwsplit then  

               proxy.global.config.rwsplit = {  

                       min_idle_connections = 1,  

                       max_idle_connections = 2,  

                       is_debug = true   

                }        

        end