Database Autonomy Service:Auto scaling

Feature description

• Prediction-based auto scaling: DAS predicts the metric values of a database instance for the next 24 hours based on the historical data of the database instance over the last 10 days. If the predicted value of a metric is greater than or equal to the preset value, scaling suggestions are provided.

• Scheduled auto scaling: DAS scales up your database instances based on the specified policy on a regular basis and scales them back to the original specifications after the specified scaling period elapses. This feature allows you to cope with predictable periodic changes in database loads at minimal costs.

• Automatic scaling for local resources: When the average CPU utilization of a database instance over an observation window reaches the specified threshold, DAS utilizes available resources on the local host to increase the number of CPU cores of the database instance to the specified value.

• Automatic storage expansion: When the used storage capacity of a database instance is greater than or equal to the specified threshold, DAS automatically scales up the storage capacity of the database instance to ensure the stability of your business.

Create a policy

1. Log on to the DAS console.

2. In the left-side navigation pane, click Management and Settings.

3. In the Auto Scaling Policies section, click Add Policy. In the Add Policy panel, select a mode from the Mode drop-down list and configure other parameters. For more information about how to configure the parameters, see the corresponding topic:

   • Prediction-based auto scaling

   • Scheduled auto scaling

   • Automatic scaling for local resources

   • Automatic storage expansion

Apply a policy

1. Log on to the DAS console.

2. In the left-side navigation pane, click Management and Settings.

3. In the Auto Scaling Policies section, find the policy that you want to apply and click Apply in the Actions column.

4. In the Apply Policies dialog box, select the database instances to which you want to apply the policy and click the icon.

5. Click Confirm to apply the policy to the selected database instance.

Cancel a policy

1. Log on to the DAS console.

2. In the left-side navigation pane, click Management and Settings.

3. In the Auto Scaling Policies section, find the policy that you want to cancel for a database instance and click the number in the Applied Instances column.

4. In the Instance Details dialog box, find the database instance for which you want to cancel the policy and click Cancel in the Actions column.

5. Click OK.

Modify a policy

1. Log on to the DAS console.

2. In the left-side navigation pane, click Management and Settings.

3. In the Auto Scaling Policies section, find the policy that you want to modify and click Modify in the Actions column.

4. In the Update Policy panel, modify the policy settings.

   Note

   • If you modify the policy, all database instances to which the policy is applied are affected.

   • If you modify a scheduled auto scaling policy, ongoing tasks associated with the policy are affected.

     • If the value of the Operation parameter of a scheduled auto scaling policy is modified within an execution period, the system does not scale the database instances back to their original specifications at scale-back time because the database instance specifications are different from those specified by the original policy.

     • If the value of the Scale-back Time parameter changes after the values of the Valid From and Recurrence parameters of a scheduled auto scaling policy are modified within an execution period, the system does not scale the database instances back to their original specifications.

5. Click OK.

Delete a policy

1. Log on to the DAS console.

2. In the left-side navigation pane, click Management and Settings.

3. Delete one or more created policies by using the following methods.

   Note

   • Only policies that are not applied to database instances can be deleted. For more information about how to cancel a policy for a database instance, see the Cancel a policy section in this topic.

   • If you delete a scheduled auto scaling policy, ongoing tasks associated with the policy are affected. If a scheduled auto scaling policy is deleted within an execution period, the system does not scale the database instances back to their original specifications.

   • To delete multiple policies at a time, select the policies and click Batch Delete.

   • To delete a single policy, find the policy that you want to delete and click Delete in the Actions column.