replication question
- From: "Jeremy Schneider" <jeremy.schneider@xxxxxxxxxxxxxx>
- To: "Oracle-L Freelists" <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 13 May 2008 10:44:47 -0500
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@xxxxxxxxxxxxxx>
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:
1. Oracle replication between sites would be too slow because it's trigger
based and would seriously impact performance, especially during heavy
traffic time.
2. 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@xxxxxxxxxxxxxx]
*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. It depends 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
http://www.ardentperf.com/category/technical
--
Jeremy Schneider
Chicago, IL
http://www.ardentperf.com/category/technical
Other related posts:
