lvs加MySQL读写分离_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[master：192.168.33.10，slave1IP：192.168.33.20，slave2IP：192.168.33.30]

客户端配置：

配置好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

[root@localhost ~]# ipvsadm -A -t 192.168.33.250:3306 -s rr

[root@localhost ~]# ipvsadm -a -t 192.168.33.250:3306 -r 192.168.33.20 -g

[root@localhost ~]# ipvsadm -a -t 192.168.33.250:3306 -r 192.168.33.30 -g

[root@localhost ~]# route add -host 192.168.33.250 dev eth0:0

[root@localhost ~]# route add default gw 192.168.33.60

[root@localhost ~]# ipvsadm -ln

IP Virtual Server version 1.2.1 (size=4096)

Prot LocalAddress:Port Scheduler Flags

-> RemoteAddress:Port           Forward Weight ActiveConn InActConn

TCP  192.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 install  mysql 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

[root@localhost ~]# 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

客户端访问：