The Ultimate RDS Instance Types Guide: What You Need To Know

Amazon’s Relational Database Service (Amazon RDS) offers a variety of database instances, which can be confusing at first. In this guide, we'll clarify what each RDS instance class, family, type, and size means in under 15 minutes.

Let's start at the beginning.

Table of Contents

• What Does An Amazon RDS Instance Do?
• RDS Instance Classes Explained
• What Are The Different RDS Instance Types?
• What Are The Different Amazon RDS Instance Sizes?
• How To Choose The Right RDS Instances For Your Workload
• Amazon RDS Instances FAQs

What Does An Amazon RDS Instance Do?

Amazon RDS is a Database-as-a-Service (DaaS) platform. RDS instances are virtual servers that provide the computing power to set up, run, and maintain databases in the AWS public cloud.

AWS refers to the specific instances that power Amazon RDS as database instances (DB instances).

DB instances provide an isolated environment in which to create and host one or more relational databases. Yet, you can access those databases just like a regular stand-alone database.

RDS DB instances (virtual hardware) run a kind of operating system (software) known as a relational database engine (DB engine). Amazon RDS currently supports six types of DB engines:

• MariaDB
• MySQL
• Microsoft MySQL Server
• PostgreSQL
• Oracle

There are different versions of these engines, each with different features. The one thing they all have in common is that they run on RDS database instances.

How do those database instances work?

RDS Instance Classes Explained

There are three types of Amazon RDS instance classes, each optimized for a specific use case:

Each RDS instance class includes both an instance type and size. An instance class can have several instance types. Then, each RDS instance type offers several instance sizes to choose from.

This flexibility gives you the freedom to choose the perfect database instance for your needs. It can also help achieve a healthy price-performance ratio. Yet, managing all those options often adds to the complexity of managing Amazon RDS.

What Are The Different RDS Instance Types?

There are two types of relational database instances available on Amazon RDS: General-purpose and Memory-optimized. Here's a table detailing the connection between RDS instance classes, families, and types.

What Are The Different Amazon RDS Instance Sizes?

The RDS service provides some control over the type of instances you can choose for your workload. Bear in mind that RDS is a managed service, so you may not have as much choice as you would when running MySQL with Amazon EC2 instances.

Another thing. Each database instance size supports a unique combination of CPU, memory, networking, and storage resources.

Here’s a handy overview of the types of Amazon RDS instance sizes to expect:

Other variables to consider when configuring RDS instances include whether they support enhanced networking, if they are EBS-optimized, and which database storage option to pair with them.

Now, it's not uncommon to feel overwhelmed by the number of RDS instance classes, families, and types available. Right-sizing database instances can be challenging for many teams. So, how do you do it?

How To Choose The Right Amazon RDS Instances For Your Workload

You can do it yourself, manually. It may require trial and error to find just the right RDS instance type for your specific workload. This process can also take a couple of weeks or months, and continuously as your workload requirements evolve. Take care not to blow a hole in your budget.

There’s a second option. Consider automating the process with a tool if you're having trouble choosing the right RDS instance.

Using CloudZero Advisor, you can choose the most suitable Amazon RDS instances based on a combination of factors, like your DB engine, Amazon region, pricing, as well as your desired network, disk, CPU, and memory performance.

Check this out:

Moreover, CloudZero empowers you to collect, analyze, and understand your Amazon RDS costs in relation to your overall AWS spend. You can also zoom in to see your costs in a way that most cloud cost optimization tools never show you, like this:

With CloudZero, you can easily identify who, when, and where your cloud budget is going by viewing your:

• Cost per customer
• Cost per feature
• Cost per team
• Cost per project
• Cost per deployment
• Cost per environment
• Cost of goods sold (COGS), and more

Drift, for example, used CloudZero to figure out exactly where they could reduce their AWS costs and saved $2.4 million. CloudZero can also deliver for you.

to get started!

Amazon RDS Instances FAQs

The following are some answers to some of the most frequently asked questions about Amazon RDS.

How much do Amazon RDS instances cost?

RDS costs depend on several factors, which we’ve detailed in our Amazon RDS pricing guide here.

What is the difference between RDS and EC2 instances?

The Amazon RDS service provides database instances, while the Amazon EC2 service provides compute instances.

How do I change my RDS instance type?

Use the AWS Command-Line Interface (AWS CLI), the AWS Management Console, or the Amazon RDS API to create or change your database instances.

Does changing my RDS instance type cause downtime?

RDS reboots your databases to apply changes, which can sometimes cause downtime. Be sure to plan your workload in advance to avoid disruptions to your service.

How long does it take to change an Amazon RDS instance?

You can either apply instance changes immediately or schedule them to apply in the next maintenance window.

Can I downgrade an RDS instance size?

You can change the size of your RDS instance depending on your workload.

Why are Amazon RDS instances more expensive than Amazon EC2 instances?

Amazon RDS is a fully managed AWS service that eliminates the need to set up, run, and maintain your own database infrastructure on AWS. This time-saving feature is reflected in RDS' higher pricing.