commons-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "G. Madhan Dennis" <mad...@isoftel.com>
Subject RE: DBCP - Redundant databases
Date Fri, 13 Feb 2004 05:12:44 GMT
Hi Dirk,

Thanks for the info. I was surfing the net today and found out this
pretty cool component called C-JDBC http://c-jdbc.objectweb.org/ . Its
still in RC status. However I think it is worth checking out. So will
try it and let you know the status.

Madhan

-----Original Message-----
From: Dirk Verbeeck [mailto:dirk.verbeeck@pandora.be] 
Sent: Friday, February 13, 2004 4:44 AM
To: Jakarta Commons Users List
Subject: Re: DBCP - Redundant databases

Currently DBCP doesn't provide any load-balancing/failover services.
There is an enhancement request:
http://issues.apache.org/bugzilla/show_bug.cgi?id=25511

But no action has been taken to implement this feature.
I would implement it by defining 2 normal datasources and then a new 
kind of datasource that does the load-balancing/failover.
Probably similar to your solution.

In the bugzilla request there is an alternative component that does 
clustering. (Didn't try it yet)

-- Dirk

G. Madhan Dennis wrote:

> Hi Everyone,
>  
> Is it possible to handle db redundancy in the Commons-DBCP? We have
two
> replicated databases. We configure DBCP to connect to the primary db.
> However if it goes down DBCP needs to reconnect to the secondary db.
How
> do I do that? I have currently arrived at a solution which involves
> using two connection pools, one for each database and alternating them
> whenever a connection fails. Is there any other way to do this?
> Thanks 
> Regards, 
> G. Madhan Dennis 
> Senior Systems Engineer 
> iSoftel India 
> Hand Phone: +91 98942 22987 
> ----------------------------------------------------------------- 
> Enabling Technologies for Carrier Services 
> Visit us at  <file:///\\www.isoftel.com> www.isoftel.com 
> ----------------------------------------------------------------- 
>  ,_, 
> (O,O) Opportunity is missed by most people, 
> (   ) because it is dressed in overalls and looks like work. 
> -"-"------------------------------------------------------------- 
>  
>  
> 



---------------------------------------------------------------------
To unsubscribe, e-mail: commons-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: commons-user-help@jakarta.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commons-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: commons-user-help@jakarta.apache.org


Mime
View raw message