This Article 
   
 Share 
   
 Bibliographic References 
   
 Add to: 
 
Digg
Furl
Spurl
Blink
Simpy
Google
Del.icio.us
Y!MyWeb
 
 Search 
   
Comparison of Database Replication Techniques Based on Total Order Broadcast
April 2005 (vol. 17 no. 4)
pp. 551-566
In this paper, we present a performance comparison of database replication techniques based on total order broadcast. While the performance of total order broadcast-based replication techniques has been studied in previous papers, this paper presents many new contributions. First, it compares with each other techniques that were presented and evaluated separately, usually by comparing them to a classical replication scheme like distributed locking. Second, the evaluation is done using a finer network model than previous studies. Third, the paper compares techniques that offer the same consistency criterion (one-copy serializability) in the same environment using the same settings. The paper shows that, while networking performance has little influence in a LAN setting, the cost of synchronizing replicas is quite high. Because of this, total order broadcast-based techniques are very promising as they minimize synchronization between replicas.

[1] J.N. Gray, P. Helland, P. O'Neil, and D. Shasha, “The Dangers of Replication and a Solution,” Proc. 1996 Int'l Conf. Management of Data, pp. 173-182, 1996.
[2] A. Schiper and M. Raynal, “From Group Communication to Transactions in Distributed Systems,” Comm. ACM, vol. 39, no. 4, pp. 84-87, 1996.
[3] G. Alonso, “Partial Database Replication and Group Communication Primitives,” Proc. Second European Research Seminar on Advances in Distributed Systems (ERSADS '97), pp. 171-176, 1997.
[4] D. Agrawal, G. Alonso, A. El Abbadi, and I. Stanoi, “Exploiting Atomic Broadcast in Replicated Databases,” Proc. EuroPar Conf. (EuroPar '97), 1997.
[5] J.M. Chang, “Simplifying Distributed Database Systems Design by Using a Broadcast Network,” Proc. Ann. SIGMOD '84 Meeting, B. Yormark, ed., vol. 14, pp. 223-233, 1984.
[6] Ö. Babaoglu and S. Toueg, “Understanding Nonblocking Atomic Commitement,” Technical Report UBLCS-93-2, Laboratory for Computer Science, Univ. of Bologna, Italy, 1993.
[7] I. Keidar and D. Dolev, “Increasing the Resilience of Distributed and Replicated Database Systems,” J. Computer and System Sciences (JCSS), vol. 57, no. 3, pp. 309-224, 1998.
[8] R. Jiménez-Paris, M. Patiño-Martínez, G. Alonso, and S. Arévalo, “A Low Latency Nonblocking Commit Server,” Proc. 15th Int'l Conf. Distributed Computing (DISC 2001), pp. 93-107, 2001.
[9] F. Pedone, R. Guerraoui, and A. Schiper, “Exploiting Atomic Broadcast in Replicated Databases,” Proc. EuroPar Conf. (EuroPar '98), 1998.
[10] B. Kemme and G. Alonso, “A Suite of Database Replication Protocols Based On Group Communication Primitives,” Proc. 18th Int'l Conf. Distributed Computing Systems (ICDCS '98), 1998.
[11] F. Pedone, R. Guerraoui, and A. Schiper, “The Database State Machine Approach,” Distributed and Parallel Databases, vol. 14, no. 1, pp. 71-98, July 2003.
[12] B. Kemme, F. Pedone, G. Alonso, and A. Schiper, “Processing Transactions over Optimistic Atomic Broadcast Protocols,” Proc. Int'l Conf. Distributed Computing Systems, 1999.
[13] J. Holliday, D. Agrawal, and A.E. Abbadi, “The Performance of Database Replication With Group Multicast,” Proc. Int'l Symp. Fault Tolerant Computing (FTCS 29), pp. 158-165, 1999.
[14] B. Kemme, “Database Replication for Clusters of Workstations,” PhD dissertation, Swiss Federal Inst. of Technology Zürich, Switzerland, 2000.
[15] F. Pedone and S. Frølund, “PRonto: A Fast Failover Protocol for Off-the-Shelf Commercial Databases,” Technical Report HPL-2000-96, Software Technology Laboratory, Hewlett-Packard Laboratories, Palo Alto, Calif., 2000.
[16] B. Kemme and G. Alonso, “Don't Be Lazy, Be Consistent: Postgres-R, A New Way to Implement Database Replication,” Proc. 26th Int'l Conf. Very Large Databases (VLDB), 2000.
[17] S. Frølund and F. Pedone, “Continental Pronto,” Proc. 20th Symp. Reliable Distributed Systems, pp. 46-55, 2001.
[18] J. Holliday, D.A.R. Steinke, and A.E. Abbadi, “Epidemic Algorithms in Replicated Databases,” IEEE Trans. Knowledge and Data Eng., vol. 15, no. 5, pp. 1218-1238, Sept./Oct., 2003.
[19] J. Holliday, D. Agrawal, and A.E. Abbadi, “Using Multicast Communication to Reduce Deadlocks in Replicated Databases,” Proc. 19th Symp. Reliable Distributed Systems, pp. 196-205, 2000.
[20] Y. Amir and C. Tutu, “From Total Order to Database Replication,” Proc. 22nd Int'l Conf. Distributed Computing Systems (ICDCS), 2002.
[21] R. Vandewall, “Database Replication Prototype,” master's thesis, Rijksuniversiteit Groningen and École Polytechnique Fédérale de Lausanne, Netherlands and Switzerland, 2000.
[22] P. Bernstein, V. Hadzilacos, and N. Goodman, Concurrency Control and Recovery in Database Systems. Addison-Wesley, 1987.
[23] V. Hadzilacos and S. Toueg, “A Modular Approach to Fault-Tolerant Broadcasts and Related Problems,” Technical Report TR94-1425, Cornell Univ., Computer Science Dept., 1994.
[24] M. Wiesmann, F. Pedone, A. Schiper, B. Kemme, and G. Alonso, “Database Replication Techniques: A Three Parameter Classification,” Proc. 19th Symp. Reliable Distributed Systems (SRDS '00), pp. 206-215, 2000.
[25] J. Holliday, D. Agrawal, and A.E. Abbadi, “The Performance of Replicated Databases Using Atomic Broadcast Group Communication,” Technical Report TRCS99-11, Computer Science Dept., Univ. of California, Santa Barbara, 1999.
[26] F.B. Schneider, “Implementing Fault-Tolerant Services Using the State Machine Approach: A Tutorial,” ACM Computing Surveys, vol. 22, no. 4, pp. 299-319, 1990.
[27] F. Pittelli and H. Garcia-Molina, “Reliable Scheduling in a TMR Database System,” ACM Trans. Computer Systems, vol. 7, no. 1, pp. 25-60, 1989.
[28] I. Keidar, “A Highly Available Paradigm For Consistent Object Replication,” master's thesis, The Hebrew Univ. of Jerusalem, Israel, 1994.
[29] M. Wiesmann, F. Pedone, A. Schiper, B. Kemme, and G. Alonso, “Understanding Replication in Databases and Distributed Systems,” Proc. 20th Int'l Conf. Distributed Computing Systems (ICDCS '00), 2000.
[30] F. Pedone, “The Database State Machine and Group Communication Issues,” PhD dissertation, École Polytechnique Fédérale de Lausanne, Switzerland, 1999.
[31] B. Kemme and G. Alonso, “A New Approach to Developing and Implementing Eager Database Replication Protocols,” ACM Trans. Database Systems, vol. 25, no. 3, pp. 333-379, 2000.
[32] CSIM18 Simulation Engine (C++ Version), Mesquite Software Inc., Austin, Texas 78759, 1994.
[33] P. Urbán, X. Défago, and A. Schiper, “Contention-Aware Metrics for Distributed Algorithms: Comparison of Atomic Broadcast Algorithms,” Proc. Ninth IEEE Int'l Conf. Computer Comm. and Networks (IC3N 2000), 2000.
[34] R. Ja, The Art of Computer System Performance Analysis: Techniques for Experimental Design, Measurement, Simulation and Modeling. John Wiley and Sons, 1991.
[35] R. Agrawal, M.J. Carey, and M. Livny, “Concurency Control Performance Modeling: Alternatives and Implications,” ACM Trans. Database Systems, vol. 12, no. 4, pp. 609-654, 1987.
[36] K. Nørvåg, O. Sandstå, and K. Bratbergsengen, “Concurrency Control in Distributed Object-Oriented Database Systems,” Proc. Advances in Databases and Information Systems Conf., pp. 9-17, 1997.
[37] P. Urbán, X. Défago, and A. Schiper, “Neko: A Single Environment to Simulate and Prototype Distributed Algorithms,” Proc. 15th Int'l Conf. Information Networking (ICOIN-15), 2001.
[38] S. Chen and D. Towsley, “A Performance Evaluation of RAID Architectures,” Technical Report UM-CS-1992-067, Dept. of Computer Science, Univ. of Masschusetts, Amherst, 1992.

Index Terms:
Distributed databases, performance attributes, distributed programming.
Citation:
Matthias Wiesmann, Andr? Schiper, "Comparison of Database Replication Techniques Based on Total Order Broadcast," IEEE Transactions on Knowledge and Data Engineering, vol. 17, no. 4, pp. 551-566, April 2005, doi:10.1109/TKDE.2005.54
Usage of this product signifies your acceptance of the Terms of Use.