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.
CREATE RESOURCE POOL poolname UNIT [=] unitname, UNIT_NUM [=] unitnum, ZONE_LIST [=] ('zone' [, 'zone' …]) ;
The name of the resource unit that you want to create.
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.
The cluster to which the resource pool that you want to create belongs.
- 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)