ApsaraDB for OceanBase:Resource isolation

Background information

The resource isolation feature classifies a tenant's resources into multiple logical units. Even if individual units overuse resources, they will not occupy the resources required by other units. Reasonable use of resource control features can also reduce the number of clusters, reduce operation and maintenance difficulties and management costs.

At present, ApsaraDB for OceanBase isolates resources through resource groups, and then assigns accounts to resource groups for resource use.

Prerequisites

• You have enabled resource isolation when purchasing instances.

  Note

  At present, the resource isolation feature is available only for customers on the allowlist. For more information, see Isolation Optimization.

• The database version must meet the following requirements:

  • If your database is of the 3.x series, the database version must be V3.2.4 or higher, and the CPU must be at least 14C.

  • If your database is of the 4.x series, the database version must be V4.2.1 or higher, and the CPU must be at least 8C.

Manage a resource group

1. Log on to the ApsaraDB for OceanBase console.

2. In the left-side navigation pane, click Instances.

3. On the Instances page, click the name of the target cluster instance to go to the Cluster Instance Workspace page.

4. (Optional) When using the resource isolation feature for the first time, you need to turn on the resource isolation feature switch on the Cluster Instance Workspace.

   1. Click Enable next to Tenant resource isolation.

      

   2. In the dialog box that appears, confirm the precautions for enabling resource isolation and click OK.

      Important

      When the resource isolation feature is being enabled, the instance will restart. Please ensure that the application has a reconnection mechanism and operate with caution.

      

5. In the left-side navigation pane, click Tenant Management. In the tenant list, click the target tenant to go to the Tenant Workspace page.

6. In the left-side navigation pane, click Resource Management.

7. View resource group information on the resource management page.

   • Create a resource group

   • Edit a resource group

   • Delete a resource group

Create a resource group

1. On the Resource Group Management page, click Create Resource Group.

   

2. In the pop-up window, configure parameters for the resource group.

   Parameter	Description
   Resource Group Name	The name of a resource group.
   Isolated Object	You can select to isolate Database Account or Background Task. This is used to specify the mapping relationship so that all resources used by the SQL statements from a user or task are the resources of the corresponding resource group.
   Database Account	Select the account assigned to the resource group from the drop-down list.
   Background Task	Select the background task assigned to the resource group from the drop-down list.
   CPU Usage Cap	The maximum proportion of CPU usage allowed for the resource group. Note The CPU usage cap for each resource group can be set to a maximum of 100%. When there is resource contention between resource groups, the system will allocate resources based on the ratio of the weights of each resource group.
   IOPS Usage Upper and Lower Limits	The maximum proportion of IO resources allowed for the resource group. Note The IOPS usage upper limit for each resource group can be set to a maximum of 100%. When there is resource contention between resource groups, the system will allocate resources based on the ratio of the weights of each resource group.
   Remarks	The remarks for the resource group.

3. Click OK. After the resource group is successfully created, the resource isolation feature takes effect.

Edit a resource group

1. On the Resource Group Management page, find the target resource group and click Edit in the Actions column.

   

2. In the pop-up window, configure parameters for the resource group.

   Parameter	Description
   Isolated Object	You can select to isolate Database Account or Background Task. This is used to specify the mapping relationship so that all resources used by the SQL statements from a user or task are the resources of the corresponding resource group.
   Database Account	Select the account assigned to the resource group from the drop-down list.
   Background Task	Select the background task assigned to the resource group from the drop-down list.
   CPU Usage Cap	The maximum proportion of CPU usage allowed for the resource group. Note The CPU usage cap for each resource group can be set to a maximum of 100%. When there is resource contention between resource groups, the system will allocate resources based on the ratio of the weights of each resource group.
   IOPS Usage Upper and Lower Limits	The maximum proportion of IO resources allowed for the resource group. Note The IOPS usage upper limit for each resource group can be set to a maximum of 100%. When there is resource contention between resource groups, the system will allocate resources based on the ratio of the weights of each resource group.

3. Click OK.

Delete a resource group

1. On the Resource Group Management page, find the target resource group and click Delete in the Actions column.

   

2. In the pop-up dialog box, click Delete.