Re: Symetric Replication
Date: 1995/07/21
Message-ID: <3upbpb$egt_at_hpcc48.corp.hp.com>#1/1
Steven Lucas (lucass_at_ix.netcom.com) wrote:
: I am implementing a solution that may be able to use Oracle's Symetric
: Replication Product. I am interested in obtaining information about
: the performance of the product when used in a database application that
: is very update intensive. I have a copy of Oracle's White Paper (Part
: A13824) but it does not mention performance issues. I am not really
: interested in using the traditional snapshot utility since this forces
: a master/slave relationship. I need to do true asynchronous
: replication where either system can initiate the replication process.
: I would appreciate any help anyone might be able to give me. Thanks in
: advance.
I've been testing and benchmarking SymRep (HP-UX 9.04, Oracle 7.1.6) for my current client right now and from a performance perspective, it is ok. Our data tends to be rather static (about 10 tables with 1-2 million rows, roughly 400 - 500 bytes per row, has dml changes which daily affects 0.5% to 1.0%), but we are replicating over a fractional T1 WAN to remote sites worldwide.
The perf tends be slower than traditional non-updatable snapshots for tables which is greater than 1% update intensive. We have pushed our benchmarks to 3% changes and the perf is acceptable. The bottleneck in our env was definitely the WAN.
Johnny Chan
Independent Oracle Specialist
Received on Fri Jul 21 1995 - 00:00:00 CEST