AnalyticDB for MySQL allows you to divide computing resources into different resource groups that physically separate the computing resources. You can use the AnalyticDB for MySQL console to create resource groups and divide computing resources of an AnalyticDB for MySQL Data Lakehouse Edition (V3.0) cluster into the resource groups to better manage and utilize resources. This topic describes how to create and modify a resource group in the AnalyticDB for MySQL console.
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.
Job Type
The job 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 Instance Management 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 Job 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 and Maximum Computing Resources parameters based on your business requirements. Click OK.
You cannot change the job type for resource groups in an AnalyticDB for MySQL Data Lakehouse Edition (V3.0) cluster.
The modification to the amounts of reserved computing resources and maximum computing resources takes effect in real time.