This topic describes how to create a tenant. In OceanBase Cloud, a tenant is similar to a common database management system and can be considered as a database instance. You can create a user tenant in the sys tenant based on business needs. The characteristics of a user tenant are the same as those of a database instance.
Prerequisites
You have created a cluster instance. For more information, see Create an instance.
Procedure
Log in to the OceanBase Cloud console.
In the left-side navigation pane, click Instances.
In the instance list, click the name of the target cluster instance to go to the Overview page of the instance.
In the upper-right corner of the page that appears, click Create Tenant.
Configure the tenant parameters based on the actual situation.
Parameter Description Tenant Name The name of the tenant. 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 mode of the tenant. Valid values: MySQL Compatible and Oracle Compatible. Number of Units The number of resource units of the tenant. OceanBase Database manages physical resources based on resource units. A resource unit is a collection of physical resources such as CPU, memory, disk space, and IOPS. Each resource unit contains three nodes. Three nodes are added each time you add a resource unit. Unit Specification The CPU and memory capacities on a single node of the tenant. Note
- The total CPU and memory capacities of all tenants cannot exceed the specifications of the cluster to which they belong.
- Total available resources of a tenant = Resources on a single node × Number of resource distribution nodes × Number of replicas
Character Set The character set of the tenant. - The utf8mb4, utf16, gbk, gb18030, and binary character sets are supported for a MySQL-compatible tenant.
- The utf8 and gbk character sets are supported for an Oracle-compatible tenant.
Table Name Case Sensitivity Specifies whether to enable case sensitivity for table names. Note
You must enable this parameter when Tenant Mode is set to
MySQL Compatible. By default, table names are case-insensitive.Time Zone The time zone of the tenant. Primary Zone The primary zone of the tenant. Remarks (Optional) Additional information about the tenant. The remarks cannot exceed 30 characters in length. Click Create. You can view the progress of tenant creation on the Instances page.