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.
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
Verification Success Criteria
- Architecture contains an Amazon RDS Primary database (rds-primary).
- Architecture contains an Amazon RDS Read Replica (rds-replica).
- Replication edge connects rds-primary to rds-replica.
- Read replica is deployed in a private subnet and readReplicaEnabled is configured.
- Negative security boundary passes (no public database exposure).
Diagnostic Starting Point (Spoiler-Free Hint)
Real Solutions Architect Interview Question
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
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-02HealthTech 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-03Retail 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-04E-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-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-06Streaming Media Platform: ASG Max Capacity Bottleneck
Increase ASG maximum capacity to at least 6 to absorb live traffic surges.…