This topic describes how to create a resource group in the resource isolation feature.
Prerequisites
- The OceanBase Cloud account used has the Project Admin or Instance Admin roles.
- The OceanBase database version is V4.2.1.8 or later. For more information about the database versions, see Database support versions.
Procedure
Go to the resource isolation page.
Log in to the OceanBase Cloud console.
In the left-side navigation pane, click Instances.
In the instance list, expand the target instance and click the tenant name to go to the Overview page of the tenant.
In the left-side navigation pane of the Overview page of the tenant, click Resource Isolation.
On the resource isolation page, click the tab Resource Group.
On this tab, click Create Resource Group.
Specify the parameters in the following table.
Parameter Description Resource Group Name The name of the resource group. Resource Isolation Method - Database Account Isolation: Specifies the mapping relationship between users and resource groups. This way, all SQL statements executed by the user use the resources allocated to the corresponding resource group. This feature allows different users to perform different types of tasks.
- Background Task Isolation: Specifies the mapping relationship between background tasks and resource groups to isolate the resources used by each task. For the types of tasks supported by this feature, see the Supported background tasks for resource isolation section below.
Database Account When you set the Database Account Isolation method, select a database account from the drop-down list. Background Task When you set the Background Task Isolation method, select a background task that requires resource isolation from the drop-down list. Remarks You can enter remarks about the resource group. Click OK. After the resource group is created, you can configure resource rules for it. For more information, see Create a resource rule.
Supported background tasks for resource isolation
| Task Name | Description |
|---|---|
| COMPACTION HIGH | Mini Merge and DDL KV Merge tasks |
| COMPACTION_LOW | Major Merge tasks |
| COMPACTION_MID | Minor Merge tasks |
| HA_LOW | Low-priority reliable tasks such as backup and backup cleanup |
| HA_MID | Medium-priority reliable tasks such as migration |
| HA_HIGH | High-priority reliable tasks such as replication, rebuild, and restore |
| DDL | Tasks for scenarios such as unique index verification and column deletion with data supplementation |
| DDL_HIGH | Minor compaction task for DDL MemTable |
| SQL_AUDIT | SQL audit log persistence |
| MVIEW | Materialized view background tasks |
| REPLAY_HIGH | Log replay |
| CLOG_HIGH | Tasks such as writing clog to local disk, uploading clog files to shared storage, and reading local disk by Follower replicas |
| CLOG_LOW | Physical standby and CDC reading tasks |
| CLOG_MID | Tasks such as Follower replica reading from shared storage and log archiving reading from local disk |
| OPT_STATS | Statistics collection tasks |
| GC_MACRO BLOCK | Macro block reclamation and reuse tasks |