The Dangers of Replication and a Solution

: Update anywhere-anytime-anyway transactional replication has unstable behavior as the workload scales up: a ten-fold increase in nodes and traffic gives a thousand fold increase in deadlocks or reconciliations. Master copy replication (primary copy) schemes reduce this problem. A simple analytic model demonstrates these results. A new two-tier replication algorithm is proposed that allows mobile (disconnected) applications to propose tentative update transactions that are later applied to a master copy. Commutative update transactions avoid the instability of other replication schemes.

• Type: Conference
• Year: 1996
• Where: SIGMOD
• Authors: Jim Gray, Pat Helland, Patrick E. O'Neil, Dennis Shasha
• Keywords: Database, Master Copy Replication, SIGMOD 1996, Two-tier Replication Algorithm, Update Transactions