RE: MultiMaster Replication
- From: Sarah Satterthwaite <ssatterthwaite@xxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Mon, 22 Aug 2005 09:54:27 -0400
Faud,
I've done a lot of experimenting with various flavors of Replication in
recent months.
1. I didn't test taking down the master definition site, but if one of the
other sites goes down, transactions just queue up until it is available
again. It handled it very nicely. I expect that the same would happen if
the master definition site went down, but you should test it (and let us
know the results).
2. Sequences can not be replicated like table data. There seem to be two
ways to handle sequences:
a. Use different ranges of the sequence at each site. Be careful that the
ranges are large enough that a database will not run out of values in its
range.
b. Use a different modulus for each database to generate unique values.
So, if you have 3 databases you could have the first start with 0, the
second start with 1 and the third start with 2. All would be incremented by
3.
Sarah Satterthwaite
-----Original Message-----
From: Fuad Arshad [mailto:fuadar@xxxxxxxxx]
Sent: Sunday, August 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:
