Database · AWS SERVICE CHEATSHEET

RDS Relational Database (RDS)

Stateful database tier managing transactional application data with automated backups, point-in-time recovery, and Multi-AZ synchronous replication.

Open Interactive RDS Sandbox → Simulate in Architecture Studio

AWS Container Placement

SUBNET

Summary

Managed relational database service for PostgreSQL, MySQL, MariaDB, Oracle, and SQL Server.

When to Use (SAA-C03)

Use for structured relational data; enable Multi-AZ for automatic failover (HA) and Read Replicas for read scaling.

Allowed Ingress Connections & Ports

Source ServiceProtocolPortArchitectural Rationale
EC2TCP5432 (Postgres), 3306 (MySQL)Backend application compute instances
ECSTCP5432, 3306Microservices containerized backend tasks
LAMBDATCP5432, 3306Serverless execution workers (via RDS Proxy)

Allowed Egress Targets & Ports

Target ServiceProtocolPortData Flow Rationale
RDSTCP5432, 3306Cross-AZ synchronous replication to Multi-AZ standby replica (KMS encryption and S3 snapshots are out-of-band AWS control plane operations requiring 0 ENI egress rules)

Key Configuration Parameters & AWS Best Practices

ParameterFormat / ExamplePurpose & Rationale
Database Engine (databaseEngine) (Required)postgresThe relational database engine and version to deploy. Why: Determines the runtime binaries, default system catalog, and connection driver protocols.
Allocated Storage (allocatedStorage) (Required)20Disk capacity provisioned for database tables, indexes, and logs. Why: AWS EBS allocates a dedicated block storage volume; minimum 20 GiB is required for most engines.
DB Subnet Group (Required)At least 2 Subnets across 2 AZsDefines the VPC subnets where database network interfaces can reside. Why: AWS requires at least 2 Availability Zones defined in the DB Subnet Group to allow Multi-AZ failover.
Master Credentials (Required)Username & Secure PasswordRoot database administrator credentials. Why: Required for initial schema migration and user provisioning.
Multi-AZ Deployment (multiAz)trueSynchronously provisions a hot standby in an alternate Availability Zone. Why: Essential for production high availability and automated failover without data loss.
Storage Encryption (storageEncrypted)trueEnables AES-256 encryption at rest for database tables, logs, and automated snapshots. Why: Compliance requirement (SOC 2 / HIPAA); must be enabled at creation time.
Deletion ProtectiontruePrevents accidental database deletion via AWS CLI or Console. Why: Guardrail against accidental data loss in production environments.

Practice Labs Using RDS Relational Database

CLF-03

Public Database Exposure Vulnerability

Move or configure RDS to be in a private subnet, disable public accessibility, and restrict ingress exclusivel…

SAA-05

SaaS Multi-Tenant DB: Least-Privilege Security Group Chaining

Replace CIDR 10.0.0.0/16 with the Application Security Group ID (sg-app) as the authorized source on port 5432…

SAA-08

Multi-Tier Highly Available Web Architecture: Dual-AZ ALB, ASG Fleet & Multi-AZ RDS

Re-architect for multi-AZ high availability: map the public ALB across dual AZs (us-east-1a and us-east-1b), d…

SAA-11

High-Read Analytics: RDS Primary Database CPU Starvation

Deploy an Amazon RDS Read Replica (rds-replica), connect it to the primary database with a replication edge, c…

SAA-16

Enterprise Multi-VPC Peering: Non-Transitive Routing & Route 53 Private Hosted Zone Fallacy

Establish a direct VPC Peering connection between VPC A and VPC C, update route tables with non-overlapping ro…

SAA-20

RDS Connection Storm Exhaustion (RDS Proxy)

Insert an Amazon RDS Proxy between the Lambda functions and the RDS database to multiplex and pool database co…

Frequently Asked Questions

Where does RDS Relational Database live inside an AWS VPC architecture?

Valid container placement: SUBNET. Stateful database tier managing transactional application data with automated backups, point-in-time recovery, and Multi-AZ synchronous replication.

When should I use RDS Relational Database on the AWS SAA-C03 exam?

Use for structured relational data; enable Multi-AZ for automatic failover (HA) and Read Replicas for read scaling.

Can I simulate RDS Relational Database packet routing without an AWS account?

Yes. CloudTracer simulates RDS Relational Database along with 53 AWS services directly in your browser and exports production Terraform HCL.

More Database Cheatsheets

DynamoDB NoSQL → ElastiCache Redis →