Publish In
International Journal of Advances in Electronics and Computer Science-IJAECS
Journal Home
Volume Issue
Volume-10,Issue-12  ( Dec, 2023 )
Paper Title
A Basic Comparison of MYSQL, POSTGRESQL and MARIADB Relational Databases Using Php on Docker
Author Name
Mevlut Kagan Balga, Fatih Basciftci
1,2Selcuk University, Department of Computer Engineering, Türkiye
The database is a way to store data electronically in an organized way. There are different types of databases, brands, query languages, and execution environments in the market. Depending on the product (software), a suitable database needs to be selected. This depends on the platform (web, desktop, mobile), programming language, licensing, costs, security, performance, etc. For the decision of databases, it is possible to check the rankings, scores, and popularity of databases. In this study, we compared 3 different relational databases which are MySQL (versions: 5.7.42 and 8.0.33), PostgreSQL (versions: 12.14, and 15.3), and MariaDB (versions: 10.6.13 and 11.0.1-rc). We performed custom tests and benchmarks. For our custom testing, we developed a basic PHP application. We used official Docker images of the given databases and PHP 7.4.33-Apache Docker image from Docker Hub and run these images using Docker version 20.10.17. In our custom testing scenarios, we inserted 1.000.000 (1M) rows to a table in these databases. We performed comparisons on execution times of 1M-Insert and different Select & Update queries in these databases. For the benchmarking, we used Sysbench with OLTP Read-Only and Read-Write benchmarks. We observed the best result with MariaDB version 10.6.13 for 1M-Insert. For other Select & Update tests, we had the best results with PostgreSQL version 12.14. We obtained the best benchmark results from MariaDB overall. Keywords - Relational databases, MySQL, PostgreSQL, MariaDB, PHP, Docker, DB Testing
  View Paper