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...
Recommended Reading
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.
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.
Cecchet E, Marguerite J, Zwaenepoel W. C-JDBC: flexible database clustering middleware. In Proceeding of USENIX Annual Technical Conference, 2004.
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.
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.
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.
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.
Plattner C, Alonso G, Özsu MT. Extending DBMSs with satellite databases. VLDB J. 2008;17(4):657–82.
Sequoia project. Available at: http://sequoia.continuent.org
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Section Editor information
Rights 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