Manage resource groups (deprecated) - Hologres - Alibaba Cloud Documentation Center

You can use resource groups to manage and allocate the compute resources of an instance. This topic describes how to use HoloWeb to create and delete resource groups, modify resource group quotas, and attach users to or detach users from a resource group.

Background information

Hologres V1.0 and earlier versions support resource isolation between instances but do not support fine-grained, user-level resource isolation within an instance. In a production environment, you often need to isolate resources for users within an instance and limit the maximum amount of resources that each user can use. This practice ensures that jobs from different users do not interfere with each other. To provide this type of fine-grained resource isolation, Hologres introduced the resource group feature. You can use resource groups to manage compute resources and achieve resource isolation within a Hologres instance. You can manage resource groups using the HoloWeb graphical interface.

Limits

Only Hologres V1.1 and later versions support using resource groups to manage compute resources within an instance. If your instance is earlier than V1.1, you must upgrade it. If the upgrade fails, see Common errors that occur when you prepare for an upgrade or join the Hologres DingTalk group to provide feedback. For more information, see How do I get more online support?.
Only users with Superuser permissions can use resource groups to manage compute resources within a Hologres instance. If you do not have the required permissions, a permission denied error is reported.
Compute resources are at the instance level. If you have multiple databases, they all share the compute resources of the instance and the resource allocation plan.
Instances of the compute group type do not support the resource group management feature. To implement resource isolation for these instances, you can divide resources into multiple compute groups.

Create a resource group

You can use the HoloWeb graphical interface to create a resource group.

Go to the HoloWeb developer page. For more information, see Connect to HoloWeb.
In the top menu bar of the HoloWeb developer page, click Security Center.
On the Security Center page, click Resource Group Management in the navigation pane on the left.
On the Resource Group Management page, select the target instance name, and click Add Resource Group.
In the Add Resource Group dialog box, enter a Resource Group Name, set the Resource Group Quota, and click OK.

Note
The sum of the quotas for all resource groups in a Hologres instance cannot exceed 1. If the sum exceeds 1, an error is reported.

Delete a resource group

Go to the HoloWeb developer page. For more information, see Connect to HoloWeb.
In the top menu bar of the HoloWeb developer page, click Security Center.
On the Security Center page, click Resource Group Management in the navigation pane on the left.
On the Resource Group Management page, find the resource group that you want to delete and click Delete in the Actions column.

Note
You cannot delete a resource group if users are attached to it.

Adjust a resource group quota

Go to the HoloWeb developer page. For more information, see Connect to HoloWeb.
In the top menu bar of the HoloWeb developer page, click Security Center.
On the Security Center page, click Resource Group Management in the navigation pane on the left.
On the Resource Group Management page, find the target resource group and click Adjust Quota in the Resource Group Quota column.
In the Adjust Quota dialog box, change the resource group quota and click OK.

Attach a user

After you create a resource group, you can use the HoloWeb graphical interface to attach users to it.

Go to the HoloWeb developer page. For more information, see Connect to HoloWeb.
In the top menu bar of the HoloWeb developer page, click Security Center.
On the Security Center page, click Resource Group Management in the navigation pane on the left.
On the Resource Group Management page, find the target resource group and click Associate User in the Actions column.
On the Attach to Resource Group page, click Add User for Association.
In the Associate User dialog box, select a user and click OK.
Note
- If you cannot find the user account in the drop-down list, the account has not been added to the current instance. You can go to the user management page to add the user.
- A user can be attached to only one resource group. If you attach a user to a new resource group, the user is automatically detached from the previous one.

Detach a user

Go to the HoloWeb developer page. For more information, see Connect to HoloWeb.
In the top menu bar of the HoloWeb developer page, click Security Center.
On the Security Center page, click Resource Group Management in the navigation pane on the left.
On the Resource Group Management page, find the target resource group and click Associate User in the Actions column.
On the Attach to Resource Group page, find the user that you want to detach and click Disassociate User in the Actions column.
In the Disassociate User dialog box, click OK.

Related SQL statements

Resource group-based isolation for a single instance (deprecated).