On Tue, Dec 11, 2007 at 11:41:58AM +0100, [EMAIL PROTECTED] wrote: > > -------- Original-Nachricht -------- > > Datum: Tue, 11 Dec 2007 14:05:24 +0900 > > Von: Simon Horman <[EMAIL PROTECTED]> > > An: General Linux-HA mailing list <[email protected]> > > Betreff: Re: [Linux-HA] ldirectord mysql TIME_WAIT > > > On Tue, Dec 11, 2007 at 05:16:02AM +0100, Jan-Michael Thölken wrote: > > > Hello, > > > > > > here is my ldirectord config for mysql: > > > > > > virtual = 192.168.0.110:3306 > > > service = mysql > > > real = 192.168.0.147:3306 gate > > > real = 192.168.0.148:3306 gate > > > checktype = negotiate > > > login = "ldirector" > > > passwd = "ldirectorpassword" > > > database = "ldirectordb" > > > request = "SELECT * FROM connectioncheck" > > > scheduler = sh > > > > > > > > > when I start heartbeat and ldirectord I got hundrets of TIME_WAITs. > > > here is my netstat output: > > > > > > tcp 0 0 192.168.0.145:54425 192.168.0.148:mysql > > TIME_WAIT > > > tcp 0 0 192.168.0.145:54407 192.168.0.148:mysql > > TIME_WAIT > > > tcp 0 0 192.168.0.145:54401 192.168.0.148:mysql > > TIME_WAIT > > > tcp 0 0 192.168.0.145:54413 192.168.0.148:mysql > > TIME_WAIT > > > tcp 0 0 192.168.0.145:54467 192.168.0.148:mysql > > TIME_WAIT > > > tcp 0 0 192.168.0.145:54473 192.168.0.148:mysql > > TIME_WAIT > > > tcp 0 0 192.168.0.145:34939 192.168.0.147:mysql > > TIME_WAIT > > > tcp 0 0 192.168.0.145:35053 192.168.0.147:mysql > > TIME_WAIT > > > > > > > > > so, every check that ldirectord does, a new TIME_WAIT appears. > > > > > > i use arp_ignore for the LVS. > > > > > > Can someone help me please? > > > > At a guess, have you set up the VIP and handled the arp problem on the > > real-servers? > > > > Yes i use arp_ignore etc. at the real servers. For my http and https servers > this works well with lditectord. The Problem occurs only with mysql :(
Can you confirm that mysql will accept connections to the VIP? Perhaps it only accepting connections to the RIP of each real-server, 192.168.0.148 and 192.168.0.147 respectively. -- Horms _______________________________________________ Linux-HA mailing list [email protected] http://lists.linux-ha.org/mailman/listinfo/linux-ha See also: http://linux-ha.org/ReportingProblems
