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 account to MariaDB:

1. Click here to access your product management interface in the Infomaniak Manager (need help?).
2. Click directly on the name assigned to the product in question.
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 on migrating to a new generation of Cloud Server.