94. RDS & Aurora Overview, 96. RDS Deployment Options

RDS

Relational Database Service

Relational Database Service

managed DB service for DB use SQL as a query language

It allows you to create databases in the cloud that are managed by AWS

• Postgres

• MySQL

• MariaDB

• Oracle

• Microsoft SQL Server

• IBM DB2

• Aurora (AWS Proprietary database)

Which of the following are not a benefit of RDS:

• Automated provisioning, OS patching

• Continuous backups and restore to specific timestamp (Point in Time Restore)!

• Monitoring dashboards

• Read replicas for improved read performance

• Multi AZ setup for DR (Disaster Recovery)

• Maintenance windows for upgrades

• Scaling capability (vertical and horizontal) • Storage backed by EBS

• You can SSH into RDS

You can SSH into RDS

Amazon Aurora

proprietary relational database technology from AWS (not open sourced)

Aurora supports

PostgreSQL and MySQL

Why is Aurora “AWS cloud optimized”

claims 5x performance improvement over MySQL on RDS, over 3x the performance of Postgres on RDS

Aurora storage automatically

grows in increments of 10GB, up to 128 TB

Aurora costs what than RDS

More

Aurora is what efficient than RDS

More

Aurora is in the free tier

False

Amazon Aurora Serverless

Automated database instantiation and auto-scaling based on actual usage

Read Replicas deployment

• Scale the read workload of your DB

• Can create up to 15 Read Replicas

• Data is only written to the main DB but can be read from any of the replicas

Multi-AZ deployment

• Failover in case of AZ outage (high availability) (Only use when main fails)

• Data is only read/written to the main database

• Can only have 1 other AZ as failover

Multi-Region (Read Replicas)

• Apps in different regions write to the main DB in another region

• Disaster recovery in case of region issue

• Local performance for global reads

• Replication cost