Transaction Routing with Freshness Control in a Cluster of Replicated Databases - Archive ouverte HAL
Communication Dans Un Congrès Année : 2003

Transaction Routing with Freshness Control in a Cluster of Replicated Databases

Résumé

We consider the use of a cluster system with a shared nothing architecture for update-intensive autonomous databases. To optimize load balancing, we use optimistic database replication with freshness control. We propose a solution to transaction routing that preserves database and application autonomy and a cost model to estimate replica freshness. Then we propose an algorithm for transaction routing that takes into account freshness requirements of transactions and replica freshness. We implemented our solution on a Linux cluster running Oracle 8i and performed extensive performance experiments using the TPC-C OLTP benchmark. Our results show that our solution outperforms existing solutions for typical transaction workloads.
Fichier non déposé

Dates et versions

hal-02019887 , version 1 (14-02-2019)

Identifiants

  • HAL Id : hal-02019887 , version 1

Citer

Hubert Naacke, François Dang Ngoc, Patrick Valduriez. Transaction Routing with Freshness Control in a Cluster of Replicated Databases. BDA 2003 - 19èmes Journées Bases de Données Avancées, Oct 2003, Lyon, France. ⟨hal-02019887⟩
85 Consultations
0 Téléchargements

Partager

More