Search code examples
mysqlamazon-web-servicesamazon-rds

How to sync 2x AWS RDS instances

I have 2x RDS single instances (MySQL) in the same region.

The goal is to copy (A) RDS to (B) RDS on nightly basis.

Is there any way to have this configuration auto sync between 2 RDS instances?

Solution

  • If your goal is to copy the contents of one Amazon RDS database such that another RDS database contains identical content, then it is easiest to use a snapshot:

    • Create an Amazon RDS Snapshot of the source database
    • Launch a new Amazon RDS database instance from the Snapshot
    • Delete the previous Amazon RDS database 'B' database, since it is now out-of-date

    The new database launched from the Snapshot will be identical to the source database (except for the instance DNS name).

    This operation can be done via AWS CLI commands.