[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]

[Linux-cluster] Re: [SOLVED] problem with heartbeat + ipvs

Was missing the DBD::mysql module so the connectioncheck was failing and setting weight to 0.

only noticed this when i ran ldirector in debug mode.

On Wed, Jul 1, 2009 at 5:24 PM, Brett Cave <brettcave gmail com> wrote:
hi all,

have a problem with HA / LB system, using heartbeat for HA and ldirector / ipvs for load balancing.

When the primary node is shut down or heartbeat is stopped, the migration of services works fine, but the loadbalancing does not work (ipvs rules are active, but connect connect to HA services). Configs on primary and secondary are the same:

primary ldirectord::ldirectord.cf

virtual =
       service = mysql
       real = gate 1000
       checktype, login, passwd, database, request values all set
       scheduler = sed

ip_forward is enabled (checked via /proc, configured via sysctl)

network configs are almost the same except for the IP address (using a bonded interface in active/passive mode)
have set iptables policies to ACCEPT with rules that would not block the traffic (99.99% sure on this).

if i try connect from a server such as, i cannot connect if the secondary is up:
[user someserver]$ mysql -h
ERROR 2003 (HY000): Can't connect to MySQL server on '' (111)

perror shows that 111 is Connection Refused

running a sniffer on the secondary HA box, i dont see the tcp 3306 packets coming in.

the arp_ignore / arp_announce kernel params are configured on teh real server, HA ip address is added on a /32 subnet to the lo interface, etc, etc.... (everything works 100% when primary is up).

sure it is something i have overlooked, any idea's?

[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]