Amazon AWS Mysql Database Full

The Survival Guides's Blog

Arrrgghhhh our web site decided to fill the 5GB database it uses !!!!!!!

When you use the AWS console you get the following error

The specified database instance is currently in the storage-full state. The only modification permitted on a database instance in this state is an increase …”

You have to use the RDS command line tools, you can see how to install them in my riveting post 🙂 Change the max_allowed_packet Amazon RDS

Once installed and working make a note of the database instance either using the management console or use

rds-describe-db-instances

Issue this command to increase the size of the database to 10GB, XXXXXXXXX is the database instance name

rds-modify-db-instance XXXXXXXX --allocated-storage 10 --apply-immediately

Once the process was started it took about 10 minutes for the database to increase in size and be back on line.

Good luck with yours !!!!

Al

View original post

  1. Leave a comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

ifssoftware.wordpress.com/

Helping you achieve more

The Survival Guides's Blog

How to Survive IT and Holidays

WordPress.com

WordPress.com is the best place for your personal blog or business site.

%d bloggers like this: