A new approach to developing and implementing eager database replication protocols
- 1 September 2000
- journal article
- Published by Association for Computing Machinery (ACM) in ACM Transactions on Database Systems
- Vol. 25 (3) , 333-379
- https://doi.org/10.1145/363951.363955
Abstract
Database replication is traditionally seen as a way to increase the availability and performance of distributed databases. Although a large number of protocols providing data consistency and fault-tolerance have been proposed, few of these ideas have ever been used in commercial products due to their complexity and performance implications. Instead, current products allow inconsistencies and often resort to centralized approaches which eliminates some of the advantages of replication. As an alternative, we propose a suite of replication protocols that addresses the main problems related to database replication. On the one hand, our protocols maintain data consistency and the same transactional semantics found in centralized systems. On the other hand, they provide flexibility and reasonable performance. To do so, our protocols take advantage of the rich semantics of group communication primitives and the relaxed isolation guarantees provided by most databases. This allows us to eliminate the possibility of deadlocks, reduce the message overhead and increase performance. A detailed simulation study shows the feasibility of the approach and the flexibility with which different types of bottlenecks can be circumvented.Keywords
This publication has 18 references indexed in Scilit:
- The Transis approach to high availability cluster communicationCommunications of the ACM, 1996
- HorusCommunications of the ACM, 1996
- TotemCommunications of the ACM, 1996
- Lightweight causal and atomic group multicastACM Transactions on Computer Systems, 1991
- Replica control in distributed systemsPublished by Association for Computing Machinery (ACM) ,1991
- Maintaining availability in partitioned replicated databasesACM Transactions on Database Systems, 1989
- Concurrency control performance modeling: alternatives and implicationsACM Transactions on Database Systems, 1987
- A √N algorithm for mutual exclusion in decentralized systemsACM Transactions on Computer Systems, 1985
- Time, clocks, and the ordering of events in a distributed systemCommunications of the ACM, 1978
- The notions of consistency and predicate locks in a database systemCommunications of the ACM, 1976