|
Christian Joelly wrote:
>
> 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...
There's two timeouts here - the tcp timeout
http://www.linuxvirtualserver.org/Joseph.Mack/HOWTO/LVS-HOWTO-11.html#ss11.29
which you will need to increase.
You also have the persistence timeout. If you want persistence to be longer
than
your current timeout, you're just going to have to increase it.
Joe
--
Joseph Mack PhD, Senior Systems Engineer, Lockheed Martin
contractor to the National Environmental Supercomputer Center,
mailto:mack.joseph@xxxxxxx ph# 919-541-0007, RTP, NC, USA
|
