| Author |
Message
|
| MK8570 |
 Posted: Wed Jan 13, 2010 9:20 am Post subject: JDBC DataSource failover |
 |
|
Apprentice
Joined: 18 Jul 2007
Posts: 26
Location: PA, USA
|
Is it possible to provide a automatic failover between 2 different datasource.
For. eg
DS1 Configured to point to DB1
DS2 Configured to point to DB2
Message flow currently uses DS1. In case of failure or DB1 is down ,we want to switch to DS2 and get connection from DS2.
Is there a dynamic way to achieve this ? |
|
| Back to top |
|
 |
| Vitor |
| Posted: Wed Jan 13, 2010 10:03 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
Presumably you've considered & rejected putting DS1 under the control of HA software, using the DS2 as a passive node?
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| MK8570 |
| Posted: Wed Jan 13, 2010 10:32 am Post subject: JDBC Failover |
|
|
Apprentice
Joined: 18 Jul 2007
Posts: 26
Location: PA, USA
|
Yes, At this point out shop does not have the $$ to make this DB HA, As a alternative we have another standby server with a snapshot of the required database that is necessary to provide the SLA .
Is it possible to define a JDBC Datasource pool in MB ? |
|
| Back to top |
|
|
| Vitor |
| Posted: Wed Jan 13, 2010 10:46 am Post subject: Re: JDBC Failover |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| MK8570 wrote: |
| Is it possible to define a JDBC Datasource pool in MB ? |
AFAIK you can point WMB at a JDBC anything. But I don't know that far and would welcome correction by an informed source.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| wmb10 |
| Posted: Mon Jan 18, 2010 9:33 am Post subject: |
|
|
Newbie
Joined: 08 Jan 2010
Posts: 2
|
| Check if load balancing with ODBC is possbile. |
|
| Back to top |
|
|
|
|
