Proceedings of the 6th IEEE Internacional Symposium on Network Computing and Applications (NCA ’07), Boston, MA, USA. 2007

Authors

Alfrânio Correia Jr.,José Pereira, Luís Rodrigues, Nuno Carvalho, Ricardo Vilaça, Rui Oliveira

Abstract

Recently, third party solutions for database replication have been enjoying an increasing popularity. Such proposals address a diversity of user requirements, namely preventing conflicting updates without the overhead of synchronous replication; clustering for scalability and availability; and heterogeneous replicas for specialized queries. Unfortunately, the lack of native support from database vendors for third party replication forces implementors to either modify the database server, restricting portability, or to develop a middleware wrapper, which causes a performance overhead. This paper addresses this problem with a novel architecture and programming interface for replication, such that different strategies can be efficiently implemented on any compliant database management system in a cost-effective manner. The contribution is two-fold. First we propose a reflective model of transaction processing and explain how it can be used to achieve replication. Then we implement the proposed architecture in Apache Derby, PostgreSQL, and Sequoia and evaluate the PostgreSQL implementation with the TPC-W industry standard benchmark.

Full Text

PDF