Autonomic Resource Management for Virtualized Database Hosting Systems

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 allocation of physical resources on demand to a database's VM according to QoS (Quality of Service) requirements. This is a challenging problem because of the highly dynamic and complex nature of database systems and their workloads. An autonomic resource management approach is proposed to address this problem based on adaptive fuzzy modeling and prediction techniques. The approach can effectively capture the relationship between a dynamically changing database workload, which is both CPU and I/O intensive, and its VM's consumption of resources, including both CPU cycles and disk bandwidth.