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 Web hosting of the MySQL to MariaDB.
Preamble
- MariaDB is an enhanced version of MySQL, with many powerful built-in features and many improvements in terms of use, safety and performance:
- MariaDB has a larger connection pool supporting up to 200,000 connections while MySQL has a smaller connection pool.
- By comparing the performance of MariaDB and MySQL, we find that replication is faster in MariaDB and slower in MySQL; MariaDB is faster than MySQL in a global way.
- MariaDB is Open Source while MySQL uses a proprietary code in its Enterprise edition.
Use MariaDB to replace MySQL
The update to MariaDB is irreversible and all sites present on your hosting will then work with this version of MariaDB. Check the compatibility of your scripts before proceeding.
To migrate web hosting to MariaDB:
- Click here in order to access the management of your product on the Manager Infomaniak (Need help?).
- Click directly on the nameallocated to the product concerned.
- Click on Databases in the left side menu.
- Click on the link Migrate in MariaDB.
To migrate a Cloud Server become aware of this other guide about migration to a new generation of Cloud Server.
Link to this FAQ: