1、使用mysql-proxy设置读写分离
配置mysql-proxy,事先要装libevent
[php]wget http://www.lua.org/ftp/lua-5.1.4.tar.gz
tar zxf lua-5.1.4.tar.gz
cd lua-5.1.4
./configure
make
make install
wget http://dev.mysql.com/get/Downloads/MySQL-Proxy/mysql-proxy-0.8.0.tar.gz/from/http://mysql.cdpa.nsysu.edu.tw/
tar zxf mysql-proxy-0.8.0.tar.gz
./configure --prefix=/usr/local/mysqlproxy
make
make install
mkdir /data/soft/mysql-proxy
mv mysql-proxy-0.8.0-freebsd7-x86-32bit/* /data/soft/mysql-proxy[/php]
编辑 .cshrc增加/data/soft/mysql-proxy/bin到path环境变量最后面
[php]source ~/.cshrc[/php]
下载rw-splitting-yt.lua放到/data/soft/mysql-proxy/下
执行:
[php]mysql-proxy -b 192.168.8.42:3306 -r 192.168.8.43:3306 --proxy-lua-script=rw-splitting-yt.lua[/php]
测试:
[php]mysql -u root -ppassword -P 4040 -h 192.168.8.42 -e "show databases"(测试的时候需多次执行)[/php]
2、嵌入防注入攻击脚本:http://code.google.com/p/mysql-ids