Backup and Restore

Amazon Aurora Backup and Restore

Automated Backups:

Point-in-Time Recovery (PITR): Enables restoration of your database to any second within your retention period, up to the last five minutes.

Retention Period: Configurable up to 35 days. Automated backups are stored in Amazon S3 with 99.999999999% durability.

Backup Characteristics:

Automatic, incremental, and continuous.

Have no impact on database performance.

Backup Process:

Daily Snapshots: A full daily snapshot is taken during the preferred backup window.

Transaction Logs: Captured regularly as updates are made to the DB instance.

Storage in S3: Data is stored in S3 and is equal to the size of the DB instance.

Automatic Backups: Enabled by default and store data across multiple AZs for durability.

Restoration Process:

Point-in-Time Recovery: Only automated backups allow for PITR with granularity of 5 minutes.

Daily Snapshots: A daily full storage volume snapshot is taken, and transaction logs are captured regularly.

New Endpoint: When you restore a DB instance, the new instance will have a new endpoint.

Backup Window: I/O may be suspended during the backup window.

Storage Type Change: Possible to change the storage type when restoring a snapshot.

Backup Retention and Policies:

Retention Period Defaults:

7 days by default (console configuration) for all DB engines except Aurora.

1 day if configured via API or CLI for Aurora.

Changing Retention: An outage occurs if changing the retention period from zero to a non-zero value or vice versa.

User-Initiated Backups:

Manual Snapshots: Can be taken at any time and copied.

Entire DB Instance Backup: Both automated and manual backups involve a storage volume snapshot of the entire DB instance.

Want to print your doc?
This is not the way.

Try clicking the ⋯ next to your doc name or using a keyboard shortcut (

CtrlP

) instead.