[lvs-users] MySQL Load Balancer/Cluster Connection Refused on Virtual IP

[Michael Schwartzkopff]

Am Freitag, 30. Mai 2008 12:38 schrieb Paul Bowden:
(...)
> Hi Graeme,
>
> I'm not sure if you wanted me to run tcpdump -qn host client-1 on the
> load balancers as well, but I ran it on lb1, lb2, sql1 and sql2 and
> here are the results:
>
> lb1 (which currently has the vip) is the only machine that mentions
> anything to do with my attempted telnet:
(...)

Hi,

this shows that the TCP SYN is comming into the director but is not forwarded 
to the real servers in the background.

In your first mail you showed the output of ipvs -L -n.
root at lb1:/etc/ha.d# 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.1.243:3306 wrr
 -> 192.168.1.246:3306           Route   0      0          0
 -> 192.168.1.247:3306           Route   0      0          0

Both real servers have the weight of "0" wich means "dead" or "please do not 
forward packets to this real server". That explains, why the TCP SYN is not 
forwarded to the real servers.

Have you checked you log files why ipvs is setting weight to "0". Perhaps the 
tests fail? Does the DB ldirectordb (according to the config) exists? Can you 
manually open the database and do the test?

-- 
Dr. Michael Schwartzkopff
MultiNET Services GmbH
Addresse: Bretonischer Ring 7; 85630 Grasbrunn; Germany
Tel: +49 - 89 - 45 69 11 0
Fax: +49 - 89 - 45 69 11 21
mob: +49 - 174 - 343 28 75

mail: misch at multinet.de
web: www.multinet.de

Sitz der Gesellschaft: 85630 Grasbrunn
Registergericht: Amtsgericht München HRB 114375
Geschäftsführer: Günter Jurgeneit, Hubert Martens

---

PGP Fingerprint: F919 3919 FF12 ED5A 2801 DEA6 AA77 57A4 EDD8 979B
Skype: misch42