1

Hi i am pretty new to Amazon RDS.my question how to Sync data from one amazon RDS machine to another? like taking a mysql Dump or something like that, and is it possible to Sync over multiple regions like from Europe RDS Machine to US RDS machine.

Rakesh
  • 411
  • 2
  • 6
  • 11

1 Answers1

3

It depends how you want to sync data. Do you want to do it automatically, and just make database B be a copy of A? Or, what if A and B have some rows with the same internal primary key, but different other information, which database do you want to be the 'master'? This question needs a lot more detail supplied. Also, read up on http://aws.amazon.com/rds/mysql/#Multi-AZ - that may answer some of your questions.

Aaron
  • 2,968
  • 1
  • 22
  • 36