Description
You can execute the CREATE RESOURCE POOL statement to create a resource pool. A resource pool represents a set of resource units that can be assigned to tenants.
Syntax
CREATE RESOURCE POOL poolname
UNIT [=] unitname,
UNIT_NUM [=] unitnum,
ZONE_LIST [=] ('zone' [, 'zone' ...]) ;
Parameters
| Parameter | Description |
|---|---|
| UNIT | The name of the resource unit that you want to create. |
| NIT_NUM | The number of resource units that you want to create in a zone. The value must be smaller than the number of OBServers in the zone. |
| ZONE_LIST | The cluster to which the resource pool that you want to create belongs. |
Examples
- Create resource pool pool1 in cluster zone1.
OceanBase(admin@test)> CREATE RESOURCE POOL pool1 unit='unit1', unit_num=1, zone_list=('zone1');
Query OK, 0 rows affected (0.01 sec)