Authors:
M. Liroz-Gistau
1
;
J. R. Juárez-Rodríguez
1
;
J. E. Armendáriz-Iñigo
1
;
J. R. Gonzalez de Mendivil
1
and
F. D. Muñoz-Escoí
2
Affiliations:
1
Universidad Pública de Navarra, Spain
;
2
Universidad Politécnica de Valencia, Spain
Keyword(s):
Database Replication, Generalized Snapshot Isolation, Read One Write All, Replication Protocols, Middleware Architecture.
Related
Ontology
Subjects/Areas/Topics:
Distributed and Mobile Software Systems
;
Distributed Architectures
;
Grid, Peer-To-Peer, and Cluster Computing
;
Software Engineering
;
Web-Based Computing
Abstract:
In database replication, primary-copy systems sort out easily the problem of keeping replicate data consistent by allowing only updates at the primary copy. While this kind of systems are very efficient with workloads dominated by read-only transactions, the update-everywhere approach is more suitable for heavy update loads. However, it behaves worse when dealing with workloads dominated by read-only transactions. We propose a new database replication paradigm, halfway between primary-copy and update-everywhere approaches, which permits improving system performance by adapting its configuration to the workload, by means of a deterministic database replication protocol which ensures that broadcast writesets are always going to be committed.