Tenants lay the foundation for database object management and resource management. They serve as containers for both database objects and resources such as CPU, memory, and I/O resources. You can create and manage tenants in the OceanBase management console.
Prerequisites
Procedure
Log on to the OceanBase management console.
In the left-side navigation pane, click Clusters.
On the Clusters page, click the name of the target cluster to go to the Cluster Workspace page.
Click Create Tenant in the upper-right corner of the page.
Set the parameters for creating the tenant as required.
Parameter
Description
Tenant Name
The tenant name.
The tenant name must start with a letter or an underscore (_), and contain 2 to 20 characters, which can be uppercase letters, lowercase letters, digits, and underscores (_). It cannot be set to sys.
Tenant Mode
The tenant mode, which can be Oracle or MySQL.
Tenant Specifications
The CPU and memory capacities of the tenant.
NoteThe total CPU and memory capacities of all tenants cannot exceed the specifications of the cluster to which they belong.
Character Set
The character set to be used in the database, which can be UTF8MB4 or GBK.
Time Zone
The time zone information.
Access to VPC
The ID of the VPC to which the ECS instance belongs.
If no suitable VPC is available, create a VPC as prompted.
Primary Zone
The primary zone of the tenant. We recommend that you create the tenant in the same zone as the database access service.
Access to vSwitch
The ID of the vSwitch to which the ECS instance belongs.
If no suitable vSwitch is available, create a vSwitch as prompted.
- (Optional)
Enter the remarks.
The remarks must be 1 to 30 characters in length. Click Create.