1

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?

0

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
  • That would be master - slave architecture by using external replica. What I want to achieve is syncing two master MySQL from AWS & GCP. – Eldwin Eldwin May 25 at 16:12
  • I believe you are looking for a master-master architecture where one master is in AWS and the other in GCP, and both instances are running via the respective platforms' managed database services. In that case you would have to set up the replication as AWS master is slave of GCP instance, and the GCP instance is a slave of the AWS master. Do note that writing to both instances at the same time is not recommended. – Hamza Saleem Ahmed May 26 at 6:53

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.