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 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 evident that replication is faster in MariaDB and slower in MySQL; MariaDB is generally faster than MySQL.
- MariaDB is Open Source, whereas MySQL uses proprietary code in its Enterprise edition.
Using MariaDB as a replacement for MySQL
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.
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 product in question.
- Click on Databases in the left sidebar.
- 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.
Link to this FAQ: