Fuzzy modeling based resource management for virtualized database systems

Lixi Wang, Jing Xu, Ming Zhao, Yicheng Tu, José A.B. Fortes

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

28 Scopus citations

Abstract

The hosting of databases on virtual machines (VMs) has great potential to improve the efficiency of resource utilization and the ease of deployment of database systems. This paper considers the problem of on-demand allocation of resources to a VM running a database serving dynamic and complex query workloads while meeting QoS (Quality of Service) requirements. An autonomic resource-management approach is proposed to address this problem. It uses adaptive fuzzy modeling to capture the behavior of a VM hosting a database with dynamically changing workloads and to predict its multi-type resource needs. A prototype of the proposed approach is implemented on Xen-based VMs and evaluated using workloads based on TPC-H and RUBiS. The results demonstrate that CPU and disk I/O bandwidth can be efficiently allocated to database VMs serving workloads with dynamically changing intensity and composition while meeting QoS targets. For TPC-H-based experiments, the resulting throughput is within 89.5 - 100% of what would be obtained using resource allocation based on peak loads, For RUBiS, the response time target (set based on the performance under peak-load-based allocation) is met for 97% of the time. Moreover, substantial resources are saved (about 62.6% of CPU and 76.5% of disk I/O bandwidth) in comparison to peak-load-based allocation.

Original languageEnglish (US)
Title of host publicationProceedings - 19th Annual IEEE/ACM International Symposium on Modeling, Analysis, and Simulation of Computer and Telecommunication Systems, MASCOTS 2011
Pages32-42
Number of pages11
DOIs
StatePublished - Sep 26 2011
Event19th Annual IEEE/ACM International Symposium on Modeling, Analysis, and Simulation of Computer and Telecommunication Systems, MASCOTS 2011 - Singapore, Singapore
Duration: Jul 25 2011Jul 27 2011

Publication series

NameIEEE International Workshop on Modeling, Analysis, and Simulation of Computer and Telecommunication Systems - Proceedings

Other

Other19th Annual IEEE/ACM International Symposium on Modeling, Analysis, and Simulation of Computer and Telecommunication Systems, MASCOTS 2011
CountrySingapore
CitySingapore
Period7/25/117/27/11

ASJC Scopus subject areas

  • Electrical and Electronic Engineering
  • Computer Networks and Communications
  • Information Systems
  • Modeling and Simulation

Fingerprint Dive into the research topics of 'Fuzzy modeling based resource management for virtualized database systems'. Together they form a unique fingerprint.

  • Cite this

    Wang, L., Xu, J., Zhao, M., Tu, Y., & Fortes, J. A. B. (2011). Fuzzy modeling based resource management for virtualized database systems. In Proceedings - 19th Annual IEEE/ACM International Symposium on Modeling, Analysis, and Simulation of Computer and Telecommunication Systems, MASCOTS 2011 (pp. 32-42). [6005366] (IEEE International Workshop on Modeling, Analysis, and Simulation of Computer and Telecommunication Systems - Proceedings). https://doi.org/10.1109/MASCOTS.2011.70