cloudstack-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Damoder Reddy <Damoder.Re...@citrix.com>
Subject RE: DB timeouts on failover
Date Mon, 27 Jan 2014 06:27:41 GMT
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:fgaudreault@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 fgaudreault@cloudops.com
514-629-6775
- - -
CloudOps
420 rue Guy
Montréal QC  H3J 1S6
www.cloudops.com
@CloudOps_


Mime
View raw message