安装mysql-proxy分发请求

（一）安装依赖包

lua-5.1

#tar zxvf lua-5.1.tar.gz
#cd lua-5.1

#sed -i ‘s#INSTALL_TOP= /usr/local#INSTALL_TOP= /usr/local/lua#’ Makefile
#make posix && make install

libevent-1.1a

#tar zxvf libevent-1.1a.tar.gz
#cd libevent-1.1a
#./configure –prefix=/usr/local/libevent
#make && make install

check-0.8.4

tar zxvf check-0.8.4.tar.gz
cd check-0.8.4
./configure
make
make install

(二)安装mysql客户端

#tar zxvf  mysql-5.1.35.tar.gz
#cd mysql-5.1.35
#./configure –prefix=/usr/local/mysql  –without-server
#make && make install

（三）设置环境变量

export LUA_CFLAGS="-I/usr/local/lua/include" LUA_LIBS="-L/usr/local/lua/lib -llua -ldl" LDFLAGS="-L/usr/local/libevent/lib -lm"
export CPPFLAGS="-I/usr/local/libevent/include"
export CFLAGS="-I/usr/local/libevent/include"

（四）安装mysql-proxy

#tar xvf mysql-proxy-0.6.1.tar.gz
#cd mysql-proxy-0.6.1
#./configure –prefix=/usr/local/mysql-proxy  –with-mysql=/usr/local/mysql  –with-lua
#Make && Make install

(五)创建启动脚本

#!/bin/bash
LUA_PATH="/usr/local/mysql-proxy/share/mysql-proxy/?.lua" /usr/local/mysql-proxy/sbin/mysql-proxy –proxy-backend-addresses=192.168.99.10:3306 –proxy-read-only-backend-addresses=192.168.99.20:3306 –proxy-lua-script=/usr/local/mysql-proxy/share/mysql-proxy/rw-splitting.lua >> /var/log/mysql-proxy.log &

#chmod a+x /usr/local/bin/mysql-proxy.sh

执行命令/usr/local/bin/mysql-proxy.sh启动服务

主要的命令行选项
–help-all显示所有的帮助选项
–admin-address=host:port         管理主机及端口，默认是4041
–proxy-address=host:port         代理服务器的监听地址及端口，默认4040
–proxy-read-only-address=host:port         只读连接时，代理服务器的监听地址及端口
–proxy-backend-addresses=host:port        连接真实服务器的地址及监听端口，默认是3306
–proxy-lua-script=file         指定lua脚本的名称

使用方法

mysql-proxy –proxy-backend-addresses=<master_ip> :3306\
        –proxy-read-only-backend-addresses=<slave_ip1>:3306 \
        –proxy-read-only-backend-addresses=<slave_ip2>:3306

测试 略。。。站长教学网 eduyo.com