First published on MSDN on Aug 30, 2018
Authored by scphang@microsoft.com
We recently announced public preview support for online migrations of MySQL to Azure Database for MySQL by using the Azure Database Migration Service (DMS). Customers can migrate their MySQL workloads hosted on premises, on virtual machines, or on AWS RDS to Azure Database for MySQL while the source databases remain online. This minimizes application downtime and reduces the SLA impact for customers.
Conceptionally, online migration with minimum downtime in DMS uses the following process:
1. Migrate initial load using bulk copy.
2. While initial load is being migrated, incoming changes are being cache and applied after initial load completes.
3. Changes in source database continue to replicate to target database until user decides to cutover.
4. During a planned maintenance window, stop the new transactions coming into source database. Application downtime starts with this step.
5. Wait for DMS to replicate the last batch of data.
6. Complete application cutover by updating the connection string to point to your instance of Azure Database for MySQL.
7. Bring the application online.
Below are prerequisites setting up DMS and step-by-step instructions for connecting to a MySQL database source on AWS RDS.
Use the following instructions provided by AWS to create a new parameter group (see the binary logging format section).
When creating the new parameter group, set the following values:
Save the new parameter group
Please refer to this tutorial to continue with schema migration, setting up DMS to do data movement and how to monitor data movement.
For known issues and workarounds, please refer to this document .
Congratulations, you have just performed a MySQL migration from AWS RDS to Azure Database for MySQL successfully!For more information, refer to the resources below. If you have any questions, please email the DMS Feedback alias at dmsfeedback@microsoft.com.
Sign in on Azure portal and set up an instance of DMS for free. We are constantly adding new database source/target pairs to DMS. Stay up-to-date on #AzureDMS news and follow us on Twitter @Data_Migrations . Join the Azure Database Migration Service (DMS) Preview Yammer group, and give us feedback via User Voice or email by contacting us at dmsfeedback@microsoft.com .
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.