MySQL Master/Slave replication from Azure to AWS

Kailasanathan, Kanthi 1 Reputation point
2022-07-13T08:46:01.347+00:00

Hi,

I would like to setup a MySQL master/slave replication as follows :

Master - MySQL managed instance in Azure
Slave - MySQL RDS instance in AWS

Please let me know if this is possible and what are the technical steps involved.

Thank you

Azure Database Migration service
Azure Migrate
Azure Migrate
A central hub of Azure cloud migration services and tools to discover, assess, and migrate workloads to the cloud.
717 questions
Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
713 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Bjoern Peters 8,781 Reputation points
    2022-07-13T12:51:47.977+00:00

    As from my understanding... this is not possible with an Azure mySQL managed Instance as you do not have access to the underlying cfg-file

    You can setup a mySQL replication within Azure through Azure Portal but not with a destination in AWS...

    Maybe this could work if you are using a Linux VM on Azure and install your mySQL server on your own...

    Sorry that I can't give you a better solution.

    0 comments
  2. Jazeem Ilyas 31 Reputation points
    2022-07-15T01:39:44.987+00:00

    Hi @Kailasanathan, Kanthi

    We had a requirement like this and it was not possible. We ended up setting the replica on different Geo locations for high availability.

    0 comments