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:

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.