Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
You can perform MySQL migrations to Azure Database for MySQL Flexible Server with minimal downtime by using Data-in replication, which limits the amount of downtime that the application incurs.
You can also refer to Database Migration Guide for detailed information and use cases about migrating databases to Azure Database for MySQL Flexible Server. This guide provides guidance that leads the successful planning and execution of a MySQL migration to Azure.
Overview
With Data-in replication, you can configure the source as your primary and the target as your replica, so that there's continuous synching of any new transactions to Azure while the application remains to run. After the target Azure side catches up with the data, 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 finish, your application is live on Azure!