Azure DB for MySQL Single Server retirement on 16th Sept, 2024 – Migrate to Flexible Server now!

Azure Database for MySQL – Single Server is scheduled to be retired by September 16, 2024.

Over the past two years, we have sent repeated reminders through public channels such as Azure Updates and blogs, as well as direct promotions via customer emails, product pages, and Azure Portal banners to complete the migration to Azure Database for MySQL Flexible Server. As part of our ongoing communication and support to safely migrate customers to the new environment, this blog will provide details on the customer experience for all workloads remaining in production starting September 16, 2024.

Running Single Server instances after the sunset date can be a security risk, as there will be no security and bug fix maintenance on the deprecated Single Server platform. To ensure our commitment to running managed instances on a reliable and secure platform after the sunset date, Single Server instances and their data files will be forcibly migrated to the appropriate Flexible Server instance in phases. This may result in the server being unavailable on servers with security and networking features.

Starting September 17, unresponsive servers that are scheduled for automatic migration and do not provide required input will be stopped. Additionally, servers with lower TLS versions, lower client driver versions, and service endpoints will also be stopped. You must go to the Azure portal to verify migration tasks and restart your servers. Complete the tasks required to proceed with automatic migration so that you can later force a migration with limited functionality, preventing your servers from becoming unavailable.

If you currently have an Azure Database for MySQL – Single Server production server, we highly recommend that you migrate your Azure Database for MySQL – Single Server instance to the Azure Database for MySQL – Flexible Server service for free using one of the following: Migration Tooling Options before September 16, 2024.

Azure Database for MySQL Import CLI

You can utilize Azure Database for MySQL Import CLI (General Availability) Migrate Azure Database for MySQL – Single Server instance to Flexible Server using snapshot backup and restore technology with a single CLI command. Based on user input, this feature provisions a target Flexible Server instance, backs up the source server, and then restores it to the target. The following properties and files are copied from the Single Server instance to the Flexible Server instance:

• Data file
• Server parameters
• Compatible Firewall Rules
• Server properties such as tier, version, SKU name, storage size, location, geo-redundant backup settings, public access settings, tags, auto-growth settings, and backup retention days settings.
• Administrator username and password

In-place automatic migration

In-place automatic migration (General Availability) Azure Database for MySQL – Single Server to Flexible Server upgrade is an in-place upgrade during the planned maintenance window for selected Single Server database workloads. If you have Single Server workloads that do not have complex features (service endpoints/VNet rules, virtual network configuration, dual infrastructure encryption, read replicas) enabled, please submit an Azure support ticket to schedule an automated migration as soon as possible.

Azure Database Migration Service (DMS)

Azure Database Migration Service (DMS) (General Availability) is a fully managed service designed to enable seamless service. Online and Offline Azure Database for MySQL – Migrate from Single Server to Flexible Server. DMS supports cross-region, cross-version, cross-resource group, and cross-subscription migrations.

conclusion

If you want to migrate your single server instances to flexible servers before September 16th without any disruption to your business continuity, take advantage of one of these options! Learn more about the experience after the sunset date here – What’s happening in Azure Database for MySQL Single Server? | Microsoft Learn.

For additional questions about Azure Database for MySQL Single Server deprecation, see: Frequently Asked Questions.