Migration of Azure MySQL database from single to flexible

Question

We have atleast less than 100GB size of data.
Question:

1. How long it will take to migrate it from single to flexible if we use the offline mode? A number would be ok.
2. Can we use the same hostname of our previous single server if we create the flexible one?

Thank you have a nice day.

Answer 1

@Khristian Dave Poleracio Thank you for the information. There are multiple options to migrate as database size is not very large. The time taken can vary, for 100Gb it could be a couple to a few hours depending on the number of database objects. To get a realistic estimate, you can do a POC with a copy of the server created via PiTR and do a dry run. It would also expose any issues that you can work-around/fix before actual production migration.

• MyDumper/MyLoader – Both Offline and Online (with Data-In Replication to provide minimal downtime migration)
Tutorial: Migrate Azure Database for MySQL – Single Server to Azure Database for MySQL – Flexible Server with open-source tools | Microsoft Learn

• Azure Database Migration Service (DMS) – Both Offline and Online (In Preview with minimal downtime)
Tutorial: Migrate Azure Database for MySQL - Single Server to Flexible Server offline using DMS via the Azure portal - Azure Database Migration Service | Microsoft Learn
Tutorial: Migrate Azure Database for MySQL - Single Server to Flexible Server online using DMS via the Azure portal - Azure Database Migration Service | Microsoft Learn

Regards
Geetha

Answer 2

Hi, @Khristian Dave Poleracio Thanks for the question and using the Microsoft Q&A platform
As I understand you want to know the duration for migrating Mysql Single server to a flexible server in offline mode and you also want to know if you can use the same hostname of a single server

on databases, db objects, tables, etc, and migration tooling used. you may do a POC with a copy of the server to get the closest estimate.

It would help answer better if you can provide the below details.

• How many vCores per server/total
• Are there Read Replicas? If Yes, how many?
• MySQL version
• Azure Region
• Downtime you can afford.
• How soon do you want to migrate?

Currently not possible to get the same hostname.

Regards
Geetha