LVS
lvs-users
Google
 
Web LinuxVirtualServer.org

using persistance for mysql database servers

To: lvs-users@xxxxxxxxxxxxxxxxxxxxxx
Subject: using persistance for mysql database servers
From: Christian Joelly <christian.joelly@xxxxxxxxx>
Date: Wed, 6 Feb 2002 15:12:58 +0100
Hello!

i have some problems using lvs for load balancing between 2 mysql
database realservers.

the application framework cocoon uses database pools which opens for
example 5 connections to the lvs'd mysql server. the problem arises
when the lvs code drops the connection(s) from the lvs persistance
tables after -p [timeout] time. then the connection pool tries to use
this connections, but they have gone away. on the mysql (real) server
the connections also show up in the processlist...

is there something wrong with my usage of lvs, mysql, db connection
pools or can i define such lvs connections not to timeout after n
seconds?

thx, Chris

-- 
KNAPP Logistics Automation  http://www.knapp.com
Ing. Christian Jölly        Tel/FAX: (++43) 316 / 495 1926 / 495 394
Günter-Knapp-Straße 5-7     A-8075 Hart bei Graz

Attachment: pgp4W5hJPlXw0.pgp
Description: PGP signature

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