Automated Backup and Restore Solution for Cross-Region Aurora MySQL Databases

Question

I'm currently managing a production RDS Aurora MySQL database located in one region, while my development environment resides in another. The production database contains approximately 1TB of data spread across multiple databases within the Aurora cluster.

I'm seeking guidance on establishing an automated backup and restore solution that operates every Sunday. The objective is to seamlessly replicate the production database to the development region for testing and development purposes.

Could anyone advise on the best practices and AWS services/tools suitable for accomplishing this task efficiently?

Answer

Hello.

If it's cross-region, I think you can set up AWS Backup to take a backup once a week and copy it to the development environment region.  
https://docs.aws.amazon.com/aws-backup/latest/devguide/backup-feature-availability.html#features-by-resource

Alternatively, I think it is possible to use DMS to perform cross-region replication.  
Please note that DMS, which requires the creation of replication instances, may be more expensive than AWS Backup.  
https://docs.aws.amazon.com/prescriptive-guidance/latest/patterns/implement-cross-region-disaster-recovery-with-aws-dms-and-amazon-aurora.html

Automated Backup and Restore Solution for Cross-Region Aurora MySQL Databases

Relevant content