RE: MultiMaster Replication

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:
3. 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.
4. 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_at_yahoo.com] Sent: Sunday, August 21, 2005 10:19 AM
To: oracle-l_at_freelists.org
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.  

--

http://www.freelists.org/webpage/oracle-l Received on Mon Aug 22 2005 - 08:56:45 CDT