Data Replication from Amazon RDS for MySQL to Amazon Aurora for PostgreSQL

We need to replicate data from an Amazon RDS (MySQL) databaes to an Aurora PostgreSQL database. Each database is on a different AWS account and region.

The data must be replicated in the PostgreSQL instance every 6 hours, so we need the guarantee that the data doesn't duplicate even if a field updated for a record.

Which method, tool, or design is better to do that? (Could be different to AWS.)

Upvotes: 0

Views: 249

Answers (2)

vanducng
vanducng

Reputation: 1119

You could facilitate one of the following services provided by AWS:

  1. Database Migration Service
  2. Glue

enter image description here

Upvotes: 1

Related Questions