Skip to main content
SpringerLink
Log in

Towards Sustainable High-Performance Transaction Processing in Cloud-based DBMS

Design considerations and optimization for transaction processing performance in service-oriented DBMS organization

  • Published:
Cluster Computing Aims and scope Submit manuscript

Abstract

Cloud-based databases often decouple database instances from physical storage to provide reliability and high availability to users. This design can robustly handle a single point of failure but needs substantial effort to attain good performance. In this paper, we analyze the decoupled architecture and present important optimization issues that we found while implementing this design. For implementing the prototyped system, we decouple MariaDB into a database instance and storage managing both transaction log and data pages. We also explore design considerations for transaction processing performance in the front-end side and efficient way of guaranteeing data durability in the back-end side. We evaluate the prototyped system using standard database benchmarks, and experimental results show that adopting the decoupled architecture for cloud-based DBMSs needs to address numerous optimization issues for achieving better performance.

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

Access this article

Log in via an institution

Price excludes VAT (USA)
Tax calculation will be finalised during checkout.

Instant access to the full article PDF.

Institutional subscriptions

Fig. 1
Fig. 2
Fig. 3
Fig. 4
Fig. 5
Fig. 6
Fig. 7
Fig. 8
Fig. 9
Fig. 10
Fig. 11
Fig. 12
Fig. 13

Similar content being viewed by others

References

  1. Mohan, C., Haderle, D., Lindsay, B., Pirahesh, H., Schwarz, P.: Aries: a transaction recovery method supporting fine-granularity locking and partial rollbacks using write-ahead logging. ACM Trans. Database Syst. 17(1), 94–162 (1992)

    Article  Google Scholar 

  2. DeWitt, D.J., Katz, R.H., Olken, F., Shapiro, L.D., Stonebraker, M.R., Wood, D.A.: Implementation techniques for main memory database systems. ACM 14, 1–8 (1984)

    Google Scholar 

  3. Kopytov, A.: Sysbench: a system performance benchmark. http://sysbench.sourceforge.net (2004)

  4. tpcc-mysql. https://github.com/Percona-Lab/tpcc-mysql

  5. Campbell, D.: Service oriented database architecture: App server-lite? In: Proceedings of the 2005 ACM SIGMOD international conference on Management of Data, pp. 857–862. ACM (2005)

  6. Härder, T.: Dbms architecture-the layer model and its evolution. Datenbank-Spektrum 13, 45–57 (2005)

    Google Scholar 

  7. Tok, W.H., Bressan, S.: Dbnet: A service-oriented database architecture. In: Proceedings of the 17th International Workshop on Database and Expert Systems Applications, DEXA’06. pp. 727–731. IEEE (2006)

  8. Subasu, I., Ziegler, P., Dittrich, K.R.: Towards service-based data management systems. In: Proceedings of the Workshop on Datenbanksysteme in Business, Technologie und Web (BTW 2007), pp. 3–86,130. Citeseer (2007)

  9. Irmert, F., Daum, M., Meyer-Wegener, K.: A new approach to modular database systems. In: Proceedings of the 2008 EDBT workshop on Software engineering for tailor-made data management, pp. 40–44. ACM (2008)

  10. Diaconu, C., Freedman, C., Ismert, E., Larson, P.A., Mittal, P., Stonecipher, R., Verma, N., Zwilling, M.: Hekaton: Sql server’s memory-optimized oltp engine. In: Proceedings of the 2013 ACM SIGMOD International Conference on Management of Data, pp. 1243–1254. ACM (2013)

  11. Stonebraker, M., Weisberg, A.: The voltdb main memory dbms. IEEE Data Eng. Bull. 36(2), 21–27 (2013)

    Google Scholar 

  12. Malviya, N., Weisberg, A., Madden, S., Stonebraker, M.: Rethinking main memory oltp recovery. In: Proceedings of the 2014 IEEE 30th International Conference on Data Engineering (ICDE), pp. 604–615. IEEE (2014)

  13. Graefe, G., Guy, W., Sauer, C.: Instant recovery with write-ahead logging: page repair, system restart, and media restore. Synth. Lect. Data Manag. 6(5), 1–85 (2014)

    Article  Google Scholar 

  14. Reid, C., Bernstein, P., Wu, M., Yuan, X.: Optimistic concurrency control by melding trees. Proc. VLDB Endow. 4(11), 944–955 (2011)

    Google Scholar 

  15. Coburn, J., Bunker, T., Schwarz, M., Gupta, R., Swanson, S.: From aries to mars: Transaction support for next-generation, solid-state drives. In: Proceedings of the twenty-fourth ACM symposium on operating systems principles, pp. 197–212. ACM (2013)

  16. Stonebraker, M., Madden, S., Abadi, D.J., Harizopoulos, S., Hachem, N., Helland, P.: The end of an architectural era: (it’s time for a complete rewrite). In: Proceedings of the 33rd International Conference on Very Large Data Bases, pp. 1150–1160. VLDB Endowment (2007)

  17. Pandis, I., Johnson, R., Hardavellas, N., Ailamaki, A.: Data-oriented transaction execution. Proc. VLDB Endow. 3(1–2), 928–939 (2010)

    Article  Google Scholar 

  18. Pandis, I., Tözün, P., Johnson, R., Ailamaki, A.: Plp: page latch-free shared-everything oltp. Proc. VLDB Endow. 4(10), 610–621 (2011)

    Article  Google Scholar 

  19. Pavlo, A., Curino, C., Zdonik, S.: Skew-aware automatic database partitioning in shared-nothing, parallel oltp systems. In: Proceedings of the 2012 ACM SIGMOD International Conference on Management of Data, pp. 61–72. ACM (2012)

  20. Jung, H., Han, H., Kang, S.: Scalable database logging for multicores. Proc. VLDB Endow. 11(2), 135–148 (2017)

    Article  Google Scholar 

Download references

Acknowledgement

This work was supported by the research fund of Hanyang University (HY-2015).

Author information

Authors and Affiliations

  1. Seoul National University, Seoul, South Korea

    Woong Sul & Heon Y. Yeom

  2. Hanyang University, Seoul, South Korea

    Hyungsoo Jung

Authors
  1. Woong Sul
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Heon Y. Yeom
    View author publications

    You can also search for this author in PubMed Google Scholar

  3. Hyungsoo Jung
    View author publications

    You can also search for this author in PubMed Google Scholar

Corresponding author

Correspondence to Hyungsoo Jung.

Rights and permissions

Reprints and permissions

About this article

Check for updates. Verify currency and authenticity via CrossMark

Cite this article

Sul, W., Yeom, H.Y. & Jung, H. Towards Sustainable High-Performance Transaction Processing in Cloud-based DBMS. Cluster Comput 22, 135–145 (2019). https://doi.org/10.1007/s10586-018-2826-3

Download citation

  • Received:

  • Revised:

  • Accepted:

  • Published:

  • Issue Date:

  • DOI: https://doi.org/10.1007/s10586-018-2826-3

Keywords

Search

Navigation