1 Amazon RDS — Managed Relational Databases
Amazon RDS (Relational Database Service) runs managed relational engines so you stop babysitting servers. It supports MySQL, PostgreSQL, MariaDB, Oracle, SQL Server and the AWS-built Aurora.
RDS handles the undifferentiated heavy lifting: provisioning, OS and engine patching, automated backups, and point-in-time recovery. You still own the schema, queries, and indexes.
- Multi-AZ — a synchronous standby replica in another Availability Zone for automatic failover and high availability.
- Read replicas — asynchronous copies that scale read traffic; they do not provide automatic failover by default.
- Storage autoscaling grows the volume as data grows.
A key distinction: Multi-AZ is about availability (failover), while read replicas are about read scalability (performance).
aws rds create-db-instance \
--db-instance-identifier app-prod \
--db-instance-class db.t3.medium \
--engine postgres \
--master-username admin \
--master-user-password 'ChangeMe123!' \
--allocated-storage 20 \
--multi-az \
--backup-retention-period 7