Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

RDS does not support creating a DB instance with the following combination

I'm trying to figure out how to create a simple DB instance. I have so far only a DBSubnetGroup and DBInstance. At this point, I've figured out a couple things based on the errors I get when I try to create a stack with my template (created in Designer).

I've now hit an error that, according to the instance class documentation it appears like it should be supported, but I guess not. Based on my snippet below, what should I be using instead?

myDB:
  Type: 'AWS::RDS::DBInstance'
  Properties:
    DBInstanceClass: db.m1.small
    DBName: myDB
    DBSubnetGroupName: !Ref myDBSubnetGroup
    Engine: mysql
    EngineVersion: 5.6.41
    AllocatedStorage: '100'
    MasterUsername: admin
    MasterUserPassword: AmazingPassword

The actual error is

RDS does not support creating a DB instance with the following combination: DBInstanceClass=db.m1.small, Engine=mysql, EngineVersion=5.6.41, LicenseModel=general-public-license. For supported combinations of instance class and database engine version, see teh documentation. (Service: AmazonRDS; Status Code: 400; Error Code: InvalidParameterCombination; Request ID: 04a8be38-9368-40e4-b677-1cdc442b3cae

Again, I've looked at the documentation and it says that db.m1.small supports MySQL v5.6. Perhaps that is out of date? I guess I can try 5.7.

Any thoughts?

like image 635
theillien Avatar asked Apr 09 '19 17:04

theillien


People also ask

What is the RDS DB instance class?

The DB instance class determines the computation and memory capacity of an Amazon RDS DB instance. The DB instance class you need depends on your processing power and memory requirements. For more information about instance class pricing, see Amazon RDS Pricing .

How to determine the AWS RDS instance class support in regions?

Using the Amazon RDS pricing page to determine DB instance class support in AWS Regions 1 Go to Amazon RDS Pricing . 2 Choose a DB engine. 3 On the pricing page for the DB engine, choose On-Demand DB Instances or Reserved DB Instances . 4 To see the DB instance classes available in an AWS Region, choose the AWS Region in Region . ...

How can I improve I/O performance of my RDS Database?

In some cases, allocating a higher amount of storage for your DB instance than the size of your database can improve I/O performance. For more information, see Amazon RDS DB instance storage. The architecture of the database: CDB (single-tenant) or non-CDB.

What is the basic building block of Amazon RDS?

The basic building block of Amazon RDS is the DB instance, where you create your databases. You choose the engine-specific characteristics of the DB instance when you create it. You also choose the storage capacity, CPU, memory, and so on, of the AWS instance on which the database server runs.


1 Answers

Taken from the aws docs:

You can only create MySQL version 5.7 and 8.0 DB instances with latest-generation and current-generation DB instance classes, in addition to the db.m3 previous-generation DB instance class.

Read more: https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_UpgradeDBInstance.MySQL.html

like image 141
alex067 Avatar answered Sep 28 '22 23:09

alex067