Jacob Baloul
Tech Entrepreneur with a taste for art and culture.
AWS RDS
Backup & Failover Solutions Intro
Jacob Baloul
b"h
Topics
- RDS Automated Backups
- Multi-AZ Deployments
- Read Replicas
RDS Backups
Automated Backups
Database Snapshots
vs
- Full Daily Snapshots combined with Transaction Logs, backup to S3.
- Allows for Point in Time restore, up to the second. (date/time picker)
- Retention Period: 1 to 35 days.
- Define Preferred Backup Window.
2 options
- Manual / User Initiated.
- Persist even if RDS instance is deleted.
- Copy Snapshots to different regions.
snapshot
snapshot
snapshot
transaction logs
mm/dd/yyyy hh:mm:ss
RDS Backups
-
Backups are RDBMS agnostic;
- ex: NO .bak, .sql, .csv, .json, .xml, <else db dump format>
-
Exporting to data level backups, requires additional DB engine specific tools;
- ex: mysql_dump, PHPMyAdmin, SQL Server Managenet Studio, etc
- Recover ONLY to point (date/time) in RDS instance retention period history.
continued...
Warning: You may experience DB I/O latency during snapshots. Schedule accordingly
RDS RESTORE & Scale
* Important to note, that one method of scaling / upsizing RDS DB instance size, is to restore a snapshot, and choose a more powerful DB engine tier aka instance class.
* Restoring an RDS backup results in a NEW instance endpoint / DNS connection string.
Multi-AZ Deployments
- Replicate within the same region between Availability Zones.
- Automatic synchronous replication & failover - single connection string.
High Availability, Disaster Recovery, Redundancy
us-east-1a
us-east-1b
Region
(primary)
(secondary)
proddb.asdf123.us-east-1.rds.amazonaws.com
endpoint:
AZ1
AZ2
Read Replicas
Scaling & Performance
- Read Only. Improve Performance. Not for DR.
- Replicate within the same region between Availability Zones.
- Replicate using cross-region replication.
- Automatic asynchronous replication - additional connection string.
- Can be promoted to primary. (breaks replication)
us-east-1a
us-east-1b
Region 1
(primary)
(read replica)
proddb.asdf123.us-east-1.rds.amazonaws.com
main endpoint:
us-west-1a
Region 2
(read replica)
rss2db.xyz789.us-west-1.rds.amazonaws.com
endpoint:
rss1db.xyz789.us-east-1.rds.amazonaws.com
endpoint:
AZ1
AZ2
Multi-AZ + Read Replicas
Combine for HA + High Performance
us-east-1a
us-east-1b
Region 1
(primary)
(secondary)
proddb.asdf123.us-east-1.rds.amazonaws.com
main Read / Write endpoint:
eu-west-1a
(read replica)
rss2db.xyz789.eu-west-1.rds.amazonaws.com
Read Only endpoint:
us-west-1a
(read replica)
rss1db.xyz789.us-west-1.rds.amazonaws.com
Read Only endpoint:
Region 2
Region 3
AZ2
AZ1
thank you
AWS RDS Backup and Failover Solutions Intro
By Jacob Baloul
AWS RDS Backup and Failover Solutions Intro
An overview of AWS RDS Backup & Failover Solutions
