RE: replication question
Date: Tue, 13 May 2008 17:14:38 +0100
2 valid concerns from the developers.
I suppose the standard questions would be
Full schema/database or just a couple of tables
I suspect the answer from Oracle would be DG but bandwidth would/might be problem
Streams is probably the way to go but it does seem a (perhaps unnecessarily) complicated beast
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Jeremy Schneider Sent: 13 May 2008 16:45
To: Oracle-L Freelists
Cc: Weiss, Stephen E (Stephen)
Subject: replication question
Have a good question from a friend of mine who's not on the list - wondering if anyone else would have input. Reply-all so that Steve can see the replies too - anyone have additional thoughts about this?
- Forwarded message ---------- From: Weiss, Stephen E (Stephen) Date: Tue, May 13, 2008 at 10:26 AM Subject: RE: General experience question... To: Jeremy Schneider <jeremy.schneider_at_ardentperf.com>
Between two geo-separated RAC databases, say one on west coast, the other on east coast.
What is the recommended method for keeping both up to date, but not necessarily immediately up to date.
There's concern from developers that:
- Oracle replication between sites would be too slow because it's trigger based and would seriously impact performance, especially during heavy traffic time.
- Oracle replication is end-of-life for Oracle Streams. We're
concerned about streams in that it's quite complex.
From: Jeremy Schneider [mailto:jeremy.schneider_at_ardentperf.com]
Sent: Tuesday, May 13, 2008 11:22 AM
To: Weiss, Stephen E (Stephen) Subject: Re: General experience question... Replication is probably the best Oracle-centric option. Itdepends a lot on the volume of updates and the data types you're using. There are also some third-party solutions available. This would be a great question to post on the oracle-l list too if you wanted some good feedback. Mind if I forward it over there?
-- Jeremy Schneider Chicago, IL http://www.ardentperf.com/category/technical The information included in this email and any files transmitted with it may contain information that is confidential and it must not be used by, or its contents or attachments copied or disclosed, to persons other than the intended addressee. If you have received this email in error, please notify BJSS. In the absence of written agreement to the contrary BJSS’ relevant standard terms of contract for any work to be undertaken will apply. Please carry out virus or such other checks as you consider appropriate in respect of this email. BJSS do not accept responsibility for any adverse effect upon your system or data in relation to this email or any files transmitted with it. BJSS Limited, a company registered in England and Wales (Company Number 2777575), VAT Registration Number 613295452, Registered Office Address, First Floor, Coronet House, Queen Street, Leeds, LS1 2TW -- http://www.freelists.org/webpage/oracle-lReceived on Tue May 13 2008 - 11:14:38 CDT