Knowledge base
1000 FAQs, 500 tutorials and explanatory videos. Here, there are only solutions!
Enable MariaDB to replace MySQL
This guide explains how to migrate a Web Hosting from MySQL to MariaDB.
Preamble
- MariaDB is an enhanced version of MySQL, featuring numerous powerful integrated features and many improvements in terms of usage, security, and performance:
- MariaDB has a larger connection pool supporting up to 200,000 connections, while MySQL has a smaller connection pool.
- When comparing the performance of MariaDB and MySQL, it is noted that replication is faster in MariaDB and slower in MySQL; MariaDB is generally faster than MySQL.
- MariaDB is Open Source, while MySQL uses proprietary code in its Enterprise edition.
Using MariaDB to replace MySQL
The update to MariaDB is irreversible and all sites on your hosting will then run on this version of MariaDB. Check the compatibility of your scripts before proceeding.
To migrate a Web Hosting to MariaDB:
- Click here to access the management of your product on the Infomaniak Manager (need help?).
- Click directly on the name assigned to the relevant product.
- Click on Databases in the left sidebar.
- Click on the link Migrate to MariaDB.
To migrate a Cloud Server, refer to this other guide about migrating to a new generation of Cloud Server.
Link to this FAQ: