How to sync 2x AWS RDS instances-CodePudding

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?

CodePudding user response：

I would suggest looking into DMS ongoing replication as it seems like a potential solution for your use case https://docs.aws.amazon.com/dms/latest/userguide/CHAP_BestPractices.html#CHAP_BestPractices.OnGoingReplication

CodePudding user response：

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.