Skip to main content

Cost-Performance Driven Resource Configuration for Database Applications in IaaS Cloud Environments

  • Conference paper
  • First Online:

Abstract

IaaS (Infrastructure-as-a-Service) typically delivers a platform virtualization environment as a service. In IaaS cloud environments, applications are deployed on VMs (virtual machines), and the customers pay for the computing resources (e.g. CPU, memory) configured to VMs. As to the resource configuration of VMs, there are some problems on cost and performance control which the cloud customers care about, such as, minimizing the financial cost while ensuring the performance, optimizing the performance within the limitation of budget, making a tradeoff between cost and performance, and balancing the performance of applications on different VMs. In this paper, we focus on database applications and present a multiple objective optimization approach to address these problems. We have carried out some evaluation experiments using TPC-H queries and PostgreSQL database in a simulated cloud environment; and the results show that the effectiveness of our approach is significant.

This is a preview of subscription content, log in via an institution.

Buying options

Chapter
USD   29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD   129.00
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD   169.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info
Hardcover Book
USD   169.99
Price excludes VAT (USA)
  • Durable hardcover edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Learn about institutional subscriptions

References

  1. TPC-H, http://www.tpc.org/tpch/default.asp

  2. Xiong, P., Wang, Z., Jung, G., Pu, C.: Study on performance management and application behavior in virtualized environment. In: IEEE 2010 Network Operations and Management Symposium (NOMS). IEEE (2010) 841–844

    Google Scholar 

  3. Somani, G., Chaudhary, S.: Application Performance Isolation in Virtualization. In: IEEE 2009 International Conference on Cloud Computing. IEEE (2009) 41–48

    Google Scholar 

  4. Kusic, D., Kephart, J.O., Hanson, J.E., Kandasamy, N., Jiang, G.: Power and performance management of virtualized computing environments via lookahead control. Cluster Computing 12 (2009) 1–15

    Article  Google Scholar 

  5. Padala, P., Hou, K.Y., Shin, K.G., Zhu, X., Uysal, M., Wang, Z., Singhal, S., Merchant, A.: Automated control of multiple virtualized resources. In: Proceedings of the 4th ACM European conference on Computer systems. ACM (2009) 13–26

    Google Scholar 

  6. Rao, J., Bu, X., Xu, C.Z., Wang, L., Yin, G.: VCONF: a reinforcement learning approach to virtual machines auto-configuration. In: Proceedings of the 6th international conference on Autonomic computing. ACM (2009) 137–146

    Google Scholar 

  7. Bu, X., Rao, J., Xu, C.Z.: CoTuner: a framework for coordinated auto-configuration of virtualized resources and appliances. In: Proceeding of the 7th international conference on Autonomic computing. ACM (2010) 75–76

    Google Scholar 

  8. Wang, X., Wang, Y.: Co-con: Coordinated control of power and application performance for virtualized server clusters. In: 17th International Workshop on Quality of Service. IEEE (2009) 1–9

    Google Scholar 

  9. Urgaonkar, R., Kozat, U.C., Igarashi, K., Neely, M.J.: Dynamic resource allocation and power management in virtualized data centers. In: IEEE 2010 Network Operations and Management Symposium (NOMS). IEEE (2010) 479–486

    Google Scholar 

  10. Shivam, P., Demberel, A., Gunda, P., Irwin, D., Grit, L., Yumerefendi, A., Babu, S., Chase, J.: 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 (2007) 1079–1081

    Google Scholar 

  11. Soror, A.A., Minhas, U.F., Aboulnaga, A., Salem, K., Kokosielis, P., Kamath, S.: Automatic virtual machine configuration for database workloads. In: Proceedings of the 2008 ACM SIGMOD international conference on Management of data. ACM (2008) 953–966

    Google Scholar 

  12. Florescu, D., Kossmann, D.: Rethinking cost and performance of database systems. ACM SIGMOD Record 38 (2009) 43–48

    Article  Google Scholar 

  13. Henzinger, T.A., Singh, A.V., Singh, V., Wies, T., Zufferey, D.: FlexPRICE: Flexible Provisioning of Resources in a Cloud Environment. In: IEEE 3rd International Conference on Cloud Computing. IEEE (2010) 83–90

    Google Scholar 

  14. Amazon EC2 Instance Types, http://aws.amazon.com/ec2/instance-types

  15. Rogers, J., Papaemmanouil, O., Cetintemel, U.: A generic auto-provisioning framework for cloud databases. In: IEEE 26th International Conference on Data Engineering Workshops (ICDEW). IEEE (2010) 63–68

    Google Scholar 

  16. OriginLab: data analysis and graphing software, http://www.originlab.com/

  17. More, J.: The Levenberg–Marquardt algorithm: implementation and theory. Numerical analysis (1978) 105–116

    Google Scholar 

  18. XenServer, http://www.citrix.com/English/ps2/products/product.asp?contentID=683148\%26;ntref=prod\_;top

    Google Scholar 

  19. PostgreSQL, http://www.postgresql.org/

Download references

Acknowledgements

The work is funded by National Natural Science Foundation of China (61073004) and Chinese Major State Basic Research Development 973 Program (2011CB302200).

Author information

Authors and Affiliations

Authors

Corresponding author

Correspondence to Shoubin Kong .

Editor information

Editors and Affiliations

Rights and permissions

Reprints and permissions

Copyright information

© 2012 Springer Science+Business Media New York

About this paper

Cite this paper

Kong, S., Li, Y., Feng, L. (2012). Cost-Performance Driven Resource Configuration for Database Applications in IaaS Cloud Environments. In: Ivanov, I., van Sinderen, M., Shishkov, B. (eds) Cloud Computing and Services Science. CLOSER 2011. Service Science: Research and Innovations in the Service Economy. Springer, New York, NY. https://doi.org/10.1007/978-1-4614-2326-3_6

Download citation

  • DOI: https://doi.org/10.1007/978-1-4614-2326-3_6

  • Published:

  • Publisher Name: Springer, New York, NY

  • Print ISBN: 978-1-4614-2325-6

  • Online ISBN: 978-1-4614-2326-3

  • eBook Packages: Computer ScienceComputer Science (R0)

Publish with us

Policies and ethics