Quantifying the Impact of Replication on the Quality-of-Service in Cloud Databases

Rasha Osman, Juan F. Perez, Giuliano Casale

Research output: Chapter in Book/Report/Conference proceedingConference contribution

1 Citation (Scopus)

Abstract

Cloud databases achieve high availability by automatically replicating data on multiple nodes. However, the overhead caused by the replication process can lead to an increase in the mean and variance of transaction response times, causing unforeseen impacts on the offered quality-of-service (QoS). In this paper, we propose a measurement-driven methodology to predict the impact of replication on Database-As-A-Service (DBaaS) environments. Our methodology uses operational data to parameterize a closed queueing network model of the database cluster together with a Markov model that abstracts the dynamic replication process. Experiments on Amazon RDS show that our methodology predicts response time mean and percentiles with errors of just 1% and 15% respectively, and under operational conditions that are significantly different from the ones used for model parameterization. We show that our modeling approach surpasses standard modeling methods and illustrate the applicability of our methodology for automated DBaaS provisioning.

Original languageEnglish (US)
Title of host publicationProceedings - 2016 IEEE International Conference on Software Quality, Reliability and Security, QRS 2016
PublisherInstitute of Electrical and Electronics Engineers Inc.
Pages286-297
Number of pages12
ISBN (Electronic)9781509041275
DOIs
StatePublished - Oct 12 2016
Externally publishedYes
Event2nd IEEE International Conference on Software Quality, Reliability and Security, QRS 2016 - Vienna, Austria
Duration: Aug 1 2016Aug 3 2016

Conference

Conference2nd IEEE International Conference on Software Quality, Reliability and Security, QRS 2016
CountryAustria
CityVienna
Period8/1/168/3/16

Fingerprint

Quality of service
Queueing networks
Parameterization
Availability
Experiments

All Science Journal Classification (ASJC) codes

  • Computer Networks and Communications
  • Software
  • Safety, Risk, Reliability and Quality

Cite this

Osman, R., Perez, J. F., & Casale, G. (2016). Quantifying the Impact of Replication on the Quality-of-Service in Cloud Databases. In Proceedings - 2016 IEEE International Conference on Software Quality, Reliability and Security, QRS 2016 (pp. 286-297). [7589808] Institute of Electrical and Electronics Engineers Inc.. https://doi.org/10.1109/QRS.2016.40
Osman, Rasha ; Perez, Juan F. ; Casale, Giuliano. / Quantifying the Impact of Replication on the Quality-of-Service in Cloud Databases. Proceedings - 2016 IEEE International Conference on Software Quality, Reliability and Security, QRS 2016. Institute of Electrical and Electronics Engineers Inc., 2016. pp. 286-297
@inproceedings{12ad6e48715f405898f29d992d1fd052,
title = "Quantifying the Impact of Replication on the Quality-of-Service in Cloud Databases",
abstract = "Cloud databases achieve high availability by automatically replicating data on multiple nodes. However, the overhead caused by the replication process can lead to an increase in the mean and variance of transaction response times, causing unforeseen impacts on the offered quality-of-service (QoS). In this paper, we propose a measurement-driven methodology to predict the impact of replication on Database-As-A-Service (DBaaS) environments. Our methodology uses operational data to parameterize a closed queueing network model of the database cluster together with a Markov model that abstracts the dynamic replication process. Experiments on Amazon RDS show that our methodology predicts response time mean and percentiles with errors of just 1{\%} and 15{\%} respectively, and under operational conditions that are significantly different from the ones used for model parameterization. We show that our modeling approach surpasses standard modeling methods and illustrate the applicability of our methodology for automated DBaaS provisioning.",
author = "Rasha Osman and Perez, {Juan F.} and Giuliano Casale",
year = "2016",
month = "10",
day = "12",
doi = "10.1109/QRS.2016.40",
language = "English (US)",
pages = "286--297",
booktitle = "Proceedings - 2016 IEEE International Conference on Software Quality, Reliability and Security, QRS 2016",
publisher = "Institute of Electrical and Electronics Engineers Inc.",
address = "United States",

}

Osman, R, Perez, JF & Casale, G 2016, Quantifying the Impact of Replication on the Quality-of-Service in Cloud Databases. in Proceedings - 2016 IEEE International Conference on Software Quality, Reliability and Security, QRS 2016., 7589808, Institute of Electrical and Electronics Engineers Inc., pp. 286-297, 2nd IEEE International Conference on Software Quality, Reliability and Security, QRS 2016, Vienna, Austria, 8/1/16. https://doi.org/10.1109/QRS.2016.40

Quantifying the Impact of Replication on the Quality-of-Service in Cloud Databases. / Osman, Rasha; Perez, Juan F.; Casale, Giuliano.

Proceedings - 2016 IEEE International Conference on Software Quality, Reliability and Security, QRS 2016. Institute of Electrical and Electronics Engineers Inc., 2016. p. 286-297 7589808.

Research output: Chapter in Book/Report/Conference proceedingConference contribution

TY - GEN

T1 - Quantifying the Impact of Replication on the Quality-of-Service in Cloud Databases

AU - Osman, Rasha

AU - Perez, Juan F.

AU - Casale, Giuliano

PY - 2016/10/12

Y1 - 2016/10/12

N2 - Cloud databases achieve high availability by automatically replicating data on multiple nodes. However, the overhead caused by the replication process can lead to an increase in the mean and variance of transaction response times, causing unforeseen impacts on the offered quality-of-service (QoS). In this paper, we propose a measurement-driven methodology to predict the impact of replication on Database-As-A-Service (DBaaS) environments. Our methodology uses operational data to parameterize a closed queueing network model of the database cluster together with a Markov model that abstracts the dynamic replication process. Experiments on Amazon RDS show that our methodology predicts response time mean and percentiles with errors of just 1% and 15% respectively, and under operational conditions that are significantly different from the ones used for model parameterization. We show that our modeling approach surpasses standard modeling methods and illustrate the applicability of our methodology for automated DBaaS provisioning.

AB - Cloud databases achieve high availability by automatically replicating data on multiple nodes. However, the overhead caused by the replication process can lead to an increase in the mean and variance of transaction response times, causing unforeseen impacts on the offered quality-of-service (QoS). In this paper, we propose a measurement-driven methodology to predict the impact of replication on Database-As-A-Service (DBaaS) environments. Our methodology uses operational data to parameterize a closed queueing network model of the database cluster together with a Markov model that abstracts the dynamic replication process. Experiments on Amazon RDS show that our methodology predicts response time mean and percentiles with errors of just 1% and 15% respectively, and under operational conditions that are significantly different from the ones used for model parameterization. We show that our modeling approach surpasses standard modeling methods and illustrate the applicability of our methodology for automated DBaaS provisioning.

UR - http://www.scopus.com/inward/record.url?scp=84995403894&partnerID=8YFLogxK

UR - http://www.scopus.com/inward/citedby.url?scp=84995403894&partnerID=8YFLogxK

U2 - 10.1109/QRS.2016.40

DO - 10.1109/QRS.2016.40

M3 - Conference contribution

AN - SCOPUS:84995403894

SP - 286

EP - 297

BT - Proceedings - 2016 IEEE International Conference on Software Quality, Reliability and Security, QRS 2016

PB - Institute of Electrical and Electronics Engineers Inc.

ER -

Osman R, Perez JF, Casale G. Quantifying the Impact of Replication on the Quality-of-Service in Cloud Databases. In Proceedings - 2016 IEEE International Conference on Software Quality, Reliability and Security, QRS 2016. Institute of Electrical and Electronics Engineers Inc. 2016. p. 286-297. 7589808 https://doi.org/10.1109/QRS.2016.40