Course contentsShow
← Cloud and Infrastructure
Lesson 400 of 2,9898. Managed DatabasesFree lesson

Storage Types for RDS

Comparing General Purpose SSD, Provisioned IOPS SSD, and Magnetic storage options for database workloads.

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.