CODEWITHSUNDEEP
mysqldatabaseamazon-web-servicesamazon-ec2rds
Jack Smother
Jack Smother

Reputation: 207

How to Synchronize MySQL Database from an On Premise to Amazon RDS

I am new to Amazon RDS, and looking to get answer for my question below and couldn't find the answer on stackoverflow yet.

I have a MySQL Database on premise that I want to synchronize with the MySQL Database on Amazon RDS. I understand that replication is possible with Amazon RDS, but how about continuous synchronization? Say my existing local database has one transaction that has been made, I want to synchronize just that transaction, either immediately or by schedule, so that I don't need to replicate the whole thing to RDS.

  1. Does RDS have this feature for MySQL or any other database?
  2. If not, what tools should I be using? EC2 + ? ?
  3. Or is there any database that supports this so I can just run the database on EC2?

Upvotes: 1

Views: 1641

Answers (1)

Exelian
Exelian

Reputation: 5888

Your best (first) option should probably be the AWS Database Migration Service. This is a migration service for exactly your use-case.

If uptime is less of an issue, you could always do a mysql_dump, move that to an EC2 instance and load that into an RDS instance.

Upvotes: 1

Related Questions