International Journal of Advances in Electronics and Computer Science ( IJAECS )
A highly rated peer reviewed monthly International Journal
Editor-in-Chief : Dr. P. Suresh
Contact Person : Technical Editor
Contact Mail : [email protected]  
Current Issue : Volume-11,Issue-2  ( Feb, 2024 ) View More
Journal Impact Factor : 2.68 View More

Journal Info
Publisher:IRAJ
ISSN (p): 2394-2835
Issues /Year :12
Stay up-to-date
Register your interests and receive email alerts tailored to your needs
Follow us
facebook twitter linked in

Paper Detail


Paper Title
A Basic Comparison of MYSQL, POSTGRESQL and MARIADB Relational Databases Using Php on Docker

Abstract
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


Author - Mevlut Kagan Balga, Fatih Basciftci

Published : Volume-10,Issue-12  ( Dec, 2023 )


DOIONLINE Number - IJAECS-IRAJ-DOIONLINE-20485   View Here

| PDF |
Viewed - 3
| Published on 2024-03-29
   
   
PAST ISSUES
Volume-11,Issue-1  ( Jan, 2024 )
Volume-10,Issue-12  ( Dec, 2023 )
Volume-10,Issue-11  ( Nov, 2023 )
Volume-10,Issue-10  ( Oct, 2023 )
Volume-10,Issue-9  ( Sep, 2023 )
Volume-10,Issue-8  ( Aug, 2023 )
Volume-10,Issue-7  ( Jul, 2023 )
Volume-10,Issue-6  ( Jun, 2023 )
Volume-10,Issue-5  ( May, 2023 )
Volume-10,Issue-4  ( Apr, 2023 )
Journal Indexed