You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@cloudstack.apache.org by Francois Gaudreault <fg...@cloudops.com> on 2014/01/23 16:33:50 UTC
DB timeouts on failover
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_
Re: DB timeouts on failover
Posted by Shanker Balan <sh...@shapeblue.com>.
On 27-Jan-2014, at 11:57 am, Damoder Reddy <Da...@citrix.com> wrote:
> 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.
Thats wonderful news. Looking forward to testing database HA in 4.3.
Thanks.
--
@shankerbalan
M: +91 98860 60539 | O: +91 (80) 67935867
shanker.balan@shapeblue.com | www.shapeblue.com | Twitter:@shapeblue
ShapeBlue Services India LLP, 22nd floor, Unit 2201A, World Trade Centre, Bangalore - 560 055
Need Enterprise Grade Support for Apache CloudStack?
Our CloudStack Infrastructure Support<http://shapeblue.com/cloudstack-infrastructure-support/> offers the best 24/7 SLA for CloudStack Environments.
Apache CloudStack Bootcamp training courses
**NEW!** CloudStack 4.2.1 training<http://shapeblue.com/cloudstack-training/>
18th-19th February 2014, Brazil. Classroom<http://shapeblue.com/cloudstack-training/>
17th-23rd March 2014, Region A. Instructor led, On-line<http://shapeblue.com/cloudstack-training/>
24th-28th March 2014, Region B. Instructor led, On-line<http://shapeblue.com/cloudstack-training/>
16th-20th June 2014, Region A. Instructor led, On-line<http://shapeblue.com/cloudstack-training/>
23rd-27th June 2014, Region B. Instructor led, On-line<http://shapeblue.com/cloudstack-training/>
This email and any attachments to it may be confidential and are intended solely for the use of the individual to whom it is addressed. Any views or opinions expressed are solely those of the author and do not necessarily represent those of Shape Blue Ltd or related companies. If you are not the intended recipient of this email, you must neither take any action based upon its contents, nor copy or show it to anyone. Please contact the sender if you believe you have received this email in error. Shape Blue Ltd is a company incorporated in England & Wales. ShapeBlue Services India LLP is a company incorporated in India and is operated under license from Shape Blue Ltd. Shape Blue Brasil Consultoria Ltda is a company incorporated in Brasil and is operated under license from Shape Blue Ltd. ShapeBlue is a registered trademark.
RE: DB timeouts on failover
Posted by Damoder Reddy <Da...@citrix.com>.
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_
Re: DB timeouts on failover
Posted by Francois Gaudreault <fg...@cloudops.com>.
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_