mysql-proxy安装
安装 lua
安装必要的软件
yum install libtermcap-devel ncurses-devel libevent-devel readline-devel gcc gcc-c++ make zlib-devel bzip2-devel openssl-devel wget http://www.lua.org/ftp/lua-5.3.3.tar.gz tar zxf lua-5.3.3.tar.gz cd lua-5.3.3 make linux test
下载mysql-proxy
wget http://cdn.mysql.com/archives/mysql-proxy/mysql-proxy-0.8.5-linux-el6-x86-64bit.tar.gz
tar -xzvf mysql-proxy-0.8.5-linux-el6-x86-64bit.tar.gz
mv -rf ./mysql-proxy-0.8.5-linux-el6-x86-64bit /soft/mysqlproxy
vi /etc/profile
增加
export LUA_PATH=/soft/mysqlproxy/share/mysql-proxy/*.lua
export PATH=$PATH:/soft/mysqlproxy/bin
esc
:wq 保存退出
cp -rf /soft/mysqlproxy/share/doc/mysql-proxy/*.lua /soft/mysqlproxy/share/mysql-proxy/
在/soft/mysqlproxy/bin目录下建立 startMysqlProxy.sh文件
vi /soft/mysqlproxy/bin/startMysqlProxy.sh
mysql-proxy --proxy-address=192.168.1.131:8888 --proxy-read-only-backend-addresses=192.168.1.131:3306 --proxy-backend-addresses=192.168.1.132:3306 --proxy-lua-script=/soft/mysqlproxy/share/mysql-proxy/rw-splitting.lua
:wq退出
登录授权
mysql -u root -p
grant all on *.* to 'root'@'192.168.1.131' identified by 'mysql';
grant all on *.* to 'root'@'192.168.1.132' identified by 'mysql';
测试 mysql -u root -h 192.168.1.131 -P 8888 -p
输入密码 mysql
登录成功表示成功