Summary: On the Performance of Consistent WideArea Database Replication
Yair Amir # Claudiu Danilov # Michal MiskinAmir + Jonathan Stanton #
Ciprian Tutu #
December 10th, 2003
In this paper we design a generic, consistent replication architecture that enables transparent
database replication and we present the optimizations and tradeo#s of the chosen design. We
demonstrate the practicality of our approach by building a prototype that replicates a Post
greSQL database system. We provide experimental results for consistent widearea database
replication. We claim that the use of an optimized synchronization engine is the key to building
a practical synchronous replication system for widearea network settings.
In many Internet applications, a large number of users that are geographically dispersed may
routinely query and update the same database. In this environment, a centralized database is
exposed to several significant risks:
. performance degradation due to high server load.
. dataloss risk due to server crashes.