MySQL Move or Replicate to Germany

Question

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.

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

Answer 1

Hi @Mike Sarafidis , welcome to Microsoft Q&A forum.

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

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 wherever the information provided helps you. This can be beneficial to other community members as well.