To handle performance pressure from business growth and high database loads, Database Autonomy Service (DAS) provides a prediction-based auto scaling feature. The system predicts performance metrics for the next 24 hours based on the instance's performance data from the last 10 days. If a predicted metric reaches the performance bottleneck threshold, DAS provides a scale-out suggestion. This feature provides only predictions and scale-out suggestions. You must manually perform any scale-out operations.
Prerequisites
The instance runs one of the following versions:
MySQL 8.0 on RDS High-availability Edition, RDS Enterprise Edition, or RDS Cluster Edition
MySQL 5.7 on RDS High-availability Edition, RDS Enterprise Edition, or RDS Cluster Edition
MySQL 5.6 on RDS High-availability Edition
MySQL 5.5 on RDS High-availability Edition
A service-linked role for DAS is created.
Billing description
This feature provides only predictions and scale-out suggestions. It does not automatically perform scale-out operations. Therefore, no fees are incurred.
Configure a 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 navigation pane on the left, choose . On the Autonomy Center page, click Autonomy Service Settings.
On the tab, click Add Policy. Set the following parameters and click OK.
Parameter
Description
Policy Name
A custom policy name.
Mode
The mode of the policy. Select Prediction-based Auto Scaling.
Engine Type
Select RDS for MySQL.
Prediction Metric Type
Select CPU Utilization (%).
Target Value
Set the target value for the prediction metric. When the predicted metric value is greater than or equal to the target value, the system provides a scale-out suggestion.
In the Recommended Policies section, find the policy that you want to add and click Apply in the Actions column. In the dialog box that appears, click Next to add the policy to the instance.
To modify a policy, click Modify in the Actions column for the policy. On the Update Policy tab, modify the policy.
To unapply a policy, find the policy in the Applied Policies section and click Unapply in the Actions column.
On the Autonomous Function Management page, click OK.
(Optional) To receive timely notifications about prediction-based auto scaling events for the instance, configure alerts and add an alert contact group.
NoteIf you have configured an alert template for the instance, follow the 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 navigation pane on the left, choose .
On the Autonomy Center page, view the Auto Scaling events for the selected time range.
Click Details for a Database Workload Prediction event to view more information.
What to do next
You can scale out the instance based on the suggestion. For more information, see Change instance specifications.