RDS Relational Database (RDS)
Stateful database tier managing transactional application data with automated backups, point-in-time recovery, and Multi-AZ synchronous replication.
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 Service | Protocol | Port | Architectural Rationale |
|---|---|---|---|
| EC2 | TCP | 5432 (Postgres), 3306 (MySQL) | Backend application compute instances |
| ECS | TCP | 5432, 3306 | Microservices containerized backend tasks |
| LAMBDA | TCP | 5432, 3306 | Serverless execution workers (via RDS Proxy) |
Allowed Egress Targets & Ports
| Target Service | Protocol | Port | Data Flow Rationale |
|---|---|---|---|
| RDS | TCP | 5432, 3306 | Cross-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
| Parameter | Format / Example | Purpose & Rationale |
|---|---|---|
| Database Engine (databaseEngine) (Required) | postgres | The relational database engine and version to deploy. Why: Determines the runtime binaries, default system catalog, and connection driver protocols. |
| Allocated Storage (allocatedStorage) (Required) | 20 | Disk 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 AZs | Defines 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 Password | Root database administrator credentials. Why: Required for initial schema migration and user provisioning. |
| Multi-AZ Deployment (multiAz) | true | Synchronously provisions a hot standby in an alternate Availability Zone. Why: Essential for production high availability and automated failover without data loss. |
| Storage Encryption (storageEncrypted) | true | Enables 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 Protection | true | Prevents accidental database deletion via AWS CLI or Console. Why: Guardrail against accidental data loss in production environments. |
Practice Labs Using RDS Relational Database
Public Database Exposure Vulnerability
Move or configure RDS to be in a private subnet, disable public accessibility, and restrict ingress exclusivel…
SAA-05SaaS 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-08Multi-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-11High-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-16Enterprise 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-20RDS 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.