This topic describes how to configure automatic storage expansion for an ApsaraDB RDS for MySQL instance.

Prerequisites

  • The RDS instance runs RDS High-availability Edition or RDS Cluster Edition and uses cloud disks.
  • The balance in your Alibaba Cloud account is sufficient for the expansion.
  • The RDS instance is in the Running state.

Usage notes

Starting February 28, 2023, optimizations of the rules for automatic storage expansion are rolled out in different regions. If your RDS instance is a primary RDS instance and has read-only RDS instances, the system checks the storage capacity of each read-only instance when automatic storage expansion is triggered for the primary instance. If the storage capacity of a read-only instance is less than the required storage capacity of the primary instance after expansion, the system preferentially expands the storage capacity of the read-only instance. After the system expands the storage capacity of all read-only instances, the system expands the storage capacity of the primary 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 to the right of Automatic Storage Expansion.
    Settings
  3. Configure the following parameters.
    ParameterDescription
    Automatic Storage ExpansionSpecifies whether to enable or disable automatic storage expansion.
    Available Storage Threshold<=The threshold based on which ApsaraDB RDS triggers automatic storage expansion. The threshold is expressed as a percentage. If the storage usage reaches the threshold, ApsaraDB RDS increases 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
    • 15% of the current storage capacity of the RDS instance
    Maximum StorageThe maximum storage capacity of the RDS instance after automatic storage expansion. The specified value must be greater than or equal to the current storage capacity of the RDS instance.
  4. Click Confirm.

Related operations

OperationDescription
ModifyDasInstanceConfigConfigures automatic storage expansion.

FAQ

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

Automatic storage expansion is supported only if your RDS instance RDS High-availability Edition or RDS Cluster Edition and uses cloud disks. If your RDS instance uses local SSDs, automatic storage expansion is not supported. In this case, you can change the specifications of your RDS instance to expand storage capacity. For more information, see Change the specifications of an ApsaraDB RDS for MySQL instance.