| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Master to Master Replication and availability
I generally dislike setting up replication for availability purposes. Data
Guard is much simpler to configure and administer if that is the goal.
If you have an application that will be used by customers in a variety of geographic locations, though, there may be benefits to putting Oracle instances close to the users to insulate them from things like network glitches. You can be pretty confident that a user in Denver can connect to an Oracle database in the Denver data center, you can be pretty confident that a user in Mubai can connect to an Oracle database in the Mubai data center. You may be significantly less confident that both users can connect to an Oracle database in Tokyo.
In other words, if the goal is improving Oracle availability, use Data Guard. If the goal is improving system availability, replication might play a role.
Justin Cave
Distributed Database Consulting, Inc.
http://www.ddbcinc.com/askDDBC
-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
On Behalf Of Loughmiller, Greg
Sent: Monday, July 12, 2004 11:46 AM
To: oracle-l_at_freelists.org
Subject: Master to Master Replication and availability
Hey guys,
Just curious here.. But "who" out there is using some sense of master-to-master replication of an OLTP application using to provide their clients a level of availability? So for example, two databases which would reside in geographically diverse data centers with synchronous replication :-)
I'm not a big fan of master-to-master synchronous replication (nor async replication) as I believe the complexity and operational overhead would far exceed providing a Stand By Database (Data Guard). But I'm looking for some feedback/experience from the folks on the mailing list.
Thanks in advance!!
Greg Loughmiller
 |
 |