1.mysql proxy负载均衡与读写分离
1.1 下载mysql proxy
http://dev.mysql.com/downloads/mysql-proxy/
1.2 配置负载均衡
配置两台mysql数据库做负载均衡,默认端口为4040
./mysql-proxy -b 192.168.118.135:3306 -b192.168.118.137:3306
使用客户端连接mysql proxy(注意负载均衡是以connection为单位)
mysql -h 192.168.118.135 -P 4040 -u root –p
1.3 配置读写分离
配置两台mysql数据库,一台为读,一台为写
./mysql-proxy -b 192.168.118.135 -r 192.168.118.137 -s/root/soft/mysql-proxy-0.8.5-linux-el6-x86-64bit/share/doc/mysql-proxy/rw-splitting.lua