cancel
Showing results for 
Search instead for 
Did you mean: 

mySQL 8 vs mariaDB

Highlighted

mySQL 8 vs mariaDB

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

2 REPLIES 2
Highlighted

Re: mySQL 8 vs mariaDB

Hello @malhyp ,

For magento 2 you need 

  • MySQL 8.0 for on-premise installations
  • MariaDB 10.4 for Magento Commerce Cloud projects

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.

Re: mySQL 8 vs mariaDB

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.