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.
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