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

Bisina · 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.

Gary Mclean · 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.

Riku_Kobayashi · 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/

rePost-User-raj · 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?

AWS-Learner · 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