A Pragmatic Protocol for Database Replication in Interconnected Clusters

Multi-master update everywhere database replication, as achieved by protocols based on group communication such as DBSM and Postgres-R, addresses both performance and availability. By scaling it to wide area networks, one could save costly bandwidth and avoid large round-trips to a distant master server. Also, by ensuring that updates are safely stored at a remote site within transaction boundaries, disaster recovery is guaranteed. Unfortunately, scaling existing cluster based replication protocols is troublesome. In this paper we present a database replication protocol based on group communication that targets interconnected clusters. In contrast with previous proposals, it uses a separate multicast group for each cluster and thus does not impose any additional requirements on group communication, easing implementation and deployment in a real setting. Nonetheless, the protocol ensures one-copy equivalence while allowing all sites to execute update transactions. Experimental evaluati...

• Type: Conference
• Year: 2006
• Where: PRDC
• Authors: J. Grov, L. Soares, Alfrânio Correia Jr., José Pereira, Rui Carlos Oliveira, Fernando Pedone
• Keywords: Database Replication, Dependable Computing, Group Communication, PRDC 2006, Replication Protocol