Hi Francois, In current Cloud Stack versions there is no way to tell management servers that wait/reconnect for some time without fencing the management server if it sees a Db Connection failure.
Also the default connection-timeout parameters for a mysql database is lying with mysql configuration file my.cnf in which we can use the following property to set the default connection timeout. "connect-timeout=seconds" The default value is 10 seconds for this property. PS : We are coming with a proper Database HA in 4.3, where we are using Mysql Connector's parameters to achieve this. Thanks & Regards Damodar/ -----Original Message----- From: Francois Gaudreault [mailto:fgaudrea...@cloudops.com] Sent: Friday, January 24, 2014 9:10 PM To: dev@cloudstack.apache.org Subject: Re: DB timeouts on failover Anyone? :S On 1/23/2014, 10:33 AM, Francois Gaudreault wrote: > Hi, > > There was a thread on the users mailing list around the DB connection > timeouts when the underlaying MySQL active/passive cluster changes > master. The solution so far is to use a crontab to monitor if the > server is crashed. > > I'm not too familiar with the tomcat or cloudstack configs, but is > there any jdbc settings or timeouts we can tweak? > -- Francois Gaudreault Architecte de Solution Cloud | Cloud Solutions Architect fgaudrea...@cloudops.com 514-629-6775 - - - CloudOps 420 rue Guy Montréal QC H3J 1S6 www.cloudops.com @CloudOps_
