A tenant is a logical concept. In OceanBase Database, it is the unit for resource allocation and serves as the foundation for database object management and resource management. After entering the tenant details page, you can view information such as the tenant's details, connection information, and accounts.
Procedure
Log in to the OceanBase Cloud console.
In the left-side navigation pane, click Instances.
In the instance list, find the target instance and click its name to go to the Overview page.
In the left-side navigation pane, click Tenants.
In the tenant management list, click the target tenant to go to the Tenant Workspace page.
In the Basic Information section, you can view information such as capacity resources, tenant mode, primary zone, and remarks.
ParameterDescriptionCompatibility Mode Displays the compatibility mode selected for the current tenant. The following compatibility modes are supported: - MySQL Compatible: Highly compatible with MySQL syntax and supports the MySQL protocol. Suitable for scenarios such as online transactions and web applications.
- Oracle Compatible: Highly compatible with Oracle syntax and supports PL/SQL. Suitable for core business systems migrating from Oracle.
- HBase API compatibility mode: Compatible with HBase APIs and supports wide-table storage. Suitable for scenarios such as massive data storage, time-series data, and log storage.
- Table API compatibility mode: Provides the Table API interface and supports structured data storage. Suitable for scenarios such as key-value storage and metadata management.
Primary zone Displays the primary zone information of the current tenant. Time Zone Displays or modifies the time zone of the current tenant. Parameter Template Currently supports parameter templates for OLTP simple transactions, OLTP complex transactions, HTAP mixed workloads, and OLAP online analytics. For more information, see Parameter template description. Maximum Available IOPS When shown, this field lists the tenant’s IOPS limit. Major Compaction Displays the daily major compaction times for the current tenant. Character Set Displays the character set of the current tenant. Collation Displays the collation of the current tenant. Tag Displays or adds tags for the tenant. Remarks The length of the remarks cannot exceed 30 characters. In the Performance Monitoring section, you can view the QPS, TPS, and average processing time of SQL statements in the last hour.
Monitoring ItemMetric IDUnitDescriptionQPS sql_all_count times/s The number of SQL statements processed per second. TPS transaction_count times/s The number of transactions processed per second. Average SQL Statement Processing Time sql_all_rt ms The average processing time of SQL statements. In the Deployment Diagram section, you can view the proxy information and zone information of the current tenant, and perform the following operations:
In the primary endpoint section, view connection information, including the public endpoint, private endpoint, and peering connection endpoint. For details, see Connect to a database.
After configuring the address, hover over the primary endpoint, access endpoint, or direct endpoint card to view basic endpoint information. Hover your mouse over the target address to display the corresponding operation buttons, which allow you to copy, edit, or delete the address.
Note
- Before deleting, ensure no other services are connected to this endpoint; otherwise, service unavailability may occur. Proceed with caution.
- Only IP addresses in the allowlist can access the database of the current tenant. For allowlist configuration, see Set up tenant allowlist groups.
After the private endpoint is configured, click Add Endpoint in the upper-right corner of the deployment diagram to add a read-only or read/write splitting endpoint. Once the endpoint is created, its card and connection information appear in the deployment diagram. For more information, see Add an endpoint.
Related operations
You can perform the following operations in the tenant workspace:
Click Connect in the upper-right corner to obtain the connection string and connect to the SQL console. For more information, see Connect to a database and Log in to the SQL console.
Click Create Account in the upper-right corner to create a new tenant account. For more information, see Create an account.
Click Create Database in the upper-right corner to create a new database. For more information, see Create a database.
Click the More icon ··· in the upper-right corner to perform the following operations: Import sample data, Import data files, Modify tenant name, Modify tenant specifications, Modify primary zone, and Delete tenant.
To modify the Binlog configuration or disable the Binlog service, click the operation icon next to Binlog. For more information, see Binlog related operations.