All Products
Search
Document Center

ApsaraDB RDS:Configure automatic storage expansion

Last Updated:Jun 03, 2024

If the storage capacity of an ApsaraDB RDS for MySQL instance is insufficient, data may fail to be written to the instance. As a result, data loss occurs or even the RDS instance breaks down, which seriously affects business operations. ApsaraDB RDS for MySQL supports automatic storage expansion when the storage capacity of an RDS instance reaches the threshold that you specify. During the expansion, you do not need to restart the RDS instance, and your services are not affected.

Prerequisites

  • The RDS instance uses the subscription or pay-as-you-go billing method.

    Note

    If the RDS instance uses the serverless billing method, the system automatically expands the storage capacity of the instance. You do not need to configure automatic storage expansion for the RDS instance.

  • The RDS instance runs RDS High-availability Edition or RDS Cluster Edition.

    Note

    If the RDS instance runs RDS Basic Edition with cloud disks, you can enable automatic storage expansion in the Database Autonomy Service (DAS) console. For more information, see Automatic space expansion.

  • The RDS instance uses cloud disks.

  • The RDS instance is in the Running state.

  • The balance in your Alibaba Cloud account is sufficient for the expansion.

Usage notes

When read-only RDS instances are attached to a primary RDS instance and automatic storage expansion is triggered for the primary RDS instance, the system automatically checks the storage capacity of each read-only RDS instance. If the storage capacity of a read-only RDS instance is smaller than the desired storage capacity of the primary RDS instance, the system first expands the storage capacity of the read-only RDS instance. After the storage capacity of each read-only RDS instance is expanded, the system automatically expands the storage capacity of the primary RDS instance. For more information, see [Notice] Optimization of automatic storage expansion for ApsaraDB RDS for MySQL instances and ApsaraDB RDS for PostgreSQL instances.

Procedure

  1. Go to the Instances page. In the top navigation bar, select the region in which the RDS instance resides. Then, find the RDS instance and click the ID of the instance.
  2. In the Usage Statistics section of the page that appears, click Settings on the right of Automatic Storage Expansion.

    设置

  3. Configure the following parameters.

    Parameter

    Description

    Automatic Storage Expansion

    Specifies whether to enable or disable automatic storage expansion.

    Available Storage ≤

    The threshold based on which automatic storage expansion is triggered. The threshold is expressed as a percentage. If the available storage reaches the threshold, the system automatically expands the storage capacity of the RDS instance.

    Note

    The maximum amount of storage that you can expand is the larger value between the following values:

    • 5 GB. If the storage capacity of the RDS instance is less than 50 GB and the percentage of the available storage is less than 10% of the storage capacity, the step size for storage capacity expansion is adjusted to 10 GB.

    • 15% of the current storage capacity of the RDS instance. The result is the nearest integer that is a multiple of 5.

    For example, if the current storage capacity is 100 GB, the storage capacity is expanded by 15 GB when the threshold is reached. After the expansion, the total storage capacity is 115 GB.

    Maximum Storage Capacity

    The maximum storage capacity of the RDS instance after the storage capacity expansion. The value of this parameter must be greater than or equal to the current storage capacity of the RDS instance.

    The following list describes the maximum storage capacity that is supported by each type of cloud disk:

    • If the RDS instance uses Enterprise SSDs (ESSDs), you can set this parameter to 32,000 GB.

    • If the RDS instance uses general ESSDs, you can set this parameter to 64,000 GB.

    • RDS instances that use standard SSDs: 6,000 GB

      Note

      The standard SSD storage type is phased out. We recommend that you upgrade the storage type of your RDS instance from standard SSD to ESSD. For more information, see Upgrade the storage type from standard SSD to ESSD.

  4. Click OK.

References

Related operations

Operation

Description

ModifyDasInstanceConfig

Configures automatic storage expansion.

FAQ

Why am I unable to find Settings on the right of Automatic Storage Expansion in the Usage Statistics section?

You must check whether the RDS instance meets the prerequisites.