How to Migrate MySQL server from On-premises to Azure using DATA MIGRATION SERVICE (DMS)

Introduction

There are several advantages to moving a MySQL database from on-premises to the cloud, such as enhanced performance, cost-effectiveness, scalability, and high availability. With minimal downtime, Azure Database Migration Service (DMS) provides a simplified and effective method of migrating MySQL databases to Azure. It supports both homogeneous migrations (from MySQL to Azure Database for MySQL) and heterogeneous migrations (from MySQL to other database types).

Steps to Perform Migration Using DMS

1. Set up DMS
   The following phase in migrating your single server to a flexible server is to set up DMS once your target flexible server has been deployed and configured.
2. Register the Resource Provider
   Check for and choose ‘Subscriptions’ in the Azure portal after logging in before launching your first DMS instance.
3. Create a Database Migration Service (DMS) instance
   Using the Azure portal, go to + Create a resource, type in Azure Database Migration Service, and choose it from the list that appears.
4. Create a Migration Project
   Locate the newly established service in the Azure interface, click to launch it, and then start a new migration project. Choose All services in the Azure interface, type in Azure Database Migration Service, and then click on Azure Database Migration Services.
5. Configure the Migration Project
   • Provide the connection information for the source MySQL instance on the Select source screen, then click Next, and then Choose a target.
   • Map the source and target databases for the migration on the Select Databases screen, then click Next: Configure migration settings.
   • To make the source read-only, choose the Make Source Server Read Only option. However, note that this is a server-level configuration. If this option is chosen, not just the chosen databases but the entire server will be made read-only.
   • Azure Database Migration Service automatically chooses the target database if the names of the source and target databases match.
6. Monitor the Migration
   To see the status of the number of tables completed, select Refresh on the migration activity screen to update the display. On the activity screen, you may choose the database name to view the current status of each table throughout their migration. To refresh the display, select Refresh.

Conclusion

Azure DMS offers powerful capabilities to manage continuous replication, track development, and address any problems. Furthermore, Azure Database for MySQL provides a completely managed environment, relieving businesses of the trouble of maintaining hardware, patches, and backups so they can concentrate on innovation and expanding their businesses.

In conclusion, a dependable and effective method that can assist companies in updating their data platform is to use Azure DMS to migrate on-premises MySQL databases to Azure. Organizations may benefit from cost savings, improved security, and cutting-edge cloud technologies by switching to Azure, which also opens the door for future scalability and digital transformation projects.

About CloudThat

CloudThat is a leading provider of Cloud Training and Consulting services with a global presence in India, the USA, Asia, Europe, and Africa. Specializing in AWS, Microsoft Azure, GCP, VMware, Databricks, and more, the company serves mid-market and enterprise clients, offering comprehensive expertise in Cloud Migration, Data Platforms, DevOps, IoT, AI/ML, and more.

CloudThat is the first Indian Company to win the prestigious Microsoft Partner 2024 Award and is recognized as a top-tier partner with AWS and Microsoft, including the prestigious ‘Think Big’ partner award from AWS and the Microsoft Superstars FY 2023 award in Asia & India. Having trained 650k+ professionals in 500+ cloud certifications and completed 300+ consulting projects globally, CloudThat is an official AWS Advanced Consulting Partner, Microsoft Gold Partner, AWS Training Partner, AWS Migration Partner, AWS Data and Analytics Partner, AWS DevOps Competency Partner, AWS GenAI Competency Partner, Amazon QuickSight Service Delivery Partner, Amazon EKS Service Delivery Partner,  AWS Microsoft Workload Partners, Amazon EC2 Service Delivery Partner, Amazon ECS Service Delivery Partner, AWS Glue Service Delivery Partner, Amazon Redshift Service Delivery Partner, AWS Control Tower Service Delivery Partner, AWS WAF Service Delivery Partner and many more.

To get started, go through our Consultancy page and Managed Services Package, CloudThat’s offerings.