Automatic virtual machine configuration for database workloads

ACM Transactions on Database Systems

Volumn 35, Issue 1, 2010, Pages

  Soror, Ahmed A ^a   Minhas, Umar Farooq ^a   Aboulnaga, Ashraf ^a   Salem, Kenneth ^a   Kokosielis, Peter ^b   Kamath, Sunil ^b  

^a UNIVERSITY OF WATERLOO   (Canada)

^b IBM TORONTO LAB   (Canada)

Author keywords

Virtual machine configuration; Virtualization

Indexed keywords

COMMON RESOURCES; DATA-BASE MANAGEMENT SYSTEMS; DATABASE WORKLOAD; ENTERPRISE SOFTWARE; OFFLINE; OPTIMIZERS; PHYSICAL COMPUTING; PHYSICAL RESOURCES; POSTGRESQL; RUN-TIME INFORMATION; RUNNING-IN; VIRTUAL MACHINE CONFIGURATION; VIRTUAL MACHINE MONITORS; VIRTUAL MACHINES; VIRTUALIZATIONS;

MANAGEMENT; MANAGEMENT INFORMATION SYSTEMS;

DATABASE SYSTEMS;

EID: 77249140703     PISSN: 03625915     EISSN: 15574644     Source Type: Journal    
DOI: 10.1145/1670243.1670250     Document Type: Article

References (36)

1. AGRAWAL, R., CHAUDHURI, S., DAS, A., AND NARASAYYA, V. R. 2003. Automating layout of relational databases. In Proceedings of the International Conference on Data Engineering (ICDE).
2. BARHAM, P. T., DRAGOVIC, B., FRASER, K., HAND, S., HARRIS, T. L., HO, A., NEUGEBAUER, R., PRATT, I., AND WARFIELD, A. 2003. Xen and the art of virtualization. In Proceedings of the ACM Symposium on Operating Systems Principles (SOSP).
3. BENNANI, M. AND MENASCE, D. A. 2005. Resource allocation for autonomic data centers using analytic performance models. In Proceedings of the IEEE International Conference on Autonomic Computing (ICAC).
4. CAREY, M. J., JAUHARI, R., AND LIVNY, M. 1989. Priority in DBMS resource scheduling. In Proceedings of the International Conference on Very Large Data Bases (VLDB).
5. CLARK, C., FRASER, K., HAND, S., HANSEN, J. G., JUL, E., LIMPACH, C., PRATT, I., ANDWARFIELD, A. 2005. Live migration of virtual machines. In Proceedings of the Symposium on Networked Systems Design and Implementation (NSDI).
6. DAGEVILLE, B. AND ZÄIT, M. 2002. SQL memory management in Oracle9i. In Proceedings of the International Conference on Very Large Data Bases (VLDB).
7. DAVISON, D. L. AND GRAEFE, G. 1995. Dynamic resource brokering for multi-user query execution. In Proceedings of the ACM SIGMOD International Conference on Management of Data. DBT3. OSDL Database Test Suite 3. http://sourceforge.net/projects/osdldbt.
8. DIAS, K., RAMACHER, M., SHAFT, U., VENKATARAMANI, V., ANDWOOD, G. 2005. Automatic performance diagnosis and tuning in Oracle. In Proceedings of the Conference on Innovative Data Systems Research (CIDR).
9. GAROFALAKIS, M. N. AND IOANNIDIS, Y. E. 1996. Multi-dimensional resource scheduling for parallel queries. In Proceedings of the ACM SIGMOD International Conference on Management of Data.
10. HABIB, I. 2008. Virtualization with KVM. Linux J. 2008, 166.
11. IBM CORPORATION. 2006. IBM DB2 v9 performance guide. ftp://ftp.software. ibm.com/ps/products/db2/info/vr9/pdf/letter/en US/db2d3e90.pdf
12. KARVE, A., KIMBREL, T., PACIFICI, G., SPREITZER, M., STEINDER, M., SVIRIDENKO, M., AND TANTAWI, A. 2006. Dynamic placement for clustered Web applications. In Proceedings of the International Conference on WWW.
13. KHANNA, G., BEATY, K., KAR, G., AND KOCHUT, A. 2006. Application performance management in virtualized server environments. In Proceedings of the IEEE/IFIP Network Operations and Management Symposium (NOMS).
14. LIU, F., ZHAO, Y.,WANG, W., ANDMAKAROFF, D. 2004. Database server workload characterization in an E-Commerce environment. In Proceedings of the IEEE International Symposium on Modeling, Analysis, and Simulation of Computer and Telecommunication Systems (MASCOTS).
15. LLANOS, D. R. 2006. TPCC-UVA: An open-source TPC-C implementation for global performance measurement of computer systems. ACM SIGMOD Rec. 35, 4.
16. MARTIN, P., LI, H.-Y., ZHENG, M., ROMANUFA, K., AND POWLEY, W. 2000. Dynamic reconfiguration algorithm: Dynamically tuning multiple buffer pools. In Proceedings of the International Conference on Database and Expert Systems Applications (DEXA).
17. MEHTA, M. AND DEWITT, D. J. 1993. Dynamic memory allocation for multiple-query workloads. In Proceedings of the International Conference on Very Large Data Bases (VLDB).
18. MICROSOFT CORPORATION. 2008. MicrosoftWindows server 2008 R2 hyper-V. http://www.microsoft.com/windowsserver2008/en/us/hyperv-main.aspx.
19. MICROSOFT CORPORATION. 2009. Virtualization case studies: Consolidation. http://www.microsoft.com/virtualization/casestudies/consolidation/default.mspx.
20. NARAYANAN, D., THERESKA, E., AND AILAMAKI, A. 2005. Continuous resource monitoring for selfpredicting DBMS. In Proceedings of the IEEE International Symposium on Modeling, Analysis, and Simulation of Computer and Telecommunication Systems (MASCOTS).
21. PARK, S.-M. AND HUMPHREY, M. 2009. Self-Tuning virtual machines for predictable escience. In Proceedings of the IEEE/ACM International Symposium on Cluster Computing and the Grid (CCGRID).
22. ROSENBLUM,M. AND GARFINKEL, T. 2005. Virtual machine monitors: Current technology and future trends. IEEE Comput. 38, 5.
23. RUTH, P., RHEE, J., XU, D., KENNELL, R., AND GOASGUEN, S. 2006. Autonomic live adaptation of virtual computational environments in amulti-domain infrastructure. In Proceedings of the IEEE International Conference on Autonomic Computing (ICAC).
24. SHIVAM, P., DEMBEREL, A., GUNDA, P., IRWIN, D. E., GRIT, L. E., YUMEREFENDI, A. R., BABU, S., AND CHASE, J. S. 2007. Automated and on-demand provisioning of virtual machines for database applications. In Proceedings of the ACM SIGMOD International Conference on Management of Data. Demonstration.
25. SMITH, J. E. AND NAIR, R. 2005. The architecture of virtual machines. IEEE Comput. 38, 5.
26. SOROR, A. A., ABOULNAGA, A., AND SALEM, K. 2007. Database virtualization: A new frontier for database tuning and physical design. In Proceedings of theWorkshop on Self-Managing Database Systems (SMDB).
27. SOROR, A. A., MINHAS, U. F., ABOULNAGA, A., SALEM, K., KOKOSIELIS, P., AND KAMATH, S. 2008. Automatic virtual machine configuration for database workloads. In Proceedings of the ACMSIGMOD International Conference on Management of Data.
28. STEINDER, M., WHALLEY, I., AND CHESS, D. 2008. Server virtualization in autonomic management of heterogeneous workloads. SIGOPS Oper. Syst. Rev. 42, 1.
29. STORM, A. J., GARCIA-ARELLANO, C., LIGHTSTONE, S., DIAO, Y., AND SURENDRA,M. 2006. Adaptive selftuning memory in DB2. In Proceedings of the International Conference on Very Large Data Bases (VLDB).
30. TANG, C., STEINDER, M., SPREITZER, M., AND PACIFICI, G. 2007. A scalable application placement controller for enterprise data centers. In Proceedings of the International Conference on World Wide Web.
31. TESAURO,G.,DAS, R.,WALSH,W. E., ANDKEPHART, J.O. 2005. Utility-Function-Driven resource allocation in autonomic systems. In Proceedings of the IEEE International Conference on Autonomic Computing (ICAC). VMware. VMware. http://www.vmware.com/.
32. WANG, X., DU, Z., CHEN, Y., AND LI, S. 2008. Virtualization-based autonomic resource management for multi-tier web applications in shared data center. J. Syst. Softw.
33. WANG, X., LAN, D., WANG, G., FANG, X., YE, M., CHEN, Y., AND WANG, Q. 2007. Appliance-Based autonomic provisioning framework for virtualized outsourcing data center. In Proceedings of the IEEE International Conference on Autonomic Computing (ICAC).
34. WATSON, J. 2008. Virtualbox: bits and bytes masquerading as machines. Linux J. 2008, 166.
35. WEIKUM, G., MöNKEBERG, A., HASSE, C., AND ZABBACK, P. 2002. Self-Tuning database technology and information services: From wishful thinking to viable engineering. In Proceedings of the International Conference on Very Large Data Bases (VLDB). XenSource. XenSource. http://www.xensource.com/.
36. YU, P. S., SYAN CHEN, M., ULRICH HEISS, H., AND LEE, S. 1992. On workload characterization of relational database environments. IEEE Trans. Softw. Engin. 18.