RDS mysql automatic backup to another rds db every 12 hours

Question

I am  having two databases prod and test.. both are based on rds mysql and in same region. I want that every 12 hours prod should be backed up into the test db. i mean prod should be backed up and should be restored to test or similarly something

Accepted Answer

Hi Raj

For your requirement of copying data from the production database to the test database on a schedule, we have a few options.

1. Use AWS Backup to backup the database on the 12-hour schedule and restore the database. The same option
2. Use DMS to create a continuous migration pipeline which would keep the databases in sync with real-time replication. ([DMS](https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Source.MySQL.html#CHAP_Source.MySQL.Homogeneous))
3. Use AWS Glue and create a Glue Job to copy data from production to test on a schedule. ([Glue](https://docs.aws.amazon.com/glue/latest/ug/connectors-chapter.html))

As you are looking for a codeless solution DMS would be the ideal option.

Answer

Similar question I’ve answered  before.

I would recommend using AWS DMS To sync the data from PROD to test and run every 12 hours.

https://docs.aws.amazon.com/dms/latest/userguide/Welcome.html

At a basic level, AWS DMS is a server in the AWS Cloud that runs replication software.

Answer

Hello.  
Wouldn't Prod's method of creating RDS snapshots every 12 hours with AWS Backup, etc. and restoring instances from the snapshots fit your use case?  
https://aws.amazon.com/jp/blogs/storage/point-in-time-recovery-and-continuous-backup-for-amazon-rds-with-aws-backup/

Answer

Hey,thanks for reply, this works for me however i will need that it gets auto restored on my test db.  any solution for that?

Answer

Hi

There is an option to perform auto recovery after every backup is peformed using Lambda function and Eventbridge rule.

https://aws.amazon.com/blogs/storage/automate-data-recovery-validation-with-aws-backup/

RDS mysql automatic backup to another rds db every 12 hours

Relevant content