Repository logo

Infoscience

  • English
  • French
Log In
Logo EPFL, École polytechnique fédérale de Lausanne

Infoscience

  • English
  • French
Log In
  1. Home
  2. Academic and Research Output
  3. Conferences, Workshops, Symposiums, and Seminars
  4. Predicting Replicated Database Scalability from Standalone Database Profiling
 
conference paper

Predicting Replicated Database Scalability from Standalone Database Profiling

Elnikety, Sameh  
•
Dropsho, Steven  
•
Cecchet, Emmanuel
Show more
2009
Proceedings of the 4th ACM EuroSys Conference
4th ACM EuroSys Conference

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.

  • Files
  • Details
  • Metrics
Type
conference paper
DOI
10.1145/1519065.1519098
Author(s)
Elnikety, Sameh  
Dropsho, Steven  
Cecchet, Emmanuel
Zwaenepoel, Willy  
Date Issued

2009

Published in
Proceedings of the 4th ACM EuroSys Conference
Start page

303

End page

316

Subjects

database replication

•

single-master systems

•

multi-master systems

•

generalized snapshot isolation

URL

URL

http://eurosys2009.informatik.uni-erlangen.de/
Editorial or Peer reviewed

REVIEWED

Written at

EPFL

EPFL units
LABOS  
Event nameEvent placeEvent date
4th ACM EuroSys Conference

Nuremberg, Germany

March 31 - April 3, 2009

Available on Infoscience
March 28, 2009
Use this identifier to reference this record
https://infoscience.epfl.ch/handle/20.500.14299/36415
Logo EPFL, École polytechnique fédérale de Lausanne
  • Contact
  • infoscience@epfl.ch

  • Follow us on Facebook
  • Follow us on Instagram
  • Follow us on LinkedIn
  • Follow us on X
  • Follow us on Youtube
AccessibilityLegal noticePrivacy policyCookie settingsEnd User AgreementGet helpFeedback

Infoscience is a service managed and provided by the Library and IT Services of EPFL. © EPFL, tous droits réservés