FCAI Wiki

RDS Cost Optimization

Instance right-sizing, storage tuning, and read replica strategy with FCAI

RDS Cost Optimization

Lower database costs while maintaining performance and reliability. FCAI highlights over-provisioning and idle replicas.

Instance classes

  • Prefer Graviton (db.m7g, db.r7g) where engines support it.
  • Right-size using CPU, memory, and IOPS trends; avoid headroom >40% over weeks.
  • Use Multi-AZ only for critical workloads; avoid for dev/test.

Storage and IOPS

  • Choose gp3; set baseline IOPS/throughput to observed needs.
  • Clean old snapshots; set lifecycle for automated backups.
  • Monitor burst balance on gp2 and migrate to gp3.

Replicas and engine features

  • Remove stale read replicas; ensure they offload traffic.
  • Evaluate Aurora Serverless v2 for spiky workloads.

Observability

  • Track CPUUtilization, FreeableMemory, ReadIOPS/WriteIOPS, DiskQueueDepth.
  • FCAI provides right-sizing recommendations and rollback guidance.