All Products
Search

This Product

    AnalyticDB for MySQL:Create a resource group

    Document Center

    AnalyticDB for MySQL:Create a resource group

    Last Updated:Mar 01, 2024

    AnalyticDB for MySQL allows you to divide computing resources into different resource groups that physically separate the computing resources. You can create resource groups by calling API operations or in the AnalyticDB for MySQL console and divide computing resources of an AnalyticDB for MySQL Data Warehouse 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.

    Prerequisites

    If you use an AnalyticDB for MySQL Data Warehouse Edition (V3.0) cluster, make sure that the following requirements are met:

    • The cluster is in elastic mode for Cluster Edition.

    • The cluster has 32 cores or more.

    • The minor version of the cluster is 3.1.3.2 or later.

      Note

      For information about how to query the minor version of a cluster, see How do I query the version of an AnalyticDB for MySQL cluster? To update the minor version of a cluster, contact technical support.

    Create a resource group

    1. Log on to the AnalyticDB for MySQL console.
    2. In the upper-left corner of the page, select a region.
    3. In the left-side navigation pane, click Clusters.

    4. On the Data Warehouse Edition (V3.0) tab, find the cluster that you want to manage and click the Cluster ID.

    5. In the left-side navigation pane, click Resource Groups.

    6. On the Resource Groups page, click Create Resource Group in the upper-right corner.

    7. 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 only letters, digits, and underscores (_). The name must start with a letter.

      Query Type

      The query type of the resource group. For more information, see Query execution modes. Valid values:

      • Default_Type: the default query type.

      • Batch: suitable for complex queries on large amounts of data, such as extract-transform-load (ETL) queries. If you set the Query Type parameter to Batch, intermediate query results can be written to disks. When you query large amounts of data, the query performance is degraded, but the compute nodes do not fail.

      • Interactive: suitable for real-time analysis queries that require low latency. The interactive query type is based only on memory and delivers high query performance. If the amount of data exceeds the processing capacity of the server, the queries may fail.

      Resource Amount

      The amount of resources that you want to allocate to the resource group.

    8. Click OK.

    Modify a resource group

    After you create a resource group, you can change the query type or modify the amount of resources for the resource group.

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

    2. Modify the Query Type and Resource Amount parameters based on your business requirements.

      Note

      If you use the default resource group of an AnalyticDB for MySQL Data Warehouse Edition (V3.0) cluster, you can change the query type but not modify the amount of resources for the resource group. The amount of resources in the default resource group is calculated based on the following formula: Amount of resources in the default resource group = Total amount of resources in a cluster - Amount of resources occupied by other resource groups in the cluster.

    3. Click OK.

      The modification to the amount of resources in an AnalyticDB for MySQL resource group takes effect in real time.

    Related SQL statements