FLEXIBLE CONTROL OF PERFORMANCE AND EXPENSES FOR DATABASE APPLICATIONS IN A CLOUD ENVIRONMENT

Shoubin Kong, Yuanping Li, Ling Feng

Abstract

IaaS is a popular cloud computing service paradigm based on virtualization technology. In an IaaS cloud environment, the service provider configures VMs with physical computing resources (e.g., CPU and memory) and leases them to IaaS customers to run their applications. The customers pay for the resources they use. Such a pay-as-you-go charging mode brings about a few critical concerns about the expenses paid and the performance received. From the standpoint of cloud customers, such concerns as minimizing the expenses while ensuring the performance, optimizing the performance within the budget limit, compromising the expenses and performance, or balancing performance of applications running on different VMs, etc. thus arise. For the IaaS provider, how to reasonably configure VMs so as to meet various requirements from different customers becomes a challenge, whose solution influences the acceptance of IaaS in the future. In this paper, we address this problem and present a weighted multiple objective optimization approach for flexible control of expenses and performance in an IaaS cloud environment. We focus on database applications, consisting of various queries to be executed on different VMs. A genetic algorithm is implemented based on a fine-grained charging model, as well as a normalized performance model. Experiments have been conducted to evaluate the effectiveness and efficiency of our approach, using TPC-H queries and PostgreSQL database in a simulated cloud environment.

References

  1. TPC-H. Retrieved October 26, 2010, from http://www.tpc.org/tpch/default.asp
  2. Amazon EC2 Instance Types. Retrieved October 29, 2010, from http://aws.amazon.com/ec2/instance-types
  3. OriginLab: data analysis and graphing software. Retrieved November 3, 2010, from http://www.originlab.com/
  4. XenServer. Retrieved November 5, 2010, from http://www.citrix.com/English/ps2/products/product.as p?contentID=683148&ntref=prod_top
  5. Bu, X., J. Rao and C. Z. Xu. 2010. CoTuner: a framework for coordinated auto-configuration of virtualized resources and appliances. In Proceeding of the 7th international conference on Autonomic computing. ACM.
  6. Florescu, D. and D. Kossmann. 2009. Rethinking cost and performance of database systems. ACM SIGMOD Record 38(1):43-48.
  7. Henzinger, T. A., A. V. Singh, V. Singh, T. Wies and D. Zufferey. 2010. FlexPRICE: Flexible Provisioning of Resources in a Cloud Environment. In 2010 IEEE 3rd International Conference on Cloud Computing. IEEE.
  8. Kusic, D., J. O. Kephart, J. E. Hanson, N. Kandasamy and G. Jiang. 2009. Power and performance management of virtualized computing environments via lookahead control. Cluster Computing 12(1):1-15.
  9. More, J. 1978. The Levenberg-Marquardt algorithm: implementation and theory. Numerical analysis:105- 116.
  10. Padala, P., K. Y. Hou, K. G. Shin, X. Zhu, M. Uysal, Z. Wang, S. Singhal and A. Merchant. 2009. Automated control of multiple virtualized resources. In Proceedings of the 4th ACM European conference on Computer systems. ACM.
  11. Rao, J., X. Bu, C. Z. Xu, L. Wang and G. Yin. 2009. VCONF: a reinforcement learning approach to virtual machines auto-configuration. In Proceedings of the 6th international conference on Autonomic computing. ACM.
  12. Rogers, J., O. Papaemmanouil and U. Cetintemel. 2010. A generic auto-provisioning framework for cloud databases. In 2010 IEEE 26th International Conference on Data Engineering Workshops (ICDEW). IEEE.
  13. Shivam, P., A. Demberel, P. Gunda, D. Irwin, L. Grit, A. Yumerefendi, S. Babu and J. Chase. 2007. Automated and on-demand provisioning of virtual machines for database applications. In Proceedings of the 2007 ACM SIGMOD international conference on Management of data. ACM.
  14. Somani, G. and S. Chaudhary. 2009. Application Performance Isolation in Virtualization. In 2009 IEEE International Conference on Cloud Computing. IEEE.
  15. Soror, A. A., U. F. Minhas, A. Aboulnaga, K. Salem, P. Kokosielis and S. Kamath. 2008. Automatic virtual machine configuration for database workloads. In Proceedings of the 2008 ACM SIGMOD international conference on Management of data. ACM.
  16. Urgaonkar, R., U. C. Kozat, K. Igarashi and M. J. Neely. 2010. Dynamic resource allocation and power management in virtualized data centers. In Network Operations and Management Symposium (NOMS). IEEE.
  17. Wang, X. and Y. Wang. 2009. Co-con: Coordinated control of power and application performance for virtualized server clusters. In 17th International Workshop on Quality of Service. IEEE.
  18. Xiong, P., Z. Wang, G. Jung and C. Pu. 2010. Study on performance management and application behavior in virtualized environment. In Network Operations and Management Symposium (NOMS). IEEE.
Download


Paper Citation


in Harvard Style

Kong S., Li Y. and Feng L. (2011). FLEXIBLE CONTROL OF PERFORMANCE AND EXPENSES FOR DATABASE APPLICATIONS IN A CLOUD ENVIRONMENT . In Proceedings of the 1st International Conference on Cloud Computing and Services Science - Volume 1: CLOSER, ISBN 978-989-8425-52-2, pages 201-210. DOI: 10.5220/0003379802010210


in Bibtex Style

@conference{closer11,
author={Shoubin Kong and Yuanping Li and Ling Feng},
title={FLEXIBLE CONTROL OF PERFORMANCE AND EXPENSES FOR DATABASE APPLICATIONS IN A CLOUD ENVIRONMENT},
booktitle={Proceedings of the 1st International Conference on Cloud Computing and Services Science - Volume 1: CLOSER,},
year={2011},
pages={201-210},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0003379802010210},
isbn={978-989-8425-52-2},
}


in EndNote Style

TY - CONF
JO - Proceedings of the 1st International Conference on Cloud Computing and Services Science - Volume 1: CLOSER,
TI - FLEXIBLE CONTROL OF PERFORMANCE AND EXPENSES FOR DATABASE APPLICATIONS IN A CLOUD ENVIRONMENT
SN - 978-989-8425-52-2
AU - Kong S.
AU - Li Y.
AU - Feng L.
PY - 2011
SP - 201
EP - 210
DO - 10.5220/0003379802010210