《Mysql代理配置说明》由会员分享，可在线阅读，更多相关《Mysql代理配置说明（2页珍藏版）》请在金锄头文库上搜索。
1、一、软件环境 机器 1：192.168.0.108（代理机器） 机器 2：192.168.0.109（数据库机器） 系统：CentOS 6.4 64 位二、代理机器安装配置 1.准备软件安装文件： libevent-2.0.21-stable.tar.gz lua-5.1.5.tar.gz glib-2.34.3.tar.xz gettext-0.18.2.tar.gz readline-6.2.tar.gzyum -y install zlib* libffi* gcc gcc-c+ make autoconf automake libtool pkgconfig lrzsz xz ncur
2、ses* readline cmake2.安装 libevent tar -zxvf libevent-2.0.21-stable.tar.gz cd libevent-2.0.21-stable ./configure make & make install3.安装 lua tar -zxvf readline-6.2.tar.gz cd readline-6.2 ./configure make & make install tar -zxvf lua-5.1.5.tar.gz cd lua-5.1.5 vi src/Makefile（64 位系统必须修改） CFLAGS= -O2 -Wa
3、ll $(MYCFLAGS) 添加-fPIC CFLAGS= -fPIC -O2 -Wall $(MYCFLAGS) make linux make install INSTALL_TOP=/usr/local/lua cp etc/lua.pc /usr/local/lib/pkgconfig/ 4.安装 glib tar -zxvf gettext-0.18.2.tar.gz cd gettext-0.18.2 ./configure -prefix=/usr/local/gettext make & make install ln -s /usr/local/gettext/bin/*
4、/usr/local/bin/ tar -Jxvf glib-2.34.3.tar.xz cd glib-2.34.3 ./configure -prefix=/usr/local/glib make & make install 5.安装 mysql-proxy（需要 mysql 客户端） export PKG_CONFIG_PATH=$PKG_CONFIG_PATH:/usr/local/lib/pkgconfig export PKG_CONFIG_PATH=$PKG_CONFIG_PATH:/usr/local/glib/lib/pkgconfig export LUA_CFLAGS=
5、“-I/usr/local/lua/include“ export LUA_LIBS=“-L/usr/local/lua/lib -llua -ldl“ export LDFLAGS=“-L/usr/local/lib -lm“ export CFLAGS=“-I/usr/local/lib“ tar -zxvf mysql-proxy-0.8.5.tar.gz cd mysql-proxy-0.8.5 ./configure -prefix=/usr/local/mysql-proxy -with-lua=/usr/local/lua -with- mysql=/usr/local/mysq
6、l make & make install mkdir /usr/local/mysql-proxy/conf cp ./lib/*.lua /usr/local/mysql-proxy/conf6.启动测试 /sbin/iptables -I INPUT -p tcp -dport 4040 -j ACCEPT /etc/rc.d/init.d/iptables save /etc/init.d/iptables restart cd /usr/local/mysql-proxy/bin ./mysql-proxy -proxy-backend-addresses=192.168.0.109:3306 -proxy-lua- script=/usr/local/mysql-proxy/conf/rw-splitting.lua测试：mysql -h 192.168.0.108 -P 4040 -uroot -p
