mysql-proxy安装

作为官方提供的mysql中间件，可以实现负载均衡、读写分离，但不支持大数据量的分库分表。

安装依赖包

1、安装lua
mkdir /usr/local/lua
tar zxf lua-5.1.5.tar.gz
cd lua-5.1.5
vi Makefile 
INSTALL_TOP= /usr/local改为INSTALL_TOP= /usr/local/lua
vi src/Makefile
CFLAGS= -O2 -Wall $(MYCFLAGS) 更改为 CFLAGS= -O2 -Wall -fPIC $(MYCFLAGS)
make linux
make install
2、安装libevent
tar zxf libevent-2.0.22-stable.tar.gz 
cd libevent-2.0.22-stable
./configure
make
make install

安装proxy

tar zxf mysql-proxy-0.8.5.tar.gz
cd mysql-proxy-0.8.5
./configure LDFLAGS="-L/home/mariadb/product/10.1/mariadb-1/lib -lm -ldl" LUA_CFLAGS="/usr/local/lua/bin/lua -I/usr/local/lua/include" LUA_LIBS="/usr/local/lua/lib/liblua.a" --prefix=/usr/local/mysql-proxy --with-lua --with-mysql=/home/mariadb/product/10.1/mariadb-1
make
make install

启动

命令行启动
./mysql-proxy --proxy-read-only-backend-addresses=192.168.10.3:3306 --proxy-backend-addresses=192.168.10.3:3306 --proxy-lua-script=/usr/local/mysql-proxy/lib/mysql-proxy/lua/rw-splitting.lua

脚本启动
/usr/local/mysql-proxy/bin/mysql-proxy --defaults-file=myproxy.cnf
cat myproxy.cnf
[mysql-proxy]  <span id="transmark"></span>
admin-username=myproxy  
admin-password=myproxypwd
admin-lua-script=/usr/local/mysql-proxy/lib/mysql-proxy/lua/admin.lua  
proxy-read-only-backend-addresses=192.168.10.3:3306
proxy-backend-addresses=192.168.10.2:3306
proxy-lua-script=/usr/local/mysql-proxy/lib/mysql-proxy/lua/rw-splitting.lua  
log-file=/usr/local/mysql-proxy/log/mysql-proxy.log  
log-level=debug  
daemon = 1
keepalive=1

说明：

1、需要设置myproxy.cnf权限：chmod 0660 myproxy.cnf
2、mysql-proxy默认端口4040
3、需要指定lua脚本（安装目录没有，则到安装包中找到）
4、通过参数指定主从
5、从库宕机不影响读，主库宕机，影响读
6、连接同mysql，只将端口改为4040即可