Please enable JavaScript.
Coggle requires JavaScript to display documents.
RDS Relation Database Service - Coggle Diagram
RDS
Relation Database Service
It's a relational database SQL
You can create a bunch of databases as Postgres, MySql, MariaDb, Oracle, Microsoft SQL Server, Aurora
RDS is a service managed by AWS
You can have
backup and restore
Automated provisioning OS patching (AWS that does it)
Monitor dashboard
Read replicas for performance
Multi AZ for DR (Disaster Recover)
Maintance Window
Scaling Capability (vertical and horizontal)
Storage can be gp2 or Iol
You can't connect using SSH
Auto scaling
it's automatically
AWS calculates if you are running out of storage and then they scale it
You need to set the MAX number of the storage that you want
AWS change the storage if
free storage is less than 10%
less storage last 5 min
6 hours have passed since last modified
Supports all databases
Read Replicas
Improve your read
Up to 15 read replicas
It can be AZ, Cross AZ or Cross Region
Replication is async, so the read is consistent
It's possible to get old data because of the sync if your app is on the read instance
Good for production structure
Network Cost
You need to pay the network if the data goes between Regions
You don't need to pay replicas in the same region
Muiti-AZ
Sync replication
App talks to DNS
There is a failover (with master and slave/standby)
Not used for scaling
The slave is going to stay in standby
You can also set replicas here
Single RDS to Multi-AZ
Zero downtime
Just need to click and modify on the console
The change is done using snapshots.
Vertical Scale (getting more CPU / RAM / IO
Horizontal Scaling (add more EC2 and replicas)