Managing Transaction Conflicts in Middleware-based Database Replication Architectures

  • Authors:
  • F. D. Munoz-Esco;J. Pla-Civera;M. I. Ruiz-Fuertes;L. Irun-Briz;H. Decker;J. E. Armendariz-Inigo;J. R. Gonzalez de Mendivil

  • Affiliations:
  • Univ. Politecnica de Valencia Camino de Vera,Spain;Univ. Politecnica de Valencia Camino de Vera,Spain;Univ. Politecnica de Valencia Camino de Vera,Spain;Univ. Politecnica de Valencia Camino de Vera,Spain;Univ. Politecnica de Valencia Camino de Vera,Spain;Univ. Publica de Navarra Campus de Arrosadia, Spain;Univ. Publica de Navarra Campus de Arrosadia, Spain

  • Venue:
  • SRDS '06 Proceedings of the 25th IEEE Symposium on Reliable Distributed Systems
  • Year:
  • 2006

Quantified Score

Hi-index 0.00

Visualization

Abstract

Database replication protocols need to detect, block or abort part of conflicting transactions. A possible solution is to check their writesets (and also their readsets in case a serialisable isolation level is requested), which however burdens the consumption of CPU time. This gets even worse when the replication support is provided by a middleware, since there is no direct DBMS support in that layer. We propose and discuss the use of the concurrency control support of the local DBMS for detecting conflicts between local transactions and writesets of remote transactions. This allows to simplify many database replication protocols and to enhance their performance.