tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Bap <bap-a...@a1.org.uk>
Subject Re: Using multiple DataSource's for fail-over.
Date Wed, 02 Sep 2009 13:22:43 GMT
Bill,

If you are using Oracle RAC, then why dont you use a RAC JDBC URL that  
contains both nodes?
A DBCP testOnBorrow will ensure only current transactions on a node  
will fail if one of the nodes goes down, and all new requests for  
connections from the pool will "recover".

Bap.


Quoting Ognjen Blagojevic <ognjen@etf.bg.ac.rs>:

> This is interesting topic.
>
> IANA-failover-expert, but one question comes to my mind. What  
> happens when the first server is recovered? Some cached connections  
> will still point to second server, while newly created connections  
> will go to the first one?
>
> Is that acceptable?
>
> Regards,
> Ognjen
>
> Bill Davidson wrote:
>> Tomcat 6.0.20 using DBCP DataSource
>> Java 1.6.0_16
>> Oracle 10g with RAC.
>>
>> I've got two Oracle RAC nodes, mirroring each other.  My current fail-over
>> method if the primary node fails is to shut down the web servers,  
>> reconfigure
>> them to use the secondary node and restart the web servers.  Not pleasant.
>>
>> I'm thinking I can make a "FailOverDataSource" that implements DataSource
>> and wraps around DataSource's for each of the two nodes.  Its  
>> getConnection()
>> method would try to use the getConnection() from the primary node,  
>> and if that
>> fails, it would try the secondary node.  Repeat logic for other DataSource
>> methods.  Instant automagic fail-over.  I've actually written it,  
>> and it seems
>> to get a hold of both DataSource's fine.  I can't kill the primary  
>> on an active
>> busy system to do a "real" test though.
>>
>> I'm thinking I can't be the first person to think of this.  Are  
>> there any obvious
>> problems with this idea?
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
>> For additional commands, e-mail: users-help@tomcat.apache.org
>>
>>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
> For additional commands, e-mail: users-help@tomcat.apache.org
>
>


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org


Mime
View raw message