mysql-proxy安装

来源：互联网发布：怎么当淘宝店铺客服编辑：程序博客网时间：2024/05/21 19:41

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

安装依赖包

1、安装luamkdir /usr/local/luatar zxf lua-5.1.5.tar.gzcd lua-5.1.5vi Makefile INSTALL_TOP= /usr/local改为INSTALL_TOP= /usr/local/luavi src/MakefileCFLAGS= -O2 -Wall $(MYCFLAGS) 更改为 CFLAGS= -O2 -Wall -fPIC $(MYCFLAGS)make linuxmake install2、安装libeventtar zxf libevent-2.0.22-stable.tar.gz cd libevent-2.0.22-stable./configuremakemake install

安装proxy

tar zxf mysql-proxy-0.8.5.tar.gzcd 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-1makemake 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.cnfcat myproxy.cnf[mysql-proxy]  <span id="transmark"></span>admin-username=myproxy  admin-password=myproxypwdadmin-lua-script=/usr/local/mysql-proxy/lib/mysql-proxy/lua/admin.lua  proxy-read-only-backend-addresses=192.168.10.3:3306proxy-backend-addresses=192.168.10.2:3306proxy-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 = 1keepalive=1

说明：

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

0 0