Mysql數據庫讀寫分離簡單配置 環境：
Master：192.168.71.128 mysql-sql-node1 Slave：192.168.71.140 mysql-data-node1 Mysql-Proxy：192.168.71.138 mysql-mgm-node rpm -q libevent glib2 pkgconfig libtool mysql-devel查看系統是否已安裝以上包，如未安裝，使用yum install 安裝。
yum install -y libtermcap-devel ncurses-devel libevent-devel readline-devel gcc-c++
一、下載程序：
wget http://www.lua.org/ftp/lua-5.1.4.tar.gz wget http://gd.tuwien.ac.at/db/mysql/Downloads/MySQL-Proxy/mysql-proxy-0.6.0.tar.gz wget http://www.monkey.org/~provos/libevent-1.4.13-stable.tar.gz
二、安裝lua：
[root@mailtest /software]# tar zxvf lua-5.1.4.tar.gz [root@mailtest lua-5.1.4]# cd lua-5.1.4 [root@mailtest lua-5.1.4]# # vi Makefile 修改： INSTALL_TOP= /usr/local/lua [root@mailtest lua-5.1.4]# make && make linux && make install 設置環境變量 [root@mailtest lua-5.1.4]# export LUA_CFLAGS="-I/usr/local/lua/include" LUA_LIBS="-L/usr/local/lua/lib -llua -ldl" LDFLAGS="-L/usr/local/libevent/lib -lm" [root@mailtest lua-5.1.4]# export CPPFLAGS="-I/usr/local/libevent/include" [root@mailtest lua-5.1.4]# export CFLAGS="-I/usr/local/libevent/include"
三、安裝 libevent：
tar zvxf libevent-1.4.13-stable.tar.gz cd libevent-1.4.13-stable ./configure --prefix=/usr/local/libevent make && make install
四、安裝mysql-proxy：
./configure --prefix=/usr/local/mysql-proxy --with-mysql=/usr/local/mysql --with-lua
make && make install
啟動：
/usr/local/mysql-proxy/sbin/mysql-proxy --proxy-read-only-backend-addresses=192.168.71.140:3306 --proxy-backend-addresses=192.168.71.128:3306 --proxy-lua-
script=/usr/local/mysql-proxy/share/mysql-proxy/rw-splitting.lua &
查看進程：
netstat -ntlp | grep mysql
編輯啟動腳本：
vi /etc/init.d/mysql-proxy
#!/bin/bash
PRODIR=/usr/local/mysql-proxy
LUA_PATH=$PRODIR/share/mysql-proxy
start(){
$PRODIR/sbin/mysql-proxy --proxy-read-only-backend-addresses=192.168.71.140:3306 --proxy-backend-addresses=192.168.71.128:3306 --proxy-lua-
script=/usr/local/mysql-proxy/share/mysql-proxy/rw-splitting.lua &
>>$PRODIR/mysql-proxy.log &
}
stop(){
kill $(pidof mysql-proxy)
if [ $? -ne 0 ];then
kill -9 $(pidof mysql-proxy)
fi
}
case "$1" in
start)
start
;;
stop)
stop
;;
restart)
stop
start
;;
*)
echo $"Usage: $0 {start|stop|restart}"
esac
修改權限：
chmod +x /etc/init.d/mysql-proxy
/etc/init.d/mysql-proxy start
測試：
在MySQL-Master 上創建測試數據庫和用戶。
mysql> create database unixhot;
mysql> GRANT ALL PRIVILEGES ON king.* to proxytest@'%' identified by 'bobo365';
連接測試
[root@MySQL-Proxy ~]# mysql -h 192.168.71.138 -P 4040 -u proxytest -p
輸入密碼即可登錄。
mysql> show processlist;
+----+-----------+----------------------+------+---------+------+-------+------------------+
| Id | User | Host | db | Command | Time | State | Info |
+----+-----------+----------------------+------+---------+------+-------+------------------+
| 14 | proxytest | 192.168.71.138:17350 | NULL | Sleep | 2 | | NULL |
| 15 | proxytest | 192.168.71.138:17355 | NULL | Query | 0 | NULL | show processlist |
| 16 | proxytest | 192.168.71.138:17358 | NULL | Sleep | 2 | | NULL |
+----+-----------+----------------------+------+---------+------+-------+------------------+
3 rows in set (0.01 sec)
