Middleware Support for Database Replication and Caching
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.
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. . 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.
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...
- 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.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.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.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
- 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
- 9.Sequoia project. Available at: http://sequoia.continuent.org