research-article

Re-evaluating designs for multi-tenant OLTP workloads on SSD-basedI/O subsystems

Authors:

Junichi Tatemura,

Hakan HacigumusAuthors Info & Claims

SIGMOD '14: Proceedings of the 2014 ACM SIGMOD International Conference on Management of Data

Pages 1383 - 1394

https://doi.org/10.1145/2588555.2588567

Published: 18 June 2014 Publication History

Abstract

Multi-tenancy is a common practice that is employed to maximize server resources and reduce the total cloud operation costs. The focus of this work is on multi-tenancy for OLTP workloads. Several designs for OLTP multi-tenancy have been proposed that vary the trade-offs made between performance and isolation. However, existing studies have not considered the impact of OLTP multi-tenancy designs when using an SSD-based I/O subsystem. In this paper, we compare three designs using both open-source and proprietary DBMSs on SSD-based I/O subsystems. Our study reveals that in contrast to the case of an HDD-based I/O subsystem, VM-based designs have fairly competitive performance compared to the non-virtualized designs (generally within 1.3-2X of the best performing case) on SSD-based I/O subsystems. Whereas previous studies were based on traditional hard disk-based environments, our results indicate that switching to a pure SSD-based I/O subsystem requires rethinking the trade-offs for multi-tenant OLTP workloads.

References

[1]

http://www.xen.org/.

[2]

http://www.vmware.com/.

[3]

http://oltpbenchmark.com/experiments/dbms_config/postgresql.conf.

[4]

Best practices for xen. http://wiki.xensource.com/xenwiki/XenBestPractices.

[5]

Flash drives replace disks at Amazon, Facebook, Dropbox. http://www.wired.com/wiredenterprise/2012/06/flash-data-centers/.

[6]

OLTPBenchmark. http://oltpbenchmark.com/wiki/index.php?title=Main_Page.

[7]

Performance best practices for VMware vSphere 4.0, VMware ESX4.0 and ESXi 4.0, vCenter Server 4.0. http://www.vmware.com/pdf/Perf_Best_Practices_vSphere4.0.pdf.

[8]

SysBench: a system performance benchmark. http://sysbench.sourceforge.net/.

[9]

L. Bouganim, B. T. Jónsson, and P. Bonnet. uFLIP: Understanding flash io patterns. In CIDR, 2009.

[10]

C. Curino, E. P. C. Jones, S. Madden, and H. Balakrishnan. Workload-aware database monitoring and consolidation. In SIGMOD Conference, pages 313--324, 2011.

Digital Library

[11]

U. F. Minhas, J. Yadav, A. Aboulnaga, and K. Salem. Database systems on virtual machines: How much do you lose? In ICDE Workshops, pages 35--41, 2008.

Digital Library

[12]

V. R. Narasayya, S. Das, M. Syamala, B. Chandramouli, and S. Chaudhuri. SQLVM: Performance isolation in multi-tenant relational database-as-a-service. In CIDR, 2013.

Digital Library

[13]

I. Pandis, P. Tözün, R. Johnson, and A. Ailamaki. Plp: Page latch-free shared-everything oltp. PVLDB, 4(10):610--621, 2011.

Digital Library

[14]

A. Pavlo, C. Curino, and S. Zdonik. Skew-aware automatic database partitioning in shared-nothing, parallel OLTP systems. In SIGMOD, pages 61--72, 2012.

Digital Library

[15]

A. Pavlo, E. P. Jones, and S. Zdonik. On predictive modeling for optimizing transaction execution in parallel OLTP systems. Proc. VLDB Endow., 5:85--96, 2011.

Digital Library

[16]

D. Porobic, I. Pandis, M. Branco, P. Tözün, and A. Ailamaki. OLTP on hardware islands. PVLDB, 5(11):1447--1458, 2012.

Digital Library

[17]

J. Schaffner, T. Januschowski, M. Kercher, T. Kraska, H. Plattner, M. J. Franklin, and D. Jacobs. RTP: robust tenant placement for elastic in-memory database clusters. In SIGMOD Conference, pages 773--784, 2013.

Digital Library

[18]

A. A. Soror, U. F. Minhas, A. Aboulnaga, K. Salem, P. Kokosielis, and S. Kamath. Automatic virtual machine configuration for database workloads. In SIGMOD Conference, pages 953--966, 2008.

Digital Library

[19]

P. Wong, Z. He, and E. Lo. Parallel analytics as a service. In SIGMOD Conference, pages 25--36, 2013.

Digital Library

Cited By

Sun JReidys BLi DChang JSnir MHuang JEeckhout LSmaragdakis GLiang KSampson AKim MRossbach C(2025)FleetIO: Managing Multi-Tenant Cloud Storage with Multi-Agent Reinforcement LearningProceedings of the 30th ACM International Conference on Architectural Support for Programming Languages and Operating Systems, Volume 110.1145/3669940.3707229(478-492)Online publication date: 30-Mar-2025
https://dl.acm.org/doi/10.1145/3669940.3707229
Kang LXue YJia WWang XKim JYoun CKang MLim HJacob BHuang J(2021)IceClave: A Trusted Execution Environment for In-Storage ComputingMICRO-54: 54th Annual IEEE/ACM International Symposium on Microarchitecture10.1145/3466752.3480109(199-211)Online publication date: 18-Oct-2021
https://dl.acm.org/doi/10.1145/3466752.3480109
Yang JPei SYang QHershcovitch MGoel AMorrison A(2019)WARCIPProceedings of the 12th ACM International Conference on Systems and Storage10.1145/3319647.3325840(155-166)Online publication date: 22-May-2019
https://dl.acm.org/doi/10.1145/3319647.3325840
Show More Cited By

Index Terms

Re-evaluating designs for multi-tenant OLTP workloads on SSD-basedI/O subsystems
1. General and reference
  1. Cross-computing tools and techniques
    1. Design

Recommendations

A Multi-tenant Database Architecture Design for Software Applications
CSE '13: Proceedings of the 2013 IEEE 16th International Conference on Computational Science and Engineering

Multi-tenant database is a new cloud computing paradigm that has recently attracted attention to deliver database functionalities for multiple tenants to create, store, and access their databases over the internet. This multi-tenant database should be ...
A Methodology for Tenant Migration in Legacy Shared-Table Multi-tenant Applications
Distributed Applications and Interoperable Systems
Abstract
Multi-tenancy enables cost-effective SaaS through resource consolidation. Multiple customers, or tenants, are served by a single application instance, and isolation is enforced at the application level. Service load for different tenants can vary ...
A placement vulnerability study in multi-tenant public clouds
SEC'15: Proceedings of the 24th USENIX Conference on Security Symposium

Public infrastructure-as-a-service clouds, such as Amazon EC2, Google Compute Engine (GCE) and Microsoft Azure allow clients to run virtual machines (VMs) on shared physical infrastructure. This practice of multi-tenancy brings economies of scale, but ...

Comments

Information & Contributors

Information

Published In

cover image ACM Conferences

SIGMOD '14: Proceedings of the 2014 ACM SIGMOD International Conference on Management of Data

June 2014

1645 pages

ISBN:9781450323765

DOI:10.1145/2588555

General Chairs:
Curtis Dyreson
Utah State University, USA
,
Feifei Li
University of Utah, USA
,
Program Chair:
M. Tamer Özsu
University of Waterloo, Canada

Copyright © 2014 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]

Sponsors

SIGMOD: ACM Special Interest Group on Management of Data

Publisher

Association for Computing Machinery

New York, NY, United States

Publication History

Published: 18 June 2014

Permissions

Request permissions for this article.

Request Permissions

Check for updates

Author Tags

Qualifiers

Research-article

Conference

SIGMOD/PODS'14

Sponsor:

SIGMOD

SIGMOD/PODS'14: International Conference on Management of Data

June 22 - 27, 2014

Utah, Snowbird, USA

Acceptance Rates

SIGMOD '14 Paper Acceptance Rate 107 of 421 submissions, 25%;

Overall Acceptance Rate 785 of 4,003 submissions, 20%

Contributors

Other Metrics

View Article Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

6
Total Citations
View Citations
559
Total Downloads

Downloads (Last 12 months)18
Downloads (Last 6 weeks)1

Reflects downloads up to 01 Mar 2025

Other Metrics

View Author Metrics

Citations

Cited By

Sun JReidys BLi DChang JSnir MHuang JEeckhout LSmaragdakis GLiang KSampson AKim MRossbach C(2025)FleetIO: Managing Multi-Tenant Cloud Storage with Multi-Agent Reinforcement LearningProceedings of the 30th ACM International Conference on Architectural Support for Programming Languages and Operating Systems, Volume 110.1145/3669940.3707229(478-492)Online publication date: 30-Mar-2025
https://dl.acm.org/doi/10.1145/3669940.3707229
Kang LXue YJia WWang XKim JYoun CKang MLim HJacob BHuang J(2021)IceClave: A Trusted Execution Environment for In-Storage ComputingMICRO-54: 54th Annual IEEE/ACM International Symposium on Microarchitecture10.1145/3466752.3480109(199-211)Online publication date: 18-Oct-2021
https://dl.acm.org/doi/10.1145/3466752.3480109
Yang JPei SYang QHershcovitch MGoel AMorrison A(2019)WARCIPProceedings of the 12th ACM International Conference on Systems and Storage10.1145/3319647.3325840(155-166)Online publication date: 22-May-2019
https://dl.acm.org/doi/10.1145/3319647.3325840
Lee DShin MChoi WRoh HPark S(2018)MV-FTL: An FTL That Provides Page-Level Multi-Version ManagementIEEE Transactions on Knowledge and Data Engineering10.1109/TKDE.2017.275701630:1(87-100)Online publication date: 1-Jan-2018
https://doi.org/10.1109/TKDE.2017.2757016
Huang JBadam ACaulfield LNath SSengupta SSharma BQureshi MKuenning GWaldspurger C(2017)FlashBloxProceedings of the 15th Usenix Conference on File and Storage Technologies10.5555/3129633.3129667(375-390)Online publication date: 27-Feb-2017
https://dl.acm.org/doi/10.5555/3129633.3129667
Kanza YYaari H(2016)External sorting on flash storageThe VLDB Journal — The International Journal on Very Large Data Bases10.1007/s00778-016-0426-525:4(495-518)Online publication date: 1-Aug-2016
https://dl.acm.org/doi/10.1007/s00778-016-0426-5

View Options

Login options

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

Full Access

Get this Publication

View options

PDF

View or Download as a PDF file.

eReader

View online with eReader.

Figures

Tables

Media

View Table of Conten