Win a copy of The Business Blockchain this week in the Cloud forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

redundant JDBC datasource for Datasource failure/suspend/overload

 
raghavendra sa
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
Our application has an requirement of handling failover/overload in backend access components. (Any suggestions other than mentioned below to handle runtime FAILURE/SUSPEND/OVERLOAD OF DATASOURCE is appreciated)

since i am a newbie in JDBC and datasource i need some clarifications on jdbc datasource.
i have a datasource DS1
associated with connectionpool CP1 , max connection capacity - 50
if i create new datasource DS2 n associate with CP1.

In runtime how many connections can be provided to our application , 100 or still 50 ?
How deeply connection objects are associated with the Datasource ?
If the above question holds good and DS1 datasource fails in runtime , do i need to transfer all the active jdbc connections to DS2, in order to perform a safe switch ?

thanks and regards
raghavendra
 
Paul Sturrock
Bartender
Posts: 10336
Eclipse IDE Hibernate Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Databases themselves often have mechanisms to manage this (e.g. Oracle RAC). Given you will need to be using whatever your database provides to maintain a hot backup I would check what is available fomr the database. If you have something like this then you only need one data source.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic