CloudOptimizer: Multi-tenancy for I/O-bound OLAP workloads

Hatem A. Mahmoud, Hyun Jin Moon, Yun Chi, Hakan Hacigümüş, Divyakant Agrawal, Amr El-Abbadi

Research output: Chapter in Book/Report/Conference proceedingConference contribution

10 Citations (Scopus)

Abstract

Consolidation of multiple databases on the same server allows service providers to save significant resources because many production database servers are often under-utilized. Recent research investigates the problem of minimizing the number of servers required to host a set of tenants when the working sets of tenants are kept in main memory (e.g., in-memory OLAP workloads, or OLTP workloads), thus the memory assigned to each tenant, as well as the I/O bandwidth and CPU time, are all dictated by the working set size of the tenant. Other research investigates the reverse problem when the number of servers is fixed, but the amount of resources allocated to different tenants on the same server needs to be configured to optimize a cost function. In this paper we investigate the problem when neither the number of servers nor the amount of resources allocated to each tenant are fixed. This problem arises when consolidating OLAP workloads of tenants whose service-level agreements (SLAs) allow for queries to be answered from disk. We study the trade-off between the amount of memory and the I/O bandwidth assigned to OLAP workloads, and develop a principled approach for allocating resources to tenants in a manner that minimizes the total number of servers required to host all tenants while satisfying the SLA of each tenant. We then explain how we modified InnoDB, the storage engine of MySQL, to be able to change the amount of resources allocated to each tenant at runtime, so as to account for fluctuations in workloads. Finally, we evaluate our approach experimentally using the TPC-H benchmark to demonstrate its effectiveness and accuracy.

Original languageEnglish
Title of host publicationAdvances in Database Technology - EDBT 2013
Subtitle of host publication16th International Conference on Extending Database Technology, Proceedings
Pages77-88
Number of pages12
DOIs
Publication statusPublished - 2 May 2013
Event16th International Conference on Extending Database Technology, EDBT 2013 - Genoa, Italy
Duration: 18 Mar 201322 Mar 2013

Publication series

NameACM International Conference Proceeding Series

Other

Other16th International Conference on Extending Database Technology, EDBT 2013
CountryItaly
CityGenoa
Period18/3/1322/3/13

    Fingerprint

Keywords

  • Algorithms
  • C.4 [Performance of Systems]: Modeling techniques
  • Experimentation
  • H.2.4 [Database Management]: Systems
  • Measurement

ASJC Scopus subject areas

  • Software
  • Human-Computer Interaction
  • Computer Vision and Pattern Recognition
  • Computer Networks and Communications

Cite this

Mahmoud, H. A., Moon, H. J., Chi, Y., Hacigümüş, H., Agrawal, D., & El-Abbadi, A. (2013). CloudOptimizer: Multi-tenancy for I/O-bound OLAP workloads. In Advances in Database Technology - EDBT 2013: 16th International Conference on Extending Database Technology, Proceedings (pp. 77-88). (ACM International Conference Proceeding Series). https://doi.org/10.1145/2452376.2452386