Skip to main content

Middleware Support for Database Replication and Caching

  • Living reference work entry
  • First Online:
Encyclopedia of Database Systems
  • 45 Accesses

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 via an institution to check access.

Access this chapter

Institutional subscriptions

Recommended Reading

  1. Amza C, Cox A, Zwaenepoel W. A comparative evaluation of transparent scaling techniques for dynamic content servers. In Proceeding of 21st International Conference on Data Engineering, 2005, p. 230–41.

    Google Scholar 

  2. Cecchet E, Candea G, Ailamaki A. Middleware-based database replication: the gaps between theory and practice. In Proceeding of ACM SIGMOD International Conference on Management of Data, 2008, p. 739–52.

    Google Scholar 

  3. Cecchet E, Marguerite J, Zwaenepoel W. C-JDBC: flexible database clustering middleware. In Proceeding of USENIX Annual Technical Conference, 2004.

    Google Scholar 

  4. Chen J, Soundararajan G, Amza C. Autonomic provisioning of backend databases in dynamic content web servers. In Proceeding of IEEE International Conference Autonomic Computing, 2006, p. 231–42.

    Google Scholar 

  5. Elnikety S, Dropsho S, Pedone F. Tashkent: uniting durability with transaction ordering for high-performance scalable database replication. In Proceeding of 1st ACM SIGOPS/EuroSys European Confertence on Computer System, 2006, p. 117–30.

    Google Scholar 

  6. Elnikety S, Dropsho S, Zwaenepoel W. Tashkent+: memory-aware load balancing and update filtering in replicated databases. In Proceeding of 2nd ACM SIGOPS/EuroSys European Conference on Computer System, 2007, p. 399–412.

    Google Scholar 

  7. Gray JN, Helland P, O’Neil P, Shasha D. The dangers of replication and a solution. In Proceeding of ACM SIGMOD International Conference on Management of Data, 1996, p. 173–82.

    Google Scholar 

  8. Plattner C, Alonso G, Özsu MT. Extending DBMSs with satellite databases. VLDB J. 2008;17(4):657–82.

    Article  Google Scholar 

  9. Sequoia project. Available at: http://sequoia.continuent.org

Download references

Author information

Authors and Affiliations

Authors

Corresponding author

Correspondence to Emmanuel Cecchet .

Editor information

Editors and Affiliations

Section Editor information

Rights and permissions

Reprints and permissions

Copyright information

© 2016 Springer Science+Business Media New York

About this entry

Cite this entry

Cecchet, E. (2016). Middleware Support for Database Replication and Caching. In: Liu, L., Özsu, M. (eds) Encyclopedia of Database Systems. Springer, New York, NY. https://doi.org/10.1007/978-1-4899-7993-3_1538-2

Download citation

  • DOI: https://doi.org/10.1007/978-1-4899-7993-3_1538-2

  • Received:

  • Accepted:

  • Published:

  • Publisher Name: Springer, New York, NY

  • Online ISBN: 978-1-4899-7993-3

  • eBook Packages: Springer Reference Computer SciencesReference Module Computer Science and Engineering

Publish with us

Policies and ethics