Azure Database for MySQL Import supports Percona XtraBackup for migrations to Flexible Server
Published Feb 28 2024 06:27 PM 2,635 Views
Microsoft

Updated May 28, 2024

 

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. To facilitate seamless migration to Azure Database for MySQL - Flexible Server, we’re pleased to announce General Availability of Azure Database for MySQL Import supporting Percona XtraBackup for external migrations. 

 

Azure Database for MySQL Import enables you to migrate your MySQL on-premises or Virtual Machine (VM) workload seamlessly to Azure Database for MySQL - Flexible Server. It uses a user-provided physical backup file (taken using Percona XtraBackup) and restores the source server's physical data files to the target server offering a simple and fast migration path. Based on user-inputs, it takes up the responsibility of provisioning your target Flexible Server and then restoring the user-provided physical backup of the source server stored in the Azure Blob storage account to the target Flexible Server instance.

 

mysql-import-external.PNG

 

The key features of Azure Database for MySQL Import for external migrations are support for: 

  • MySQL On-prem/VM workloads with version = 5.7, 8.0 as data source.
  • Physical backup files taken using Percona XtraBackup. 
  • Schema and data migration. Logins must be migrated using dump/restore. Users can set up data replication between the source and target to achieve minimal downtime.
  • Fast data backup and restore to target, suitable for bigger workloads.
  • A CLI user experience that enables customers to perform migrations at scale.
  • Provisioning a target flexible server based on customer inputs to Azure Database for MySQL Import CLI command, consequently triggering import.

 

For more information about using Azure Database for MySQL Import for migration of MySQL workloads to Azure Database for MySQL – Flexible Server, see Migrate MySQL on-premises or Virtual Machine (VM) workload to Azure Database for MySQL - Flexible Se...

 

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

Co-Authors
Version history
Last update:
‎May 28 2024 09:09 AM
Updated by: