Apache+Lvs+Mysql读写分离
此次实验是基于mysql-abb基础上，apache数据实现读写分离，写走master，读通过分发器走slave1和slave2.
环境：Linux5.5-OS
客户端IP:192.168.18.113,route：192.168.18.73 和192.168.33.60
ApacheIP:192.168.33.50,分发器IP：192.168.33.40，虚拟vip：192.168.33.250
mysql
客户端配置：
配置好IP地址，添加网关
route add default gw 192.168.18.73
route配置：
配置好IP地址，设置好路由转发。
echo 1 > /proc/sys/net/ipv4/ip_forward
分发器配置：虚拟VIP：192.168.33.250
安装 yum install ipvsadm -y
# ipvsadm -A -t 192.168.33.250:3306 -s rr
# ipvsadm -a -t 192.168.33.250:3306 -r 192.168.33.20 -g
# ipvsadm -a -t 192.168.33.250:3306 -r 192.168.33.30 -g
# route add -host 192.168.33.250 dev eth0:0
# route add default gw 192.168.33.60
# ipvsadm -ln
IP Virtual Server version 1.2.1 (size=4096)
Prot LocalAddress:Port Scheduler Flags
-> RemoteAddress:Port Forward Weight ActiveConn InActConn
TCP192.168.33.250:3306 rr
-> 192.168.33.30:3306 Route 1 0 0
-> 192.168.33.20:3306 Route 1 0 0
mysql-abb配置：
yum installmysql mysql-server
mysql-abb配置参考上篇博客。
在master上创建用户
mysql> GRANT all privileges ON *.* TO 'tom'@'%' identified by '123';
mysql> flush privileges;
在slave1配置，slave2和slave1一样
ifconfig lo:0 192.168.33.250/32 broadcast 192.168.33.250 up
route add -host 192.168.33.250 dev lo:0
echo 1 > /proc/sys/net/ipv4/conf/all/arp_ignore
echo 2 > /proc/sys/net/ipv4/conf/all/arp_announce
# route add default gw 192.168.33.60
Apache配置：
yum install httpd php php-mysql -y
把mysql-w-r.tar.gz软件包解压到/var/www/html下
vim mysql-c.php（写）
$con = mysql_connect("192.168.33.10","tom","123");
vim insert.php（写）
$con = mysql_connect("192.168.33.10","tom","123");
vim mysql-r.php（读）
$con = mysql_connect("192.168.33.250","tom","123");
重启 /etc/init.d/httpd restart
客户端访问：
页:
[1]