![]() Version of AWS RDS can be a little bit older than official latest version. Mariadb(ver10.4.12) > postgresql(ver12.2) > mysql(ver8.0.20) ItemĬomparison using AWS RDS’s latest versionĪWS RDS is managed database, so by using it, you can compare RDB with tuned status. In this benchmark, the result was like this I used latest stable version of each RDB with default settings of them. Test condition: 8 concurrent access in 60 seconds using sysbench. ![]() Machine: 1 server = Linode 1CPU/1GB RAM/SSD Comparison by benchmark for RDB’s performance Comparison using latest version with default setting – MariaDB(MySQL) can have only 64 key index per table. – Error criteria is stricter than MariaDB, so you can avoid problem caused by unexpected hading of data. – PostgreSQL has more function than MariaDB – PostGIS helps you to develop application with GIS – 3rd Party software which provides REST API( PostgREST), Software which provides GraphQL API( Graphile) help you to develop software which use JSON, which means you can develop mobile app and SPA(Single Page Application) with less effort. – PostgreSQL supports Native JSON type (jsonb), so speed of accessing to Json’s data is far faster than MariaDB(MySQL) thogh MariaDB is providing Virtual Column whose performance is not enough Reason of choosing PostgreSQL over MariaDB – MariaDB provided you better performance in default configuration and in AWS’s RDS’s setting based on the benchmark result in May/2020 compared to PostgreSQL – MariaDB is basically compatible with MySQL and there are many engineers who have the experience of using MySQL – MariaDB(MySQL) had better DB management tool like WorkBench and A5:SQL Mk-2 compared to PosgreSQL – If you have MariaDB system for WordPress, maintaining PostgreSQL and MariaDB cost you more in therms of system and human resource Even if you won’t contruct the system only by WordPress, infrastructure for WordPress is always required – Market share of WordPress as web sites exceeded 36% and it is still growing. – WordPress supports only MariaDB and MySQL, which means WordPress doesn’t work with PostgreSQL Reason of choosing MariaDB over PostgreSQL So if you wonder whether you should adopt MariaDB or MySQL, MariaDB is better choice for you. – MariaDB provided you better performance in default configuration and in AWS’s RDS’s setting based on the benchmark result in May/2020 compared to MySQL. As result, MariaDB has more functions now compared to MySQL Oracle has its own RDB Oracle, so it is hard to commit fully to MySQL’s success in terms of Oracle. – Original developer of MySQL is developing MariaDB. – Oracle purchased MySQL, which created concern and most of Linux distributors are now adopting MariaDB. No => MariaDB Background of Flow chart Reason of choosing MariaDB anyway instead of MySQL Do you need more than 64 columns with index in 1 table? Do you want to develop mobile app or app using GIS? Your service will be created based on WordPress Flowchart of choosing suitable RDB for you I will show you background of flowchart in addition to benchmark result later. In this article, I compare 3 major OSS RDBs(MariaDB, MySQL and PostgreSQL) So I provide flowchart by which you can choose suitable RDB(Relational DataBase) for you. We often encounter articles listing what is good and what is bad but there is no conclusion for readers about which one you should use. Which RDB should I use, MariaDB, MySQL or PostgreSQL? Comparison using AWS RDS's latest version.Comparison using latest version with default setting.Comparison by benchmark for RDB's performance.Reason of choosing PostgreSQL over MariaDB.Reason of choosing MariaDB over PostgreSQL.Reason of choosing MariaDB anyway instead of MySQL.Flowchart of choosing suitable RDB for you.Which RDB should I use, MariaDB, MySQL or PostgreSQL?.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |