AWS Relational Database Service
cloud
AWS
Jan 15, 2024
5 minutes
Go Back
Print
Blog
Related Posts
Home
What is a Amazon Relational Database Service (AWS RDS)?
It is a
managed DB service
for DB that use
SQL to query data (OLTP)
It allows you to create following dbs in the cloud:
RDS
Postgres
MariaDB
Microsoft SQL
MySQL
Oracle
Aurora (AWS PROPRIATERY OFFERING)
What is the advantage of using Amazon RDS over EC2 Database Instance?
Automated Provisioning and OS Patching
Continious Backup & Restore to specific timestamp (point-in-time-restore)
Monitoring Dashboard
Read replicas for improved read peformance
Multi-AZ setup for Disaster Recovery
Scaling Capablity
Storage backed by EBS
Maintainance window for updates (updates are handelled by AWS!!)
RDS Deployment Options - Read Replicas (Read Scalablity) & Multi-AZ (High-Availablity)
Read Replicas:
Scale the read workload of your DB.
Can create upto 15 Read Replicas
Failover Multi-AZ:
Failover in case of AZ outage (High-Availablity)
Data is only read/written into the main Database (DO NOT CONFUSE MULTI-AZ WITH WRITE-REPLICAS!!)
Can only have 1 other AZ as failover.
Multi-Region Read Replicas:
Disaster Recovery in case of Region Issues.
Local Peformance for global reads.
Replication Costs.