mac mysql 的lb_mysql的lb集群

一：客户端：192.168.19 17.1添加默认网关：192.168.19 17.2二：路由器：192.168.18.1 16

192.168.17.2开启路由转发功能vim /etc/sysctl.conf

net.ipv4.ip_forward = 1三分发器ipvsadm-1.24-10.i386.rpm安装这个包ifconfig eth0:0 192.168.18.250/32 broadcast 192.168.18.250 up

[root@localhost Cluster]# route add -host 192.168.18.250 dev eth0:0

[root@localhost Cluster]# ipvsadm -A -t 192.168.18.250:3306 -s rr

[root@localhost Cluster]# ipvsadm -a -t 192.168.18.250:3306 -r 192.168.18.5 -g

[root@localhost Cluster]# ipvsadm -a -t 192.168.18.250:3306 -r 192.168.18.6 -g

[root@localhost Cluster]# ipvsadm-ln

-bash: ipvsadm-ln: command not found

[root@localhost Cluster]# 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.18.250:3306 rr

-> 192.168.18.26:3306            Route   1      0          0

-> 192.168.18.36:3306            Route   1      0          0四安装apache  php php-mysql将index.html    insert.php     mysql-c.php     mysql-i.html       mysql-r.php拷贝到/var/www/html这个目录下vim mysql-c.php

$con = mysql_connect("192.168.18.46","zhu","123456");

vim insert.php

$con = mysql_connect("192.168.18.46","pan","123456");

vim mysql-r.php

$con = mysql_connect("192.168.18.250","pan","123456");因为主的是写辅的是读得所以分别添加对应的mysql AB的地址注意辅助的地址因为有两个BB还要做分发所以那里的地址为虚拟的vip创建步骤看后面重启apache注意一定要安装php五mysql  A  B  B

192.168.18.46

192.168.18.36

192.168.18.26安装步骤请看以前blog

A创建两个用户mysql>  GRANT ALL PRIVILEGES ON *.* TOidentified by '123456';

mysql>  GRANT ALL PRIVILEGES ON *.* TOidentified by '123456';

mysql> flush privileges;与前面apache上得对应了B1:

vip：ifconfig lo:0 192.168.18.250/32 broadcast 192.168.2.250 up主机路由：route add�host 192.168.18.250 dev lo:0默认路由：route add default gw 192.168.18.2

echo 1 > /proc/sys/net/ipv4/conf/all/arp_ignore

echo 2 > /proc/sys/net/ipv4/conf/all/arp_announce

mysql重启B2:

vip：ifconfig lo:0 192.168.18.250/32 broadcast 192.168.2.250 up主机路由：route add�host 192.168.18.250 dev lo:0默认路由：route add default gw 192.168.18.2

echo 1 > /proc/sys/net/ipv4/conf/all/arp_ignore

echo 2 > /proc/sys/net/ipv4/conf/all/arp_announce

mysql重启