Create a primary tenant

A tenant can be seen as a container for database objects and resources such as CPU, memory, and I/O resources. You can create a primary tenant in a cluster based on business needs.

You can create a primary tenant in the following ways in the OceanBase Cloud Platform (OCP) console:

• Create a primary tenant on the Tenants page.

• Create a primary tenant on the Tenant Management page of a specified cluster.

This topic describes how to create a primary tenant on the Tenants page.

Prerequisites

• The cluster where you want to create a tenant is the running primary cluster.

• You have logged on with an account that has the permissions to manage the cluster. For example, you act as the system administrator or the OCP tenant administrator.

• Optional. You have created a parameter template by referring to Manage tenant parameter templates.

  When you need to create multiple tenants with the same parameter configuration, you can use a parameter template to avoid repeatedly configuring the same parameters.

• The following conditions are met before you enable the arbitration service for a tenant:

  • The arbitration service is added for the cluster to which the tenant belongs, and the service is in the RUNNING state.

  • The locality of the tenant includes two or four full-featured replicas.

  • The resources available on the server hosting the arbitration service meet the resource requirements.

    You can modify the resource requirements by using the following system parameters based on your business requirements. For more information, see Modify system parameters.

    • ocp.arbitration.min.remain.disk.size: the minimum size in MB of the clog disk on the arbitration service host required when the arbitration service is enabled for the tenant. The parameter value is in the (a,b) format, indicating the minimum clog disk sizes required when the tenant has two and four full-featured replicas, respectively. Default value: [12,24].
    • ocp.arbitration.max.cpu.used.percentage: the maximum CPU utilization in percentage (%) allowed on the arbitration service host when the arbitration service is enabled for the tenant. Default value: 90.
    • ocp.arbitration.max.memory.used.percentage: the maximum memory usage in percentage (%) allowed on the arbitration service host when the arbitration service is enabled for the tenant. Default value: 90.

Procedure

1. Log on to the OCP console.

2. In the left-side navigation pane, click Tenants. The Tenants page appears.

3. Click Create Tenant in the upper-right corner.

   

4. Configure the parameters in the Basic Information section. The required parameters and their descriptions are listed in the following table.

   Parameter	Description
   Tenant Type	Select Primary Tenant. Note If the tenant version is earlier than OceanBase Database V4.2, you cannot select a tenant type. The default value is Primary Tenant.
   Select Cluster	Select a cluster for the tenant. Note When you create a primary tenant on the Tenant Management page of a specified cluster, the current cluster is used by default.
   Tenant Name	The tenant name must be 2 to 64 characters in length and can contain letters, digits, and underscores (_).
   Administrator Password	The password of the tenant administrator account, which can be randomly generated. The administrator account is root in MySQL mode. The administrator account is SYS in Oracle mode. The password must meet the following requirements: The length is 8 to 32 characters. The password contains at least three of the following character types: digits(0~9), uppercase letters(A~Z), lowercase letters(a~z), and special characters (ie: ~!@#%^&*_-+=|(){}[]:;,.?/).
   Character Set and Encoding	In MySQL mode, the supported character sets are utf8mb4, binary, gbk, gb18030, and latin1. The default character set is utf8mb4 in MySQL mode. In Oracle mode, the supported character sets are utf8mb4, gbk, and gb18030. The default character set is utf8mb4 in Oracle mode.
   Collation	The detailed collation corresponding to the specified character set.
   Remarks	This parameter is optional and allows you to add additional information.

   

5. Configure the parameters in the Replica Settings section.

   By default, the system displays configurable zones based on the zone information of the selected cluster. If you do not need to create a replica in a zone, click the Delete icon to delete the zone. The zone information parameters that need to be configured and their descriptions are listed in the following table.

   Parameter	Description
   Replica Type	The type of the replica. Valid values: Full-featured Replica Read-only Replica Log Replica Select multiple full-featured replicas to ensure that they are in the majority. Note In a standalone centralized database, only full-featured replicas are supported.
   Unit Specification	OCP has a set of built-in unit specifications. You can select the specifications that you need from the list of unit specifications or click Add Specification at the bottom of the list to add custom specifications. For more information, see OCP resource unit specifications. Notice We recommend that you set the same specifications and number of units for full-featured replicas. Different specifications or numbers of units can affect performance or stability. If the OceanBase Database version of the cluster is V4.0.0 or later, take note of the following considerations: You cannot configure less than one CPU core for the tenant. By default, the cluster limits the minimum memory size. You can adjust the limit by modifying the __min_full_resource_pool_memory parameter. For example, if the version is V4.1.0, you can modify the parameter by referring to Modify cluster parameters.
   Units	The number of units in the zone. The number of resource units cannot exceed the number of OBServer nodes in the zone. If the cluster version is OceanBase Database V4.0 or later, you can only set the same number of units for all zones, which is 1 by default. If the cluster version is earlier than OceanBase Database V4.0, you can set different numbers of units for different zones. Note In a standalone centralized database, the default number of units is 1, which cannot be modified.
   Zone Priority Rankings	Specifies whether to define priorities for the zones of the tenant. The priorities affect the priority of the primary zone of the sys tenant. If this parameter is not specified, the zone priorities of the sys tenant are used by default. If Zone Priority Rankings is enabled while no zone priorities, the random priority is used. To configure zone priorities, you can select one or more zones from the list on the left that displays all zones in the current cluster and add the selected zones to the list on the right. By default, the priority of a zone added earlier is higher than that of a zone added later, and the zones added at the same time have the same priority. After you move the zones to the box on the right side, you can also drag them upward or downward to adjust their priority order. A zone takes priority over those beneath it. Note In a standalone centralized database, the zone priority rankings are not displayed, and Zone1 has the highest priority.

   

6. Configure the parameters in the Security Settings section.

   • Access from all IP addresses is supported: This tenant can be accessed by any IP address.

     Notice

     This mode causes access security risks. Proceed with caution.

   • Custom: You can add allowed clients into the allowlist in the formats described in the following table. Example:

     Format	Example
     IP address	xxx.xxx.xxx.1,xxx.xxx.xxx.2
     Subnet/Mask	xxx.xxx.xxx.1/24
     Fuzzy match	xxx.xxx.xxx.% or xxx.xxx.xxx._
     Mixed	xxx.xxx.xxx.1,xxx.xxx.xxx.2,xxx.xxx.xxx.%,xxx.xxx.xxx._,xxx.xxx.xxx.1/24
     %	% indicates that all clients can connect to this tenant.

     Notice

     You must add the IP addresses of the OCP and OBProxy servers to the allowlist. Otherwise, you cannot manage the tenant from OCP.

   

7. Enable Parameter Configurations and configure the tenant parameters.

   • You can click the button in section ① of the following figure to add startup parameters one by one and set their values.

   • You can also click Select Parameter Template as shown in section ② of the following figure and select a parameter template. The system will automatically populate parameters in this section by using the template.

   Note

   • If you are creating a tenant in MySQL mode by using a parameter template that contains parameters that are valid only in Oracle mode, you must manually delete those parameters.
   • If no tenant parameter template is available, you can click Create Tenant Parameter Template to create one. For more information, see Manage tenant parameter templates.

   

8. Click Submit. The page that appears prompts you that the tenant creation task has been submitted and displays the summary information of the task.

   • To view the task details, click View Task Details.

   • To return to the Tenants list, click Return to Tenants List. In the Tenants list, you can view the status and task details of the new tenant, and delete the tenant if the tenant creation failed.

     

   Note

   When the task status is Completed, you can check the status of the new tenant in the Tenants list on the Tenant Management page. The new tenant is created if its status is Running.