Performance Analysis of Docker-based Database Management Systems Compared to Virtual Machine-based Systems: A Comparative Study
Keywords:Database Management Systems, Docker, MongoDB, MySQL, PostgreSQL
Computer virtualization is a very old technology. Due to a lot of technical barriers, computer containerization has been introduced recently. Nowadays, computer containerization is playing a major role in information technology and containerization is a trending topic. Among the practitioner of information technology, a lot of software services are moving to containerization instead of traditional virtual machines. Among the most famous software services: database management systems are a leading service. Among most computer containerization technologies, Docker is the most popular and trending container vendor. Therefore, identification of the performance of database management systems on the Docker-based platform is an essential task for the practitioner. This research study aims to identify the practical aspects of each database management system on the Docker-based infrastructure for main database management system operations. For the study: Ubuntu 18.04 Long Term Support (used package with architecture: GNU/Linux 4.15.0-112-generic x86_64) cloud-based operating system was used and on that operating system the Docker infrastructure was launched. Docker version 19.03.9 was launched for the study. On Docker: MySQL, PostgreSQL, and MongoDB database management system containers were launched separately. SELECT, DELETE, UPDATE, and INSERT operations were used for the performance evaluations of database management system response times. This research identified that there was an increase in the performance of the Docker platform with a 95% confidence interval level for all data records to virtual machine-based platforms. Finally, the research study identified that Docker-based database management system has a quick response time than virtual machine-based database management systems.
John Paul Martin, A. Kandasamy, and K. Chandrasekaran. 2018. Exploring the support for high performance applications in the container runtime environment. Hum.- centric Comput. Inf. Sci. 8, 1, Article 124 (December 2018), 15 pages. DOI:https://doi.org/10.1186/s13673-017-0124-3
B. I. Ismail et al., "Evaluation of Docker as Edge computing platform," 2015 IEEE Conference on Open Systems (ICOS), 2015, pp. 130-135, doi: 10.1109/ICOS.2015.7377291.
surprising facts about real Docker adoption, 2021. [Online]. Available: https://www.datadoghq.com/docker- adoption/. [Accessed: 25- Jun- 2021].
Empowering App Development for Developers | Docker, Docker, 2021. [Online]. Available: https://www.docker.com/. [Accessed: 25- Jun- 2021].
Database Management System Tutorial - Tutorialspoin, Tutorialspoint.com, 2021. [Online]. Available: https://www.tutorialspoint.com/dbms/index.htm. [Accessed: 25- Jun- 2021]
SQL - RDBMS Concepts - Tutorialspoint, Tutorialspoint.com, 2021. [Online]. Available: https://www.tutorialspoint.com/sql/sql-rdbms- concepts.htm. [Accessed: 25- Jun- 2021].
docker stats, Docker Documentation, 2021. [Online]. Available: https://docs.docker.com/engine/reference/commandline/st ats/. [Accessed: 25- Jun- 2021].
F. Paraiso, S. Challita, Y. Al-Dhuraibi and P. Merle, "Model-Driven Management of Docker Containers," 2016 IEEE 9th International Conference on Cloud Computing (CLOUD), 2016, pp. 718-725, doi: 10.1109/CLOUD.2016.0100
J. Stubbs, W. Moreira and R. Dooley, "Distributed Systems of Microservices Using Docker and Serfnode," 2015 7th International Workshop on Science Gateways, 2015, pp. 34-39, doi: 10.1109/IWSG.2015.16
Peinl, R., Holzschuher, F. & Pfitzer, F. Docker Cluster Management for the Cloud - Survey Results and Own Solution. J Grid Computing 14, 265–282 (2016). https://doi.org/10.1007/s10723-016-9366-y
D. Liu and L. Zhao, "The research and implementation of cloud computing platform based on docker," 2014 11th International Computer Conference on Wavelet Actiev Media Technology and Information Processing(ICCWAMTIP), 2014, pp. 475-478, doi: 10.1109/ICCWAMTIP.2014.7073453.
M. T. Chung, N. Quang-Hung, M. Nguyen and N. Thoai, "Using Docker in high performance computing applications," 2016 IEEE Sixth International Conference on Communications and Electronics (ICCE), 2016, pp. 52- 57, doi: 10.1109/CCE.2016.7562612
M. G. Xavier, I. C. De Oliveira, F. D. Rossi, R. D. Dos Passos, K. J. Matteussi and C. A. F. D. Rose, "A Performance Isolation Analysis of Disk-Intensive Workloads on Container-Based Clouds," 2015 23rd Euromicro International Conference on Parallel, Distributed, and Network-Based Processing, 2015, pp.253-260, doi: 10.1109/PDP.2015.67
S. Thorpe, “Databases in containers - dzone,” dzone.com, 14-Jun-2018. [Online]. Available: https://dzone.com/articles/databases-in-containers. [Accessed: 05-Apr-2023].
“Is it recommended to use database as a container in production environment?,” Stack Overflow, 01-Nov-1964. [Online]. Available: https://stackoverflow.com/questions/48515460/is-it- recommended-to-use-database-as-a-container-in- production-environment. [Accessed: 05-Apr-2023]
D. Damodaran B, S. Salim, and S. M. Vargese, “Performance evaluation of mysql and mongodb databases,” International Journal on Cybernetics & Informatics, vol. 5, no. 2, pp. 387–394, 2016.
Kithulwatta W.M.C.J.T., Jayasena K.P.N., Kumara B.T.G.S., Rathnayaka R.M.K.T. (2021), International Conference on Advances in Computing and Technology (ICACT–2021) Faculty of Computing and Technology (FCT), University of Kelaniya, Sri Lanka 7-12