- 최신
- 최다 투표
- 가장 많은 댓글
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/
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.
Hi Raj
For your requirement of copying data from the production database to the test database on a schedule, we have a few options.
- Use AWS Backup to backup the database on the 12-hour schedule and restore the database. The same option
- Use DMS to create a continuous migration pipeline which would keep the databases in sync with real-time replication. (DMS)
- Use AWS Glue and create a Glue Job to copy data from production to test on a schedule. (Glue)
As you are looking for a codeless solution DMS would be the ideal option.
You do not necessarily need continuous migration. You can simply request a point in time restore every 12 hours to a 'test' database.
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?
Hi, see above: I proposed a solution for it.
hi, any other way except lambda ? i want to make it codeless as much as possible. Though i'll try this any let you know.Thanks
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/
관련 콘텐츠
- 질문됨 7년 전
To fully automate the process, you can use the EventBridge event on Backup Job State Change and trigger a Lambda that will use the prod backup to restore on test automatically. See https://docs.aws.amazon.com/aws-backup/latest/devguide/eventbridge.html