AWS RDS

Amazon Relational Database Service (RDS) takes care of provisioning, patching, backups, and failover for relational databases. Supports MySQL, PostgreSQL, MariaDB, Oracle, SQL Server, and Amazon Aurora.

Core Concepts

• DB Instance — an isolated database environment in the cloud
• Multi-AZ — synchronous standby replica in another AZ for high availability
• Read Replica — asynchronous copy for read scaling
• Parameter Group — engine configuration settings
• Subnet Group — defines which subnets RDS can use
• Aurora — AWS-native engine, MySQL/PostgreSQL compatible, 5x faster

Provisioning a Database