Development and Production Slots for Azure MySql Server

Question

I am wondering if there are any provisions to swap database server from development to production slots, similar to 'deployment slots' provided for Azure App Service? What are the recommended guidelines for migrating Azure Database for Mysql from development to production environments?

Answer 1

Hi @Umer Rashid

There are no provisions to swap database servers from development to production slots for Azure Database for MySQL. You need to migrate your Azure Database for MySQL.

For migration, you can use Data-in Replication, which limits the amount of downtime that is incurred by the application.  Data-in Replication synchronizes data from a source MySQL server on-premises, in virtual machines (VMs), or in cloud database services

Or you can use dump and restore migration process. You can use the mysqldump command-line utility or a third-party MySQL tool to do dump and restore commands. Migrate using dump and restore - Azure Database for MySQL - Flexible Server | Microsoft Learn Thank you!