All Products
Search

This Product

    PolarDB:Setting Up Automatic Expansion of ESSD Cloud Disk Storage Space

    Document Center

    PolarDB:Setting Up Automatic Expansion of ESSD Cloud Disk Storage Space

    Last Updated:Nov 11, 2024

    When the database storage is insufficient, data may fail to be written, which results in data loss or even database crash and seriously affects your business. PolarDB for MySQL Standard Edition supports automatic storage scale-up when the storage reaches the threshold. During the scale-up, you do not need to restart the cluster and your business is not affected.

    Prerequisites

    • A PolarDB for MySQL Standard Edition cluster whose engine version is MySQL 8.0.2, MySQL 8.0.1, or MySQL 5.7 is created.

      Note

      • PolarDB for MySQL Standard Edition does not support the MySQL 5.6 engine version.

      • The storage of a PolarDB for MySQL Enterprise Edition cluster is automatically scaled based on the actual usage. No additional operations are required.

    • Your Alibaba Cloud account does not have overdue payments and is sufficient in balance for the scale-up. Otherwise, the scale-up fails.

    Usage notes

    • The storage is automatically scaled up when any one of the following storage resources is insufficient: storage capacity, number of iNodes, or number of blktags. The following list describes the trigger conditions:

      • The storage space is less than 1 TB and the amount of available resources is less than 30% of the total amount of resources.

      • The storage space is greater than or equal to 1 TB and less than or equal to 10 TB and the amount of available resources is less than 20% of the total amount of resources.

      • The storage space is greater than 10 TB and the amount of available resources is less than 10% of the total amount of resources.

    • The storage is automatically scaled up by 20 GB or 15% of the current storage space, whichever is larger. For example, if the current storage space is 200 GB, the storage is automatically scaled up by 30 GB. If the current storage space is 100 GB, the storage is automatically scaled up by 20 GB.

    • You can disable the automatic storage scale-up feature at any time after a PolarDB for MySQL Standard Edition cluster is created. To disable the feature, turn off Enable Auto Scaling in the Auto Scaling Settings dialog box in the PolarDB console.

    • Automatic storage scale-up does not affect your business.

    Preparations

    Note

    • Before you enable automatic storage scale-up, make sure that you have created the AliyunServiceRoleForDAS role. For more information, see AliyunServiceRoleForDAS role.

    • If you have created the AliyunServiceRoleForDAS role, directly enable automatic storage scale-up.

    • If you have not created the AliyunServiceRoleForDAS role, perform the following operations:

    1. Log on to the RAM console with an Alibaba Cloud account.

    2. In the left-side navigation pane, choose Identities > Roles.

    3. On the Roles page, click Create Role.

    4. On the Create Role page, set the Select Trusted Entity parameter to Alibaba Cloud Service and click Next.

    截图1.png

    1. Set the Role Type parameter to Service Linked Role.

    2. Set the Select Service parameter to Database Autonomy Service.

      After you select the service, you can view the name, note, and policy that are predefined for the service-linked role. Click View Policy Details to view the detailed information about the policy.

    截图2.png

    1. Click OK.

    2. Click Close.

    Enable automatic storage scale-up

    Enable automatic storage scale-up when you create a cluster

    To enable automatic storage scale-up when you create a Standard Edition cluster, perform the following operations on the buy page:

    1. Log on to the PolarDB console.

    2. In the left-side navigation pane, click Clusters. In the upper-left corner of the Clusters page, select the region in which you want to create a cluster.

    3. Click Create Cluster.

    4. Complete the configurations of the cluster.

    Note

    For information about the prerequisites for configuring a cluster, see the "Prerequisites" section of this topic.

    1. In the Storage section, turn on Automatic Storage Expansion and configure the Maximum Storage parameter. The default value of the Maximum Storage parameter is 64000 GB.

    64TB.png

    1. Click Buy Now.

    Enable automatic storage scale-up for an existing cluster

    To enable automatic storage scale-up for an existing Standard Edition cluster, perform the following operations in the PolarDB console:

    1. Log on to the PolarDB console.

    2. In the left-side navigation pane, click Clusters. In the upper-left corner of the Clusters page, select the region in which the cluster that you want to manage is deployed.

    3. Find the cluster and click the cluster ID.

    4. In the upper-right corner of the Distributed Storage section, click Enable automatic scale-up.

    截图3.png

    1. In the Auto Scaling Settings dialog box, turn on Enable Auto Scaling and configure the Maximum Storage Capacity parameter. The default value of the Maximum Storage Capacity parameter is 64000 GB.

    64.png

    1. Click OK.

    Others

    Storage exhaustion may be caused by excessive temporary files, log files, and data files. For information about how to resolve this issue, see FAQ.