Storage Types for RDS
What you'll learn: You'll understand the three main storage options for RDS databases and when to use each one.
When you launch a managed database in the cloud, you need to choose what kind of storage sits underneath it. Think of storage types like different types of engines in cars — some are built for everyday commuting, others for high-performance racing, and some are older but still functional for light use.
General Purpose SSD (gp3/gp2)
This is the balanced, all-around option for most workloads. General Purpose SSD provides consistent baseline performance that scales with storage size. It's like a reliable sedan — good enough for most daily database operations without breaking the bank. Use this when your database has moderate, predictable traffic patterns.
Key characteristics:
- Cost-effective baseline performance
- Burst capability for occasional spikes
- Ideal for dev/test and small-to-medium production databases
Provisioned IOPS SSD (io1/io2)
This is the high-performance option for demanding workloads. You explicitly provision a specific number of input/output operations per second (IOPS), guaranteeing consistent, fast performance. Think of it as a sports car — you pay more, but you get predictable speed when you need it.
Key characteristics:
- Guaranteed IOPS performance
- Low-latency consistency
- Best for transaction-heavy, mission-critical databases
Magnetic Storage (Legacy)
This is the older, slower option that's being phased out. It uses traditional spinning disks rather than solid-state technology. Like an old truck — cheap but slow, suitable only for infrequent access or legacy applications you're planning to migrate away from.
Key characteristics:
- Lowest cost
- Unpredictable performance
- Not recommended for new workloads
Key Takeaway: Choose General Purpose SSD for most databases, Provisioned IOPS SSD when you need guaranteed performance for critical workloads, and avoid Magnetic storage for new projects.