A tenant is a logical concept in OceanBase Database and serves as the unit for resource allocation, as well as the foundation for managing database objects and resources. On the Overview page of the tenant, you can view information such as the tenant 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 of the instance.
In the left-side navigation pane, click Tenants.
In the tenant list, click the target tenant to go to the Overview page of the tenant.
You can perform operations such as creating an account, connecting to a database, accessing the SQL console, importing sample data, importing a data file, migrating data, modifying the tenant name, modifying the tenant specifications, switching to a new primary zone, and deleting the tenant. For more information, see Create an account, Connect to a database, Log in to the SQL console, Import data, Migrate data, Modify the tenant name, Modify the tenant specifications, Switch to a new primary zone, and Delete a tenant.
You can view the resource capacity, tenant mode, primary zone, etc. in the basic information section of the tenant.
Parameter Description Compatibility Mode Displays the tenant's mode. Supported modes: MySQL-compatible tenant and Oracle-compatible tenant. Primary Zone Shows the primary zone information of the tenant. Time Zone Displays or modifies the tenant's time zone configuration. Parameter Template Pre-configured templates include: OLTP Simple Transactions, OLTP Complex Transactions, HTAP Mixed Workloads, OLAP Online Analytics. For details, see Parameter template overview. Maximum Available IOPS The maximum available IOPS of the tenant. Note
In the current version, only instances purchased through Alibaba Cloud, Huawei Cloud, and AWS support viewing IOPS information.
Major Compaction Displays the daily major compaction schedule for tenant data. Character Set Indicates the tenant's character set. Collation Specifies the tenant's collation rules. Remarks Free-text notes (max 30 characters). In the Performance Monitoring section, you can view the QPS, TPS, and average SQL query processing time in the last hour.
Monitoring Item Metric Unit Description QPS sql_all_count time/s The number of SQL queries processed per second. TPS transaction_count time/s The number of transactions processed per second. Average SQL Query Processing Time sql_all_rt ms The average SQL query processing time. In the Deployment Topology section, you can view the proxy information and zone information of the current tenant, and perform the following operations:
- You can click Get Endpoint to create a private endpoint. For more information, see Connect to a database.
After the private endpoint is configured, you can hover the pointer over View Endpoint Information to view the endpoint ID, and click the
icon on the right to copy the endpoint ID.Hover the pointer over the primary endpoint card. A delete icon appears in the upper-right corner of the card. Click the delete icon to delete the endpoint configuration of the private endpoint. You can also click the
icon next to the public endpoint to copy the public endpoint.Note
Before you delete an endpoint, make sure that no other services are connected to this endpoint. Otherwise, the service may become unavailable. Proceed with caution.
After the private endpoint is configured, you can click Add Endpoint in the upper-right corner of the deployment topology to add an endpoint for the proxy layer. For more information, see Add an endpoint.
Related operations
On the Overview page of the tenant, you can perform the following actions:
Click the Connect button 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 import sample data, import data files, migrate data, modify the tenant name, modify the tenant specification, switch the primary zone, or delete the tenant. For more information, see Import data, Migrate data, Modify the tenant name, Modify the tenant specification, Switch the primary zone, and Delete a tenant.
To modify the Binlog configuration or disable the Binlog service, click the More actions icon next to Binlog and select an option. For more information, see Manage Binlog.