AnalyticDB for MySQL provides the resource group management feature. You can divide computing resources of an AnalyticDB for MySQL Data Lakehouse Edition (V3.0) cluster into multiple resource groups to better manage and utilize resources. This topic describes how to create and modify a resource group.
Create a resource group
Log on to the AnalyticDB for MySQL console. In the upper-left corner of the console, select a region. In the left-side navigation pane, click Clusters. On the Data Lakehouse Edition (V3.0) tab, find the cluster that you want to manage and click the cluster ID.
In the left-side navigation pane, choose Cluster Management > Resource Management. On the page that appears, click the Resource Groups tab.
In the upper-right corner of the tab, click Create Resource Group. In the panel that appears, configure the parameters that are described in the following table.
Parameter
Description
Resource Group Name
The name of the resource group. The name must be 2 to 30 characters in length and can contain letters, digits, and underscores (_). The name must start with a letter.
Task Type
The task type of the resource group. Valid values:
Interactive: suitable for real-time processing scenarios that require high queries per second (QPS) and low response time (RT). In these scenarios, you can use scheduled scaling to scale computing resources.
Job: suitable for batch processing scenarios that require high throughput. In these scenarios, you can use on-demand scaling to scale computing resources.
Reserved Computing Resources
For an interactive resource group, configure this parameter in the range of 16 AnalyticDB compute units (ACUs) to the amount of reserved computing resources that are not allocated within the cluster in increments of 16 ACUs.
For a job resource group, configure this parameter in the range of 0 ACUs to the amount of reserved computing resources that are not allocated within the cluster in increments of 8 ACUs.
NoteTo obtain the amount of reserved computing resources that are not allocated within the cluster, choose Cluster Management > Resource Management in the left-side navigation pane, click the Resource Overview tab, and then view the value of Unallocated Reserved Computing Resources.
Maximum Computing Resources
The maximum amount of computing resources that can be scaled up for a job resource group. Unit: ACU. Valid values: 8 to 520. The value must be in increments of 8 ACUs.
ImportantThis parameter is available only when you set the Task Type parameter to Job.
Click OK.
Modify a resource group
After you create a resource group, you can modify the amount of resources for the resource group.
On the Resource Groups tab, find the resource group that you want to modify and click Modify in the Actions column. In the panel that appears, modify the Reserved Computing Resources or Maximum Computing Resources parameter based on your business requirements. Click OK.
You cannot change the task type for resource groups in a Data Lakehouse Edition (V3.0) cluster.
The modification to the amount of reserved computing resources or maximum computing resources takes effect in real time.