☁️
AWS Solutions Architect Associate SAA-C03 Study Notes/
🔶
Amazon Aurora/
🟢
RDS & Aurora – Restore Options
🟢

RDS & Aurora – Restore Options

  • Restoring from automated backups or manual snapshots always creates a new DB instance or cluster — it does not overwrite the existing one.

Restore MySQL RDS from Amazon S3

  • Take a backup of your on-premises or self-managed MySQL database.
  • Upload the backup file to Amazon S3.
  • Use the RDS restore from S3 feature to create a new RDS MySQL instance populated with that data.
  • Supported formats include MySQL dump files and other compatible backup formats.

Restore MySQL Aurora from Amazon S3

  • Take a backup of your on-premises database using Percona XtraBackup (required for Aurora MySQL).
  • Upload the backup file to Amazon S3.
  • Use Aurora’s restore from S3 capability to create a new Aurora MySQL cluster with the imported data.