To manage the performance impact of business growth and high database workloads, Database Autonomy Service (DAS) provides prediction-based auto scaling. DAS analyzes an instance's performance data over the past 10 days to predict its metrics for the next 24 hours. When DAS predicts a metric will reach the performance bottleneck threshold, it generates a scale-out suggestion. This feature only generates predictions and scale-out suggestions. It does not automatically scale out the instance. You must scale out the instance manually.
Prerequisites
-
The instance must run one of the following versions:
ApsaraDB RDS for MySQL 8.4 on RDS High-availability Edition or RDS Cluster Edition
ApsaraDB RDS for MySQL 8.0 on RDS High-availability Edition, RDS Enterprise Edition, or RDS Cluster Edition
ApsaraDB RDS for MySQL 5.7 on RDS High-availability Edition, RDS Enterprise Edition, or RDS Cluster Edition
ApsaraDB RDS for MySQL 5.6 on RDS High-availability Edition
ApsaraDB RDS for MySQL 5.5 on RDS High-availability Edition
-
You must have a service-linked role for DAS.
Billing
This feature only generates predictions and suggestions and does not automatically scale out instances. Therefore, it incurs no fees.
Configure prediction-based auto scaling policy
-
Go to the RDS Instances page. In the top navigation bar, select a region, and then click the ID of the target instance.
-
In the left navigation pane, choose . On the Autonomy Center page, click Autonomy Service Settings.
-
On the tab, click Add Policy, configure the following parameters, and then click OK.
Parameter
Description
Policy Name
Enter a custom name for the policy.
Mode
Select Prediction-based Auto Scaling.
Engine Type
Select RDS MySQL.
Metric Type
Select CPU Utilization (%).
Destination Value
The metric's target value. If the predicted value is greater than or equal to this value, DAS generates a scale-out suggestion.
-
In the Recommended Policies section, find the policy that you want to add, click Apply in the Actions column, and then click Next in the dialog box that appears.
-
To modify an existing policy, click Modify in the Actions column for the policy, and then make changes on the Update Policy tab.
-
To unapply a policy, find it in the Applied Policies section and click Cancel in the Actions column.
-
-
On the Autonomous Function Management page, click OK.
-
(Optional) Configure alerts and add an alert contact group to receive timely notifications of prediction-based auto scaling events.
NoteIf you have already configured an alert template for the instance, follow the system prompts to add an alert rule for the corresponding autonomy event to the template.
View prediction-based auto scaling results
-
Go to the RDS Instances page. In the top navigation bar, select a region, and then click the ID of the target instance.
-
In the left navigation pane, choose .
-
On the Autonomy Center page, view the auto-scaling events for the selected time range.
-
Click Details for a Database Workload Prediction event.
On the details page, the event type is an auto-scaling event, the severity is Notice, and the event name is Database Workload Prediction.
Next steps
Use the scale-out suggestion to scale out the instance. For more information, see change specifications.