Containerized and Host-Based RDBMSs Performance Comparison
Issued Date
2025-01-01
Resource Type
eISSN
28377109
Scopus ID
2-s2.0-105035767820
Journal Title
Proceedings of the IEEE International Conference on Computer and Communications Iccc
Start Page
12
End Page
16
Rights Holder(s)
SCOPUS
Bibliographic Citation
Proceedings of the IEEE International Conference on Computer and Communications Iccc (2025) , 12-16
Suggested Citation
Napradit A., Masrijun P., Rassameeroj I. Containerized and Host-Based RDBMSs Performance Comparison. Proceedings of the IEEE International Conference on Computer and Communications Iccc (2025) , 12-16. 16. doi:10.1109/ICCC68654.2025.11438083 Retrieved from: https://repository.li.mahidol.ac.th/handle/123456789/116450
Title
Containerized and Host-Based RDBMSs Performance Comparison
Author(s)
Author's Affiliation
Corresponding Author(s)
Other Contributor(s)
Abstract
The rapid adoption of containerization has transformed application deployment, offering significant advantages in portability and resource isolation. However, the performance implications for stateful, I/O-intensive applications like relational database management systems (RDBMSs) remain a critical concern. This paper presents a comprehensive performance evaluation comparing containerized and non-containerized deployments of two leading open-source RDBMSs, MySQL and PostgreSQL. We designed and implemented an experimental framework comprising three distinct architectural designs across nine scenarios, utilizing Sysbench to systematically measure transactions per second (TPS), queries per second (QPS), and latency. Our results indicate that, overall, container-based RDBMS deployments showed a performance advantage. Specifically, PostgreSQL consistently exhibited superior performance in a containerized environment, while MySQL's performance varied depending on the scenario. A key finding is the notable performance overhead associated with persistent storage in containers compared to nonpersistent storage. The study concludes that while containers can provide a performance benefit for RDBMSs, the realworld deployment choice requires a careful balance between performance gains and the absolute necessity of data integrity provided by persistent storage.