skip to main content
10.1145/2851613.2851621acmconferencesArticle/Chapter ViewAbstractPublication PagessacConference Proceedingsconference-collections
research-article

Elastic provisioning for cloud databases with uncertainty management

Published:04 April 2016Publication History

ABSTRACT

Cloud computing is a compelling, emerging paradigm that supports on-demand services with pay-as-you-go model. It is fundamental for cloud providers to allocate resource quantities suitable to ensure performance while reducing the operational costs related to both overprovisioning and penalties for SLA violations. Performance of cloud services may be unstable because of the environment. Most automatic provisioning techniques lack the capacity to handle the uncertainty of service performance. In this work, we investigate uncertainty management for cloud database elasticity from a probabilistic, performance-driven standpoint, and propose ProDBC, a novel approach for elastic provisioning. ProDBC uses a separate network for profiling in order to build a probabilistic model describing the relationship between workload, resource quantities and the subsequent performance. This model is embedded into a cost function in which the trade-off between infrastructure cost, SLA violation rate and the confidence level (uncertainty) is controlled intuitively. Experimental results obtained with the OLTP Database Benchmark showed provisioning actions taken by ProDBC provides elasticity while limiting the number of SLA violations.

References

  1. E. Cecchet, R. Singh, U. Sharma, and P. Shenoy. Dolly: virtualization-driven database provisioning for the cloud. In ACM VEE, pages 51--62, 2011. Google ScholarGoogle ScholarDigital LibraryDigital Library
  2. E. F. Coutinho, F. R. C. Sousa, P. A. L. Rego, D. G. Gomes, and J. N. de Souza. Elasticity in cloud computing: a survey. annals of telecommunications - annales des télécommunications, pages 1--21, 2014.Google ScholarGoogle Scholar
  3. C. Curino, E. P. Jones, S. Madden, and H. Balakrishnan. Workload-aware database monitoring and consolidation. In SIGMOD '11, pages 313--324, 2011. Google ScholarGoogle ScholarDigital LibraryDigital Library
  4. T. L. C. da Silva, M. A. Nascimento, J. A. F. de Macêdo, F. R. C. Sousa, and J. C. Machado. Non-intrusive elastic query processing in the cloud. J. Comput. Sci. Technol., 28(6):932--947, 2013.Google ScholarGoogle ScholarCross RefCross Ref
  5. D. E. Difallah, A. Pavlo, C. Curino, and P. Cudré-Mauroux. Oltp-bench: An extensible testbed for benchmarking relational databases. PVLDB, 7(4):277--288, 2013. Google ScholarGoogle ScholarDigital LibraryDigital Library
  6. H. Fernandez, G. Pierre, and T. Kielmann. Autoscaling web applications in heterogeneous cloud infrastructures. In IC2E, 2014. Google ScholarGoogle ScholarDigital LibraryDigital Library
  7. A. Guabtni, R. Ranjan, and F. Rabhi. A workload-driven approach to database query processing in the cloud. The Journal of Supercomputing, 63(3):722--736, 2013. Google ScholarGoogle ScholarDigital LibraryDigital Library
  8. T. Heinze, V. Pappalardo, Z. Jerzak, and C. Fetzer. Auto-scaling techniques for elastic data stream processing. In DEBS '14, pages 318--321, 2014. Google ScholarGoogle ScholarDigital LibraryDigital Library
  9. U. F. Minhas, R. Liu, A. Aboulnaga, K. Salem, J. Ng, and S. Robertson. Elastic scale-out for partition-based database systems. In SMDB, pages 281--288, 2012. Google ScholarGoogle ScholarDigital LibraryDigital Library
  10. G. A. C. Santos, J. G. R. Maia, L. O. Moreira, F. R. C. Sousa, and J. C. Machado. Scale-space filtering for workload analysis and forecast. In CLOUD '13, pages 677--684, 2013. Google ScholarGoogle ScholarDigital LibraryDigital Library
  11. J. Schad, J. Dittrich, and J.-A. Quiané-Ruiz. Runtime measurements in the cloud: Observing, analyzing, and reducing variance. PVLDB, 3(1):460--471, 2010. Google ScholarGoogle ScholarDigital LibraryDigital Library
  12. F. R. C. Sousa and J. C. Machado. Towards elastic multi-tenant database replication with quality of service. In UCC '12, pages 168--175, 2012. Google ScholarGoogle ScholarDigital LibraryDigital Library
  13. F. R. C. Sousa, L. O. Moreira, G. A. C. Santos, and J. C. Machado. Quality of service for database in the cloud. In CLOSER '12, pages 595--601, 2012.Google ScholarGoogle Scholar

Index Terms

  1. Elastic provisioning for cloud databases with uncertainty management

      Recommendations

      Comments

      Login options

      Check if you have access through your login credentials or your institution to get full access on this article.

      Sign in
      • Published in

        cover image ACM Conferences
        SAC '16: Proceedings of the 31st Annual ACM Symposium on Applied Computing
        April 2016
        2360 pages
        ISBN:9781450337397
        DOI:10.1145/2851613

        Copyright © 2016 ACM

        Permission to make digital or hard copies of all or part of this work for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial advantage and that copies bear this notice and the full citation on the first page. Copyrights for components of this work owned by others than ACM must be honored. Abstracting with credit is permitted. To copy otherwise, or republish, to post on servers or to redistribute to lists, requires prior specific permission and/or a fee. Request permissions from [email protected]

        Publisher

        Association for Computing Machinery

        New York, NY, United States

        Publication History

        • Published: 4 April 2016

        Permissions

        Request permissions about this article.

        Request Permissions

        Check for updates

        Qualifiers

        • research-article

        Acceptance Rates

        SAC '16 Paper Acceptance Rate252of1,047submissions,24%Overall Acceptance Rate1,650of6,669submissions,25%

      PDF Format

      View or Download as a PDF file.

      PDF

      eReader

      View online with eReader.

      eReader