Database Autonomy Service (DAS) provides the automatic performance scaling feature. During peak hours, DAS automatically scales up a database instance to handle peak-hour traffic and ensure business stability. DAS monitors the CPU utilization of the database instance in real time. If the CPU utilization per unit of time decreases, DAS automatically scales down the database instance. This topic describes how to enable the automatic performance scaling feature.

Prerequisites

  • An ApsaraDB RDS for MySQL instance of the High-availability Edition or a PolarDB for MySQL instance of the Cluster Edition is connected to DAS. The ApsaraDB RDS for MySQL instance uses standard or enhanced SSDs.
  • The billing method of the ApsaraDB RDS for MySQL instance or the PolarDB for MySQL instance is pay-as-you-go.
  • The Enable Autonomy Service switch is turned on for the database instance. For more information, see Autonomy center.

Scenario example

You enable the automatic performance scaling feature for a database instance in DAS. During peak hours, DAS automatically scales up the instance. This operation doubles the read/write throughput and lowers the CPU utilization from more than 90% to 25%. This allows the instance to run under heavy load for nearly 10 consecutive hours. After the read and write traffic decreases and the CPU utilization drops to less than 25%, DAS automatically scales down the instance to the original specification.

This way, DAS ensures the stability of online business in an effective way.

Procedure

  1. Log on to the DAS console.
  2. In the left-side navigation pane, click Instance Monitoring.
  3. Find the instance for which you want to enable the automatic performance scaling feature, and click the instance ID. The instance details page appears.
  4. In the left-side navigation pane, click Autonomy Center.
  5. On the Autonomy Center page, click Autonomy Service Settings in the upper-right corner.
  6. In the Settings dialog box, enable automatic performance scaling and configure the following parameters.
    s
    Parameter Description
    Average CPU Utilization The CPU utilization threshold that triggers the automatic performance scaling operation. If the average CPU utilization is greater than or equal to the specified value, the automatic performance scaling operation is triggered.
    Maximum Specifications The upper limit to which the instance specifications can be upgraded for automatic performance scaling. DAS changes the specifications of a database instance by one level at a time. For example, DAS changes the instance specification from 4 cores to 8 cores and then to 16 cores based on business requirements. This process continues until the instance specifications reach the specified upper limit.
    Observation Window The time window during which DAS monitors the CPU utilization of the database instance. If the CPU utilization reaches the threshold within an observation window, DAS triggers automatic scaling at the end of the observation window. By default, the CPU utilization reaches the threshold if it remains higher than 70% for longer than half the duration of an observation window.
  7. Click OK.