All Products
Search
Document Center

AnalyticDB for MySQL:Create a resource group

Last Updated:Apr 28, 2024

AnalyticDB for MySQL allows you to divide computing resources into different resource groups that physically separate computing resources. You can use the AnalyticDB for MySQL console to create resource groups and divide the 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 in the AnalyticDB for MySQL console.

Create a resource group

Create an interactive 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. Select Interactive from the drop-down list. Interactive resource groups are 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.

    Cluster Size

    The size of a single compute cluster. Unit: AnalyticDB compute units (ACUs). The minimum value is 16 ACUs.

    Note

    The cluster size is not subject to the reserved computing resources in AnalyticDB for MySQL Data Lakehouse Edition (V3.0). If the cluster size is greater than the reserved computing resources, you are charged for the excess part based on elastic resources. For more information, see Pricing for Data Lakehouse Edition (V3.0).

    Enable Multi-cluster

    Specifies whether to enable the multi-cluster feature.

    Mode

    The mode in which the multi-cluster resource group runs in AnalyticDB for MySQL Data Lakehouse Edition (V3.0). Valid values:

    • Elastic: allows you to specify different values for the Minimum Clusters and Maximum Clusters parameters. In this mode, AnalyticDB for MySQL starts or shuts down compute clusters based on the query load on the resource group.

      • The initial number of compute clusters in the resource group is equal to the value of the Minimum Clusters parameter. As the number of concurrent user queries increases for the resource group and queries start to queue due to insufficient resources, AnalyticDB for MySQL automatically starts additional compute clusters, up to the value of the Maximum Clusters parameter.

      • As the query load on the resource group decreases, AnalyticDB for MySQL automatically shuts down excess compute clusters, down to the value of the Minimum Clusters parameter.

    • Maximum: allows you to specify the same value for the Minimum Clusters and Maximum Clusters parameters. The specified value must be greater than or equal to 2. In this mode, when the resource group is created, AnalyticDB for MySQL starts all the specified compute clusters.

      This mode is effective for statically controlling the total amount of computing resources in the resource group, particularly if you have large numbers of concurrent user queries and the numbers do not fluctuate significantly.

    Minimum Clusters

    The minimum number of compute clusters that you must run in the resource group. The value must be less than or equal to the maximum number of compute clusters. The minimum value is 1.

    Maximum Clusters

    The maximum number of compute clusters that you can run in the resource group. The maximum value is 10.

  4. Click OK.

Create a job 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. Select Job from the drop-down list. Job resource groups are suitable for batch processing scenarios that require high throughput. In these scenarios, you can use on-demand scaling to scale computing resources.

    Minimum Computing Resources

    Valid value: 0ACU.

    Maximum Computing Resources

    The maximum amount of computing resources. Configure this parameter in the range of 8 ACUs to 1,024 ACUs in increments of 8 ACUs. The maximum amount of computing resources that can be configured in the console is 1,024 ACUs. If you want to modify the amount of resources, submit a ticket.

    Spot Instance

    Specifies whether to enable the spot instance feature for the resource group.

    After you enable the spot instance feature, Spark jobs that run in the job resource group attempt to use the spot instance resources.

  4. Click OK.

Modify a resource group

After you create a resource group, you can modify the resource amount settings, and enable or disable the spot instance or multi-cluster feature for the resource group. To modify a resource group, perform the following steps:

  1. On the Resource Groups page, find the resource group that you want to modify and click Modify in the Actions column.

  2. In the Modify Resource Group panel, modify the resource amount settings, and enable or disable the spot instance or multi-cluster feature for the resource group.

  3. Click OK.

Important
  • You cannot change the job type for a resource group 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.

  • You cannot enable the multi-cluster feature for existing interactive resource groups.

References

Multi-cluster scaling model