Re: Relication strategie..

Sequences, longs and long raws do not replicate using Oracle's Advanced Replication. You either have to assign sequence number ranges to each server or your a composite primary key i.e. pk (server_id, record_id).

As far as strategies for replication, I have just finished almost 500 pages of reading on the subject. It is not simple to implement and maintain. When building a replication, pay special attention to Oracle's conflict resolution options and how they will behave in your particular database systems. As far as replicating 15 servers in a multiple master replication, I sure hope you have bandwidth. Your network is going to be very busy.

Also, I would stay away from the single master, two phase commit strategy (synchronous replication)unless you are 100% sure about the redundancy of all of the systems and the infrastructure. Any server/network failure will result in halting all replication. Everything stops.

Daniel
Austin, TX

"Gaetan Poitras" <gpoitras_at_colt.vpi.hydro.qc.ca> wrote in message news:388DC65A.BE8B7FC8_at_colt.vpi.hydro.qc.ca...
>
>
> Hi, If I use asynchronous and bidirectional replication..
> Can I replicate sequences ..
>
> Also, wich strategie is the best..
> If I have around 30 tables to replicate with maby 3 or 4 of those table
> have more than 4 transactions by minutes on each site....
>
> Then , I have 15 servers, with 15 databases.. I want all of them
> replicated bidirectional, so all of them will be up to date..
>
> Should I use one master and 14 others replicate with the master.. It
> mean that a transaction done in one site will be transfert to the master
> site, then will be re-transfer to all other 13 site...
> Or should I do a kind of tree.. with one big master, connect with 3 or 4
> "sub-master" and each sub-master are connect with 3 or 4 other sites...
>
> I want to know if there is a better way than the TIMESTAMP way, to
> resolve replicate conflic when the same row is updated simultanously on
> different database..? Particuly when you have 15 databases.....
>
> --
> - Gaetan Poitras --
> - E-Mail: gpoitras_at_colt.vpi.hydro.qc.ca -
>
>
>
Received on Wed Jan 26 2000 - 14:40:33 CST