You can use resource groups to partition and manage an instance's computing resources. This topic describes how to manage resource groups in HoloWeb, including creating and deleting groups, adjusting quotas, and managing user associations.
Background
While Hologres V1.0 and earlier support instance-level resource isolation, they do not support fine-grained, user-level isolation within an instance. In production environments, you often need to isolate resources for each user within an instance and cap the resources that each user can consume to prevent their jobs from interfering with one another. To provide this fine-grained isolation, Hologres introduced resource groups to manage computing resources and implement resource isolation within an instance. HoloWeb provides a graphical interface to manage these resource groups.
Limitations
Only Hologres V1.1 and later versions support using resource groups to manage computing resources within a Hologres instance. If your instance is an earlier version, see Troubleshoot upgrade preparation failures or join the Hologres DingTalk group for support. For more information, see How can I get more online support?.
Only users with superuser privileges can use resource groups to manage computing resources in a Hologres instance. Otherwise, you will receive an "insufficient permissions" error.
Computing resources are allocated at the instance level. If a user has multiple databases within an instance, they all share the instance's computing resources and the same resource allocation plan.
Instances of the virtual warehouse type do not support resource group management. Instead, create multiple virtual warehouses to achieve resource isolation.
Create resource group
Go to the HoloWeb development page. For more information, see Connect to HoloWeb.
In the top navigation bar, 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 then click OK.
NoteThe total quota of all resource groups within a Hologres instance cannot exceed 1.0; otherwise, an error is reported.
Delete resource group
Go to the HoloWeb development page. For more information, see Connect to HoloWeb.
In the top navigation bar, 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 to delete and click Delete in the Actions column.
NoteYou cannot delete a resource group that has associated users.
Adjust resource group quota
Go to the HoloWeb development page. For more information, see Connect to HoloWeb.
In the top navigation bar, 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 to modify and click Adjust Quota in the Resource Group Quota column.
In the Adjust Quota dialog box, modify the resource group quota and click OK.
The resource group quota must be a value between 0.1 and 0.9, inclusive, and accurate to one decimal place.
Associate user
After creating a resource group, associate users with it in HoloWeb.
Go to the HoloWeb development page. For more information, see Connect to HoloWeb.
In the top navigation bar, 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 to manage and click Associate User in the Actions column.
On the Associate Resource Group page, click Add User for Association.
In the Associate User dialog box, select a user and click OK.
NoteIf a user does not appear in the drop-down list, they have not yet been added to the instance. You must first add them on the User Management page.
A user can be associated with only one resource group. Associating a user with a new resource group overwrites the previous association.
Disassociate user
Go to the HoloWeb development page. For more information, see Connect to HoloWeb.
In the top navigation bar, 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 to manage and click Associate User in the Actions column.
On the Associate Resource Group page, find the user to disassociate and click Disassociate User in the Actions column.
In the Disassociate User dialog box, click OK.