| Author |
Message
|
| MQWays |
 Posted: Thu Jun 10, 2010 7:19 am Post subject: MQ for Site-to-Site Data Replication |
 |
|
Acolyte
Joined: 20 Jan 2008
Posts: 61
|
Hello,
Has anyone used MQ for site-to-site data replication.
We have two site i.e. Active and DR. The backend database in each site is Oracle. I was thinking of doing the data replication between two sites over MQ. Bandwidth is not a constraint.
Any suggestions, experiences, recommendation.
Thanks |
|
| Back to top |
|
 |
| sumit |
| Posted: Thu Jun 10, 2010 7:28 am Post subject: |
|
|
Partisan
Joined: 19 Jan 2006
Posts: 398
|
Why don't you use Oracle to repliacte data between active and DR server?
However, search for 'duplicate message' in this site and you can find some related conversation.
_________________
Regards
Sumit |
|
| Back to top |
|
|
| MQWays |
| Posted: Thu Jun 10, 2010 7:42 am Post subject: |
|
|
Acolyte
Joined: 20 Jan 2008
Posts: 61
|
| Oracle replication needs higher level of expertise and has its own issues such as Oracle streams does not fully support BLOBs, conflicts due to bidirectional replication and has other performance related issues. |
|
| Back to top |
|
|
| Vitor |
| Posted: Thu Jun 10, 2010 7:48 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| MQWays wrote: |
| Oracle replication needs higher level of expertise |
It certainly requires Oracle expertise but not beyond the reach of a qualified DBA.
I'd also have thought (and this is an entirely subjective view) that such replication would be more straightforward than some kind of triggered process sending inserted rows as WMQ messages.
Unless you have a different, more ingenious, replacation method in mind?
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| MQWays |
| Posted: Thu Jun 10, 2010 12:54 pm Post subject: |
|
|
Acolyte
Joined: 20 Jan 2008
Posts: 61
|
Hi,
Bandwidth, performance and cost are the main factors due to which I am thinking about MQ. MQ provides guaranteed delivery and Oracle already has a product called Oracle Messaging Gateway. OMG can be specifically configured with MQ to transport messages as soon as data is entered in 'Advanced Queue' table.
Please review
http://www.ibm.com/developerworks/websphere/library/techarticles/0807_tuli/0807_tuli.html
for details on how is it configured.
Does any one have OMG and MQ Integration experience. How reliable is it. Does it really deliver an overall good solution. |
|
| Back to top |
|
|
| exerk |
| Posted: Thu Jun 10, 2010 1:14 pm Post subject: |
|
|
Jedi Council
Joined: 02 Nov 2006
Posts: 6339
|
| MQWays wrote: |
| ...MQ provides guaranteed delivery... |
No it doesn't, it provides assured delivery, which is a different animal.
_________________
It's puzzling, I don't think I've ever seen anything quite like this before...and it's hard to soar like an eagle when you're surrounded by turkeys. |
|
| Back to top |
|
|
| fatherjack |
| Posted: Thu Jun 10, 2010 1:41 pm Post subject: |
|
|
Knight
Joined: 14 Apr 2010
Posts: 522
Location: Craggy Island
|
| exerk wrote: |
| MQWays wrote: |
| ...MQ provides guaranteed delivery... |
No it doesn't, it provides assured delivery, which is a different animal. |
Only in IBM's lawyers' dictionary. 
From my dictionary:
| Quote: |
| guarantee: a promise or assurance, something that assures a particular outcome or condition |
_________________
Never let the facts get in the way of a good theory. |
|
| Back to top |
|
|
| Vitor |
| Posted: Thu Jun 10, 2010 2:02 pm Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| fatherjack wrote: |
| Only in IBM's lawyers' dictionary. |
It's an important distinction. Guaranteed delivery implies delivery within a given timescale or framework, assured does not.
So if your channel is in retry you can be assured that the messages will make it to their destination once the network is back, but you can't guarantee when that will be.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| fatherjack |
| Posted: Thu Jun 10, 2010 2:23 pm Post subject: |
|
|
Knight
Joined: 14 Apr 2010
Posts: 522
Location: Craggy Island
|
| Vitor wrote: |
| Guaranteed delivery implies delivery within a given timescale |
Which dictionary does this definition come? If you guarantee a message/mail/package/anything will get to its destination there is no implied timescale. However, if you gaurantee it will get there within 3 days there is a stated, not implied, timescale and you have the delivery company's assurance/guarantee it will be delivered within 3 days.
So according to my dictionary 'guaranteed' pretty much = 'assured'.
But was the timescale of delivery really the reason IBM changed it's claim of guaranteed to assured delivery?
_________________
Never let the facts get in the way of a good theory. |
|
| Back to top |
|
|
| Vitor |
| Posted: Thu Jun 10, 2010 3:46 pm Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| fatherjack wrote: |
| So according to my dictionary 'guaranteed' pretty much = 'assured'. |
That "pretty much" is the difference between an SLA breach (and financial penalties) and best endevours at fixing a problem.
| fatherjack wrote: |
| But was the timescale of delivery really the reason IBM changed it's claim of guaranteed to assured delivery? |
So far as I know, neither MQSeries or WMQ ever claimed guaranteed delivery. It's always been assured delivery. Certainly MQSv2.1 called itself "an assured delivery system"
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| fatherjack |
| Posted: Thu Jun 10, 2010 3:58 pm Post subject: |
|
|
Knight
Joined: 14 Apr 2010
Posts: 522
Location: Craggy Island
|
| Vitor wrote: |
| That "pretty much" is the difference between an SLA breach (and financial penalties) and best endevours at fixing a problem. |
According to who ......... IBM's lawyers maybe? But not the OED.
| Vitor wrote: |
| So far as I know, neither MQSeries or WMQ ever claimed guaranteed delivery. |
Oh yes it did. Maybe 2.0 although definitely not version 1 (ezBridgeTransact). Any historians amongst us?
_________________
Never let the facts get in the way of a good theory. |
|
| Back to top |
|
|
| gbaddeley |
| Posted: Thu Jun 10, 2010 4:53 pm Post subject: |
|
|
Jedi Knight
Joined: 25 Mar 2003
Posts: 2538
Location: Melbourne, Australia
|
|
| Back to top |
|
|
| MQWays |
| Posted: Thu Jun 10, 2010 10:16 pm Post subject: |
|
|
Acolyte
Joined: 20 Jan 2008
Posts: 61
|
|
| Back to top |
|
|
| exerk |
| Posted: Thu Jun 10, 2010 11:10 pm Post subject: |
|
|
Jedi Council
Joined: 02 Nov 2006
Posts: 6339
|
| fatherjack wrote: |
| exerk wrote: |
| MQWays wrote: |
| ...MQ provides guaranteed delivery... |
No it doesn't, it provides assured delivery, which is a different animal. |
Only in IBM's lawyers' dictionary.
From my dictionary:
| Quote: |
| guarantee: a promise or assurance, something that assures a particular outcome or condition |
|
So your unique message that can never, ever, be replicated is sent from your server to an intermediate server which then blows up with no chance of recovery - the message never makes it to the target server. Either you're going to call Ghostbusters, or sue the vendor who told you their delivery system was 'guaranteed' 
_________________
It's puzzling, I don't think I've ever seen anything quite like this before...and it's hard to soar like an eagle when you're surrounded by turkeys. |
|
| Back to top |
|
|
| exerk |
| Posted: Thu Jun 10, 2010 11:11 pm Post subject: |
|
|
Jedi Council
Joined: 02 Nov 2006
Posts: 6339
|
Yes, I've done it and it wasn't at all stressful to set up - but luckily I had a good Oracle Admin to assist 
_________________
It's puzzling, I don't think I've ever seen anything quite like this before...and it's hard to soar like an eagle when you're surrounded by turkeys. |
|
| Back to top |
|
|
|
|
