Day 23: RDS Backups and Restoration ๐Ÿ”„๐Ÿš€

Day 23: RDS Backups and Restoration ๐Ÿ”„๐Ÿš€


2 min read

Introduction ๐ŸŒŸ๐Ÿšง

Embark on a voyage through the cosmos of RDS (Relational Database Service) backups and restoration, unraveling the intricacies of automated backups, manual snapshots, and the celestial Aurora database. As we navigate this journey, discover the art of data preservation and the various options for restoring databases.

Managed disaster recovery with Amazon RDS for SQL Server using cross-Region  automated backups | AWS Database Blog

RDS Backups ๐Ÿ“…๐Ÿ’พ

Automated Backups

  • Daily full backup during the backup window

  • Transaction logs backed up every 5 minutes

  • Point-in-time recovery from the oldest backup to 5 minutes ago

  • Retention of 1 to 35 days (set 0 to disable automated backups)

Automate the RDS backup function using Lambda | by Kubernetes Advocate |  AVM Consulting Blog | Medium

Manual DB Snapshots

  • User-triggered snapshots

  • Retention for as long as desired

  • Tip: In a stopped RDS database, consider snapshotting & restoring to save on storage costs.

Aurora Backups ๐Ÿ“ˆ๐Ÿ’ 

Automated Backups

  • Retention for 1 to 35 days (cannot be disabled)

  • Point-in-time recovery within the retention timeframe

Manual DB Snapshots

  • User-triggered with retention flexibility

Restore Options ๐Ÿ”„๐Ÿ”

Amazon RDS for SQL Server - Encrypted Backup/Restore - โ‹ฎIWConnect

RDS & Aurora Restore Options

  • Restoration creates a new database

  • MySQL RDS Database Restore from S3

    • Backup on-premises database

    • Store on Amazon S3

    • Restore onto a new RDS instance running MySQL

  • MySQL Aurora Cluster Restore from S3

    • Backup on-premises database using Percona XtraBackup

    • Store on Amazon S3

    • Restore onto a new Aurora cluster running MySQL

Aurora Database Cloning ๐ŸŒ๐Ÿ”ง

Swift Replication

  • Create a new Aurora DB Cluster from an existing one

  • Faster than snapshot & restore

  • Utilizes the copy-on-write protocol

  • Initially shares the same data volume as the original cluster

  • Allocates additional storage and separates data when updates occur

  • Swift, cost-effective, and ideal for staging databases without impacting production

Conclusion ๐ŸŒŒโš–๏ธ

As we conclude this cosmic exploration, RDS and Aurora unveil their sophisticated backup and restoration mechanisms. From automated backups painting a daily canvas of data resilience to Aurora's swift cloning for staging, the celestial databases offer a symphony of options. May your data be secure, restorable, and ready for the next cosmic adventure! ๐Ÿš€๐Ÿ›ฐ๏ธ

Image Credits:

Did you find this article valuable?

Support Prasad Suman Mohan by becoming a sponsor. Any amount is appreciated!