MQSeries.net :: View topic - Dual data source

MQSeries.net

Tech Exchange

Education

Certifications

Library

Info Center

SupportPacs

FAQÂ Â

Usergroups

RSS Feed - WebSphere MQ Support

RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Dual data source

Dual data source

« View previous topic :: View next topic »

Author

Message

smeunier

Posted: Tue Aug 11, 2009 5:38 am Post subject: Dual data source

Partisan

Joined: 19 Aug 2002
Posts: 305
Location: Green Mountains of Vermont

I have been asked to investigate the possibility of using a dual data source (Oracle) to provide a back-up data source in the event that the primary is not functional due to an outage. Essentially this would be to interpet db return codes and determine if the alternate path should be used. I'm wondering if anyone has any ideas on this for an approach? Currently the primary datasource is defined as a property of the bar file with db actions done in a compute node.

Vitor

Posted: Tue Aug 11, 2009 6:51 am Post subject: Re: Dual data source

Grand High Poobah

Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA

smeunier wrote:

I have been asked to investigate the possibility of using a dual data source (Oracle) to provide a back-up data source in the event that the primary is not functional due to an outage.

Use a software solution (HACMP or similar) to protect your Oracle db; easier and TCO will be lower.

Failing that, you could capture the exception code on error and use Try/Catch & Filter nodes to redirect the message.

FWIW faced with this scenario I've either a) used HACMP as above or b) held the messages on a backout queue.

There are undoubtably a large number of other possible solutions, many of which could be better.
_________________
Honesty is the best policy.
Insanity is the best defence.

mqjeff

Posted: Tue Aug 11, 2009 8:00 am Post subject:

Grand Master

Joined: 25 Jun 2008
Posts: 17447

Either put your single Oracle DB in an HA configuration using standard OS level HA tools, like HACMP.

Or use Oracle technologies like RAC to put your Oracle DB in an HA configuration.

Firmly tell management that any money saved by not buying those things will be consumed with extras in trying to solve this problem by hand.

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Dual data source

Jump to:

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Protected by Anti-Spam ACP