On Wed, Jul 27, 2011 at 11:55:17AM +0000, Manoj Kumar wrote: > Hi Team, > > We have setup 2 Mysql Master -2 replication and frontend by the Haproxy. We > are using one Master for all write/read also and second Master is as backup > in Haproxy. But we are getting some issue when we connect Mysql using Haproxy > and wait for sometime Haproxy automatically close the session even we changed > timeout client 1800000. but when we connect to Mysql directly (without using > Haproxy) it is working fine. We want to keep connection open with Mysql > atleat 1 hours. Please guide me.
One hour is 3600s = 3600000 ms. You configured half of it. Probably you just need to change this value. Also, please set your "timeout server" to the same value, I don't see it set at all and you should see a warning when starting your service. Regards, Willy
