RE: MultiMaster Replication
- From: "Marquez, Chris" <cmarquez@xxxxxxxxxxxxxxxx>
- To: <fuadar@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 23 Aug 2005 23:00:15 -0400
>>1....there needs to be a master definition site.
>>if the communication breaks between 2 sites
>>will we have to change the master definition site.
It is possible to change the "master definition site", but generally this would
only be done of the original master definition site is "gone", "dead",
"lost"...temporary loss of one multi-master site does not mean re-defining the
master definition site...unless you need to do repadmin tasks that must be done
for the (down) master definition site.
>>2...replicate sequences
I used local sequence on each side the would *not* collide buy using different
START and INCREMENT values.
I liked Oracle Multi Master Replication for *simple* TABLE level replication
where most or all transaction happen on one node...more than that and the admin
of it (any transaction based replication) becomes painful.
hth
Chris Marquez
Oracle DBA
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx on behalf of Fuad Arshad
Sent: Sun 8/21/2005 10:19 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: MultiMaster Replication
I've been reading up on multimaster replication and had a few questions.
1. After the multimaster replication setup there needs to be a master
definition site. if the communication breaks between 2 sites will we have to
change the master definition site.
2. the tables the i'm trying to replicate have sequences that i need to
transform to sequences on the other side.
oracle seems to say its possbile but i cant find an example.
If anyone on the list has had experience with multimaster. if they could drop
me an email and we could chat a little bit offline that would be really great.
Other related posts:
