I have 4 servers:
- One is loadbalancer, installed keepalived and ipvsadm - LV1
- One is failover for loadbalancer, installed keepalived and ipvsadm too - LV2
- The other servers was installed httpd and mysqld. (RealServer)
LV1 load balancing for both httpd and mysql. And it's working fine.
VIP for http: 192.168.1.110
VIP for mysql: 192.168.1.111
Now I want to setup a website on RealServers , with URL is http://192.168.1.110
, and this website connect to mysql via VIP 192.168.1.111, this means real servers will connect to their mysql via load balancer (LV!).
I tried to connect mysql via VIP from real server but it cannot.
Please help me if I can make this?
Thanks so much!!