After you divide the computing resources of a cluster into resource pools, you can manage the resource pools and better utilize the computing resources. This topic describes how to create and modify resource pools and bind users to or unbind users from resource pools.
The AnalyticDB for MySQL must meet the following conditions at the same time:
- AnalyticDB for MySQL cluster must be an Elastic mode for Cluster Edition.
- The cluster must have 32 or more cores.
- The cluster kernel version must be 22.214.171.124 or above.
You can divide the computing resources of an AnalyticDB for MySQL elastic cluster into multiple resource pools and bind different users to each resource pool to implement isolation. This way, you can schedule computing tasks based on priorities to protect core business from being affected by complex computing and emergencies. You can also classify queries and allocate resources to maximize cluster performance. For more information, see Resource pool overview.
For example, User A and User B need to perform simple queries, and User C needs to
perform complex queries and analysis on large amounts of data. In this case, you can
bind User A and User B to the resource pool named
source_a whose query type is
Interactive, and bind User C to the resource pool named
source_b whose query type is
Batch. This way, when User C performs large-scale computing and queries, the performance
of simple queries is unaffected.
Create a resource pool
- Log on to the AnalyticDB for MySQL console by your Alibaba Cloud account.
- In the upper-left corner of the page, select the region where clusters reside.
- In the left-side navigation pane, click Clusters.
- On the V3.0 Clusters tab, click the target Cluster ID.
- In the left-side navigation pane, click Resource Pool Management.
- On the Resource Pool Management page, click New Resource Pool in the upper-right corner.
- Configure the resource pool.
Parameter Description Resource Pool Name The name of the resource pool. 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 type of SQL queries used in the resource pool. For more information, see Query execution types. Default value: Default_Type. Valid values:
- Batch: the batch query type. This type is ideal for complex queries on a large amount of data, such as extract, transform, and load (ETL) queries. Intermediate query results can be written to disks. If you query large amounts of data, the query performance is degraded, but the computing nodes do not fail.
- Interactive: the interactive query type. This type is ideal for real-time queries that require low latency. The quick interactive query type is based only on memory, which delivers high query performance. However, if the data amount exceeds the processing capacity of the server, the queries may fail.
Resources The amount of resources allocated to the resource pool.
- Click OK to create the resource pool.
Modify a resource pool
- On the Resource Pool Management page, find the resource pool that you want to modify and click Modify in the Actions column.
- Modify the Query Type or Resources parameter.
- Click OK.
Bind or unbind a user
You can bind different users to different resource pools to meet multi-tenancy and hybrid load requirements within clusters. For more information, see Binding between users and resource pools.
- On the Resource Pool Management page, find the resource pool to which you want to bind a user and click Bind User in the Actions column.
- On the Bind User page, select a user that you want to bind from the Username drop-down list and click Bind User. In the Bind User message, click OK.
- To bind more users, repeat Step 2.
- To unbind a user, click Unbind in the Actions column corresponding to the user in the username list. In the Unbind User message, click OK.