Workload-aware database monitoring and consolidation

In most enterprises, databases are deployed on dedicated database servers. Often, these servers are underutilized much of the time. For example, in traces from almost 200 production servers from different organizations, we see an average CPU utilization of less than 4%. This unused capacity can be potentially harnessed to consolidate multiple databases on fewer machines, reducing hardware and operational costs. Virtual machine (VM) technology is one popular way to approach this problem. However, as we demonstrate in this paper, VMs fail to adequately support database consolidation, because databases place a unique and challenging set of demands on hardware resources, which are not well-suited to the assumptions made by VM-based consolidation. Instead, our system for database consolidation, named Kairos, uses novel techniques to measure the hardware requirements of database workloads, as well as models to predict the combined resource utilization of those workloads. We formalize the co...

• Type: Journal
• Year: 2011
• Where: SIGMOD
• Authors: Carlo Curino, Evan P. C. Jones, Samuel Madden, Hari Balakrishnan
• Keywords: Database, Database Consolidation, Linear Optimization, Optimization Program, SIGMOD 2011