All Products
Search
Document Center

AnalyticDB for MySQL:Create a resource group

Last Updated:Mar 11, 2024

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

  1. 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.

  2. In the left-side navigation pane, choose Cluster Management > Resource Management. On the page that appears, click the Resource Groups tab.

  3. 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.

    Note

    To 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.

    Important

    This parameter is available only when you set the Job Type parameter to Job.

  4. 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.

Important
  • 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.