How to sync easily between a master database from Google Cloud SQL and a master database from Amazon RDS

Posted on

Question :

I’ve created a master – slave (replication) in Google Cloud SQL.
I’ve also created a master – slave (replication) in Amazon RDS.

I want to sync two master MysQL from Google Cloud SQL and Amazon RDS. What’s the approach can be done?

Answer :

Theoretically, just adding replication masters to the two servers should work over the MySQL protocol, and without needing any additional configuration.

You can review the procedures at the below links for details on each side of the process:

  1. AWS – How can I replicate an Amazon RDS for MySQL instance by using binary logs to an on-premises environment?
  2. GCP – Configuring external replicas
  3. GCP – Replicating from an external server

Leave a Reply

Your email address will not be published. Required fields are marked *