Knowledge base
1000 FAQs, 500 tutorials and explanatory videos. Here, there are only solutions!
Upgrading MySQL to MariaDB
This guide explains how to migrate web hosting from MySQL to MariaDB.
MariaDB replaces MySQL!
MariaDB is an improved version of MySQL. It comes with many powerful built-in features and numerous usability, security, and performance enhancements.
Key differences
- MariaDB has a larger connection pool supporting up to 200,000+ connections whereas MySQL has a smaller connection pool.
- Comparing the performance of MariaDB and MySQL, it can be seen that replication is faster in MariaDB and slower in MySQL.
- MariaDB is Open Source while MySQL uses proprietary code in its Enterprise edition.
- Comparing MariaDB and MySQL, MariaDB is faster than MySQL.
Use MariaDB as a replacement for MySQL
The update to MariaDB is irreversible and all the sites on your hosting will then work with this version of MariaDB. We recommend that you check your scripts for compatibility before proceeding.
To migrate web hosting to MariaDB:
- open the Manager ( manager.infomaniak.com )
- go to Web Hosting
- if necessary click on the hosting / domain name concerned
- in the left side panel, click on Databases
- click on the Migrate to MariaDB link
To migrate a managed Cloud Server follow the instructions (click here) about migrating to a new generation of Cloud Server.
Link to this FAQ: