Predicting replicated database scalability from standalone database profiling
Sameh Elnikety, Steven G. Dropsho, Emmanuel Cecchet, Willy Zwaenepoel · 2009
This paper develops analytical models to predict through-put and response time of a replicated database using meas-urements 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 provi-sioning. The models capture the scalability limits stemming from update propagation and aborts for both multi-master and single-master replicated databases that support snap-shot isolation.