Automatic virtual machine configuration for databas workloads

Ahmed A. Soror, Umar Farooq Minhast, Ashraf Aboulnaga, Kenneth Salens, Peter Kokosielis, Sunil Kamath

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

63 Citations (Scopus)

Abstract

Virtual machine monitors are becoming popular tools for the deployment of database management systems and other enterprise software applications. In this paper, we consider a common resource consolidation scenario, in which several database management system instances, each running in a virtual machine, are sharing a common pool of physical computing resources. We address the problem of optimizing the performance of these database management systems by controlling the configurations of the virtual machines in which they run. These virtual machine configurations determine how the shared physical resources will be allocated to the different database instances. We introduce a virtualization design advisor that uses information about the anticipated workloads of each of the database systems to recommend workload-specific configurations offline. Furthermore, runtime information collected after the deployment of the recommended configurations can be used to refine the recommendation. To estimate the effect of a particular resource allocation on workload performance, we use the query optimizer in a new what-if mode. We have implemented our approach using both PostgreSQL and DB2, and we have experimentally evaluated its effectiveness using DSS and OLTP workloads.

Original languageEnglish
Title of host publicationProceedings of the ACM SIGMOD International Conference on Management of Data
Pages953-966
Number of pages14
DOIs
Publication statusPublished - 10 Dec 2008
Externally publishedYes
Event2008 ACM SIGMOD International Conference on Management of Data 2008, SIGMOD'08 - Vancouver, BC, Canada
Duration: 9 Jun 200812 Jun 2008

Other

Other2008 ACM SIGMOD International Conference on Management of Data 2008, SIGMOD'08
CountryCanada
CityVancouver, BC
Period9/6/0812/6/08

Fingerprint

Enterprise software
Computer monitors
Information use
Consolidation
Resource allocation
Virtual machine
Virtualization

Keywords

  • Resource consolidation
  • Virtual machine configuration
  • Virtualization

ASJC Scopus subject areas

  • Software
  • Information Systems

Cite this

Soror, A. A., Minhast, U. F., Aboulnaga, A., Salens, K., Kokosielis, P., & Kamath, S. (2008). Automatic virtual machine configuration for databas workloads. In Proceedings of the ACM SIGMOD International Conference on Management of Data (pp. 953-966). [1376711] https://doi.org/10.1145/1376616.1376711

Automatic virtual machine configuration for databas workloads. / Soror, Ahmed A.; Minhast, Umar Farooq; Aboulnaga, Ashraf; Salens, Kenneth; Kokosielis, Peter; Kamath, Sunil.

Proceedings of the ACM SIGMOD International Conference on Management of Data. 2008. p. 953-966 1376711.

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

Soror, AA, Minhast, UF, Aboulnaga, A, Salens, K, Kokosielis, P & Kamath, S 2008, Automatic virtual machine configuration for databas workloads. in Proceedings of the ACM SIGMOD International Conference on Management of Data., 1376711, pp. 953-966, 2008 ACM SIGMOD International Conference on Management of Data 2008, SIGMOD'08, Vancouver, BC, Canada, 9/6/08. https://doi.org/10.1145/1376616.1376711
Soror AA, Minhast UF, Aboulnaga A, Salens K, Kokosielis P, Kamath S. Automatic virtual machine configuration for databas workloads. In Proceedings of the ACM SIGMOD International Conference on Management of Data. 2008. p. 953-966. 1376711 https://doi.org/10.1145/1376616.1376711
Soror, Ahmed A. ; Minhast, Umar Farooq ; Aboulnaga, Ashraf ; Salens, Kenneth ; Kokosielis, Peter ; Kamath, Sunil. / Automatic virtual machine configuration for databas workloads. Proceedings of the ACM SIGMOD International Conference on Management of Data. 2008. pp. 953-966
@inproceedings{2cc5337667084a8cbfa9d4a8d946973e,
title = "Automatic virtual machine configuration for databas workloads",
abstract = "Virtual machine monitors are becoming popular tools for the deployment of database management systems and other enterprise software applications. In this paper, we consider a common resource consolidation scenario, in which several database management system instances, each running in a virtual machine, are sharing a common pool of physical computing resources. We address the problem of optimizing the performance of these database management systems by controlling the configurations of the virtual machines in which they run. These virtual machine configurations determine how the shared physical resources will be allocated to the different database instances. We introduce a virtualization design advisor that uses information about the anticipated workloads of each of the database systems to recommend workload-specific configurations offline. Furthermore, runtime information collected after the deployment of the recommended configurations can be used to refine the recommendation. To estimate the effect of a particular resource allocation on workload performance, we use the query optimizer in a new what-if mode. We have implemented our approach using both PostgreSQL and DB2, and we have experimentally evaluated its effectiveness using DSS and OLTP workloads.",
keywords = "Resource consolidation, Virtual machine configuration, Virtualization",
author = "Soror, {Ahmed A.} and Minhast, {Umar Farooq} and Ashraf Aboulnaga and Kenneth Salens and Peter Kokosielis and Sunil Kamath",
year = "2008",
month = "12",
day = "10",
doi = "10.1145/1376616.1376711",
language = "English",
isbn = "9781605581026",
pages = "953--966",
booktitle = "Proceedings of the ACM SIGMOD International Conference on Management of Data",

}

TY - GEN

T1 - Automatic virtual machine configuration for databas workloads

AU - Soror, Ahmed A.

AU - Minhast, Umar Farooq

AU - Aboulnaga, Ashraf

AU - Salens, Kenneth

AU - Kokosielis, Peter

AU - Kamath, Sunil

PY - 2008/12/10

Y1 - 2008/12/10

N2 - Virtual machine monitors are becoming popular tools for the deployment of database management systems and other enterprise software applications. In this paper, we consider a common resource consolidation scenario, in which several database management system instances, each running in a virtual machine, are sharing a common pool of physical computing resources. We address the problem of optimizing the performance of these database management systems by controlling the configurations of the virtual machines in which they run. These virtual machine configurations determine how the shared physical resources will be allocated to the different database instances. We introduce a virtualization design advisor that uses information about the anticipated workloads of each of the database systems to recommend workload-specific configurations offline. Furthermore, runtime information collected after the deployment of the recommended configurations can be used to refine the recommendation. To estimate the effect of a particular resource allocation on workload performance, we use the query optimizer in a new what-if mode. We have implemented our approach using both PostgreSQL and DB2, and we have experimentally evaluated its effectiveness using DSS and OLTP workloads.

AB - Virtual machine monitors are becoming popular tools for the deployment of database management systems and other enterprise software applications. In this paper, we consider a common resource consolidation scenario, in which several database management system instances, each running in a virtual machine, are sharing a common pool of physical computing resources. We address the problem of optimizing the performance of these database management systems by controlling the configurations of the virtual machines in which they run. These virtual machine configurations determine how the shared physical resources will be allocated to the different database instances. We introduce a virtualization design advisor that uses information about the anticipated workloads of each of the database systems to recommend workload-specific configurations offline. Furthermore, runtime information collected after the deployment of the recommended configurations can be used to refine the recommendation. To estimate the effect of a particular resource allocation on workload performance, we use the query optimizer in a new what-if mode. We have implemented our approach using both PostgreSQL and DB2, and we have experimentally evaluated its effectiveness using DSS and OLTP workloads.

KW - Resource consolidation

KW - Virtual machine configuration

KW - Virtualization

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

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

U2 - 10.1145/1376616.1376711

DO - 10.1145/1376616.1376711

M3 - Conference contribution

SN - 9781605581026

SP - 953

EP - 966

BT - Proceedings of the ACM SIGMOD International Conference on Management of Data

ER -