Am 13.12.2007 um 05:34 schrieb Simon Horman:
On Wed, Dec 12, 2007 at 01:38:30PM +0100, Jan-Michael Thölken wrote:
Am 12.12.2007 um 03:59 schrieb Simon Horman:
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.
Loadbalancing is working, that means die VIP accept connections.
The problem is, that for every negatiote-check a new TIME_WAIT
appears.
When you say load balancing is working what do you mean?
Are connections from end-users to VIP:mysql working?
If not it is possible that the real-servers are not
accepting connections made to VIP:mysql. This is because
ldirectord actually checks RIP:mysql not VIP:mysql as checking
the latter is rather tricky to achieve.
all connections are working :) but:
every RIP:mysql-check ends in a TIME_WAIT connection as you can see
as follow
lb2:~# netstat
Aktive Internetverbindungen (ohne Server)
Proto Recv-Q Send-Q Local Address Foreign Address
State
tcp 0 0 192.168.0.146:54578 192.168.0.148:mysql
TIME_WAIT
tcp 0 0 192.168.0.146:54590 192.168.0.148:mysql
TIME_WAIT
tcp 0 0 192.168.0.146:54584 192.168.0.148:mysql
TIME_WAIT
tcp 0 0 192.168.0.146:54566 192.168.0.148:mysql
TIME_WAIT
tcp 0 0 192.168.0.146:54572 192.168.0.148:mysql
TIME_WAIT
tcp 0 0 192.168.0.146:54644 192.168.0.148:mysql
TIME_WAIT
tcp 0 0 192.168.0.146:54650 192.168.0.148:mysql
TIME_WAIT
tcp 0 0 192.168.0.146:54626 192.168.0.148:mysql
TIME_WAIT
tcp 0 0 192.168.0.146:54638 192.168.0.148:mysql
TIME_WAIT
tcp 0 0 192.168.0.146:54632 192.168.0.148:mysql
TIME_WAIT
there are about 300 of this connections but only for the mysql not
for http or https.
every mysql-check leaves a TIME_WAIT connection.
if i disable the negotiate check and change it to ping, it works and
there are no more TIME_WAITs.
the second strange thing on both loadbalancer is, both have a average
load of one. the active and the passive
and there is no traffic.
--
Horms
_______________________________________________
Linux-HA mailing list
[email protected]
http://lists.linux-ha.org/mailman/listinfo/linux-ha
See also: http://linux-ha.org/ReportingProblems
_______________________________________________
Linux-HA mailing list
[email protected]
http://lists.linux-ha.org/mailman/listinfo/linux-ha
See also: http://linux-ha.org/ReportingProblems
