Migration of local MySQL 5.5 databases
Please use the “Print” function at the bottom of the page to create a PDF.
For Managed Dedicated Servers
In this article we have compiled answers to frequently asked questions about the upcoming migration of MySQL 5.5 databases for Managed Servers.
Why is migration taking place?
The requirements for system security and the integrity of the database and hosting platform necessitate the migration of outdated MySQL databases to modern and regularly maintained database servers. As your local databases are still running on the outdated database management system MySQL 5.5, we will update the databases to a current, secure, and stable version: MariaDB 10.
What are the advantages of migration?
- MariaDB 10 is fully compatible with MySQL 5.5.
- MariaDB 10 supports more up-to-date SQL specifications.
- As part of the migration, your databases are moved to dedicated database servers, allowing you to automatically benefit from the advantages of our performance databases: The infrastructure specially designed for database operation combines excellent performance with maximum security. It also offers high availability thanks to geo-redundancy (there is virtually no downtime).
Why migrate to MariaDB and not to MySQL?
MariaDB 10 is a powerful and modern open source database management system that is still fully compatible with your outdated MySQL 5.5 database. This allows us to automatically migrate your databases to MariaDB, whereas this would not be possible in all cases with a current MySQL version, as MySQL is not designed for backward compatibility to the same extent as MariaDB.
In addition, MariaDB contains many improvements and optimizations compared to MySQL, especially in the areas of performance and scalability. This can be particularly beneficial for WordPress websites that need to handle a large number of page views and users. By using MariaDB, WordPress websites can run faster and more stable, which can lead to a better user experience and higher search engine rankings.
Will my website be offline during the migration?
During the migration, data can still be read from the database so that your website or application can continue to read and display information during the migration. A WRITE action (changing or adding data records) is not possible during the migration.
How long will the migration of the databases take?
The duration of the migration depends on the size of the database. It usually takes less than 10 minutes. To ensure data integrity, write access to the database is blocked during the migration.
Which of my databases are affected?
All local MySQL 5.5 databases (localhost) will be migrated to the new remote shared target systems.
If less than 10 databases are affected, we have listed the names of the affected databases in the migration email you received from us.