Determining DB instance class support in Amazon Web Services Regions - Amazon Relational Database Service
Using the Amazon RDS pricing page to determine DB instance class support in Amazon Web Services RegionsUsing the Amazon CLI to determine DB instance class support in Amazon Web Services Regions
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

Determining DB instance class support in Amazon Web Services Regions

To determine the DB instance classes supported by each DB engine in a specific Amazon Web Services Region, you can take one of several approaches. You can use the Amazon Web Services Management Console, the Amazon RDS Pricing page, or the describe-orderable-db-instance-options command for the Amazon Command Line Interface (Amazon CLI).

Note

When you perform operations with the Amazon Web Services Management Console, it automatically shows the supported DB instance classes for a specific DB engine, DB engine version, and Amazon Web Services Region. Examples of the operations that you can perform include creating and modifying a DB instance.

Using the Amazon RDS pricing page to determine DB instance class support in Amazon Web Services Regions

You can use the Amazon RDS Pricing page to determine the DB instance classes supported by each DB engine in a specific Amazon Web Services Region.

To use the pricing page to determine the DB instance classes supported by each engine in a Region

  1. Go to Amazon RDS Pricing.

  2. In the Amazon Pricing Calculator for Amazon RDS section, choose Create your custom estimate now.

  3. In Choose a Region, choose an Amazon Web Services Region.

  4. In Find a Service, enter Amazon RDS.

  5. Choose Configure for your configuration option and DB engine.

  6. Use the section for compatible instances to view the supported DB instance classes.

  7. (Optional) Choose other options in the calculator, and then choose Save and view summary or Save and add service.

Using the Amazon CLI to determine DB instance class support in Amazon Web Services Regions

You can use the Amazon CLI to determine which DB instance classes are supported for specific DB engines and DB engine versions in an Amazon Web Services Region. The following table shows the valid DB engine values.

Engine names Engine values in CLI commands More information about versions

Db2

db2-ae

db2-se

Db2 on Amazon RDS versions

MariaDB

mariadb

MariaDB on Amazon RDS versions

Microsoft SQL Server

sqlserver-ee

sqlserver-se

sqlserver-ex

sqlserver-web

Microsoft SQL Server versions on Amazon RDS

MySQL

mysql

MySQL on Amazon RDS versions

Oracle

oracle-ee

oracle-se2

Amazon RDS for Oracle Release Notes

PostgreSQL

postgres

Available PostgreSQL database versions

For information about Amazon Web Services Region names, see Amazon Regions.

The following examples demonstrate how to determine DB instance class support in an Amazon Web Services Region using the describe-orderable-db-instance-options Amazon CLI command.

Note

To limit the output, these examples show results only for the General Purpose SSD (gp2) storage type. If necessary, you can change the storage type to General Purpose SSD (gp3), Provisioned IOPS (io1), or magnetic (standard) in the commands.

Listing the DB instance classes that are supported by a specific DB engine version in an Amazon Web Services Region

To list the DB instance classes that are supported by a specific DB engine version in an Amazon Web Services Region, run the following command.

For Linux, macOS, or Unix:

aws rds describe-orderable-db-instance-options --engine engine --engine-version version \
    --query "*[].{DBInstanceClass:DBInstanceClass,StorageType:StorageType}|[?StorageType=='gp2']|[].{DBInstanceClass:DBInstanceClass}" \
    --output text \
    --region region

For Windows:

aws rds describe-orderable-db-instance-options --engine engine --engine-version version ^
    --query "*[].{DBInstanceClass:DBInstanceClass,StorageType:StorageType}|[?StorageType=='gp2']|[].{DBInstanceClass:DBInstanceClass}" ^
    --output text ^
    --region region

For example, the following command lists the supported DB instance classes for version 13.6 of the RDS for PostgreSQL DB engine in US East (N. Virginia).

For Linux, macOS, or Unix:

aws rds describe-orderable-db-instance-options --engine postgres --engine-version 15.4 \
    --query "*[].{DBInstanceClass:DBInstanceClass,StorageType:StorageType}|[?StorageType=='gp2']|[].{DBInstanceClass:DBInstanceClass}" \
    --output text \
    --region us-east-1

For Windows:

aws rds describe-orderable-db-instance-options --engine postgres --engine-version 15.4 ^
    --query "*[].{DBInstanceClass:DBInstanceClass,StorageType:StorageType}|[?StorageType=='gp2']|[].{DBInstanceClass:DBInstanceClass}" ^
    --output text ^
    --region us-east-1

Listing the DB engine versions that support a specific DB instance class in an Amazon Web Services Region

To list the DB engine versions that support a specific DB instance class in an Amazon Web Services Region, run the following command.

For Linux, macOS, or Unix:

aws rds describe-orderable-db-instance-options --engine engine --db-instance-class DB_instance_class \
    --query "*[].{EngineVersion:EngineVersion,StorageType:StorageType}|[?StorageType=='gp2']|[].{EngineVersion:EngineVersion}" \
    --output text \
    --region region

For Windows:

aws rds describe-orderable-db-instance-options --engine engine --db-instance-class DB_instance_class ^
    --query "*[].{EngineVersion:EngineVersion,StorageType:StorageType}|[?StorageType=='gp2']|[].{EngineVersion:EngineVersion}" ^
    --output text ^
    --region region

For example, the following command lists the DB engine versions of the RDS for PostgreSQL DB engine that support the db.r5.large DB instance class in US East (N. Virginia).

For Linux, macOS, or Unix:

aws rds describe-orderable-db-instance-options --engine postgres --db-instance-class db.m7g.large \
    --query "*[].{EngineVersion:EngineVersion,StorageType:StorageType}|[?StorageType=='gp2']|[].{EngineVersion:EngineVersion}" \
    --output text \
    --region us-east-1

For Windows:

aws rds describe-orderable-db-instance-options --engine postgres --db-instance-class db.m7g.large ^
    --query "*[].{EngineVersion:EngineVersion,StorageType:StorageType}|[?StorageType=='gp2']|[].{EngineVersion:EngineVersion}" ^
    --output text ^
    --region us-east-1