mysql主从复制之读写分离(mysql-proxy)

mysql主从复制：读写分离mysql-proxy
代理机：

tar zxf mysql-proxy-0.8.5-linux-el6-x86-64bit.tar.gz -C /usr/local	#安装
/cd /usr/local/
ln -s mysql-proxy-0.8.5-linux-el6-x86-64bit mysql-proxy

[root@server5 mysql-proxy]# mkdir conf	#手动建立配置文件目录

vim mysql-proxy.conf
[mysql-proxy]
proxy-address=0.0.0.0:3306
proxy-backend-addresses=172.25.1.3:3306
proxy-read-only-backend-addresses=172.25.1.4:3306
proxy-lua-script=/usr/local/mysql-proxy/share/doc/mysql-proxy/rw-splitting.lua
pid-file=/usr/local/mysql-proxy/log/mysql-proxy.pid
plugins=proxy
log-file=/usr/local/mysql-proxy/log/mysql-proxy.log
log-level=debug
keepalive=true
daemon=true

vim /usr/local/mysql-proxy/share/doc/mysql-proxy/rw-splitting.lua
#确定lua脚本在并更改
min_idle_connections = 1,	#最小一个最大两个才会启动读写分离
max_idle_connections = 2,

chmod 600 /usr/local/mysql-proxy/conf/mysql-proxy.conf
/usr/local/mysql-proxy/bin/mysql-proxy --defaults-file=/usr/local/mysql-proxy/conf/mysql-proxy.conf		#重启
cat /usr/local/mysql-proxy/log/mysql-proxy.log	#查看是否成功

主：

grant insert,update,select on *.* to wjj@'%' identified by 'redhat';		#重新授权新用户
flush privileges;	#刷新

测试：

mysql -h 172.25.1.5 -uroot -predhat在真机连接代理
insert into userinfo values('westos-jj','11111');
在真机上读写，判断数据主从库都会写入
insert into userinfo values('westos-jj','66666');
stop slave;		关闭从数据库
select * from userinfo;

---