LVS
lvs-users
Google
 
Web LinuxVirtualServer.org

Re: [lvs-users] MySQL Load Balancer/Cluster Connection Refused on Virtua

To: "LinuxVirtualServer.org users mailing list." <lvs-users@xxxxxxxxxxxxxxxxxxxxxx>
Subject: Re: [lvs-users] MySQL Load Balancer/Cluster Connection Refused on Virtual IP
From: Michael Schwartzkopff <misch@xxxxxxxxxxx>
Date: Fri, 30 May 2008 12:53:49 +0200
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@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@xxxxxxxxxxx
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


<Prev in Thread] Current Thread [Next in Thread>