Sciweavers

Share
EUROSYS
2009
ACM

Predicting replicated database scalability from standalone database profiling

10 years 3 months ago
Predicting replicated database scalability from standalone database profiling
This paper develops analytical models to predict the throughput and the response time of a replicated database using measurements of the workload on a standalone database. These models allow workload scalability to be estimated before the replicated system is deployed, making the technique useful for capacity planning and dynamic service provisioning. The models capture the scalability limits stemming from update propagation and aborts for both multi-master and single-master replicated databases that support snapshot isolation. We validate the models by comparing their throughput and response time predictions against experimental measurements on two prototype replicated database systems running the TPC-W and RUBiS workloads. We show that the model predictions match the experimental results for both the multi-master and single-master designs and for the various workload mixes of TPC-W and RUBiS. Categories and Subject Descriptors D.4.5. [Reliability]: Fault-tolerance; D.4.8. [Performan...
Sameh Elnikety, Steven G. Dropsho, Emmanuel Cecche
Added 10 Mar 2010
Updated 10 Mar 2010
Type Conference
Year 2009
Where EUROSYS
Authors Sameh Elnikety, Steven G. Dropsho, Emmanuel Cecchet, Willy Zwaenepoel
Comments (0)
books