Please enable JavaScript.
Coggle requires JavaScript to display documents.
9.94: RDS & Aurora: Backup and monitor - Coggle Diagram
9.94:
RDS & Aurora: Backup and monitor
RDS Automated backup
Daily full backup DB
Transaction logs are backup every 5 mins -> restore any time
1 to 35 day retention, set 0 to disable auto backup
RDS Manual DB snapshot
retention as long as you want
trick: in a stop RDS db, you will still pay for storage. If you plan on stopping it for a long time ->snapshot & restore instead
Aurora automated backup
1 to 35 day (can't disable)
recovery in that timeframe
Manual DB snapshot
Retention as long as you want
RDS&Aurora restore opts
Restore RDS/Aurora backup or snapshot creates new DB
Restore MySQL
RDS
DB from S3
Create a backup of your on-premises DB
Store it on AMZ S3
Restore backup file on new RDS instance running MySQL
Restore MySQL
Aurora
cluster from S3
Create backup of your on-premises DB using Percona XtraBackup
Store backup file on AMZ S3
Restore backup file on new Aurora cluster running MySQL
Aurora DB Cloning
Create new Aurora DB Cluster from an existing one
Faster than snapshot&restore
Use copy-on-write protocol
new DB cluster uses same data volume as the original DB cluster
when updates are made to the new DB cluster data, additional storage is allocated and data is copied to be separated
Very fast & cost effective
Useful to create a staging DB from production DB without impacting the production DB