All Products
Search
Document Center

CREATE RESOURCE POOL

Last Updated: Jun 18, 2021

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)