Durch die Nutzung von AWS re:Post stimmt du den AWS re:Post Nutzungsbedingungen
AWS re:Postre:Post

RDS mysql automatic backup to another rds db every 12 hours

0

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

Themen
SpeicherMigration und ModernisierungAnalysenDatenbank
Tags
Sicherung & WiederherstellungAmazon Relational Database ServiceDatenbankMySQL
Sprache
English
rePost-User-raj
gefragt vor 10 Monaten409 Aufrufe
5 Antworten
1

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/

profile picture
EXPERTE
Riku_Kobayashi
beantwortet vor 10 Monaten
profile pictureAWS
EXPERTE
Didier_Durand
überprüft vor 10 Monaten
1

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.

profile picture
EXPERTE
Gary Mclean
beantwortet vor 10 Monaten
0
Akzeptierte Antwort

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)
  3. 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.

profile picture
Bisina
beantwortet vor 10 Monaten
  • philaws MODERATOR
    vor 10 Monaten

    You do not necessarily need continuous migration. You can simply request a point in time restore every 12 hours to a 'test' database.

0

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?

rePost-User-raj
beantwortet vor 10 Monaten
  • Didier_Durand EXPERTE
    vor 10 Monaten

    Hi, see above: I proposed a solution for it.

  • rePost-User-raj
    vor 10 Monaten

    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

0

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/

AWS
AWS-Learner
beantwortet vor 10 Monaten

Du bist nicht angemeldet. Anmelden um eine Antwort zu veröffentlichen.

Eine gute Antwort beantwortet die Frage klar, gibt konstruktives Feedback und fördert die berufliche Weiterentwicklung des Fragenstellers.

Richtlinien für die Beantwortung von Fragen

Relevanter Inhalt