All Products
Search
Document Center

Hologres:Manage resource groups (Beta)

Last Updated:May 16, 2023

Hologres provides the resource group management feature. You can use this feature to divide computing resources into multiple resource groups for better resource management and utilization. This topic describes how to use HoloWeb to create or delete resource groups, adjust the resource group quota, and bind or unbind users to resource groups.

Background information

Hologres V1.0 and earlier support resource isolation among instances, but do not support the fine-grained resource isolation among users in a specific instance. However, many scenarios require a limit on the resources available to each user in an instance to prevent interference. In these cases, resource isolation among users in an instance is needed. To meet this need, Hologres provides the resource group management feature. You can use this feature to isolate and manage computing resources in an instance in a visualized manner.

Limits

  • Only Hologres V1.1 and later allow you to use resource groups to manage computing resources in a Hologres instance. If the version of your Hologres instance is earlier than V1.1, manually upgrade your Hologres instance in the Hologres console or join the DingTalk group 32314975 for technical support. For more information about how to manually upgrade your Hologres instance in the Hologres console, see Instance upgrade.

  • Only a superuser can use resource groups to manage computing resources in a Hologres instance. If a regular user attempts to use the resource group management feature, an error is reported to indicate that the user does not have sufficient permissions.

  • In Hologres, computing resources are allocated based on instances. If you have multiple databases in an instance, all the databases share the computing resources of the instance and have the same quota.

Create a resource group

Use HoloWeb to create a resource group in a visualized manner.

  1. Log on to the HoloWeb console. For more information, see HoloWeb quick start.

  2. In the HoloWeb console, click Security Center in the top navigation bar.

  3. On the Security Center page, click Resource Group Management in the left-side navigation pane.

  4. On the Resource Group Management page, select the instance that you want to manage from the Instance Name drop-down list and click Add Resource Group.

    Create a resource group
  5. In the Add Resource Group dialog box, set the Resource Group Name and Quota parameters and click OK.

    Note

    The total quota of all resource groups in a Hologres instance cannot exceed 1. Otherwise, the system reports an error.

Delete a resource group

  1. Log on to the HoloWeb console. For more information, see HoloWeb quick start.

  2. In the HoloWeb console, click Security Center in the top navigation bar.

  3. On the Security Center page, click Resource Group Management in the left-side navigation pane.

  4. On the Resource Group Management page, find the resource group that you want to delete and click Delete in the Operation column.

    Note

    If a user is bound to the resource group, the resource group cannot be deleted.

Adjust the resource group quota

  1. Log on to the HoloWeb console. For more information, see HoloWeb quick start.

  2. In the HoloWeb console, click Security Center in the top navigation bar.

  3. On the Security Center page, click Resource Group Management in the left-side navigation pane.

  4. On the Resource Group Management page, find the resource group whose quota you want to adjust and click Adjust Quota in the Resource Group Quota column.

  5. In the Adjust Quota dialog box, adjust the quota and click OK.

Bind a user to the resource group

After you create a resource group, you can use HoloWeb to bind a user to the resource group in a visualized manner.

  1. Log on to the HoloWeb console. For more information, see HoloWeb quick start.

  2. In the HoloWeb console, click Security Center in the top navigation bar.

  3. On the Security Center page, click Resource Group Management in the left-side navigation pane.

  4. On the Resource Group Management page, find the resource group to which you want to bind a user and click Associate User in the Operation column.

  5. On the page that appears, click Add User for Association.

  6. In the Associate User dialog box, select a user from the drop-down list and click OK.

    Note
    • If you cannot find the user that you want to bind to the resource group in the drop-down list, the user is not added to the current instance. In this case, add the user on the User Management page.

    • A user can be bound to only one resource group. If you repeatedly bind a user to different resource groups, the last resource group prevails.

Unbind a user from a resource group.

  1. Log on to the HoloWeb console. For more information, see HoloWeb quick start.

  2. In the HoloWeb console, click Security Center in the top navigation bar.

  3. On the Security Center page, click Resource Group Management in the left-side navigation pane.

  4. On the Resource Group Management page, find the resource group to which you want to bind a user and click Associate User in the Operation column.

  5. On the page that appears, find the user that you want to unbind and click the Disassociate User in the Operation column.

  6. In the Disassociate User message, click OK.

Related SQL statements

For more information, see Isolate computing resources in a Hologres instance (beta).