AWS RDS Cheatsheet
Top commands.
Overview
The RDS CLI cheatsheet captures the patterns operators actually use during RDS investigation. Fluency at RDS commands shortens recovery time and informs scaling decisions before they hit production.
- Top commands.
describe-db-instances,create-db-snapshot,modify-db-instance,restore-db-instance-from-snapshot; the four that cover most paths. - Snapshots. Manual snapshots before risky changes; automated snapshots for daily backup; the foundation of recovery.
- Read replicas plus Multi-AZ. Replicas offload read traffic; Multi-AZ provides synchronous failover; the two solve different problems.
- Performance Insights. Top SQL by load; the per-query view that reveals slow queries before users complain.
The approach
The practical approach: Multi-AZ by default, snapshots automated, Performance Insights always on. The team's discipline produces predictable RDS, not just running RDS.
- describe-db-instances. Status of all instances; first call when investigating cluster-wide health.
- create-db-snapshot --db-snapshot-identifier pre-migration. Manual snapshot before any risky modification; the rollback that always works.
- modify-db-instance --apply-immediately. Apply a config change; the flag that distinguishes "now" from "next maintenance window."
- describe-events. Recent RDS events; the audit log of what AWS did to the instance and why.
- Document the cluster. Per-cluster configuration committed to the repo; supports operational reviews and onboarding.
Why this compounds
RDS fluency compounds across operations. Each instance operated teaches a pattern; database operational expertise accrues; mean-time-to-recovery falls over the team's tenure.
- Better recovery. Snapshots plus restore-from-snapshot make rollback boring; risky changes become reversible.
- Better resilience. Multi-AZ tolerates AZ failures; RPO/RTO targets become measurable instead of aspirational.
- Better investigation. Performance Insights reveals slow queries inline; query tuning becomes routine, not heroic.
- Institutional knowledge. Each command run teaches RDS internals; the team's database engineering muscle grows.
RDS fluency is an operational discipline that pays off across years. Nova AI Ops integrates with RDS telemetry, surfaces patterns, and supports the team's database discipline.