Encyclopedia of Database Systems

2018 Edition
| Editors: Ling Liu, M. Tamer Özsu

Middleware Support for Database Replication and Caching

  • Emmanuel Cecchet
Reference work entry
DOI: https://doi.org/10.1007/978-1-4614-8265-9_1538

Definition

Database replication is a technique that aims at providing higher availability and performance than a single RDBMS. A database replication middleware implements a number of replication algorithms on top of existing RDBMS. Features provided by the replication middleware include load balancing, caching, and fault tolerance.

Historical Background

Database replication is a well-known mechanism for performance scaling and availability of databases across a wide range of requirements. Limitations of 2-phase commit and synchronous replication have been pointed out early on by Gray et al. [7]. Since then, research on middleware-based replication addresses these issues and tries to provide solutions for better performance and availability while maintaining consistency guarantees for applications.

Foundations

Database replication is a wide area of research that encompasses multiple architectures and possible designs. This entry does not address in-core database replication, where the...

This is a preview of subscription content, log in to check access.

Recommended Reading

  1. 1.
    Amza C, Cox A, Zwaenepoel W. A comparative evaluation of transparent scaling techniques for dynamic content servers. In: Proceedings of the 21st International Conference on Data Engineering; 2005. p. 230–41.Google Scholar
  2. 2.
    Cecchet E, Candea G, Ailamaki A. Middleware-based database replication: the gaps between theory and practice. In: Proceedings of the ACM SIGMOD International Conference on Management of Data; 2008. p. 739–52.Google Scholar
  3. 3.
    Cecchet E, Marguerite J, Zwaenepoel W. C-JDBC: flexible database clustering middleware. In: Proceedings of the USENIX 2004 Annual Technical Conference; 2004.Google Scholar
  4. 4.
    Chen J, Soundararajan G, Amza C. Autonomic provisioning of backend databases in dynamic content web servers. In: Proceedings of the 2006 IEEE International Conference on Autonomic Computing; 2006. p. 231–42.Google Scholar
  5. 5.
    Elnikety S, Dropsho S, Pedone F. Tashkent: uniting durability with transaction ordering for high-performance scalable database replication. In: Proceedings of the 1st ACM SIGOPS/EuroSys European Confertence on Computer System; 2006. p. 117–30.CrossRefGoogle Scholar
  6. 6.
    Elnikety S, Dropsho S, Zwaenepoel W. Tashkent+: memory-aware load balancing and update filtering in replicated databases. In: Proceedings of the 2nd ACM SIGOPS/EuroSys European Conference on Computer System; 2007. p. 399–412.Google Scholar
  7. 7.
    Gray JN, Helland P, O’Neil P, Shasha D. The dangers of replication and a solution. In: Proceedings of the ACM SIGMOD International Conference on Management of Data; 1996. p. 173–82.CrossRefGoogle Scholar
  8. 8.
    Plattner C, Alonso G, Özsu MT. Extending DBMSs with satellite databases. VLDB J. 2008;17(4):657–82.CrossRefGoogle Scholar
  9. 9.
    Sequoia project. Available at: http://sequoia.continuent.org

Copyright information

© Springer Science+Business Media, LLC, part of Springer Nature 2018

Authors and Affiliations

  1. 1.EPFLLausanneSwitzerland

Section editors and affiliations

  • Cristiana Amza
    • 1
  1. 1.Dept. of Elec. and Comp. Eng.Univ. of TorontoTorontoCanada