Increasing DB instance storage capacity - Amazon Relational Database Service

Increasing DB instance storage capacity

If you need space for additional data, you can scale up the storage of an existing DB instance. To do so, you can use the Amazon RDS Management Console, the Amazon RDS API, or the AWS Command Line Interface (AWS CLI). For information about storage limits, see Amazon RDS DB instance storage.

Note

You can't reduce the amount of storage for a DB instance after storage has been allocated. When you increase the allocated storage, it must be by at least 10 percent. If you try to increase the value by less than 10 percent, you get an error.

Scaling storage for RDS for SQL Server DB instances is supported only for the General Purpose SSD and Provisioned IOPS SSD storage types.

To monitor the amount of free storage for your DB instance so you can respond when necessary, we recommend that you create an Amazon CloudWatch alarm. For more information on setting CloudWatch alarms, see Using CloudWatch alarms.

Scaling storage usually doesn't cause any outage or performance degradation of the DB instance. After you modify the storage size for a DB instance, the status of the DB instance is storage-optimization.

Note

Storage optimization can take several hours. You can't make further storage modifications for either six (6) hours or until storage optimization has completed on the instance, whichever is longer. You can view the storage optimization progress in the AWS Management Console or by using the describe-db-instances AWS CLI command.

To increase storage for a DB instance

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

  2. In the navigation pane, choose Databases.

  3. Choose the DB instance that you want to modify.

  4. Choose Modify.

  5. Enter a new value for Allocated storage. It must be greater than the current value.

    Modify the amount of storage for a DB instance

  6. Choose Continue to move to the next screen.

  7. Choose Apply immediately in the Scheduling of modifications section to apply the storage changes to the DB instance immediately.

    Or choose Apply during the next scheduled maintenance window to apply the changes during the next maintenance window.

  8. When the settings are as you want them, choose Modify DB instance.

To increase the storage for a DB instance, use the AWS CLI command modify-db-instance. Set the following parameters:

  • --allocated-storage – Amount of storage to be allocated for the DB instance, in gibibytes.

  • --apply-immediately – Use --apply-immediately to apply the storage changes immediately.

    Or use --no-apply-immediately (the default) to apply the changes during the next maintenance window. An immediate outage occurs when the changes are applied.

For more information about storage, see Amazon RDS DB instance storage.

To increase storage for a DB instance, use the Amazon RDS API operation ModifyDBInstance. Set the following parameters:

  • AllocatedStorage – Amount of storage to be allocated for the DB instance, in gibibytes.

  • ApplyImmediately – Set this option to True to apply the storage changes immediately. Set this option to False (the default) to apply the changes during the next maintenance window. An immediate outage occurs when the changes are applied.

For more information about storage, see Amazon RDS DB instance storage.