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?
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 .
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 . ...
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.
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.
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
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With