Search
×
Log in or create an account
If you have an account with us, please log in.

You have no items in your shopping cart.

Frequently Asked Questions

How can we help you?

banner image

Magento 2 MySQL

MySQL is one of the most in-demand databases for e-commerce websites due to the secure financial transactions that have data integrity, a possibility of the management of deeply embedded applications, and its consistent availability. However, by no means all merchants know Magento 2 basic requirements

Magento 2 MySQL specifications

Magento 2 is compatible with MariaDB*, Percona* and MySQL.
MySQL specifications:

  • The latest Magento version doesn’t operate with MySQL 5.5 but MySQL 5.6.x and better will suit;
  • Magento 2.1.2 and later versions are compatible with MySQL 5.7.x;
  • MySQL triggers are used to enhance database accessibility during reindexing;
  • If you need to import many products, you are able to increase the value for max_allowed_packet to make 16MB, which is larger than the default.

**MariaDB and Percona are compatible with Magento due to the support of MySQL APIs.

Magento 2 MySQL Config

Learn it before adjusting MySQL to your store needs:

  • you won’t be able to run any custom triggers, as they can introduce incompatibilities with future Magento versions;
  • read about restrictions for MySQL triggers before making any changes;
  • learn about replication formats supported by Magento 2, e.g.: the platform doesn’t support MySQL statement-based replication.

See here to get how to configure the Magento database instance and a remote connection.

Rate the answer?

Total rating: 1.0

If you didn’t find the answer on your question, please, ask here:

Back to top