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

Introduction

• MariaDB is an enhanced version of MySQL, featuring numerous powerful built-in features and many improvements in terms of usability, 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 found that replication is faster in MariaDB and slower in MySQL; MariaDB is faster than MySQL overall.
  • MariaDB is Open Source, while MySQL uses proprietary code in its Enterprise edition.
• The upgrade to MariaDB is irreversible, and all websites on your hosting will then run with this version of MariaDB.
  • Check the compatibility of your scripts before proceeding.
• During this operation, the statistics are reset.

Using MariaDB as a replacement for MySQL

To migrate a web hosting to MariaDB:

1. Click here to access the hosting & site management section in your Infomaniak Manager (❓: help).
2. Click on the name of the relevant hosting.
3. Click on Databases in the left-hand menu.
4. Click on the Migrate to MariaDB link.

To migrate a Cloud Server, please refer to this other guide about migrating to a new generation of Cloud Server.