Hologres:Manage resource groups (deprecating)

Prerequisites

Before you begin, make sure that you have:

• A Hologres instance running V1.1 or later. If your instance runs an earlier version, upgrade it first. If the upgrade fails, see Common errors that occur when you prepare for an upgrade or contact support

• Superuser permissions on the instance. Without superuser permissions, all resource group operations return a permission denied error

Limitations

• Instances of the compute group type do not support resource group management. To isolate resources for these instances, divide resources into multiple compute groups instead.

• Compute resources are scoped to the instance level. All databases in an instance share the same compute resources and resource allocation plan.

Navigate to resource group management

All operations in this topic start from the same page. To get there:

1. Go to the HoloWeb developer page. For more information, see Connect to HoloWeb.

2. In the top menu bar, click Security Center.

3. In the left navigation pane, click Resource Group Management.

4. On the Resource Group Management page, select the target instance.

Create a resource group

1. Navigate to resource group management and click Add Resource Group.

   

2. In the Add Resource Group dialog box, enter a Resource Group Name, set the Resource Group Quota, and click OK.

The sum of all resource group quotas in an instance cannot exceed 1. An error is reported if the total exceeds this limit.

Delete a resource group

You cannot delete a resource group that has users attached to it. Detach all users first.

1. Navigate to resource group management.

2. Find the resource group you want to delete and click Delete in the Actions column.

Adjust a resource group quota

1. Navigate to resource group management.

2. Find the target resource group and click Adjust Quota in the Resource Group Quota column.

3. In the Adjust Quota dialog box, change the quota value and click OK.

   

Attach a user

Each user can belong to only one resource group. Attaching a user to a new resource group automatically detaches them from the previous one.

1. Navigate to resource group management.

2. Find the target resource group and click Associate User in the Actions column.

3. On the Attach to Resource Group page, click Add User for Association.

4. In the Associate User dialog box, select a user and click OK.

If the user account does not appear in the drop-down list, the account has not been added to the instance yet. Add the user on the user management page first.

Detach a user

1. Navigate to resource group management.

2. Find the target resource group and click Associate User in the Actions column.

3. On the Attach to Resource Group page, find the user you want to detach and click Disassociate User in the Actions column.

4. In the Disassociate User dialog box, click OK.

What's next

To manage resource groups using SQL statements instead of the graphical interface, see Resource group-based isolation for a single instance (deprecated).