MySQL Cluster with Redundant Load balancing
I've been trying to get this load balancing working for a while now but completely stumped.
All servers are virtual machines running Centos5
My Setup is,
1 X MySQL management server
2 X MySQL Cluster nodes
2 X Load Balancers
The MySQL Cluster works perfectly and the heartbeat monitors of the loadbalancers works.
My issue is when I try and connect to the Virtual IP it says
Error 2003 (HY000): Can't connect to MySQL server on '192.168.12.210' (110).
when I run ip addr sh seth0 I get
2: seth0: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc pfifo_fast qlen 1000
link/ether 00:15:5d:0f:73:0a brd ff:ff:ff:ff:ff:ff
inet 192.168.12.212/24 brd 192.168.12.255 scope global seth0
inet 192.168.12.210/24 brd 192.168.12.255 scope global secondary seth0
inet6 fe80::215:5dff:fe0f:730a/64 scope link
valid_lft forever preferred_lft forever
and when I run ldirectord ldirectord.cf status
ldirectord for /etc/ha.d/ldirectord.cf is running with pid: 2430
and I know the nodes are ready because ipvsadm -L -n
IP Virtual Server version 1.2.1 (size=4096)
Prot LocalAddress:Port Scheduler Flags
-> RemoteAddress:Port Forward Weight ActiveConn InActConn
TCP 192.168.12.210:3306 wrr
-> 192.168.12.215:3306 Route 1 0 0
-> 192.168.12.214:3306 Route 1 0 0
The only clue I can see as to why this isn't working is the the load balancer isn't listening on port 3306.
netstat -nap | grep 3306 shows lots of connections to the MySQL cluster, I presume testing it's available.
The firewall is disabled so it should just be forwarding the traffic. Can someone help me before I go crazy please?