Menu
Amazon Relational Database Service
User Guide (API Version 2014-10-31)

Working with Storage

To specify how you want your data stored in Amazon RDS, you select a storage type and provide a storage size when you create or modify a DB instance. Later, you can increase the amount or change the type of storage by modifying the DB instance. For more information about which storage type to use for your workload, see Amazon RDS Storage Types.

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). If you are using General Purpose SSD or Provisioned IOPS SSD storage, you can increase your storage to a maximum of 16 TiB. Scaling storage for Amazon RDS for SQL Server database instance, is supported only for General Purpose SSD or Provisioned IOPS SSD storage types.

We recommend that you create a CloudWatch alarm to monitor the amount of free storage for your DB instance so you can respond when necessary. For more information on setting CloudWatch alarms, see Using Amazon RDS Event Notification.

In most cases, scaling storage doesn't require any outage and does not degrade performance of the server. After you modify the storage size for a DB instance, the status of the DB instance is storage-optimization. The DB instance is fully operational after a storage modification. However, you can't make further storage modifications for either six (6) hours or while the DB instance status is storage-optimization, whichever is longer.

If you have a SQL Server DB instance and have not modified the storage configuration since November 2017, you might experience a short outage of a few minutes when you modify your DB instance to increase the allocated storage. After the outage, the DB instance is online but in the storage-optimization state. Performance might be degraded during storage optimization.

Note

You can't reduce the amount of storage for a DB instance after it has been allocated.

AWS Management Console

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 Instances.

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

  4. For Instance actions, choose Modify.

  5. Type a new value for Allocated Storage. It must be greater than the current value.

    
								Modify the amount of storage for a DB instance

    Note

    When you increase Allocated Storage it must be by at least 10 %. If you try to increase by less than 10 % you see an error.

  6. Choose Continue to move to the next screen.

  7. To immediately initiate conversion of the DB instance to use the new storage type, choose the Apply immediately check box in the Scheduling of modifications section. If you want the changes to be applied in the next maintenance window, choose that option.

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

CLI

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

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

  • --apply-immediately – Use --apply-immediately to initiate conversion immediately, or --no-apply-immediately (the default) to apply the conversion during the next maintenance window. An immediate outage occurs when the conversion is applied. For more information about storage, see DB instance storage.

API

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

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

  • ApplyImmediately – Set this option to True if you want to initiate conversion immediately. If this option is False (the default), the scaling is applied during the next maintenance window. An immediate outage occurs when the conversion is applied.

    For more information about storage, see DB instance storage.

Changing your storage type

You can change the type of storage for your DB instance by using the AWS Management Console, the Amazon RDS API, or the AWS Command Line Interface (AWS CLI).

When you convert from one storage type to another an outage occurs while the data for that DB instance is migrated to a new volume. The duration of the migration depends on several factors such as database load, storage size, storage type, and amount of IOPS provisioned (if any). The typical migration time is a few minutes. The DB instance is available for use during the migration. However, when you are migrating to or from magnetic storage, the migration time can take up to several days in some cases. During the migration to or from magnetic storage, the DB instance is available for use, but might experience performance degradation.

Storage conversions from Provisioned IOPS SSD or magnetic storage to General Purpose SSD storage can potentially deplete the I/O credits allocated for General Purpose SSD storage. This is especially on smaller volumes. After the initial I/O burst credits for the volume are depleted, the remaining data is converted at the base performance rate of 3 IOPS per GiB of allocated General Purpose SSD storage. This approach can result in significantly longer conversion times.

AWS Management Console

To change the storage type 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 Instances.

    Note

    To filter the list of DB instances, for Filter instances, type a text string for Amazon RDS to use to filter the results. Only DB instances whose names contain the string appear.

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

  4. For Instance actions, choose Modify.

  5. On the Modify DB Instance page, choose the type of storage from the Storage type list. If you are modifying your DB instance to use Provisioned IOPS SSD storage type, then also provide a Provisioned IOPS value.

    
								Console Tags tab
  6. Choose Continue.

  7. To apply the changes to the DB instance immediately, choose the Apply immediately check box in the Scheduling of modifications section. Alternatively, you can choose Apply during the next scheduled maintenance window.

    An immediate outage occurs when the storage type changes. For more information about storage, see

  8. Review the parameters to be changed, and choose Modify DB instance to complete the modification.

CLI

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

  • --storage-type – Set to io1 for Provisioned IOPS.

  • --apply-immediately – Use --apply-immediately to initiate conversion immediately. Use --no-apply-immediately (the default) to apply the conversion during the next maintenance window.

API

To change the type of storage for a DB instance, use the Amazon RDS API ModifyDBInstance action. Set the following parameters:

  • StorageType – Set to io1 for Provisioned IOPS.

  • ApplyImmediately – Set this option to True if you want to initiate conversion immediately. If this option is False (the default), the conversion is applied during the next maintenance window.

Modifying Provisioned IOPS SSD storage settings

You can modify the settings for a DB instance that uses Provisioned IOPS SSD Storage by using the AWS Management Console, the Amazon RDS API, or the AWS CLI. Specify the storage type, allocated storage, and the amount of Provisioned IOPS that you require. You can choose between 1,000 IOPS and 100 GiB of storage up to 40,000 IOPS and 16 TiB (16384 GiB) of storage, depending on your database engine.

Although you can reduce the amount of IOPS provisioned for your instance, you can't reduce the amount of General Purpose SSD or magnetic storage allocated.

AWS Management Console

To change the Provisioned IOPS settings 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 Instances.

    Note

    To filter the list of DB instances, for Filter instances, type a text string for Amazon RDS to use to filter the results. Only DB instances whose names contain the string appear.

  3. Choose the DB instance with Provisioned IOPS that you want to modify.

  4. For Instance actions, choose Modify.

  5. On the Modify DB Instance page, choose Provisioned IOPS for Storage type and then provide a Provisioned IOPS value.

    
						Console Tags tab

    If the value you specify for either Allocated storage or Provisioned IOPS is outside the limits supported by the other parameter, a warning message is displayed. This messages gives the range of values required for the other parameter.

  6. Choose Continue.

  7. To apply the changes to the DB instance immediately, choose the Apply immediately check box in the Scheduling of modifications section. Alternatively, you can choose Apply during the next scheduled maintenance window.

    An immediate outage occurs when the storage type changes. For more information about storage, see

  8. Review the parameters to be changed, and choose Modify DB instance to complete the modification.

    The new value for allocated storage or for Provisioned IOPS appears in the Status column.

CLI

To change the Provisioned IOPS setting for a DB instance, use the AWS CLI modify-db-instance command. Set the following parameters:

  • --storage-type – Set to io1 for Provisioned IOPS.

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

  • --iops – The new amount of Provisioned IOPS for the DB instance, expressed in I/O operations per second.

  • --apply-immediately – Use --apply-immediately to initiate conversion immediately. Use --no-apply-immediately (the default) to apply the conversion during the next maintenance window.

API

To change the Provisioned IOPS settings for a DB instance, use the Amazon RDS API ModifyDBInstance action. Set the following parameters:

  • StorageType – Set to io1 for Provisioned IOPS.

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

  • Iops – The new IOPS rate for the DB instance, expressed in I/O operations per second.

  • ApplyImmediately – Set this option to True if you want to initiate conversion immediately. If this option is False (the default), the modification is applied during the next maintenance window.