Benchmarking OLTP/web databases in the cloud: The OLTP-bench framework

Carlo Curino, Djellel E. Difallah, Andrew Pavlo, Philippe Cudre-Mauroux

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

Abstract

Benchmarking is a key activity in building and tuning data management systems, but the lack of reference workloads and a common platform makes it a time consuming and painful task. The need for such a tool is heightened with the advent of cloud computing- with its pay-per-use cost models, shared multi-tenant infrastructures, and lack of control on system configuration. Benchmarking is the only avenue for users to validate the quality of service they receive and to optimize their deployments for performance and resource utilization. In this talk, we present our experience in building several adhoc benchmarking infrastructures for various research projects targeting several OLTP DBMSs, ranging from traditional relational databases, main-memory distributed systems, and cloud-based scalable architectures. We also discuss our struggle to build meaningful micro-benchmarks and gather workloads representative of real-world applications to stress-test our systems. This experience motivates the OLTP-Bench project, a "batteries-included" benchmarking infrastructure designed for and tested on several relational DBMSs and cloud-based database-as-a-service (DBaaS) offerings. OLTP-Bench is capable of controlling transaction rate, mixture, and workload skew dynamically during the execution of an experiment, thus allowing the user to simulate a multitude of practical scenarios that are typically hard to test (e.g., time-evolving access skew). Moreover, the infrastructure provides an easy way to monitor performance and resource consumption of the database under test. We also introduce the ten included workloads, derived from either synthetic micro benchmarks, popular benchmarks, and real world applications, and how they can be used to investigate various performance and resource-consumption characteristics of a data management system. We showcase the effectiveness of our benchmarking infrastructure and the usefulness of the workloads we selected by reporting sample results from hundreds of side-byside comparisons on popular DBMSs and DBaaS offerings.

Original languageEnglish (US)
Title of host publicationCloudDB'12 - Proceedings of the 3rd ACM International Workshop on Cloud Data Management, Co-located with CIKM 2012
Pages17-20
Number of pages4
DOIs
StatePublished - 2012
Event3rd ACM International Workshop on Cloud Data Management, CloudDB 2012 - Co-located with CIKM 2012 - Maui, HI, United States
Duration: Oct 29 2012Oct 29 2012

Publication series

NameInternational Conference on Information and Knowledge Management, Proceedings

Conference

Conference3rd ACM International Workshop on Cloud Data Management, CloudDB 2012 - Co-located with CIKM 2012
CountryUnited States
CityMaui, HI
Period10/29/1210/29/12

Keywords

  • Benchmarking
  • OLTP
  • Testbed
  • Transactional
  • Web
  • Workload

ASJC Scopus subject areas

  • Decision Sciences(all)
  • Business, Management and Accounting(all)

Fingerprint Dive into the research topics of 'Benchmarking OLTP/web databases in the cloud: The OLTP-bench framework'. Together they form a unique fingerprint.

  • Cite this

    Curino, C., Difallah, D. E., Pavlo, A., & Cudre-Mauroux, P. (2012). Benchmarking OLTP/web databases in the cloud: The OLTP-bench framework. In CloudDB'12 - Proceedings of the 3rd ACM International Workshop on Cloud Data Management, Co-located with CIKM 2012 (pp. 17-20). (International Conference on Information and Knowledge Management, Proceedings). https://doi.org/10.1145/2390021.2390025