Replica Refresh Strategies in a Database Cluster - Archive ouverte HAL Accéder directement au contenu
Communication Dans Un Congrès Année : 2006

Replica Refresh Strategies in a Database Cluster

Cécile Le Pape
  • Fonction : Auteur
  • PersonId : 965544
Stéphane Gançarski

Résumé

Relaxing replica freshness has been exploited in database clusters to optimize load balancing. However, in most approaches, refreshment is typically coupled with other functions such as routing or scheduling, which makes it hard to analyze the impact of the refresh strategy itself on performance. In this paper, we propose to support routing-independent refresh strategies in a database cluster with mono-master lazy replication. First, we propose a model for capturing existing refresh strategies. Second, we describe the support of this model in Refresco, a middleware prototype for freshness-aware routing in database clusters. Third, we describe an experimental validation to test some typical strategies against different workloads. The results show that the choice of the best strategy depends not only on the workload, but also on the conflict rate between transactions and queries and on the level of freshness required by queries. Although there is no strategy that is best in all cases, we found that one strategy is usually very good and could be used as default strategy.

Dates et versions

hal-01337133 , version 1 (24-06-2016)

Identifiants

Citer

Cécile Le Pape, Stéphane Gançarski. Replica Refresh Strategies in a Database Cluster. VECPAR'06 Workshop on High-Performance Data Management in Grid Environments (selected papers), Jun 2006, Rio de Janeiro, Brazil. pp.679-691, ⟨10.1007/978-3-540-71351-7_54⟩. ⟨hal-01337133⟩
69 Consultations
0 Téléchargements

Altmetric

Partager

Gmail Facebook X LinkedIn More