Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Unable to change RDS instance class

I'm trying to upgrade the instance class of our database to increase capacity, but whenever I try I get an error

An error occurred (InvalidParameterCombination) when calling the ModifyDBInstance operation: Invalid max storage size for engine name mysql and storage type gp2: 1001

I've tried using the RDS console, and the CLI but get the same error.

I have absolutely no clue what this error means though. For storage, we have the following configuration:

storage config

When I first setup the database, the storage was much smaller. We increased the storage to 1000GB to get more IOPs but everything was valid then. How can it be invalid now?

like image 729
PaReeOhNos Avatar asked Nov 06 '22 03:11

PaReeOhNos


People also ask

Can you change RDS instance security group?

Modify the default security group, or. Create a new security group (as your have done), then go to the RDS console, click on your database, then choose Instance actions -> Modify and modify the security groups that are associated with the DB instance (add the new security group, remove the default security group)

How do I change the RDS instance of AZ?

If your RDS is single instance and in the different AZ to your EC2 instance, you will need to take a snapshot and create the instance again in order to change the availability zone.

Which option of a group Cannot be modified?

You can't modify or delete this default option group, but any new option group that you create derives its settings from the default option group.


1 Answers

You have allocated storage of 1000, and with autoscaling enabled, you need to have at least 10% larger storage for the Maximum storage threshold but you only have 1001.

Generelly speaking, when you increase the allocated storage, it must be by at least 10 percent so it does not make sence to have autoscaling enabled in your case, if you still want autoscaling then change the max storage to be at least 1100.

like image 125
adnat Avatar answered Nov 15 '22 06:11

adnat