question

MikeSarafidis-3263 avatar image
0 Votes"
MikeSarafidis-3263 asked AnuragSharma-MSFT commented

MySQL Move or Replicate to Germany

We need to move for financial reasons our Azure Database for MySQL from North Europe (Ireland) to Germany. We have seen that the specific resource type is available at Datacenters in Germany.

As far as I can see it is not possible to move the specific resource type to different region with resource "Move". Is this correct?

I have also looked up at the approach of creating a read replication and then stop the replication and use it as master. However, I cannot create a read replica at German Region. There is no such option.
136342-image.png

What else can we do in order to move our database to Germany?


azure-database-mysqlazure-database-migration
image.png (85.3 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

AnuragSharma-MSFT avatar image
0 Votes"
AnuragSharma-MSFT answered AnuragSharma-MSFT commented

Hi @MikeSarafidis-3263, welcome to Microsoft Q&A forum.

Rightly as per the article, using resource mover we can only move below resources as of now:

136524-image.png

Also, as of now we cannot create a read replica from North Europe to Germany region.

However, we can create a backup of Azure MySQL on blob storage from one region and then restore it on another region. Please check the below article that has step by step description of the same:

Backup Azure Database for MySQL to a Blob Storage

Tips and Tricks in using mysqldump and mysql restore to Azure Database for MySQL

Also we can achieve the same using MySQL Workbench:

Migrate your MySQL database by using import and export

Please let us know if this helps or else we can discuss further on the same.


Please don't forgot to click on accept it as answer button 136554-image.png wherever the information provided helps you. This can be beneficial to other community members as well.



image.png (33.3 KiB)
image.png (7.6 KiB)
· 3
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Dear AnuragSharma,

Thank you for your response.

Dumping a database and restoring elsewhere will have as a result large downtime.

We need an approach with the less possible downtime.

How much time will it need to dump to blob storage and restore to database 100GB of data? Can you give me a time estimation?

0 Votes 0 ·

Thanks for your response, yes it can have some downtime. I am checking internally if there is a way we can reduce the downtime or any alternative way to do if possible.

0 Votes 0 ·

Thanks @MikeSarafidis-3263 for your patience. I checked with internal team and yes based on the current scenario we need to use mysqldump and restore to achieve our requirements. Normally It should be 4-6 hrs of downtime but testing would be the best way for them to validate the same since there are many variables in the infrastructure and database schema which contributes to the migration time. There are some recommendations we have for them to improve the migration time

Migrate using dump and restore - Azure Database for MySQL | Microsoft Docs
Migrate using dump and restore - Azure Database for MySQL | Microsoft Docs

You can also refer to below post which has an automation script:

Migrate from Azure Database for MySQL - Single Server to Flexible Server in 5 easy steps! - Microsoft Tech Community


0 Votes 0 ·