Minimal-downtime migration to Azure Database for MySQL
APPLIES TO: Azure Database for MySQL - Single Server Azure Database for MySQL - Flexible Server
You can perform MySQL migrations to Azure Database for MySQL with minimal downtime by using the newly introduced continuous sync capability for the Azure Database Migration Service (DMS). This functionality limits the amount of downtime that is incurred by the application.
You can also refer to Database Migration Guide for detailed information and use cases about migrating databases to Azure Database for MySQL. This guide provides guidance that will lead the successful planning and execution of a MySQL migration to Azure.
Azure DMS performs an initial load of your on-premises to Azure Database for MySQL, and then continuously syncs any new transactions to Azure while the application remains running. After the data catches up on the target Azure side, you stop the application for a brief moment (minimum downtime), wait for the last batch of data (from the time you stop the application until the application is effectively unavailable to take any new traffic) to catch up in the target, and then update your connection string to point to Azure. When you are finished, your application will be live on Azure!
- For more information about migrating databases to Azure Database for MySQL, see the Database Migration Guide.
- View the video Easily migrate MySQL/PostgreSQL apps to Azure managed service, which contains a demo showing how to migrate MySQL apps to Azure Database for MySQL.
- See the tutorial Migrate MySQL to Azure Database for MySQL online using DMS.