Re: Replication Advice Needed
- From: Sandeep Dubey <dubey.sandeep@xxxxxxxxx>
- To: cmarquez@xxxxxxxxxxxxxxxx
- Date: Fri, 23 Sep 2005 12:47:41 -0400
Charlotte,
If there is no DML at remote database use MM and your life is very easy.
If there will be DML at remote you have choice of using multi master
AR or streams. Choose one where you are more confident. If I have to
learn both, it would be streams.
The Streams architecture is lot more flexible than Oracle
Replication's. This leads me to suspect that Oracle will be pushing
Streams over Replication in subsequent releases, so I would expect new
features in Streams, like DDL changes, that aren't in Oracle
Replication. Realistically, though, I don't expect any serious
movement away from Replication for at least a few releases, so I
wouldn't tend to be overly concerned on this front.
Streams replication is log based. Capture process catpures DDL and DML
changes. So no additional overhead on user transactions. (Mutil maser
uses internal trigger and this will get fired for each DML. There's a
slight overhead on user transactions)
Oracle Replication is a significantly more mature product-- it is
quite usable with older databases. Oracle Streams is a much newer
technology and is only usable among different 9i or higher databases.
Most competent Oracle developers and DBA's are familiar with Oracle
Replication, while many fewer have any real experience with Streams.
Regards
Sandeep
On 9/23/05, Marquez, Chris <cmarquez@xxxxxxxxxxxxxxxx> wrote:
>
>
> Charlotte,
>
> Very quickly...
>
> I would use Multi Master Advanced Replication for this.
> Multi Master Replication is perfect for "small-ish / low-volume tables"
> with little dependencies where data changes happen infrequently and
> on one database MOST/ALL of the time
>
> I would stay far away from "synchronous" Replication...just run
> the "push" and "purge" jobs say every five minutes...unless you
> really need real time changes at both ends.
>
> Having sad all of this I have no real experience with Streams and
> maybe some here will say that it is just as well.
>
> If you go with Multi Master Replication I can send you some personal notes.
>
> Be forewarned that Multi Master Advanced Replication is not with
> administration head aches as is *ANY* transaction based data synchronization
> option/tool.
>
>
> hth
>
> Chris Marquez
> Oracle DBA
>
>
> -----Original Message-----
> From: oracle-l-bounce@xxxxxxxxxxxxx on behalf of Charlotte Hammond
> Sent: Fri 9/23/2005 10:55 AM
> To: ORACLE-L
> Subject: Replication Advice Needed
>
> Hi All,
>
> We need to keep 5 (small-ish / low-volume) tables on a
> remote database in sync with those in the local
> database. We want synchronous updates of the remote
> tables when the network allows but we also want to
> apply queued transactions after recovery from a
> network failure such that no transactions are ever
> lost (assuming the local database to be "unbreakable"
> :-)
>
> I'm thinking of advanced replication or streams but
> unfortunately I don't have any experience in either.
> I know this is going to require lots of reading and
> experimenting but I was hoping to short-circuit this
> by at least focusing on the right technology to start
> with!: what sounds like the best fit - AR or streams?
> (This is on 10g)
>
> Thank you all in advance for any help
>
> Charlotte
>
>
>
>
>
> __________________________________
> Yahoo! Mail - PC Magazine Editors' Choice 2005
> http://mail.yahoo.com
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
>
> -----Original Message-----
> From: oracle-l-bounce@xxxxxxxxxxxxx on behalf of Charlotte Hammond
> Sent: Fri 9/23/2005 10:55 AM
> To: ORACLE-L
> Subject: Replication Advice Needed
>
> Hi All,
>
> We need to keep 5 (small-ish / low-volume) tables on a
> remote database in sync with those in the local
> database. We want synchronous updates of the remote
> tables when the network allows but we also want to
> apply queued transactions after recovery from a
> network failure such that no transactions are ever
> lost (assuming the local database to be "unbreakable"
> :-)
>
> I'm thinking of advanced replication or streams but
> unfortunately I don't have any experience in either.
> I know this is going to require lots of reading and
> experimenting but I was hoping to short-circuit this
> by at least focusing on the right technology to start
> with!: what sounds like the best fit - AR or streams?
> (This is on 10g)
>
> Thank you all in advance for any help
>
> Charlotte
>
>
>
>
>
> __________________________________
> Yahoo! Mail - PC Magazine Editors' Choice 2005
> http://mail.yahoo.com
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
