Automatic virtual machine configuration for database workloads

Ahmed A. Soror, Umar Farooq Minhas, Ashraf Aboulnaga, Kenneth Salem, Peter Kokosielis, Sunil Kamath

Research output: Contribution to journalArticle

41 Citations (Scopus)

Abstract

Virtual machine monitors are becoming popular tools for the deployment of database management systems and other enterprise software. In this article, we consider a common resource consolidation scenario in which several database management system instances, each running in a separate 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 system 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 and to handle changes in the workload. 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
Article number7
JournalACM Transactions on Database Systems
Volume35
Issue number1
DOIs
Publication statusPublished - 1 Feb 2010
Externally publishedYes

Fingerprint

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

Keywords

  • Virtual machine configuration
  • Virtualization

ASJC Scopus subject areas

  • Information Systems

Cite this

Automatic virtual machine configuration for database workloads. / Soror, Ahmed A.; Minhas, Umar Farooq; Aboulnaga, Ashraf; Salem, Kenneth; Kokosielis, Peter; Kamath, Sunil.

In: ACM Transactions on Database Systems, Vol. 35, No. 1, 7, 01.02.2010.

Research output: Contribution to journalArticle

Soror, Ahmed A. ; Minhas, Umar Farooq ; Aboulnaga, Ashraf ; Salem, Kenneth ; Kokosielis, Peter ; Kamath, Sunil. / Automatic virtual machine configuration for database workloads. In: ACM Transactions on Database Systems. 2010 ; Vol. 35, No. 1.
@article{ef52a0c92421428cbb287483ded58a36,
title = "Automatic virtual machine configuration for database workloads",
abstract = "Virtual machine monitors are becoming popular tools for the deployment of database management systems and other enterprise software. In this article, we consider a common resource consolidation scenario in which several database management system instances, each running in a separate 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 system 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 and to handle changes in the workload. 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 = "Virtual machine configuration, Virtualization",
author = "Soror, {Ahmed A.} and Minhas, {Umar Farooq} and Ashraf Aboulnaga and Kenneth Salem and Peter Kokosielis and Sunil Kamath",
year = "2010",
month = "2",
day = "1",
doi = "10.1145/1670243.1670250",
language = "English",
volume = "35",
journal = "ACM Transactions on Database Systems",
issn = "0362-5915",
publisher = "Association for Computing Machinery (ACM)",
number = "1",

}

TY - JOUR

T1 - Automatic virtual machine configuration for database workloads

AU - Soror, Ahmed A.

AU - Minhas, Umar Farooq

AU - Aboulnaga, Ashraf

AU - Salem, Kenneth

AU - Kokosielis, Peter

AU - Kamath, Sunil

PY - 2010/2/1

Y1 - 2010/2/1

N2 - Virtual machine monitors are becoming popular tools for the deployment of database management systems and other enterprise software. In this article, we consider a common resource consolidation scenario in which several database management system instances, each running in a separate 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 system 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 and to handle changes in the workload. 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. In this article, we consider a common resource consolidation scenario in which several database management system instances, each running in a separate 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 system 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 and to handle changes in the workload. 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 - Virtual machine configuration

KW - Virtualization

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

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

U2 - 10.1145/1670243.1670250

DO - 10.1145/1670243.1670250

M3 - Article

VL - 35

JO - ACM Transactions on Database Systems

JF - ACM Transactions on Database Systems

SN - 0362-5915

IS - 1

M1 - 7

ER -