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.
Prerequisites
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 3.1.3.2 or above.
Note
- If you need to upgrade the kernel version, please submit a ticket to contact the support.
- For more information about cluster editions and specifications, see Editions.
Background information
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
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.