Edit

Select the right tools for migration to Azure Database for MySQL

  • Article

APPLIES TO: Azure Database for MySQL - Single Server Azure Database for MySQL - Flexible Server

Migrations are multi-step projects that can be tough to complete. Migrating database servers across platforms involves more than data and schema migration. There are also several other components, such as server configuration parameters, networking, access control rules, etc., to move. These are required to ensure that the functionality of the database server in the new target platform mimics the source.

For detailed information and use cases about migrating databases to Azure Database for MySQL, refer to the Database Migration Guide. This document provides pointers to help you successfully plan and execute a MySQL migration to Azure.

In general, migrations can be categorized as either offline or online.

  • With an offline migration, the source server is taken offline, and a dump and restores of the databases are performed on the target server.

  • With an online migration (migration with minimal downtime), the source server allows updates, and the migration solution will take care of replicating the ongoing changes between the source and target server along with the initial dump and restore on the target.

If your application can afford some downtime, offline migrations are always the preferred choice, as they're simple and easy to execute. However, an online migration is the best choice if your application can only afford minimal downtime. Migrations of most OLTP systems, such as payment processing and e-commerce, fall into this category.

Decision table

There are both offline and online migration scenarios to help you select the right tools for migrating to Azure Database for MySQL - Flexible Server.

Offline

To help you select the right tools for migrating to Azure Database for MySQL, consider the detail in the following table for offline migrations.

Migration Scenario Tool(s) Details More information
Single to Flexible Server (Azure portal) Database Migration Service (classic) and the Azure portal Tutorial: DMS (classic) with the Azure portal (offline) Suitable for < 1TB workloads; cross-region, cross-storage type and cross-version migrations.
Single to Flexible Server (Azure CLI) Azure MySQL Import CLI Tutorial: Azure MySQL Import Recommended - Suitable for all sizes of workloads, extremely performant for > 500 GB workloads.
MySQL databases (>= 1 TB) to Azure Database for MySQL Dump and Restore using MyDumper/MyLoader + High Compute VM Migrate large databases to Azure Database for MySQL using mydumper/myloader Best Practices for migrating large databases to Azure Database for MySQL

Online

To help you select the right tools for migrating to Azure Database for MySQL - Flexible Server, consider the detail in the following table for online migrations.

Migration Scenario Tool(s) Details More information
Single to Flexible Server (Azure portal) Database Migration Service (classic) Tutorial: DMS (classic) with the Azure portal (online) Recommended
Single to Flexible Server Mydumper/Myloader with Data-in replication Migrate Azure Database for MySQL – Single Server to Azure Database for MySQL – Flexible Server with open-source tools N/A
Azure Database for MySQL Flexible Server Data-in replication Mydumper/Myloader with Data-in replication Configure Data-in replication - Azure Database for MySQL Flexible Server N/A

Next steps