数据库读写分离

(1)解压安装

[root@server4 ~]# tar zxf mysql-proxy-0.8.5-linux-el6-x86-64bit.tar.gz

[root@server4 ~]# mv mysql-proxy-0.8.5-linux-el6-x86-64bit /usr/local/

[root@server4 ~]# cd /usr/local/

[root@server4 local]# mv mysql-proxy-0.8.5-linux-el6-x86-64bit/ mysql-proxy

[root@server4 local]# cd mysql-proxy/bin

[root@server4 bin]# ./mysql-proxy

[root@server4 bin]# cd ..

（2）修改配置文件

[root@server4 mysql-proxy]# mkdir conf

[root@server4 mysql-proxy]# cd conf/

[root@server4 conf]# pwd/usr/local/mysql-proxy/conf

[root@server4 conf]# vim mysql-proxf.conf

修改内容如下：

******************

[mysql-proxy]

user=root

proxy-address=172.25.18.4:3306

proxy-backend-addresses=172.25.18.2:3306

proxy-read-only-backend-addresses=172.25.18.3:3306

proxy-lua-script=/usr/local/mysql-proxy/share/doc/mysql-proxy/rw-splitting.lua

plugins=proxy

log-file=/usr/local/mysql-proxy/logs/mysql-proxy.log

log-level=debug

keepalive=true

daemon=true

***************

（3）编写mysql-proxy文件

[root@server4 mysql-proxy]# pwd

/usr/local/mysql-proxy/share/doc/mysql-proxy

[root@server4 mysql-proxy]# vim rw-splitting.lua

***************

-- connection poo

lif not proxy.global.config.rwsplit then

proxy.global.config.rwsplit = {

min_idle_connections = 1, ##最小连接数

max_idle_connections = 2, ##最大连接数

is_debug = false

***************

（4）配置logs目录

[root@server4 mysql-proxy]# pwd

/usr/local/mysql-proxy

[root@server4 mysql-proxy]# mkdir logs

[root@server4 logs]# chmod 660 /usr/local/mysql-proxy/conf/mysql-proxf.conf

[root@server4 logs]# /usr/local/mysql-proxy/bin/mysql-proxy --defaults-file=/usr/local/mysql-proxy/conf/mysql-proxf.conf