This guide explains how to migrate a Web Hosting from MySQL to MariaDB.

Preamble

• MariaDB is an enhanced version of MySQL, featuring numerous powerful built-in features and many improvements in terms of usage, security, and performance:
  • MariaDB has a larger connection pool supporting up to 200,000 connections, whereas MySQL has a smaller connection pool.
  • When comparing the performance of MariaDB and MySQL, it is observed that replication is faster in MariaDB and slower in MySQL; MariaDB is faster than MySQL overall.
  • MariaDB is Open Source, whereas MySQL uses proprietary code in its Enterprise edition.
• The update to MariaDB is irreversible, and all sites on your hosting will subsequently run with this version of MariaDB.
  • Check the compatibility of your scripts before proceeding.
• During this operation, the statistics are reset.

Using MariaDB instead of MySQL

To migrate a Web Hosting to MariaDB:

1. Click here to access the management of your product on the Infomaniak Manager (need help?).
2. Click directly on the name assigned to the product concerned.
3. Click on Databases in the left sidebar.
4. Click on the link Migrate to MariaDB.

To migrate a Cloud Server, refer to this other guide regarding the migration to a new generation of Cloud Server.