Priority in DBMS resource scheduling
VLDB '89 Proceedings of the 15th international conference on Very large data bases
Dynamic resource brokering for multi-user query execution
SIGMOD '95 Proceedings of the 1995 ACM SIGMOD international conference on Management of data
Multi-dimensional resource scheduling for parallel queries
SIGMOD '96 Proceedings of the 1996 ACM SIGMOD international conference on Management of data
Dynamic Memory Allocation for Multiple-Query Workloads
VLDB '93 Proceedings of the 19th International Conference on Very Large Data Bases
Xen and the art of virtualization
SOSP '03 Proceedings of the nineteenth ACM symposium on Operating systems principles
The Architecture of Virtual Machines
Computer
Resource Allocation for Autonomic Data Centers using Analytic Performance Models
ICAC '05 Proceedings of the Second International Conference on Automatic Computing
Utility-Function-Driven Resource Allocation in Autonomic Systems
ICAC '05 Proceedings of the Second International Conference on Automatic Computing
Continuous resource monitoring for self-predicting DBMS
MASCOTS '05 Proceedings of the 13th IEEE International Symposium on Modeling, Analysis, and Simulation of Computer and Telecommunication Systems
Dynamic placement for clustered web applications
Proceedings of the 15th international conference on World Wide Web
Adaptive self-tuning memory in DB2
VLDB '06 Proceedings of the 32nd international conference on Very large data bases
A scalable application placement controller for enterprise data centers
Proceedings of the 16th international conference on World Wide Web
Automated and on-demand provisioning of virtual machines for database applications
Proceedings of the 2007 ACM SIGMOD international conference on Management of data
Appliance-Based Autonomic Provisioning Framework for Virtualized Outsourcing Data Center
ICAC '07 Proceedings of the Fourth International Conference on Autonomic Computing
VLDB '02 Proceedings of the 28th international conference on Very Large Data Bases
Journal of Systems and Software
Autonomic Live Adaptation of Virtual Computational Environments in a Multi-Domain Infrastructure
ICAC '06 Proceedings of the 2006 IEEE International Conference on Autonomic Computing
Database Virtualization: A New Frontier for Database Tuning and Physical Design
ICDEW '07 Proceedings of the 2007 IEEE 23rd International Conference on Data Engineering Workshop
VCONF: a reinforcement learning approach to virtual machines auto-configuration
ICAC '09 Proceedings of the 6th international conference on Autonomic computing
Automatic virtual machine configuration for database workloads
ACM Transactions on Database Systems (TODS)
Tuning database configuration parameters with iTuned
Proceedings of the VLDB Endowment
Reflective control for an elastic cloud application: an automated experiment workbench
HotCloud'09 Proceedings of the 2009 conference on Hot topics in cloud computing
Predicting completion times of batch query workloads using interaction-aware models and simulation
Proceedings of the 14th International Conference on Extending Database Technology
Zephyr: live migration in shared nothing databases for elastic cloud platforms
Proceedings of the 2011 ACM SIGMOD International Conference on Management of data
Towards cost-effective storage provisioning for DBMSs
Proceedings of the VLDB Endowment
URL: A unified reinforcement learning approach for autonomic cloud management
Journal of Parallel and Distributed Computing
Case study of scientific data processing on a cloud using hadoop
HPCS'09 Proceedings of the 23rd international conference on High Performance Computing Systems and Applications
DejaVu: accelerating resource allocation in virtualized environments
ASPLOS XVII Proceedings of the seventeenth international conference on Architectural Support for Programming Languages and Operating Systems
The evolving landscape of data management in the cloud
International Journal of Computational Science and Engineering
Dynamic management of resources and workloads for RDBMS in cloud: a control-theoretic approach
PhD '12 Proceedings of the on SIGMOD/PODS 2012 PhD Symposium
Automatic scaling of selective SPARQL joins using the TIRAMOLA system
SWIM '12 Proceedings of the 4th International Workshop on Semantic Web Information Management
An architecture framework for application-managed scaling of cloud-hosted relational databases
Proceedings of the WICSA/ECSA 2012 Companion Volume
Application-aware cross-layer virtual machine resource management
Proceedings of the 9th international conference on Autonomic computing
A Survey on Database Performance in Virtualized Cloud Environments
International Journal of Data Warehousing and Mining
A workload-driven approach to database query processing in the cloud
The Journal of Supercomputing
ProRea: live database migration for multi-tenant RDBMS with snapshot isolation
Proceedings of the 16th International Conference on Extending Database Technology
CloudOptimizer: multi-tenancy for I/O-bound OLAP workloads
Proceedings of the 16th International Conference on Extending Database Technology
MeT: workload aware elasticity for NoSQL
Proceedings of the 8th ACM European Conference on Computer Systems
Hi-index | 0.00 |
Virtual machine monitors are becoming popular tools for the deployment of database management systems and other enterprise software applications. In this paper, we consider a common resource consolidation scenario, in which several database management system instances, each running in a 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 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 offine. Furthermore, runtime information collected after the deployment of the recommended configurations can be used to refine the recommendation. 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.