Hi to all, we are setting up a new magento store and would like to know if there is a preferred choice of database for the latest version of Magento? The host has asked if we prefer mySQL 8 or mariaDB and not 100% sure, looking online I don't see anything that helps.
Any suggestions? The site has a few thousand products and might get 10000 hits a day when its well established.
Cheers M
Hello @malhyp ,
For magento 2 you need
Magento is also compatible, but has not been tested and is not recommended, with MySQL 5.7.9, MariaDB 10.2, and Percona 5.7.
Magento only uses MySQL features compatible with MariaDB. MariaDB may not be compatible with all MySQL features, however; so be sure to research compatibility issues before using a feature in your Magento module.
Reindexing on MariaDB 10.4 takes more time compared to other MariaDB or MySQL versions
Thanks.
Both MySQL and MariaDB will work with Magento.
Just a note that the latest MySQL 8 removed Query Caching which is a feature that may help with Magento performance in certain circumstances.
Hello malhyp,
You should be aware of a few key differences between mySQL 8 and mariaDB:
All of these features make mySQL 8 a better choice for certain applications.
MySQL 8 and MariaDB are two popular open-source relational database systems. They both offer several features that make them useful for different purposes. Here are some key differences between the two systems:- MySQL 8 is faster and more memory efficient than MariaDB.- MySQL 8 supports batch processing, which makes it ideal for data analysis and automation tasks.- MariaDB has built-in support for JSON, making it a good choice if you need to work with large amounts of data that is formatted in JSON format.
I hope this information will help you to choose between MySQL and mariaDB.
--------------------------
Regards,
Rex M