Amazon Relational Database Service
User Guide (API Version 2012-01-15)
Print this pageEmail this pageGo to the ForumsView the PDFShare this page on TwitterShare this page on FacebookBookmark this page on DeliciousSubmit this page to RedditSubmit this page to DiggDid this page help you?  Yes  No   Tell us about it...

Scaling DB Instance Storage

If your DB instance runs out of storage space or file system resources, its status will change to storage-full and your DB Instance will no longer be available.

The following example shows the output of a rds-describe-db-instances command for a DBInstance which has used up all its storage:

PROMPT> rds-describe-db-instances mydbinstance
			DBINSTANCE  mydbinstance  2009-12-22T23:06:11.915Z  db.m1.large  mysql     50  sa  
			storage-full  mydbinstance.clla4j4jgyph.us-east-1.rds.amazonaws.com  3306  
			us-east-1b  3   n  5.1.57  general-public-license 
			SECGROUP  default  active
			PARAMGRP  default.mysql5.1  in-sync

You can also check the RDS events to see if your storage space is exhausted using the DescribeEvents API or the rds-describe-events command.

The following example shows a storage-full event being returned by the rds-describe-events command:

PROMPT>rds-describe-events --source-type db-instance --source-identifier  mydbinstance
		2009-12-22T23:44:14.374Z  mydbinstance  Allocated storage has been exhausted db-instance  
	
[Important]Important

We highly recommend that you constantly monitor the FreeStorageSpace RDS metric published in CloudWatch to ensure that your DB Instance has enough free storage space. For more information on monitoring RDS DB Instances, see Viewing DB Instance Metrics.

You can change the amount of disk space available to your DB Instance using the ModifyDBInstance API or the rds-modify-db-instance command.

[Important]Important

The maximum storage for an Amazon RDS DB Instance is 1024GB.

In this example, you change the storage size of an existing DB Instance called mydbinstance to 1024 GB.

[Note]Note

Your DB Instance will remain available (if it does not have a storage-full status) during a scale storage operation. If you want to scale storage immediately, include the ApplyImmediately flag in the ModifyDBInstance request (or the --apply-immediately flag with the rds-modify-db-instance command). If you do not specify the ApplyImmediately, the scale storage will occur during the next maintenance window, or after the next reboot of the DB Instance.

It is only possible to increase the storage size of a DB Instance. Decreasing the storage size of a DB Instance is not permitted.

You must increase storage size in increments of at least 10%. If you specify an increase of less than 10%, the provided value will be rounded up to 10%.

AWS Management Console

  1. Sign in to the AWS Management Console and open the Amazon RDS console at https://console.aws.amazon.com/rds/.

  2. In the My DB Instances list, select the check box next to the DB Instance you wish to delete.

  3. Click the Modify button.

    The Modify DB Instance window appears.

  4. Type the amount of storage you want (in gigabytes) into the Allocated Storage text box.

  5. Click the OK button.

CLI

  • Use the command rds-modify-db-instance as in the following example.

    PROMPT>rds-modify-db-instance mydbinstance --allocated-storage 1024

    This command produces output similar to the following.

    DBINSTANCE  mydbinstance   2009-10-21T18:32:37.080Z  db.m1.large  MySQL     50
    sa  available  mydbinstance.clouwupjnvmq.us-east-1.rds.amazonaws.com   3306
    us-east-1a  3  db.m1.xlarge  1024  n  5.1.57  general-public-license 
    SECGROUP  default  active
    PARAMGRP  default.MySQL5.1  in-sync					
    				

API

To modify the storage size of an DB Instance

  • Call ModifyDBInstance with the following parameters:

    • DBInstanceIdentifier = myinstancename

    • AllocatedStorage = 1024

    Example

    https://rds.amazonaws.com/
     ?Action=ModifyDBInstance
     &DBInstanceIdentifier=mydbinstance
     &AllocatedStorage=1024
     &SignatureVersion=2
     &SignatureMethod=HmacSHA256
     &Timestamp=2009-10-14T17%3A48%3A21.746Z
     &AWSAccessKeyId=<AWS Access Key ID>
     &Signature=<Signature>