Re: Data Replication Reliability

From: Chris Dipple <chris_at_chin.demon.co.uk>
Date: 1996/11/22
Message-ID: <eNXQhBA0QalyEw7R_at_chin.demon.co.uk>#1/1

In article <328B2FA3.AF_at_ibm.net>, "Scott T. Johnson" <sjohnson_at_ibm.net> writes
>Has anyone seen any good articles on the reliability of Oracle's data
>replication. What happens to synchronous replication if the network
>goes down? What happens if one of the servers is unavailable?
>
>Thanks,
>Scott

For synchronous replication read two-phase commit. If a node is inaccessable for any reason then your application will hang and eventually time out. You will have to turn replication off to the downed site. We tried Oracle synchronous replication and found problems with speed and with our own triggers (the use of sequences, USER and SYSDATE in user defined triggers are bad news). Good Luck.

-- 
Chris Dipple, Production DBA, Royal Bank of Scotland

Received on Fri Nov 22 1996 - 00:00:00 CET

This message: [ Message body ]
Next message: Chris Dipple: "Re: Oracle Master Program ?"
Previous message: Chris Dipple: "Re: Best Front End for Oracle?"
In reply to: Scott T. Johnson: "Data Replication Reliability"
Next in thread: Chris Dipple: "Re: Oracle Master Program ?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message