Paper Info
Title
Fuzzy Modeling Based Resource Management for Virtualized Database Systems
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.
Year
DOI
Venue
2011
10.1109/MASCOTS.2011.70
MASCOTS
Keywords
Field
DocType
resource allocation,complex query workloads,resource management,on-demand allocation,peak-load-based allocation,o bandwidth,xen-based vms,database system,resource utilization,multi-type resource need,virtualized database systems,substantial resource,databases,data model,database management systems,virtual machines,virtual machine,resource manager,predictive models,data models,qos,prediction model,quality of service,fuzzy set theory,dynamic scheduling
Data modeling,Virtual machine,Computer science,Quality of service,Real-time computing,Throughput,Distributed computing,Resource management,Resource allocation,Bandwidth (signal processing),Dynamic priority scheduling,Operating system,Database
Conference
Citations 
PageRank 
References 
24
0.87
27
Authors
5
Name
Order
Citations
PageRank
Lixi Wang1553.60
Jing Xu2523.35
Ming Zhao327417.91
Yi-Cheng Tu443433.86
Jose A. B. Fortes544652.01