SAA-C03 · Domain 2: Design High-Performing Architectures

High-Read Analytics: RDS Primary Database CPU Starvation

Client Profile: An e-commerce platform experiences severe transaction slowdowns during daily executive sales reporting cycles. Investigation shows the Amazon RDS PostgreSQL primary instance spikes to 99% CPU and throttles application checkout writes. Although Multi-AZ replication is enabled, the synchronous standby instance does not accept connections and cannot offload read queries. The lead architect tasked you with decoupling read reporting queries from write traffic.

Launch Interactive Lab in Browser → Browse All 56 AWS Labs

Lab Objective

Deploy an Amazon RDS Read Replica (rds-replica), connect it to the primary database with a replication edge, configure readReplicaEnabled: true, and ensure it resides in a private subnet.

Exam Track & Type

Solutions Architect Associate (SAA) (SAA-C03) · Live Outage Troubleshooting Drill

FinOps & Cost Impact

Deploying an RDS Read Replica allows right-sizing the primary write instance to a smaller tier while cost-effectively scaling read throughput horizontally across up to 15 read replicas.

AWS Services Involved

VPC Cheatsheet → SUBNET Cheatsheet → EC2 Cheatsheet → RDS Cheatsheet → RTB Cheatsheet →

Verification Success Criteria

Diagnostic Starting Point (Spoiler-Free Hint)

When analytical and reporting traffic causes CPU exhaustion on a relational database primary instance, why does enabling Multi-AZ standby failover NOT solve read performance bottlenecks, and what dedicated read-scaling mechanism does AWS RDS provide?

Real Solutions Architect Interview Question

Compare the operational architecture, replication mechanisms, and endpoint addressing of RDS Multi-AZ deployments versus RDS Read Replicas.

Frequently Asked Questions

How do I troubleshoot "High-Read Analytics: RDS Primary Database CPU Starvation" in AWS?

When analytical and reporting traffic causes CPU exhaustion on a relational database primary instance, why does enabling Multi-AZ standby failover NOT solve read performance bottlenecks, and what dedicated read-scaling mechanism does AWS RDS provide?

Which AWS certification exam covers this architecture scenario?

This interactive lab maps directly to SAA-C03 (Solutions Architect Associate (SAA)) under Domain 2: Design High-Performing Architectures.

Do I need an AWS account or credit card to practice this lab?

No. CloudTracer runs a stateful VPC packet engine locally in your browser so you can debug Route Tables, Security Groups, NACLs, and target groups with $0 AWS cloud spend.

Related SAA-C03 Troubleshooting Labs

SAA-01

FinTech Payment Ledger: $6,750 NAT Gateway S3 Cost Surge

Add an S3 prefix-list destination route in the private route table targeting the S3 Gateway Endpoint.…

SAA-02

HealthTech EMR Backend: Asymmetric Outbound NAT Routing

Re-point the private route table default route pointing to NAT (0.0.0.0/0 -> nat-xxx) in the public subnet.…

SAA-03

Retail Banking PCI Audit: Stateless NACL Ephemeral Drop

Add an outbound NACL rule permitting return ephemeral traffic (TCP 1024-65535) to 0.0.0.0/0.…

SAA-04

E-Commerce Flash Sale: ALB 502 Bad Gateway Port Mismatch

Reconcile Target Group port to match the backend EC2 application port (80) to restore healthy status.…

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-06

Streaming Media Platform: ASG Max Capacity Bottleneck

Increase ASG maximum capacity to at least 6 to absorb live traffic surges.…