Data Management

Predicting Replicated Database Scalability From Standalone Database Profiling

Free registration required

Executive Summary

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.

  • Format: PDF
  • Size: 859.7 KB