This topic describes how to configure automatic storage expansion for an ApsaraDB RDS for MySQL instance.
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 uses the standard product type.
The RDS instance is in the Running state.
The balance in your Alibaba Cloud account is sufficient for the expansion.
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 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 [Product changes/Feature changes] Optimization of automatic storage expansion for ApsaraDB RDS for MySQL instances and ApsaraDB RDS for PostgreSQL instances.
- 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.
In the Usage Statistics section of the page that appears, click Settings on the right of Automatic Storage Expansion.
Configure the following parameters.
Automatic Storage Expansion
Specifies whether to enable or disable automatic storage expansion.
Available Storage ≤
The threshold based on which the system triggers automatic storage expansion. The threshold is expressed as a percentage. If the storage usage reaches the threshold, the system 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:
15% of the current storage capacity of the RDS instance
Maximum Storage Capacity
The 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.
If the RDS instance uses enhanced 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.
If the RDS instance uses standard SSDs, you can set this parameter to 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 enhanced SSD (ESSD). For more information, see Upgrade the storage type from standard SSD to ESSD.
Configures automatic storage expansion.
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.