Please enable JavaScript.
Coggle requires JavaScript to display documents.
9.87: RDS - Relation Database Service - Coggle Diagram
9.87
: RDS - Relation Database Service
Types
Postgres
MySQL
MariaDB
Oracle
Microsoft SQL Server
Aurora
Features
Automated provisioning, OS patching
Continuous backup, restore to specific timestamp
Monitoring dashboard
Read replicas for improved read performance
Multi AZ setup for DR (Disaster Recovery)
Maintenance windows for upgrades
Scaling capability (vertical, horizontal)
Storage backed by EBS (gp2 or io1)
Can't SSH into your instance
Storage Auto Scaling
When RDS defect running out of free DB storage->Auto Scale
Avoid manually scaling your DB storage
Have to set
Maximum Storage Threshold
Auto modify storage if:
Free storage < 10% of allocated storage
Low storage lasts at least 5 minutes
6 hours have passed since last modify
Useful for app with
unpredictable workloads
unpredictable workload
Support all RDS DB engine (MariaDB, MySQL, PostgreSQL, SQL Server, Oracle
1. RDS - Read Replicas
Up to 15 Read Replicas
Within AZ, Cross AZ, Cross Region
ASYNC, so read are eventually consistent
Replicas can be promoted to their own DB
Are used for SELECT only kind of statement (Not insert, update, delete)
Network Cost
For RDS Read Replicas within the same region, you don't have to pay the network cost
2. RDS multi AZ (Disaster Recovery)
SYNC replication
1 DNS name - automatic app failover to standby
Increase availability
Failover in case loss of AZ, loss of network, instance or storage failure
No manual intervention in app
Not used for scaling
From single AZ to multi AZ
Zero downtime operation (no need to stop DB)
Just click on "modify" for the DB
RDS Custom
Manage Oracle and MSSQL with OS and DB customization
Access underlying DB and OS so you can
Configure settings
Install patches
Enable native function
Access underlying EC2 instance using SSH and SSM Session Manager
Deactivate automation mode to perform your customization, should take snapshot before