Upgrade Azure Database for MySQL - Single Server to Flexible Server using Azure DMS

Overview

Our flagship offering, Azure Database for MySQL – Flexible Server, is well-positioned to serve as the best platform for hosting your MySQL workloads, offering maximum control and flexibility to run your MySQL servers. We're now directing all of our energies and feature investments towards Flexible Server, with Azure Database for MySQL - Single Server on path for retirement on 16 September 2024.

In the interim, you’ll need to upgrade your service by using Azure Database Migration Service (DMS) to migrate to Flexible Server. This "upgrade” to Flexible Server will provide you with the following key benefits:

• 1.5x improved price-performance of the Business Critical service tier with latest v5 compute SKUs, which can scale up to 96 vCores and IOPs scale up to 48K IOPs
  
• Increased uptime by using zone redundant or same-zone hot standby and our custom maintenance windows.
  
• Cost optimization through multiple features such as Burstable SKUs (up to 20 vCores), Stop/Start and Reserved Instances.
  

Leverage Azure Database Migration Service for a smooth upgrade

DMS is designed to provide an intuitive, self-serve migration experience for customers seeking to migrate MySQL – Single Server to Flexible Server, and at their own pace.

Depending on their database size, the nature of their workload, and their applications tolerance for downtime, customers can choose to perform either an offline or online migration.

• Offline migration - DMS currently supports performing an offline migration of data and schema. For detailed steps on how to perform an offline migration, see Migrate Azure Database for MySQL - Single Server to Flexible Server offline using DMS.
  
• Online migration - DMS currently supports performing online migrations, which provides an integrated experience, taking the initial backup and streaming the binlog changes from the source single server to the target flexible server. You can complete migrations with minimum downtime for critical applications, which limits the impact to service level availability and inconvenience to end customers. For more information, see Migrate Azure Database for MySQL - Single Server to Flexible Server online using DMS.
  

Customers can also achieve an online migration by performing an offline migration in conjunction with 'Enable Transactional Consistency'' and Data-in replication.

Summary

With the added benefits provided by Azure Database for MySQL - Flexible Server and Single Server on the road to retirement by 16 September 2024, there’s no better time to consider upgrading your Single Server instances using DMS!

If you have any feedback or questions about the information provided above, please refer to the published FAQs or leave a comment below or email us at AskAzureDBforMySQL@service.microsoft.com. Thank you!

Continue reading...