OceanBase
English日本語简体中文
Docs Home
Products
Integrations
Release Notes

Databases

OceanBase DatabaseOceanBase Cloud OceanBase Best Practices

Tools

OceanBase Cloud PlatformOceanBase Migration ServiceOceanBase Developer CenterOceanBase Migration AssessmentOceanBase Admin ToolOceanBase Loader and DumperOceanBase DeployerKubernetes operator for OceanBaseOceanBase Diagnostic Tool OceanBase Binlog Service

Connectors and Middleware

OceanBase Database Proxy OceanBase Connector/C OceanBase Connector/J OceanBase Connector/ODBC OceanBase Connector/NETOceanBase Command-Line Client

Databases

OceanBase DatabaseOceanBase Cloud OceanBase Best Practices

Connectors and Middleware

OceanBase Database Proxy OceanBase Connector/C OceanBase Connector/J OceanBase Connector/ODBC OceanBase Connector/NETOceanBase Command-Line Client

Tools

OceanBase Cloud PlatformOceanBase Migration ServiceOceanBase Developer CenterOceanBase Migration AssessmentOceanBase Admin ToolOceanBase Loader and DumperOceanBase DeployerKubernetes operator for OceanBaseOceanBase Diagnostic Tool OceanBase Binlog Service
OceanBase DatabaseOceanBase Cloud ToolsConnectors and MiddlewareLifecycle Support Policy

OceanBase Cloud

  • Product Updates & Announcements
    • What's new
      • Release notes for 2026
      • Release notes for 2025
      • Release notes for 2024
      • Release history
    • Product announcements
      • Notice of underlying component upgrades for OceanBase Cloud database proxy clusters on Alibaba Cloud
      • AI Service Model Launch and Delisting Notice
      • Data development module deprecation notice
      • Optimization of Backup and Restore commercialization strategy
      • Database proxy billing update
      • AWS instance pricing adjustment
      • Billing notice for limited-time free OMS instances
      • Notice of cross-AZ data transfer billing adjustments (OceanBase Cloud on AWS)
  • Product Introduction
    • Overview
    • Management mode and scenarios
    • Core features
      • High availability with cross-cloud active-active architecture
      • High availability with cross-cloud primary-standby databases
      • Multi-layer online scaling and on-demand adjustment
    • Deployment modes
    • Product specifications
    • Product billing
      • Overview
      • Instance billing
        • Alibaba Cloud instance billing
        • Huawei Cloud instance billing
        • AWS instance billing
        • Google Cloud instance billing
        • Azure instance billing
      • Backup and restore billing
      • SQL audit billing
      • Migrations billing
      • Database proxy billing
      • Binlog service billing
      • Read-only replica billing
      • AI model billing
    • Supported database versions
  • Get Started
    • Quick start with Flagship Edition
    • Create a Flagship Edition cluster instance
    • Create a tenant
    • Use the database
  • Work with DBaaS Instances
    • Work with flagship edition instances
      • Overview
      • Create an instance
        • Overview
        • Create via OceanBase Cloud official website
        • Create via AWS Marketplace
        • Create via GCP Marketplace
        • Create via Huawei Cloud Marketplace
        • Create via Alibaba Cloud Marketplace
        • Create via Azure Marketplace
      • Connect to an instance
        • Configure network connection
          • Overview
          • Connect using a public IP address
          • Connect using Azure Private Link
          • Connect using Google Cloud Private Service Connect
          • Connect using Huawei Cloud VPC Endpoint
          • Connect using a Huawei Cloud peering connection
          • Connect using AWS PrivateLink
          • Connect using AWS VPC peering
          • Connect using Alibaba Cloud VPC
        • MySQL compatible mode
          • Connect with clients
            • Connect to OceanBase Cloud by using Client ODC
            • Connect to OceanBase Cloud by using a MySQL client
            • Connect to OceanBase Cloud by using OBClient
          • Connect with drivers
            • Java
              • Connect to OceanBase Cloud using SpringBoot
              • SpringBatch sample application for connecting to OceanBase Cloud
              • spring-jdbc
              • SpringDataJPA sample application for connecting to OceanBase Cloud
              • Hibernate application development with OceanBase Cloud
              • Sample program for connecting to OceanBase Cloud
              • connector-j
              • Use TestContainers to connect to and use OceanBase Cloud
            • Python
              • Connect to OceanBase Cloud using mysqlclient
              • Connect to OceanBase Cloud using PyMySQL
              • Use the MySQL-connector-python driver to connect to and use OceanBase Cloud
              • Use SQLAlchemy to connect to an OceanBase Cloud database
              • Connect to an OceanBase Cloud database using Django
              • Connect to an OceanBase Cloud database by using peewee
            • C
              • Use MySQL Connector/C to connect to OceanBase Cloud
            • Go
              • Connect to OceanBase Cloud using the Go-SQL-Driver/MySQL driver
              • Connect to OceanBase Cloud using GORM
            • PHP
              • Use the EXT driver to connect to OceanBase Cloud
              • Connect to OceanBase Cloud by using the MySQLi driver
              • Use the PDO driver to connect to OceanBase Cloud
            • Rust
              • Rust application example for connecting to OceanBase Cloud
              • SeaORM example for connecting to OceanBase Cloud
            • Ruby
              • ActiveRecord sample application for OceanBase Cloud
              • Connect to OceanBase Cloud by using mysql2
              • Connect to OceanBase Cloud by using Sequel
          • Use database connection pool
            • Database connection pool configuration
            • Connect to OceanBase Cloud by using a Tomcat connection pool
            • Connect to OceanBase Cloud by using a C3P0 connection pool
            • Connect to OceanBase Cloud by using a Proxool connection pool
            • Connect to OceanBase Cloud by using a HikariCP connection pool
            • Connect to OceanBase Cloud by using a DBCP connection pool
            • Connect to OceanBase Cloud by using Commons Pool
            • Connect to OceanBase Cloud by using a Druid connection pool
        • Oracle compatible mode
          • Connect with clients
            • Connect to OceanBase Cloud by using OBClient
            • Connect to OceanBase Cloud by using Client ODC
          • Connect with drivers
            • Java
              • Connect to OceanBase Cloud using OceanBase Connector/J
              • Connect to OceanBase Cloud by using Spring Boot
              • SpringBatch application example for connecting to OceanBase Cloud
              • Connect to OceanBase Cloud using Spring JDBC
              • Connect to OceanBase Cloud by using Spring Data JPA
              • Connect to OceanBase Cloud by using Hibernate
              • Use MyBatis to connect to OceanBase Cloud
              • Use JFinal to connect to OceanBase Cloud
            • Python
              • Python Driver for Oracle Mode
            • C/C++
              • Connect to OceanBase Cloud using OceanBase Connector/C
              • Connect to OceanBase Cloud using OceanBase Connector/ODBC
              • Use SqlSugar to connect to OceanBase Cloud
          • Use database connection pool
            • Database connection pool configuration
            • Sample program that uses a Tomcat connection pool to connect to OceanBase Cloud
            • C3P0 connection pool connects to OceanBase Cloud
            • Connect to OceanBase Cloud using Proxool connection pool
            • Sample program that uses HikariCP to connect to OceanBase Cloud
            • Use DBCP connection pool to connect to OceanBase Cloud
            • Connect to OceanBase Cloud by using Commons Pool
            • Connect to OceanBase Cloud by using a Druid connection pool
        • KV compatible mode
          • Connect to a cluster by using the OBKV-HBase client
      • Developer guide
        • MySQL compatible mode
          • Plan database objects
            • Create a database
            • Create a table group
            • Create a table
            • Create an index
            • Create an external table
          • Write data
            • Insert data
            • Update data
            • Delete data
            • Replace data
            • Generate test data in batches
          • Read data
            • Single-table queries
            • Join tables
              • INNER JOIN queries
              • FULL JOIN queries
              • LEFT JOIN queries
              • RIGHT JOIN queries
              • Subqueries
              • Lateral derived tables
            • Use operators and functions in queries
              • Use arithmetic operators in queries
              • Use numerical functions in queries
              • Use string concatenation operators in queries
              • Use string functions in queries
              • Use datetime functions in queries
              • Use aggregate functions in queries
              • Use NULL-related functions in queries
              • Use the CASE conditional operator in queries
              • Use the SELECT ... FOR UPDATE statement to lock query results
              • Use the SELECT ... LOCK IN SHARE MODE statement to lock query results
            • Use a DBLink in queries
            • Set operations
          • Manage transactions
            • Overview
            • Start a transaction
            • Savepoints
              • Mark a savepoint
              • Roll back a transaction to a savepoint
              • Release a savepoint
            • Commit a transaction
            • Roll back a transaction
        • Oracle compatible mode
          • Plan database objects
            • Create a table group
            • Create a table
            • Create an index
            • Create an external table
          • Write data
            • Insert data
            • Update data
            • Delete data
            • Replace data
            • Generate test data in batches
          • Read data
            • Single-table queries
            • Join tables
              • INNER JOIN queries
              • FULL JOIN queries
              • LEFT JOIN queries
              • RIGHT JOIN queries
              • Subqueries
              • Lateral derived tables
            • Use operators and functions in queries
              • Use arithmetic operators in queries
              • Use numerical functions in queries
              • Use string concatenation operators in queries
              • Use string functions in queries
              • Use datetime functions in queries
              • Use aggregate functions in queries
              • Use CASE functions in queries
            • Use a DBLink in queries
            • Set operations
          • Manage transactions
            • Overview
            • Start a transaction
            • Savepoints
              • Mark a savepoint
              • Roll back a transaction to a savepoint
            • Commit a transaction
            • Roll back a transaction
        • KV compatible mode
          • OBKV-Table Java development guide
          • Table data operation examples
            • Insert data with OBKV-Table
            • Query data with OBKV-Table
            • Update data with OBKV-Table
            • Delete data with OBKV-Table
          • Table Java development
            • Connect to an instance by using the OBKV-Table Java client
          • HBase data operation examples
            • OBKV-HBase application development overview
            • OBKV-HBase data operation examples
      • Manage instances
        • Manage instances
          • View the instance list
          • Instance workbench overview
          • Stop and start instances
          • Unit migration
        • Manage tenants
          • Tenant overview
          • Create a tenant
          • Modify tenant specifications
          • Modify tenant names
          • Add an endpoint
          • Resource isolation
            • Overview
            • Manage resource groups
              • Create a resource group
              • View a resource group
              • Edit a resource group
              • Delete a resource group
            • Manage isolation rules
              • Create an isolation rule
              • View isolation rules
              • Edit an isolation rule
              • Delete a quarantine rule
          • Modify primary zone
          • Modify the maximum number of connections for a tenant proxy
          • Enable the AI function built-in AI models
          • Monitor tenant performance
            • Overview
            • View performance and SQL monitoring details
            • View transaction monitoring details
            • View storage and cache monitoring details
            • View Binlog service monitoring
            • Customize a monitoring dashboard for a tenant
          • Diagnostics
            • View performance monitoring data
            • Real-time diagnostics
              • SQL diagnostics
                • Top SQL
                • Slow SQL
                • Suspicious SQL
                • High-risk SQL
                • SQL details
              • Session management
                • Session management
              • Optimization management
                • Manage active outlines
                • View optimization history
              • SQL audit
          • Manage tenant parameters
            • Manage tenant parameters
            • Parameters for tenants
            • Parameter template overview
          • Delete a tenant
          • Manage databases and accounts
            • Create accounts
            • Manage accounts
            • Create a database (MySQL compatible mode)
            • Manage databases (MySQL compatible mode)
        • Monitor instance performance
          • Overview
          • Monitor the performance of databases in an instance
          • Monitor multidimensional metrics of an instance
          • Monitor the performance of hosts in an instance
          • Monitor database proxy
          • Monitor database proxy hosts
          • Monitor cross-cloud network performance
          • Customize a monitoring dashboard for an instance
        • Manage major compactions
          • Initiate a major compaction
          • View compaction records
          • Update time for compactions
        • Manage instance parameters
          • Manage parameters
          • Parameters for cluster instances
        • Change instance configurations
          • Set compute auto-scaling
          • Set storage auto-scaling
          • View history of configuration changes
          • Change configuration
          • Switch the deployment mode
        • Manage standby instances
          • Overview
          • Create a standby instance
          • Create a cross-cloud standby instance
          • Primary-standby instance workspace
          • Configure a primary-standby synchronization strategy
          • Configure global endpoint
          • Enable automatic forwarding of standby write requests
          • Primary-standby instance switchover
          • Initiate failover
          • Detach a standby instance
          • Release a standby instance
        • Release an instance
        • Database proxy
          • Overview
          • Manage database proxy
          • Direct load
        • Manage alerts
          • Overview
          • Manage alert rules
            • Create an alert rule
            • View an alert rule
            • Edit an alert rule
            • Delete an alert rule
          • View alert history
          • Manage alert templates
            • Create an alert template
            • View an alert template
            • Edit an alert template
            • Copy an alert rule template
            • Delete an alert template
          • Manage muting rules
            • Create an alert muting rule
            • View an alert muting rule
            • Edit an alert muting rule
            • Delete an alert muting rule
          • Manage alert notification templates
            • Create an alert notification template
            • View an alert notification template
            • Edit an alert notification template
            • Copy an alert notification template
            • Delete an alert notification template
          • Manage alert contacts
            • Add an alert contact
            • Add an alert contact group
            • View an alert contact
            • Edit an alert contact
            • Delete an alert contact
            • Obtain a webhook URL
          • Monitoring metrics for alerts
        • Backup and restore
          • Overview
          • Backup strategy
          • Initiate a backup immediately
          • Data backup
          • Initiate a restore
          • Data restore
          • Restore data from the instance recycle bin
        • Diagnostics
          • View performance monitoring data
          • Capacity diagnostics
          • One-click diagnostics
            • Initiate one-click diagnostics
            • View one-click diagnostic report
              • Exceptions
              • Real-time diagnostics
              • Optimization suggestions
              • Capacity management
              • Security management
          • Real-time diagnostics
            • SQL diagnostics
              • Top SQL
              • Slow SQL
              • Suspicious SQL
              • High-risk SQL
              • SQL details
              • SQL monitoring metrics list
            • Session management
              • Session management
            • Request analysis
              • Request analysis
          • Root cause diagnostics
            • Exception handling
            • Enable system autonomy
          • SQL audit
          • Materialized view analysis
          • Optimization center
            • Optimization suggestions
            • Manage active outlines
            • SQL review
            • View the optimization history
        • Manage read-only replicas
          • Overview
          • Instance read-only replicas
            • Add a read-only replica to an instance
            • View read-only replicas of an instance
            • Manage read-only replicas of an instance
            • Delete a read-only replica of an instance
          • Tenant read-only replicas
            • Add a read-only replica to a tenant
            • View read-only replicas of a tenant
            • Manage read-only replicas of a tenant
            • Delete a read-only replica of a tenant
        • Manage tags
        • Manage JVM-dependent services
      • Data source management
        • Overview of data source management
        • Manage data sources
        • User privileges
          • User privileges for compatibility assessment
          • User privileges for data migration
          • User privileges for performance assessment
          • User privileges for data archiving
          • User privileges for data cleanup
        • Connect via private network
          • AWS
          • Huawei Cloud
          • Alibaba Cloud
          • Azure
          • Private IP address segments
        • Connect via public network
          • AWS
          • Huawei Cloud
          • Alibaba Cloud
          • Azure
      • Data lifecycle management
        • Archive data
        • Clean up data
      • Manage recycle bin
        • Instance recycle bin
        • Manage databases and tables in recycle bin
          • Overview
          • Instance-level recycle bin
          • Tenant-level recycle bin
    • Work with transactional instances
      • Overview
      • Create an instance
        • Overview
        • Create via OceanBase Cloud official website
        • Create via AWS Marketplace
        • Create via GCP Marketplace
        • Create via Huawei Cloud Marketplace
        • Create via Alibaba Cloud Marketplace
        • Create via Azure Marketplace
      • Connect to an instance
        • MySQL compatible mode
          • Overview
          • Get connection string
            • Overview
            • Connect to a database by using AWS PrivateLink
            • Access the database by using an Azure private network connection
            • Connect using AWS VPC peering
            • Connect using Google Cloud Private Service Connect
            • Connect using Huawei Cloud VPC Endpoint
            • Connect using Alibaba Cloud VPC
            • Connect using a public IP address
            • Connect using a Huawei Cloud peering connection
          • Connect with clients
            • Connect to OceanBase Cloud by using Client ODC
            • Connect to OceanBase Cloud by using a MySQL client
            • Connect to OceanBase Cloud by using OBClient
          • Connect with drivers
            • Java
              • Connect to OceanBase Cloud using SpringBoot
              • SpringBatch sample application for connecting to OceanBase Cloud
              • spring-jdbc
              • SpringDataJPA sample application for connecting to OceanBase Cloud
              • Hibernate application development with OceanBase Cloud
              • Sample program for connecting to OceanBase Cloud
              • connector-j
              • Use TestContainers to connect to and use OceanBase Cloud
            • Python
              • Connect to OceanBase Cloud using mysqlclient
              • Connect to OceanBase Cloud using PyMySQL
              • Use the MySQL-connector-python driver to connect to and use OceanBase Cloud
              • Use SQLAlchemy to connect to an OceanBase Cloud database
              • Connect to an OceanBase Cloud database using Django
              • Connect to an OceanBase Cloud database by using peewee
            • C
              • Use MySQL Connector/C to connect to OceanBase Cloud
            • Go
              • Connect to OceanBase Cloud using the Go-SQL-Driver/MySQL driver
              • Connect to OceanBase Cloud using GORM
            • PHP
              • Use the EXT driver to connect to OceanBase Cloud
              • Connect to OceanBase Cloud by using the MySQLi driver
              • Use the PDO driver to connect to OceanBase Cloud
            • Rust
              • Rust application example for connecting to OceanBase Cloud
              • SeaORM example for connecting to OceanBase Cloud
            • ruby
              • ActiveRecord sample application for OceanBase Cloud
              • Connect to OceanBase Cloud by using mysql2
              • Connect to OceanBase Cloud by using Sequel
          • Use database connection pool
            • Database connection pool configuration
            • Connect to OceanBase Cloud by using a Tomcat connection pool
            • Connect to OceanBase Cloud by using a C3P0 connection pool
            • Connect to OceanBase Cloud by using a Proxool connection pool
            • Connect to OceanBase Cloud by using a HikariCP connection pool
            • Connect to OceanBase Cloud by using a DBCP connection pool
            • Connect to OceanBase Cloud by using Commons Pool
            • Connect to OceanBase Cloud by using a Druid connection pool
        • Oracle compatible mode
          • Overview
          • Get connection string
            • Overview
            • Connect to a database by using AWS PrivateLink
            • Access a database by using an Azure private network connection
            • Connect using AWS VPC peering
            • Connect using Google Cloud Private Service Connect
            • Connect using Huawei Cloud VPC Endpoint
            • Connect using a public IP address
          • Connect with clients
            • Connect to OceanBase Cloud by using OBClient
            • Connect to OceanBase Cloud by using Client ODC
          • Connect with drivers
            • Java
              • Connect to OceanBase Cloud using OceanBase Connector/J
              • Connect to OceanBase Cloud by using Spring Boot
              • SpringBatch application example for connecting to OceanBase Cloud
              • Connect to OceanBase Cloud using Spring JDBC
              • Connect to OceanBase Cloud by using Spring Data JPA
              • Connect to OceanBase Cloud by using Hibernate
              • Use MyBatis to connect to OceanBase Cloud
              • Use JFinal to connect to OceanBase Cloud
            • Python
              • Python Driver for Oracle Mode
            • C
              • Connect to OceanBase Cloud using OceanBase Connector/C
              • Connect to OceanBase Cloud using OceanBase Connector/ODBC
              • Use SqlSugar to connect to OceanBase Cloud
          • Use database connection pool
            • Database connection pool configuration
            • Sample program that uses a Tomcat connection pool to connect to OceanBase Cloud
            • C3P0 connection pool connects to OceanBase Cloud
            • Connect to OceanBase Cloud using Proxool connection pool
            • Sample program that uses HikariCP to connect to OceanBase Cloud
            • Use DBCP connection pool to connect to OceanBase Cloud
            • Connect to OceanBase Cloud by using Commons Pool
            • Connect to OceanBase Cloud by using a Druid connection pool
      • Developer guide
        • MySQL compatible mode
          • Plan database objects
            • Create a database
            • Create a table group
            • Create a table
            • Create an index
            • Create an external table
          • Write data
            • Insert data
            • Update data
            • Delete data
            • Replace data
            • Generate test data in batches
          • Read data
            • Single-table queries
            • Join tables
              • INNER JOIN queries
              • FULL JOIN queries
              • LEFT JOIN queries
              • RIGHT JOIN queries
              • Subqueries
              • Lateral derived tables
            • Use operators and functions in queries
              • Use arithmetic operators in queries
              • Use numerical functions in queries
              • Use string concatenation operators in queries
              • Use string functions in queries
              • Use datetime functions in queries
              • Use type conversion functions in queries
              • Use aggregate functions in queries
              • Use NULL-related functions in queries
              • Use the CASE conditional operator in queries
              • Use the SELECT ... FOR UPDATE statement to lock query results
              • Use the SELECT ... LOCK IN SHARE MODE statement to lock query results
            • Use a DBLink in queries
            • Set operations
          • Manage transactions
            • Overview
            • Start a transaction
            • Savepoints
              • Mark a savepoint
              • Roll back a transaction to a savepoint
              • Release a savepoint
            • Commit a transaction
            • Roll back a transaction
        • Oracle compatible mode
          • Plan database objects
            • Create a table group
            • Create a table
            • Create an index
            • Create an external table
          • Write data
            • Insert data
            • Update data
            • Delete data
            • Replace data
            • Generate test data in batches
          • Read data
            • Single-table queries
            • Join tables
              • INNER JOIN queries
              • FULL JOIN queries
              • LEFT JOIN queries
              • RIGHT JOIN queries
              • Subqueries
              • Lateral derived tables
            • Use operators and functions in queries
              • Use arithmetic operators in queries
              • Use numerical functions in queries
              • Use string concatenation operators in queries
              • Use string functions in queries
              • Use datetime functions in queries
              • Use type conversion functions in queries
              • Use aggregate functions in queries
              • Use NULL-related functions in queries
              • Use CASE functions in queries
              • Use the SELECT ... FOR UPDATE statement to lock query results
            • Use a DBLink in queries
            • Set operations
          • Manage transactions
            • Overview
            • Start a transaction
            • Savepoints
              • Mark a savepoint
              • Roll back a transaction to a savepoint
            • Commit a transaction
            • Roll back a transaction
      • Manage instances
        • Manage instances
          • View the instance list
          • Instance overview
          • Stop and restart instances
          • Unit migration
        • Manage tenants
          • Tenant overview
          • Create a tenant
          • Modify tenant specifications
          • Modify tenant names
          • Add an endpoint
          • Resource isolation
            • Overview
            • Manage resource groups
              • Create a resource group
              • View a resource group
              • Edit a resource group
              • Delete a resource group
            • Manage isolation rules
              • Create an isolation rule
              • View isolation rules
              • Edit an isolation rule
              • Delete a quarantine rule
          • Modify primary zone
          • Modify the maximum number of connections for a tenant proxy
          • Enable the AI function built-in AI models
          • Monitor tenant performance
            • Overview
            • View performance and SQL monitoring details
            • View transaction monitoring details
            • View storage and cache monitoring details
            • View Binlog service monitoring
            • Customize a monitoring dashboard for a tenant
          • Diagnostics
            • Real-time diagnostics
              • SQL diagnostics
                • Top SQL
                • Slow SQL
                • Suspicious SQL
                • High-risk SQL
              • SQL audit
          • Manage tenant parameters
            • Manage tenant parameters
            • Parameters for tenants
            • Parameter template overview
          • Delete a tenant
          • Manage databases and accounts
            • Create accounts
            • Manage accounts
            • Create a database (MySQL compatible mode)
            • Manage databases (MySQL compatible mode)
        • Monitor instance performance
          • Overview
          • Monitor the performance of databases in an instance
          • Monitor multidimensional metrics of an instance
          • Monitor the performance of hosts in an instance
          • Monitor database proxy
          • Monitor database proxy hosts
          • Monitor cross-cloud network performance
          • Customize a monitoring dashboard for an instance
        • Manage major compactions
          • Initiate a major compaction
          • View compaction records
          • Update time for compactions
        • Manage instance parameters
          • Manage parameters
          • Parameters for cluster instances
        • Change instance configurations
          • Set storage auto-scaling
          • View history of configuration changes
          • Change configuration
          • Switch the deployment mode
        • Manage standby instances
          • Overview
          • Create a standby instance
          • Create a cross-cloud standby instance
          • View details of primary and standby instances
          • Configure global endpoint
          • Enable automatic forwarding for write requests of standby databases
          • Primary-standby instance switchover
          • Initiate failover
          • Detach a standby instance
          • Release a standby instance
        • Release an instance
        • Database proxy
          • Overview
          • Manage database proxy
          • Direct load
        • Manage alerts
          • Overview
          • Manage alert rules
            • Create an alert rule
            • View an alert rule
            • Edit an alert rule
            • Delete an alert rule
          • View alert history
          • Manage alert templates
            • Create a trigger condition template
            • View an alert template
            • Edit an alert template
            • Copy an alert rule template
            • Delete an alert template
          • Manage muting rules
            • Create an alert muting rule
            • View an alert muting rule
            • Edit an alert muting rule
            • Delete an alert muting rule
          • Manage alert notification templates
            • Create an alert notification template
            • View an alert notification template
            • Edit an alert notification template
            • Copy an alert notification template
            • Delete an alert notification template
          • Manage alert contacts
            • Add an alert contact
            • Add an alert contact group
            • View an alert contact
            • Edit an alert contact
            • Delete an alert contact
            • Obtain a webhook URL
          • Monitoring metrics for alerts
        • Backup and restore
          • Overview
          • Backup strategy
          • Initiate a backup immediately
          • Data backup
          • Initiate a restore
          • Data restore
          • Restore data from the instance recycle bin
        • Diagnostics
          • View performance monitoring data
          • Capacity diagnostics
          • One-click diagnostics
            • Initiate one-click diagnostics
            • View one-click diagnostic report
              • Exceptions
              • Real-time diagnostics
              • Optimization suggestions
              • Capacity management
              • Security management
          • Real-time diagnostics
            • SQL diagnostics
              • Top SQL
              • Slow SQL
              • Suspicious SQL
              • High-risk SQL
              • SQL details
              • SQL monitoring metrics list
            • Session management
              • Session management
            • Request analysis
              • Request analysis
          • Root cause diagnostics
            • Exception handling
            • Enable system autonomy
          • SQL audit
          • Materialized view analysis
          • Optimization center
            • Optimization suggestions
            • Manage active outlines
            • SQL review
            • View the optimization history
        • Manage read-only replicas
          • Overview
          • Instance read-only replicas
            • Add a read-only replica to an instance
            • View read-only replicas of an instance
            • Manage read-only replicas of an instance
            • Delete a read-only replica of an instance
          • Tenant read-only replicas
            • Add a read-only replica to a tenant
            • View read-only replicas of a tenant
            • Manage read-only replicas of a tenant
            • Delete a read-only replica of a tenant
        • Manage tags
        • Manage JVM-dependent services
      • Data source management
        • Connect via private network
          • Google Cloud
        • Connect via public network
          • Google Cloud
      • Overview of data source management
      • Data lifecycle management
        • Overview
        • Archive data
        • Clean up data
        • Data archiving configurations
      • Manage recycle Bin
        • Instance recycle bin
        • Manage databases and tables in recycle bin
          • Overview
          • Instance-level recycle bin
          • Tenant-level recycle bin
    • Work with analytical instances
      • Overview
      • Core features
      • Connect to an instance
        • Overview
        • Get connection string
          • Overview
          • Connect using AWS PrivateLink
          • Connect using Huawei Cloud VPC Endpoint
          • Connect using a public IP address
        • Connect with clients
          • Connect to OceanBase Cloud by using Client ODC
          • Connect to OceanBase Cloud by using a MySQL client
          • Connect to OceanBase Cloud by using OBClient
        • Connect with drivers
          • Java
            • Connect to OceanBase Cloud by using Spring Boot
            • Connect to OceanBase Cloud by using Spring Batch
            • Connect to OceanBase Cloud by using Spring Data JDBC
            • Connect to OceanBase Cloud by using Spring Data JPA
            • Connect to OceanBase Cloud by using Hibernate
            • Connect to OceanBase Cloud by using MyBatis
            • Connect to OceanBase Cloud using MySQL Connector/J
          • Python
            • Connect to OceanBase Cloud by using mysqlclient
            • Connect to OceanBase Cloud by using PyMySQL
            • Connect to OceanBase Cloud using MySQL Connector/Python
          • C
            • Connect to OceanBase Cloud using MySQL Connector/C
          • Go
            • Connect to OceanBase Cloud using Go-SQL-Driver/MySQL
          • PHP
            • Connect to OceanBase Cloud using PHP
        • Use database connection pool
          • Database connection pool configuration
          • Connect to OceanBase Cloud by using a Tomcat connection pool
          • Connect to OceanBase Cloud by using a C3P0 connection pool
          • Connect to OceanBase Cloud by using a Proxool connection pool
          • Connect to OceanBase Cloud by using a HikariCP connection pool
          • Connect to OceanBase Cloud by using a DBCP connection pool
          • Connect to OceanBase Cloud by using Commons Pool
          • Connect to OceanBase Cloud by using a Druid connection pool
      • Create an instance
      • Data table design
        • Table overview
        • Best practices
          • Unit 1: Best practices for optimizing storage structures and query performance
          • Unit 2: Best practices for creating special indexes
      • Export data
      • OceanBase data processing
      • Query acceleration
        • Statistics
        • Materialized views for query acceleration
        • Select a query parallelism level
      • Manage instances
        • Instance overview
        • Change configuration
        • Set storage auto-scaling
        • Modify primary zone
        • Manage parameters
        • Backup and restore
          • Backup overview
          • Backup strategies
          • Immediate backup
          • Data Backup
          • Initiate restore
          • Data restore
        • Monitor instance performance
          • Overview
          • Monitor the performance of databases in an instance
          • Monitor the performance of hosts in an instance
        • Manage major compactions
          • Initiate a major compaction
          • View compaction records
          • Update time for compactions
        • Database proxy
          • Overview
          • Manage database proxy
          • Direct load
        • Manage alerts
          • Overview
          • Manage alert rules
            • Create an alert rule
            • View an alert rule
            • Edit an alert rule
            • Delete an alert rule
          • View alert history
          • Manage alert templates
            • Create a trigger condition template
            • View an alert template
            • Edit an alert template
            • Copy an alert template
            • Delete an alert template
          • Manage muting rules
            • Create an alert muting rule
            • View an alert muting rule
            • Edit an alert muting rule
            • Delete an alert muting rule
          • Manage alert notification templates
            • Create an alert notification template
            • View an alert notification template
            • Edit an alert notification template
            • Copy an alert notification template
            • Delete an alert notification template
          • Manage alert contacts
            • Add an alert contact
            • Add an alert contact group
            • View an alert contact
            • Edit an alert contact
            • Delete an alert contact
            • Obtain a webhook URL
          • Monitoring metrics for alerts
        • Diagnostics
          • View performance monitoring data
          • Capacity diagnostics
          • Real-time diagnostics
            • SQL diagnostics
              • Top SQL
              • Slow SQL
              • Suspicious SQL
              • High-risk SQL
              • SQL details
              • SQL monitoring metrics list
            • Session management
              • Session management
            • Optimization management
              • Manage active outlines
              • View the optimization history
            • Request analysis
              • Request analysis
        • Stop and restart instances
        • Release instances
        • Manage databases and accounts
          • Create and manage accounts
          • Create a database
          • Manage databases
        • Manage tags
      • Overview of data source management
      • Data lifecycle management
        • Archive data
        • Clean up data
      • Performance diagnosis and tuning
        • Use the DBMS_XPLAN package for performance diagnostics
        • Use the GV$SQL_PLAN_MONITOR view for performance analysis
        • Views related to AP performance analysis
      • Performance testing
      • Product integration
      • Manage recycle Bin
        • View instance recycle bin
        • Manage databases and tables in recycle bin
          • Overview
          • Instance recycle bin
    • Work with Key-Value instances
      • Try out Key-Value instances
        • Create an instance
        • Create a tenant
        • Create an account for a database user
        • OBKV HBase data operation examples
      • Use Table model
        • Create an instance
        • Manage instances
          • Manage instances
            • View the instance list
            • Instance overview
            • Stop and restart instances
            • Release an instance
          • Manage tenants
            • Create a tenant
            • Modify tenant specifications
            • Modify tenant names
            • Delete a tenant
            • Tenant overview
            • Resource isolation
              • Overview
              • Manage resource groups
                • Create a resource group
                • View a resource group
                • Edit a resource group
                • Delete a resource group
              • Manage isolation rules
                • Create an isolation rule
                • View isolation rules
                • Edit an isolation rule
                • Delete a quarantine rule
            • Monitor tenant performance
              • Overview
              • View performance and SQL monitoring details
              • View transaction monitoring details
              • View storage and cache monitoring details
              • OBKV-Table
              • Customize a monitoring dashboard for a tenant
            • Diagnostics
              • Top SQL
            • Manage tenant parameters
              • Manage tenant parameters
              • Parameters for tenants
            • Manage databases and accounts
              • Create and manage accounts
              • Create a database
              • Manage databases
            • Modify primary zone
          • Monitor instance performance
            • Overview
            • Monitor the performance of databases in an instance
            • Monitor multi-dimensional metrics of an instance
            • Monitor the performance of hosts in a cluster
            • Customize monitoring dashboards for an instance
          • Manage major compactions
            • Initiate major compactions
            • View compaction records
            • Update time for compactions
          • Manage instance parameters
            • Parameter management overview
            • Parameters for cluster instances
          • Change instance configurations
            • Set storage auto-scaling
            • View history of configuration changes
            • Change configuration
            • Switch the deployment mode
          • Database proxy
            • Overview
            • Manage database proxy
          • Manage alerts
            • Overview
            • Manage alert rules
              • Create an alert rule
              • View an alert rule
              • Edit an alert rule
              • Delete an alert rule
            • View alert history
            • Manage alert templates
              • Trigger condition template management
              • Create an alert template
              • View an alert template
              • Edit an alert template
              • Copy an alert template
              • Delete an alert template
            • Manage muting rules
              • Create an alert muting rule
              • View an alert muting rule
              • Edit an alert muting rule
              • Delete an alert muting rule
            • Manage alert contacts
              • Add an alert contact
              • Add an alert contact group
              • View an alert contact
              • Edit an alert contact
              • Delete an alert contact
              • Obtain a webhook URL
            • Monitoring metrics for alerts
          • Backup and restore
            • Backup overview
            • Backup strategies
            • Immediate backup
            • Data backup
            • Initiate restore
            • Data restore
          • Diagnostics
            • View performance monitoring data
            • Top SQL
            • Capacity diagnostics
            • Request analysis
          • Manage recycle Bin
            • View instance recycle bin
            • Manage databases and tables in recycle bin
              • Overview
              • Instance-level recycle bin
              • Tenant-level recycle bin
          • Manage tags
      • Use HBase model
        • OBKV-HBase Overview
        • Create an instance
        • Develop in HBase model
          • Connect to an instance by using the OBKV-HBase client
        • Manage instances
          • Manage instances
            • View the instance list
            • Instance overview
            • Stop and restart instances
            • Release an instance
          • Manage tenants
            • Create a tenant
            • Modify tenant specifications
            • Modify tenant names
            • Delete a tenant
            • Tenant overview
            • Resource isolation
              • Overview
              • Manage resource groups
                • Create a resource group
                • View a resource group
                • Edit a resource group
                • Delete a resource group
              • Manage isolation rules
                • Create an isolation rule
                • View isolation rules
                • Edit an isolation rule
                • Delete a quarantine rule
            • Monitor tenant performance
              • Overview
              • View performance and SQL monitoring details
              • View transaction monitoring details
              • View storage and cache monitoring details
              • OBKV-HBase
              • Customize a monitoring dashboard for a tenant
            • Diagnostics
              • Top SQL
            • Manage tenant parameters
              • Manage tenant parameters
              • Parameters for tenants
            • Manage databases and accounts
              • Create and manage accounts
              • Create a database
              • Manage databases
            • Modify primary zone
          • Monitor instance performance
            • Overview
            • Monitor the performance of databases in an instance
            • Monitor multi-dimensional metrics of an instance
            • Monitor the performance of hosts in a cluster
            • Customize monitoring dashboards for an instance
          • Manage major compactions
            • Initiate major compactions
            • View compaction records
            • Update time for compactions
          • Manage instance parameters
            • Parameter management overview
            • Parameters for cluster instances
          • Change instance configurations
            • Set storage auto-scaling
            • View history of configuration changes
            • Change configuration
            • Switch the deployment mode
          • Database proxy
            • Overview
            • Manage database proxy
          • Manage alerts
            • Overview
            • Manage alert rules
              • Create an alert rule
              • View an alert rule
              • Edit an alert rule
              • Delete an alert rule
            • View alert history
            • Manage alert templates
              • Trigger condition template management
              • Create an alert template
              • View an alert template
              • Edit an alert template
              • Copy an alert template
              • Delete an alert template
            • Manage muting rules
              • Create an alert muting rule
              • View an alert muting rule
              • Edit an alert muting rule
              • Delete an alert muting rule
            • Manage alert contacts
              • Add an alert contact
              • Add an alert contact group
              • View an alert contact
              • Edit an alert contact
              • Delete an alert contact
              • Obtain a webhook URL
            • Monitoring metrics for alerts
          • Backup and restore
            • Backup overview
            • Backup strategies
            • Immediate backup
            • Data backup
            • Initiate restore
            • Data restore
          • Diagnostics
            • View performance monitoring data
            • Top SQL
            • Capacity diagnostics
            • Request analysis
          • Manage recycle Bin
            • View instance recycle bin
            • Manage databases and tables in recycle bin
              • Overview
              • Instance-level recycle bin
              • Tenant-level recycle bin
          • Manage tags
        • Overview of data source management
        • Performance test
      • Connect Key-Value instances
        • Overview
        • Connect using Huawei Cloud VPC Endpoint
        • Connect using a public IP address
  • AI Features
    • AI services
      • Overview of AI service
      • Quick start
      • Manage AI API keys
      • Use AI models
      • Use Claude Code with OceanBase MaaS
      • Use Codex CLI and Codex App with OceanBase MaaS
      • Use the memory feature
      • AI APIs
        • Access guide
        • AI service APIs
          • AI API list
          • Anthropic compatible APIs
            • List Anthropic models
            • Create a message
            • Create a message (default base URL)
          • OpenAI compatible APIs
            • List models
            • Create chat completion
            • Create embedding
            • Rerank
            • Reranks
            • Create response
          • Vertex AI compatible APIs
            • Generate content
            • Stream generate content
          • Image and video generation APIs
            • Create an image generation task
            • Create a video generation task
            • Retrieve task status
          • Image model APIs
            • gpt-image-2 text-to-image
            • gpt-image-2 image editing
            • gemini-3-pro-image text-to-image
            • gemini-3-pro-image image-to-image / image editing
          • OpenAI compatible batches and files APIs
            • Upload file
            • List files
            • Retrieve file
            • Delete file
            • Get file content
            • Get file content (POST)
            • Create batch
            • List batches
            • openai-compatible-apis
            • Retrieve batch (POST)
            • Cancel batch
          • Memory APIs
            • listSpaces - Paginated list of memory spaces
            • createSpace - Create a memory space
            • getSpace - Get details of a specified memory space
            • updateSpace - Update the name and description of a space
            • deleteSpace - Delete a space
            • extractMemories - Extract memories from dialogue messages
            • listMemories - List memories in a space
            • addMemory - Add a memory directly
            • getMemory - Retrieve a single memory
            • updateMemory - Update a single memory
            • deleteMemory - Delete a single memory
            • distillMemory - Distill experiences from conversations
            • searchExperiences - Search for experiences
            • getExperience - Retrieve a single experience
            • deleteExperience - Delete a single experience
            • feedbackExperiences - Submit feedback on experiences
            • setExperienceObsolescence - Set the obsolete status of an experience
            • combinedSearch - Combined search for memories and experiences
      • Built-in models
    • OceanBase OAgent
      • What is OceanBase OAgent?
      • Quick start with OceanBase OAgent
      • Configure a channel
      • Set skills
      • View OceanBase OAgent token usage
  • Migrations
    • Data migration and import solutions
    • Data assessment and migration quick start
    • Assess compatibility
      • Overview
      • Perform online assessment
      • Perform offline assessment
      • Manage compatibility assessment tasks
        • View a compatibility assessment task
        • View and download a compatibility assessment report
        • Stop a compatibility assessment task
        • Delete a compatibility assessment task
      • Obtain files for upload
      • Configure PrivateLink
      • Add an IP address to an allowlist
    • Data source management
      • Create a data source
      • Manage data sources
      • User privileges
        • User privileges for compatibility assessment
        • User privileges for data migration
        • User privileges for performance assessment
        • User privileges for data archiving
        • User privileges for data cleanup
      • Connect via private network
        • AWS
        • Huawei Cloud
        • Alibaba Cloud
        • Azure
        • Private IP address range
      • Connect via public network
        • AWS
        • Huawei Cloud
        • Alibaba Cloud
        • Azure
      • Connect via VPC peering
        • Configure an AWS data service peering connection
        • Configure a Huawei Cloud data service peering connection
        • Configure an Alibaba Cloud data service peering connection
        • Configure a Google Cloud data service peering connection
    • Migrate data
      • Overview
      • Migrations specification
      • Purchase a data migration instance
      • Migrate data from a MySQL database to the MySQL-compatible mode of OceanBase Database
      • Migrate data from OceanBase Database in MySQL-compatible mode to a MySQL database
      • Data migration between tenants of OceanBase Database in the same compatibility mode
      • Migrate data between OceanBase database tenants of different compatibility modes
      • Migrate data from an Oracle database to an Oracle-compatible tenant of OceanBase Database
      • Migrate data from an Oracle-compatible tenant of OceanBase Database to an Oracle database
      • Configure a two-way synchronization task
      • Migrate data from OceanBase Database to Kafka
      • Migrate data from a TiDB database to the MySQL-compatible mode of OceanBase Database
      • Migrate incremental data from OceanBase Database in MySQL-compatible mode to TiDB Database
      • Migrate data from a PostgreSQL database to OceanBase Database
      • Migrate incremental data from OceanBase Database to PostgreSQL Database
      • Migrate data from a Lindorm/HBase database to the HBase API compatible mode of OceanBase Database
      • Migrate incremental data from OceanBase Database in HBase API compatibility mode to a Lindorm/HBase database
      • Migrate data from OceanBase Database to RocketMQ
      • Migrate data from OceanBase Database to DataHub
      • Migrate data from OceanBase Database in MySQL mode to ADB
      • Migrate data from PolarDB-X 2.0 to OceanBase Database in MySQL mode
      • Manage data migration tasks
        • View details of a data migration task
        • Rename a data migration task
        • View and modify migration objects
        • View and modify migration parameters
        • Configure alert monitoring
        • Manage data migration tasks by using tags
        • Intelligent diagnosis
        • Start, stop, and resume a data migration task
        • Clone a data migration task
        • Terminate and release a data migration task
      • Features
        • Custom DML/DDL configurations
        • DDL synchronization scope
        • Use SQL conditions to filter data
        • Rename a migration object
        • Set an incremental synchronization timestamp
        • Instructions on schema migration
        • Configure and modify matching rules
        • Wildcard rules
        • Import migration objects
        • Download conflict data
        • Change a topic
        • Column filtering
        • Data formats
        • Partition settings
      • Authorize an Alibaba Cloud account
      • SQL statements for querying table objects
      • Online DDL tools
      • Create a trigger
      • Modify the log level of a self-managed PostgreSQL instance
      • Supported DDL statements for synchronization and their limitations
        • DDL synchronization from Aurora MySQL DB clusters to MySQL-compatible tenants of OceanBase Database
        • DDL synchronization from MySQL-compatible tenants of OceanBase Database to Aurora MySQL DB clusters
        • DDL synchronization between MySQL-compatible tenants of OceanBase Database
        • DDL synchronization from Oracle databases to Oracle-compatible tenants of OceanBase Database
        • DDL synchronization from Oracle-compatible tenants of OceanBase Database to Oracle databases
        • DDL synchronization between Oracle-compatible tenants of OceanBase Database
        • DDL synchronization from OceanBase databases to Kafka instances
    • Data subscription
      • Create a data subscription task
      • Manage data subscription tasks
        • View details of a data subscription task
        • Configure subscription information
        • Modify the name of a data subscription task
        • View and modify subscription objects
        • View data subscription parameters
        • Set up data subscription alerts
        • Start, stop, and resume data subscription tasks
        • Clone a data subscription task
        • Release a data subscription task
      • Manage private connections for data subscriptions
      • Configure consumer subscription
      • Message formats
    • Data validation
      • Overview
      • Create a data validation task
      • Manage data validation tasks
        • View details of a data validation task
        • View and modify validation objects
        • View and modify validation parameters
        • Manage data validation tasks with tags
        • Start, pause, and resume data validation tasks
        • Clone a data validation task
        • Release a data validation task
      • Features
        • Import validation objects
        • Rename the validation object
        • Filter objects by using SQL conditions
        • Configure the matching rules for the validation object
    • Assess performance
      • Overview
      • Obtain traffic files from a database instance
      • Create a full performance assessment task
      • Create an SQL file parsing task
      • Create an SQL file replay task
      • Manage performance assessment tasks
        • View the details of a performance assessment task
        • View a performance assessment report
        • Retry and stop a performance assessment task
        • Delete a performance assessment task
      • Obtain a database instance
      • Create an access key
    • Import data
      • Import data
      • Direct load
      • Supported file formats and encoding formats for Data Import
      • Sample data introduction
    • Binlog service
      • Overview
      • Purchase the Binlog service
      • Manage Binlog service
        • View details of the Binlog service
        • Change configuration
        • Modify the auto-scaling strategy for storage space
        • Modify the elasticity strategy for compute units
        • Disable the Binlog service
    • Upgrade assistant
  • Security
    • OceanBase Cloud account settings
      • Manage personal account information
      • Multi-factor authentication
      • Organization authentication
        • Enable organization authentication
        • Configure IdP
      • Manage AccessKeys
      • Time zone settings
      • Manage cloud marketplace accounts
      • Account audit
    • Organizations and projects
      • Overview
      • Manage organization information
      • Project management
        • Manage projects
        • Cross-project bidirectional authorization
        • AI settings
        • Manage object storage configurations
        • Subscribe to project messages
      • Manage members
      • Permissions for roles
      • Cost management
        • Overview
        • Cost details
        • Manage cost units
      • Operation audit
    • Database accounts and privileges
      • Account privileges
      • Authorize cloud vendor accounts
      • AWS KMS key management
      • Support access control
    • Security and encryption
      • Set allowlist groups
      • SSL encryption
      • Transparent Data Encryption (TDE)
    • Monitoring dashboard
    • Events
    • Support plans
      • Overview of OceanBase Cloud support plans
      • Subscribe to and manage support plans
  • SQL Console
    • Overview
    • Access SQL Console
    • SQL editing and execution
    • PL compilation
    • Result set editing
    • Execution analysis
    • Database object management
      • Create a table
      • Create a view
      • Create a function
      • Create a stored procedure
      • Create a program package
      • Create a trigger
      • Create a type
      • Create a sequence
      • Create a synonym
    • Session variable management
    • Functional keys in SQL Console
    • Intelligent SQL development
  • Integrations
    • Overview
    • Schema evolution
      • Liquibase
      • Flyway
    • Data ingestion
      • Canal
      • dbt
      • Debezium
      • Flink
      • Glue
      • Informatica Cloud
      • Kafka
      • Maxwell
      • SeaTunnel
      • DataWorks
      • NiFi
    • SQL development
      • DataGrip
      • DBeaver
      • Navicat
      • TablePlus
    • Orchestration
      • DolphinScheduler
      • Linkis
      • Airflow
    • Visualization
      • Grafana
      • Power BI
      • Quick BI
      • Superset
      • Tableau
    • Observability
      • Datadog
      • Prometheus
    • Database management
      • Bytebase
    • AI
      • LlamaIndex
      • Dify
      • LangChain
      • Tongyi Qianwen
      • OpenAI
      • n8n
      • Trae
      • SpringAI
      • Cline
      • Cursor
      • Continue
      • Toolbox
      • CamelAI
      • Firecrawl
      • Hugging Face
      • Ollama
      • Google Gemini
      • Cloudflare Workers AI
      • Qoder
      • OpenCode
      • Claude Code
      • GitHub Copilot
      • Codex
      • Jina AI
      • Augment Code
      • Claude Code
      • Kiro
    • Development tools
      • Cloudflare Workers
      • Vercel
  • Best practices
    • Best practices for achieving high availability through cross-cloud active-active deployment
    • High availability through cross-cloud primary-standby databases (1:1)
    • High availability through cross-cloud primary-standby databases (1:n)
    • High host CPU usage
    • Best practices for read/write splitting in OceanBase Cloud
    • Best practices for migrating data from AWS RDS to OceanBase Cloud
  • References
    • System architecture
    • System management
    • Database object management
    • Database design and specification constraints
    • SQL reference
    • System views
    • Parameters and system variables
    • Error codes
    • Performance tuning
    • Open API References
      • Overview of Open APIs
      • Service endpoints
      • Using API
      • Open APIs
        • Cluster management
          • DescribeInstances
          • DescribeInstance
          • CreateInstance
          • DeleteInstance
          • ModifyInstanceName
          • describe-node-options
          • StopCluster
          • StartCluster
          • ModifyInstanceSpec
          • DescribeInstanceTopology
          • DescribeReadonlyInstances
          • CreateReadonlyInstance
          • ModifyReadonlyInstanceSpec
          • ModifyReadonlyInstanceDiskSize
          • ModifyReadonlyInstanceNodeNum
          • DeleteReadonlyInstance
          • DescribeInstanceAvailableRoZones
          • DescribeInstanceParameters
          • UpdateInstanceParameters
          • DescribeInstanceParametersHistory
          • ModifyInstanceTagList
          • ModifyInstanceNodeNum
          • DescribeInstanceAnomalyEvents
          • DescribeOasClusterAnomalySqlList
          • DescribeOasClusterSlowSQLList
          • DescribeInstanceSqlAuditServiceInfo - Query SQL Audit Service Information
          • DescribeProxyClusterForInstance - Query ODP clusters associated with an instance
          • SwitchoverInstance - Perform a primary/standby switchover
        • Tenant management
          • DescribeTenants
          • DescribeTenant - Query Information of a Specified Tenant in a Specified Cluster
          • CreateTenants
          • DeleteTenants
          • ModifyTenantName
          • ModifyTenant
          • ModifyTenantUserDescription
          • ModifyTenantUserStatus
          • GetTenantCreateConstraints
          • ModifyTenantPrimaryZone
          • GetTenantCreateCpuConstraints
          • GetTenantCreateMemConstraints
          • GetTenantModifyCpuConstraints
          • GetTenantModifyMemConstraints
          • CreateTenantSecurityIpGroup
          • DescribeTenantSecurityIpGroups
          • ModifyTenantSecurityIpGroup
          • DeleteTenantSecurityIpGroup
          • DescribeTenantPrivateLink
          • DeletePrivatelinkConnection
          • CreatePrivatelinkService
          • ConnectPrivatelinkService
          • AddPrivatelinkServiceUser
          • BatchKillProcessList
          • DescribeProcessStatsComposition
          • DescribeTenantAddressInfo - Query Tenant Address Information
          • DescribeTenantAvailableRoZones
          • ModifyTenantReadonlyReplica
          • DescribeTenantParameters
          • UpdateTenantParameters
          • DescribeTenantParametersHistory
          • ModifyTenantTagList
          • CreateReadonlyPrivatelink
          • CreateReadwritePrivatelink
          • DescribeTenantPublicAddress - Query Tenant Public IP Address
          • DescribeTenantSqlAuditServiceInfo - Query SQL Audit Service Information for a Tenant
        • Tenant user management
          • CreateTenantUser
          • DescribeTenantUsers
          • DeleteTenantUsers
          • ModifyTenantUserPassword
          • ModifyTenantUserRoles
        • Database management
          • CreateDatabase
          • DescribeDatabases
          • DeleteDatabases
          • ModifyDatabaseUserRoles
          • DescribeTableSchema
        • Backup and restore
          • DescribeDataBackupSet
          • DescribeRestorableTenants
          • ModifyBackupStrategy
          • CreateTenantRestoreTask
          • CreateDataBackupTask
          • DescribeOneDataBackupSet
          • CreateBackupSetDownloadLink - Create a backup set download link
          • DeleteBackupSetDownloadTask - Delete a backup set download task
          • DescribeBackupSetDownloadLink - Query a backup set download link
          • DescribeBackupStrategy - Query backup strategy
        • Database proxy management
          • CreateTenantAddress
          • CreateTenantSingleTunnelSLBAddress
          • DeleteTenantAddress
          • DescribeTenantAddress
          • ModifyOdpClusterSpec
          • ModifyTenantAddressPort
          • ModifyTenantAddressDomainPrefix
          • ConfirmPrivatelinkConnection
          • DescribeTenantAddressInfo
        • Data source management
          • ListDataSources - List data sources
          • CreateDataSource - Create a data source
          • DeleteDataSource - Delete a data source
        • OMS project management
          • DescribeProject - Query project details
          • CreateProject - Create a project
          • DeleteProject - Delete a project
          • DescribeProjectSteps - Query project steps
          • StartProject - Start a project
          • StopProject - Stop a project
          • ResumeProject - Resume a project
          • ReleaseProject - Release project resources
          • UpdateProjectConfig - Update project configuration
          • ListProjectModifyRecords - List project modification records
          • CreateProjectModifyRecords - Create modification records (add or remove tables)
          • CancelProjectModifyRecord - Cancel a modification record
          • RetryProjectModifyRecords - Retry a modification
          • StopProjectModifyRecords - Terminate a modification
          • GetModifyRecord - Query modification record details
          • DescribeTransferMapping - Query transfer object mappings
        • Monitoring management
          • DescribeTenantMetrics
          • DescribeMetricsData
          • CreatePrometheusIntegration - Create a Prometheus Monitoring Integration
          • DeletePrometheusIntegration - Delete Prometheus Monitoring Integration
          • ListPrometheusIntegration - Query Prometheus Monitoring Integration List
          • DescribeNodeMetrics
        • Diagnostic management
          • DescribeOasTopSQLList
          • DescribeOasAnomalySQLList
          • DescribeOasSlowSQLList
          • DescribeOasSQLText
          • DescribeSqlAudits
          • DescribeOutlineBinding
          • DescribeSampleSqlRawTexts
          • DescribeSQLTuningAdvices
          • DescribeOasSlowSQLSamples
          • DescribeOasSQLTrends
          • DescribeOasSQLPlanGroup
          • DescribeRcaRecord
          • DescribeTopSQLComparision
          • DescribeSessionStatsGroupBySqlId
          • DescribeIndexes
          • DescribeOasHighRiskSQL
        • Security management
          • CreateSecurityIpGroup
          • DescribeInstanceSSL
          • ModifyInstanceSSL
          • DescribeTenantEncryption
          • ModifyTenantEncryption
          • ModifySecurityIps
          • DeleteSecurityIpGroup
          • DescribeTenantSecurityConfigs
          • DescribeInstanceSecurityConfigs
        • Tag management
          • DescribeTags
          • CreateTags
          • UpdateTag
          • DeleteTag
        • Historical event management
          • DescribeOperationEvents
        • AI service management
          • CreateAIServiceAPIKey
          • DeleteAIServiceAPIKey
          • ListAIServiceAPIKeys
      • Open API FAQ
      • Differences between ApsaraDB for OceanBase APIs and OceanBase Cloud APIs
    • Download OBClient
      • Download OBClient
      • Download OceanBase Connector/J
      • Download client ODC
      • Download OceanBase Connector/ODBC
      • Download OBClient Libs
    • Performance Tests
      • OLTP performance test: Sysbench benchmark
      • OLAP performance test: TPC-H benchmark
      • OLTP performance test: TPC-C benchmark
    • Metrics References
      • Cluster database
      • Cluster hosts
      • Binlog service
      • Cross-cloud network channel connection
      • Performance and SQL
      • Transactions
      • Storage and caching
      • Proxy database
      • Proxy host
    • ODC User Guide
      • What is ODC?
        • What is ODC?
        • Limitations
      • Quick start
        • Client ODC
          • Overview
          • Install Client ODC
          • Use Client ODC
        • Web ODC
          • Overview
          • Use Web ODC
      • Data source management
        • Create a data source
        • Data sources and project collaboration
        • Database O&M
          • Session management
          • Global variable management
          • Recycle bin management
      • SQL development
        • Edit and execute SQL statements
        • Perform PL compilation and debugging
        • Edit and export the result set of an SQL statement
        • Execution analysis
        • Generate test data
        • System settings
        • Database objects
          • Table objects
            • Overview
            • Create a table
          • View objects
            • Overview
            • Create a view
            • Manage views
          • Materialized view objects
            • Overview
            • Create a materialized view
            • Manage materialized views
          • Function objects
            • Overview
            • Create a function
            • Manage functions
          • Stored procedure objects
            • Overview
            • Create a stored procedure
            • Manage stored procedures
          • Sequence objects
            • Overview
            • Create a sequence
            • Manage sequences
          • Package objects
            • Overview
            • Create a program package
            • Manage program packages
          • Trigger objects
            • Overview
            • Create a trigger
            • Manage triggers
          • Type objects
            • Overview
            • Create a type
            • Manage types
          • Synonym objects
            • Overview
            • Create a synonym
            • Manage synonyms
      • Import and export
        • Import schemas and data
        • Export schemas and data
      • Database change management
        • User permission management
          • Users and roles
          • Automatic authorization
          • User permission management
        • Project collaboration management
        • Risk levels, risk identification rules, and approval processes
        • SQL check specifications
        • SQL window specification
        • Database change management
        • Batch database change management
        • Online schema changes
        • Synchronize shadow tables
        • Schema comparison
      • Data lifecycle management
        • Partitioning plan management
          • Manage partitioning plans
          • Set partitioning strategies
          • Examples
        • SQL plan task
      • Data desensitization and auditing
        • Desensitize data
        • Operation records
      • Notification management
        • Overview
        • View notification records
        • Manage notification channel
          • Create a notification channel
          • View, edit, and delete a notification channel
          • Configure a custom channel
        • Manage notification rules
      • Best practices
        • Tips for SQL development
        • Explore ODC team workspaces
        • Understanding real-time SQL diagnostics for OceanBase AP
        • OceanBase historical database solutions
        • ODC SQL check for automatic identification of high-risk operations
        • Manage and modify sharded databases and tables via ODC
        • Data masking and control practices
        • Enterprise-level control and collaboration: Safeguard every database change
    • Data development
      • Overview
      • Workspace management
      • Worksheet management
      • Compute node pool management
      • Workflow management
      • Dashboard management
      • Manage Git repositories
      • SQL development
        • SQL editing and execution
        • Result set editing
        • Execution analysis
        • Database object management
          • Create a table
          • Create a view
          • Create a function
          • Create a stored procedure
        • Session variable management
        • Git integration
      • Sample datasets
      • Data development terms
  • Manage Billing
    • Access billing
    • View bills
      • View orders
    • View monthly bills
    • View payment details
    • Manage AI service billing
      • Usage monitoring
      • View API key records
      • Rate limits & quotas
    • Payment method
      • Use vouchers for payment
    • View invoices
  • Legal Agreements
    • OceanBase Cloud Services Agreement
    • AI Service Addendum
    • Service Level Agreement
    • OceanBase Data Processing Addendum
    • Service Level Agreement for OceanBase Cloud Migration Service
    • Historical agreements
      • Service Level Agreement for OceanBase Cloud Migration Service (Released March 20, 2026)

Download PDF

Document Feedback
  1. Documentation Center
  2. OceanBase Cloud

DescribeTenants

Last Updated:2026-09-22 07:23:31

Overview
API details
Constraints
Request path
Request parameters
Response parameters
Examples
Request example
Response example

Overview

You can call this API to query the list of tenants in an OceanBase Cloud database instance based on specified conditions. You can perform fuzzy matching on the tenant name and filter tenants by tags. You can also perform pagination queries.

API details

Constraints

The caller must have an AccessKey for accessing APIs of OceanBase Cloud. For information about how to obtain the AccessKey ID and AccessKey Secret, see Manage AccessKeys.

Request path

GET /api/v2/instances/{instanceId}/tenants

Request parameters

Path

Parameter
Type
Required
Description
Example value
instanceId String Yes OceanBase cluster ID. obcluster-*****

Query

Parameter
Type
Required
Description
Example value
requestId String Yes ID of the request. This parameter is used for tracing. dc302d76-66b5-48d8-ab53-a035********
pageNumber Integer No number of the page to return.
  • Value range: 1 to 1000.
  • Default value: 1.
1
pageSize Integer No number of entries to return on a page.
  • Value range: 1 to 100.
  • Default value: 10.
10
tenantName String No name of the tenant.
You can perform fuzzy matching on the tenant name.
pay_****
tagList String No list of tags. N/A

Response parameters

Field
Type
Description
Example value
success Boolean Whether the operation succeeded. true
errorCode String Error code. INVALID_PARAMETER
errorMessage String Error message. Invalid parameter
data Object Business data (object). N/A
cost Number Time consumed. 1.0
server String Server address, typically the IP address of an OBServer node. 10.0.0.10
requestId String Request ID. d04eabba****
totalCount Number Total record count. 100.0
extra Object Extended information. {}

data object fields

Field
Type
Description
Example value
dataList Array Dataset. [{"tenantId": "t4louaeei****"}]
total Number Total data volume. 100.0
hasMore Boolean Whether there is more data. true

data.dataList[] object fields

Field
Type
Description
Example value
tenantId String Tenant ID. t4louaeei****
ocpTenantId Integer OCP internal tenant identifier. xxxxxx
tenantName String Tenant name. xxxxxx
managementMode String Management mode: DBAAS or MAAS. DBAAS
gmtCreate String Creation time. 2026-02-25 15:40:43+00:00
createTime String Creation time (UTC). 2026-02-25 15:40:43+00:00
tenantMode String Tenant mode, for example, MySQL or Oracle. xxxxxx
primaryRegion String Primary region. cn-hangzhou
primaryZone String Primary zone. cn-hangzhou-i
status String Current status of the task or resource. ONLINE
cpu Integer Number of processor cores or specification. 4
mem Integer Total memory, in GB. 16
diskSize Integer Disk size. 200
unitCpu Integer Processor specification per unit. 2
unitMem Integer Memory specification per unit. 8
unitNum Integer Number of units. 1
unitDiskSize Integer Disk size per unit. 200
vpcId String VPC identifier. vpc-xxxx****
deployType String Deployment type. multiple
description String Description. For tenants used in business transactions.
tenantConnections Array Tenant connection information. [{"tenantId": "t4louaeei****"}]
tenantZones Array Zone information. [{"name": "Data source name"}]
tenantResource Object Tenant resource specification information. N/A
tenantResource.cpu Object N/A. N/A
tenantResource.memory Object N/A. N/A
tenantResource.disk Object N/A. N/A
tenantResource.unitNum Integer Number of units. 1
enableBinlogService Boolean Whether to enable the Binlog service. true
readonlyConnectionAddable String Whether a read-only address can be added. Valid values:
  • ADDABLE: The address can be added.
  • DISABLED: The address cannot be added.
  • INVISIBLE: The entry for adding the address is hidden.
ADDABLE
readwriteConnectionAddable String Whether a read/write splitting address can be added. Valid values:
  • ADDABLE: The address can be added.
  • DISABLED: The address cannot be added.
  • INVISIBLE: The entry for adding the address is hidden.
ADDABLE
timeZone String Time zone configured for the tenant. +08:00
charset String Character set configured for the tenant. utf8mb4
collation String Collation configured for the tenant. utf8mb4_general_ci
lowerCaseTableNamesParam Integer Case sensitivity of table names for the tenant. 1
parameterTemplate String Parameter template. oltp
tagList Array Tenant tags. [{"tagKey": "env", "tagValue": "prod"}]
tenantCompatibilityMode String Tenant compatibility mode. A TP cluster returns MySQL or Oracle, and a KV cluster returns HBase or Table. xxxxxx
dataMergeTime String Tenant major compaction time (available only in 4.x clusters). 02:00
enableProxyPublicLink Boolean Whether to enable public access. false
enableProxyPeeringLink Boolean Whether to enable peering access. false
odpDefaultVersion String default ODP version for tenant creation addresses. 4.2.1
enableProxyService Boolean Whether to enable the proxy service. true
globalAddressAddable String Whether a global address can be added. Valid values:
  • ADDABLE: The address can be added.
  • DISABLED: The address cannot be added.
  • INVISIBLE: The entry for adding the address is hidden.
ADDABLE
enableStandbyReadWriteSplit String Read/write splitting switch status for primary/standby databases. ENABLED
instanceZoneReplicas Array Replica list in the zone of the instance. [{"logicalZone": "ap-beijing-3-ro-z0"}]
zones Array Zone list, separated by commas. N/A
tenantMaxConnections Integer Maximum number of connections for the tenant. xxxxxx
ragCluster Object RAG cluster information. N/A
ragCluster.gmtCreate String Creation time. 2026-02-25 15:40:43+00:00
ragCluster.gmtModified String Modification time. 2026-02-26 10:40:43+00:00
ragCluster.ragClusterId String RAG cluster ID. obcluster-*****
ragCluster.ragClusterArn String RAG cluster ARN. acs:oceanbase:cn-hangzhou:200006001999:rag/rag-123456
ragCluster.instanceId String OceanBase cluster ID. obcluster-*****
ragCluster.tenantId String Tenant ID. t4louaeei****
ragCluster.region String Region, required for some object storage vendors, for example, S3. ap-guangzhou
ragCluster.zone String Zone. cn-hangzhou-i
ragCluster.version String OceanBase version. 2.2.52
ragCluster.cloudProvider String Cloud vendor where the resource or data source is located. xxxxxx
ragCluster.status String Current status of the task or resource. ONLINE
ragCluster.resourceAccount String Resource account. 3
ragCluster.uid String User ID. 20000600****
enableRag Boolean Whether to enable RAG. false
iops Integer IOPS metric for storage. 1000
aiFunctionStatus String AI function status. ENABLED
privateLinkExisted Boolean Whether a private link exists. true
tenantCompatibilityControl String Tenant compatibility control configuration. xxxxxx
unitLogDisk Integer Unit log disk specification. 100
directConnectionAddable String Whether a direct connection address can be added. Valid values:
  • ADDABLE: The address can be added.
  • DISABLED: The address cannot be added.
  • INVISIBLE: The entry for adding the address is hidden.
ADDABLE
directConnectionAddableReasonType String Reason why a direct connection address cannot be created. Valid values: INSTANCE_LEVEL for an instance-level reason and TENANT_LEVEL for a tenant-level reason. This field is null when the address can be created. INSTANCE_LEVEL
instanceType String Instance type. DEDICATE****
tenantType String Tenant type. Ultimate Edition TP, KV, and AP tenants are distinguished at the tenant level, whereas non-Ultimate Edition tenants are distinguished by instance type. xxxxxx
odpAddressStatus String ODP connection readiness status for the tenant (available only at the tenant level). Valid values: ONLINE and PENDING_CREATE.

Semantics: Indicates whether the tenant currently has at least one available primary address. The frontend uses this field to determine whether the cards for the primary address, private network connection, peering connection, or public network connection are still in the "Preparing" state. This prevents users from repeatedly clicking to create an address when the tenant is already online but its first batch of primary addresses is still being created.

Determination rules:

  • If the set of primary address server groups of the tenant is empty after groups in the DELETED state are excluded, the status defaults to ONLINE. These server groups cover five primary address types, including private network addresses, public network addresses, and Alibaba Cloud OBPROXY addresses. This situation occurs when Alibaba Cloud CLB does not create ODPs or when an empty tenant has just been created.
  • If at least one element in the set is ONLINE, the status is ONLINE. Public network or peering addresses subsequently added in the PENDING_CREATE state do not affect the overall status. An ODP proxy cluster that later enters the O&M state also does not affect the overall status.
  • If none of the primary addresses are ONLINE, which typically occurs when a tenant has just come online and its first batch of primary addresses is still being created, the status is PENDING_CREATE.

This field differs from the scope for allowlist distribution. The cluster-level ModifyClusterSecurityIpGroup and tenant-level ModifyTenantSecurityIpGroup operations use strict L1+L2 determination: all primary address server groups and all associated ODP proxy clusters must be ONLINE, and any O&M state blocks distribution. This field does not consider the O&M state of proxy clusters or require all primary addresses to be ONLINE.

.
ONLINE

data.dataList[].instanceZoneReplicas[] object fields

Field
Type
Description
Example value
logicalZone String Logical zone. ap-beijing-3-ro-z0
replicaType String Replica type, for example, FULL, READONLY, or LOGONLY. FULL
zoneRegionName String Region name where the replica is located. test-name
zoneLogicalId Integer Logical zone ID where the replica is located. xxxxxx
zoneId String Zone ID. cn-hangz****
status String Current status of the task or resource. ONLINE
nodeNum Integer Number of nodes. 3
readonlyInstanceId String Read-only instance ID. obcluster-*****-ro
replicaResource Object Replica resource specification information. N/A
replicaResource.cpu Object N/A. N/A
replicaResource.memory Object N/A. N/A
replicaResource.diskSize Object N/A. N/A
readOnlyReplicaType Object N/A. N/A

data.dataList[].tagList[] object fields

Field
Type
Description
Example value
tagKey String Tag key. env
tagValue String Tag value. prod

data.dataList[].tenantConnections[] object fields

Field
Type
Description
Example value
tenantId String Tenant ID. t4louaeei****
vpcId String VPC identifier. vpc-xxxx****
userVpcOwnerId String Account identifier of the user's VPC. 20000600****
vSwitchId String Switch identifier. vsw-xxxx****
connectionZones Array Zones connected to the connection. ["cn-hangzhou-i"]
connectionLogicalZones Array List of logical zones associated with the connection address. ["cn-hangzhou-i"]
connectionReplicaType String Replica type accessed via the connection address. FULL
tenantEndpointId String Supplemental tenant endpoint ID for multi-cloud v5. te-xxxxx****
addressId String In multi-cloud scenarios, this is the VIP service group name. rs-private-internet-*****
addressStatus String Connection status. ONLINE
serviceType String Address type. PRIVATE
addressType String Address type: MASTER, READONLY. MASTER
networkType String Network type. INTRANET
role String Connection type: READWRITE/READONLY. For primary addresses, the read/write type is sometimes also distinguished. The primary address of a standby database is read-only. READWRITE
userNameFormat String Username format when using this address: one-part, two-part, or three-part. TWO_PART
useSSL Boolean Whether to enable SSL. false
proxyClusterInfo Object ODP proxy cluster information associated with the tenant connection. N/A
proxyClusterInfo.proxyClusterId String ODP proxy cluster ID. proxy-12****
proxyClusterInfo.proxyMode String ODP proxy mode. DEDICATED
proxyClusterInfo.zone String Zone. cn-hangzhou-i
proxyClusterInfo.unitSpec String Unit specification. 2C4G
proxyClusterInfo.unitNum Number Number of units. 1.0
proxyClusterInfo.sharedUnitNumLimit Integer Upper limit on the number of units for a shared mode proxy service in a Kubernetes cluster. 3
proxyClusterInfo.exclusiveUnitNumLimit Integer Upper limit on the number of exclusive mode units for a proxy service in a Kubernetes cluster. 3
proxyClusterInfo.status String Current status of the task or resource. ONLINE
proxyClusterInfo.proxyServiceVersion String Architecture version. 4.2.1.0
proxyClusterInfo.proxyVersion String Proxy version. 4.2.1.0
proxyClusterInfo.createTime String Creation time (UTC). 2026-02-25 15:40:43+00:00
proxyClusterInfo.expireTime String Expiration time. 2020-12-23 04:14:48+00:00
proxyClusterInfo.deployMode String Data replica mode (n/n-n/n-n-n). 1-1-1
proxyClusterInfo.maxUnitNum Number Elastic upper limit for Serverless ODP (from K8s ODPClusterSpec.maxUnitNum). 3.0
proxyClusterInfo.slaveZone String Standby zone of the replica (added in ODP commercial edition, returned only in dual/triple-zone primary/standby deployments). cn-hangzhou-i
proxyClusterInfo.nodeDistribution String Node distribution (added in ODP commercial edition, replaces deployMode). cn-hangzhou-i:1,cn-hangzhou-j:1
proxyClusterInfo.nodeCpu Number Node specification (added in ODP commercial edition, replaces unitSpec * unitNum). 4.0
proxyClusterInfo.nodeNum Integer Number of nodes (added in ODP commercial edition). 3
proxyClusterInfo.deploymentArchitecture String Deployment architecture (added in the commercial edition of ODP). For more information, see com.oceanbase.cloud.infra.common.enums.ProxyDeploymentArchitecture. Existing ODP clusters that have not been commercialized display SINGLE_AZ_DEPLOYMENT, DUAL_AZ_DEPLOYMENT, or MULTI_AZ_DEPLOYMENT. SINGLE_ZONE
proxyClusterInfo.proxyServerIds Array ODP proxy node IDs. ["resource****"]
proxyClusterInfo.enableArchitectureUpgrade Boolean Whether architecture upgrade is enabled. true
odpVersion String ODP version. 4.2.1
readStrategyConfigResponse Object Read traffic strategy configuration for the tenant connection address. N/A
readStrategyConfigResponse.odpVersion String ODP version. 4.2.1
readStrategyConfigResponse.trafficStrategy String Traffic strategy. ZONE_FIRST
readStrategyConfigResponse.replicaParams Array Replica selection. N/A
readStrategyConfigResponse.disasterRecoveryReplicaParams Array Disaster recovery replica. N/A
readStrategyConfigResponse.balancedStrategy String Balancing strategy. BALANCED
readStrategyConfigResponse.disasterRecoveryStrategy String Disaster recovery strategy. Automatically checks the primary replica when the current replica is unavailable. PRIMARY_FIRST
addressMasterZoneId String Primary zone of the address. cn-hangz****
loadBalanceType String Load balancing type. Only required for Alibaba Cloud and distinguishes between NLB and CLB. NLB
internetAddress String Public IP address. 8.8.8.8
internetPort Integer Public port. 2881
internetDomain String Public domain name. pay-core-public.oceanbase.example.com
internetAddressStatus String Public IP address status. ONLINE
internetMaxConnectionNum Integer Maximum number of public connections. 10000
internetMaxConnectionNumLimit Integer Limit on the maximum number of public connections. 20000
internetRpcPort Integer Public RPC port. 2882
internetProxyClusterId String Public proxy cluster ID. proxy-12****
internetLoadBalanceType String Load balancing type for the public IP address. NLB
intranetAddress String Private IP address. 10.0.0.10
intranetPort Integer Private network port. 2881
intranetDomain String Private network domain name. pay-core-private.oceanbase.example.com
intranetAddressStatus String Private network address status. ONLINE
maxConnectionNum Integer Maximum number of private network connections. 10000
maxConnectionNumLimit Integer Limit on modifying the maximum number of private network connections. 20000
intranetRpcPort Integer Private network RPC port. 2882
enableRPc Boolean Whether to enable RPC for direct import. true
disableRpcReason String Reason for prohibiting the enabling of RPC. ODP proxy is not ready
intranetAddressMasterZoneId String Primary zone ID. cn-hangz****
intranetAddressSlaveZoneId String Standby zone ID. cn-hangz****
deleteSingleTunnelAddress Boolean Whether the primary private network address of Alibaba Cloud can be deleted. true
intranetProxyClusterId String Private network proxy cluster ID. proxy-12****
forceMigratedObproxyIntranetDeleteInternet Boolean Whether to delete the public network address when deleting the private network address of a migrated primary address that also has a public network address. true
intranetLoadBalanceType String Load balancing type for the private network address. NLB
privateLinkList Array Private link list information. [{"privateLinkStatus": "ONLINE"}]
intranetPeeringAddress String Peering address. 10.1.0.10
intranetPeeringPort Integer Peering address port. 2881
intranetPeeringDomain String Peering address domain name. pay-core-peering.oceanbase.example.com
intranetPeeringAddressStatus String Peering address status. ONLINE
intranetPeeringMaxConnectionNum Integer Maximum number of connections for the peering address. 10000
peeringDstVpcId String Peer VPC ID. vpc-peer****
peeringDstCidrList String Peer CIDR block. 10.1.0.0****
peeringId String Peering connection ID. pcx-xxxx****
intranetPeeringProxyClusterId String Private network peering address proxy cluster ID. proxy-12****
intranetRagPort Integer Private network RAG port. 8080
internetRagPort Integer Public network RAG port. 8080
internetRagAddress String Public network RAG address. pay-core-rag-public.oceanbase.example.com
enableRagHttp Boolean Whether to enable the RAG HTTP port. false
isVirtualServerGroup Boolean Whether the address uses a virtual server group or a primary/standby server group when one side is migrated. false
isMigrated Integer Whether an address on one side of the cluster has been migrated. 0
userFormatConnStatus String Online status for one-part connection addresses. ONLINE
userFormatConnUnsupportedReason String Reason why one-part access cannot be enabled. 2881

data.dataList[].tenantConnections[].connectionLogicalZones[] element fields

Field
Type
Description
Example value
data.dataList[].tenantConnections[].connectionLogicalZones[] String Logical zone associated with the connection address. cn-hangzhou-i

data.dataList[].tenantConnections[].connectionZones[] element fields

Field
Type
Description
Example value
data.dataList[].tenantConnections[].connectionZones[] String Zone connected to the connection. cn-hangzhou-i

data.dataList[].tenantConnections[].privateLinkList[] object fields

Field
Type
Description
Example value
privateLinkStatus String Status of the private link. ONLINE
privateLinkServiceId String ID of the private link service endpoint. resource****
privateLinkEndpointId String ID of the private link endpoint. resource****
privateLinkEndpointVpcId String VPC ID of the PrivateLink endpoint. vpc-xxxx****
privateLinkEndpointSubnetId String Subnet ID of the PrivateLink endpoint. resource****
privateLinkServiceAccount String Primary account of the private link service. 3
privateLinkUserAccount String Account in the allowlist of the private link service. 3
privateLinkDomain String Private domain name. pay-core.oceanbase.example.com
intranetAddress String Private IP address. 10.0.0.10
intranetDomain String Private network domain name. pay-core-private.oceanbase.example.com
deletePrivateLink Boolean Whether the primary private network address can be deleted (cannot be deleted if a global address is associated). true

data.dataList[].tenantZones[] object fields

Field
Type
Description
Example value
name String Zone name and zone ID. Data source name
replicaType String Replica type, for example, FULL, READONLY, or LOGONLY. FULL
region String Region. ap-guangzhou
role String Role, for example, READWRITE or READONLY. READWRITE
tenantZoneReplicas Array Replica information in the zone. N/A

data.dataList[].tenantZones[].tenantZoneReplicas[] object fields

Field
Type
Description
Example value
zoneReplicaType String Replica type of the tenant in the zone, for example, FULL, READONLY, or COLUMNSTORE. FULL
zoneNodes Integer Number of nodes covered by the replica. 1
logicZoneName String Name of the logical zone where the tenant replica is located. cn-hangzhou-i
copyId Integer Sort number of the replica in the tenant topology, used to distinguish different replicas under the same tenant. xxxxxx
fullCopyId Integer Display number for full-featured replicas, corresponding to Full-featured Replica 1 and Full-featured Replica 2 on the page. xxxxxx
readOnlyCopyId Integer Display number for read-only replicas, corresponding to Read-only Replica 1 and Read-only Replica 2 on the page. xxxxxx
tenantZoneRole String Role of the tenant replica, for example, read/write replica, standby replica, or read-only replica. cn-hangz****
readOnlyReplicaType Object N/A. N/A
unitInfoList Array Unit resource details associated with the replica. [{}]

data.dataList[].zones[] object fields

Field
Type
Description
Example value
zoneId String Zone ID. cn-hangz****
region String Required for some object storage vendors, for example, S3. ap-guangzhou
zoneDisk String Data disk capacity displayed for this zone. 200
logicZoneId String Logical zone ID. resource****
replicaType String Replica type, for example, FULL, READONLY, or LOGONLY. FULL
nodes Array List of nodes in the logical zone. [{"nodeId": "xxxxxx"}]

data.dataList[].zones[].nodes[] object fields

Field
Type
Description
Example value
nodeId String Node ID. xxxxxx
serverIp String Server IP parameter. 10.0.0.10
nodeCopyId Integer Sort number of the node replica in the topology. xxxxxx
nodeStatus String Current running status of the node. ONLINE
replicaType String Replica type hosted by the node, for example, FULL, READONLY, or LOGONLY. FULL
fullCopyId Integer Display number for full-featured replicas. xxxxxx
readOnlyCopyId Integer Display number for read-only replicas. xxxxxx
logicalZone String Logical zone. ap-beijing-3-ro-z0
readOnlyReplicaType Object N/A. N/A
nodeResource Object N/A. N/A

Examples

Request example

curl --digest -u '<Your AccessKey ID:AccessKey Secret>' \
  --request GET \
  --url 'https://api-cloud.oceanbase.com/api/v2/instances/{instanceId}/tenants?requestId={requestId}&pageNumber={pageNumber}&pageSize={pageSize}&tenantName={tenantName}&tagList={tagList}' \
  -H 'X-Ob-Project-Id: <Project ID>'

Note

  • A project ID uniquely identifies a project. For information about how to obtain the project ID of an instance, see Manage projects.
  • Make sure that the specified project ID matches the project that contains instanceId.

Response example

JSON format

{
    "success": true,
    "errorCode": "INVALID_PARAMETER",
    "errorMessage": "Invalid parameter",
    "data": {
        "dataList": [
            {
                "tenantId": "t4louaeei****",
                "ocpTenantId": 1,
                "tenantName": "xxxxxx",
                "managementMode": "DBAAS",
                "gmtCreate": "2026-02-25 15:40:43+00:00",
                "createTime": "2026-02-25 15:40:43+00:00",
                "tenantMode": "xxxxxx",
                "primaryRegion": "cn-hangzhou",
                "primaryZone": "cn-hangzhou-i",
                "status": "ONLINE",
                "cpu": 4,
                "mem": 16,
                "diskSize": 200,
                "unitCpu": 2,
                "unitMem": 8,
                "unitNum": 1,
                "unitDiskSize": 200,
                "vpcId": "vpc-xxxx****",
                "deployType": "multiple",
                "description": "A tenant for business transactions",
                "tenantConnections": [
                    {
                        "tenantId": "t4louaeei****",
                        "vpcId": "vpc-xxxx****",
                        "userVpcOwnerId": "20000600****",
                        "vSwitchId": "vsw-xxxx****",
                        "connectionZones": "---\n- \"cn-hangzhou-i\"",
                        "connectionLogicalZones": "---\n- \"cn-hangzhou-i\"",
                        "connectionReplicaType": "FULL",
                        "tenantEndpointId": "te-xxxxx****",
                        "addressId": "rs-private-internet-*****",
                        "addressStatus": "ONLINE",
                        "serviceType": "PRIVATE",
                        "addressType": "MASTER",
                        "networkType": "INTRANET",
                        "role": "READWRITE",
                        "userNameFormat": "TWO_PART",
                        "useSSL": false,
                        "proxyClusterInfo": {
                            "proxyClusterId": "proxy-12****",
                            "proxyMode": "DEDICATED",
                            "zone": "cn-hangzhou-i",
                            "unitSpec": "2C4G",
                            "unitNum": 1.0,
                            "sharedUnitNumLimit": 3,
                            "exclusiveUnitNumLimit": 3,
                            "status": "ONLINE",
                            "proxyServiceVersion": "4.2.1.0",
                            "proxyVersion": "4.2.1.0",
                            "createTime": "2026-02-25 15:40:43+00:00",
                            "expireTime": "2020-12-23 04:14:48+00:00",
                            "deployMode": "1-1-1",
                            "maxUnitNum": 3.0,
                            "slaveZone": "cn-hangzhou-i",
                            "nodeDistribution": "cn-hangzhou-i:1,cn-hangzhou-j:1",
                            "nodeCpu": 4.0,
                            "nodeNum": 3,
                            "deploymentArchitecture": "SINGLE_ZONE",
                            "proxyServerIds": "---\n- \"r****",
                            "enableArchitectureUpgrade": true
                        },
                        "odpVersion": "4.2.1",
                        "readStrategyConfigResponse": {
                            "odpVersion": "4.2.1",
                            "trafficStrategy": "ZONE_FIRST",
                            "replicaParams": [
                                {}
                            ],
                            "disasterRecoveryReplicaParams": [
                                {}
                            ],
                            "balancedStrategy": "BALANCED",
                            "disasterRecoveryStrategy": "PRIMARY_FIRST"
                        },
                        "addressMasterZoneId": "cn-hangz****",
                        "loadBalanceType": "NLB",
                        "internetAddress": "xxx.xxx.x.xxx:xxx",
                        "internetPort": 2881,
                        "internetDomain": "pay-core-public.oceanbase.example.com",
                        "internetAddressStatus": "ONLINE",
                        "internetMaxConnectionNum": 10000,
                        "internetMaxConnectionNumLimit": 20000,
                        "internetRpcPort": 2882,
                        "internetProxyClusterId": "proxy-12****",
                        "internetLoadBalanceType": "NLB",
                        "intranetAddress": "xxx.xxx.x.xxx:xxx",
                        "intranetPort": 2881,
                        "intranetDomain": "pay-core-private.oceanbase.example.com",
                        "intranetAddressStatus": "ONLINE",
                        "maxConnectionNum": 10000,
                        "maxConnectionNumLimit": 20000,
                        "intranetRpcPort": 2882,
                        "enableRPc": true,
                        "disableRpcReason": "ODP proxy is not ready",
                        "intranetAddressMasterZoneId": "cn-hangz****",
                        "intranetAddressSlaveZoneId": "cn-hangz****",
                        "deleteSingleTunnelAddress": true,
                        "intranetProxyClusterId": "proxy-12****",
                        "forceMigratedObproxyIntranetDeleteInternet": true,
                        "intranetLoadBalanceType": "NLB",
                        "privateLinkList": [
                            {
                                "privateLinkStatus": "ONLINE",
                                "privateLinkServiceId": "resource****",
                                "privateLinkEndpointId": "resource****",
                                "privateLinkEndpointVpcId": "vpc-xxxx****",
                                "privateLinkEndpointSubnetId": "resource****",
                                "privateLinkServiceAccount": "3",
                                "privateLinkUserAccount": "3",
                                "privateLinkDomain": "pay-core.oceanbase.example.com",
                                "intranetAddress": "xxx.xxx.x.xxx:xxx",
                                "intranetDomain": "pay-core-private.oceanbase.example.com",
                                "deletePrivateLink": true
                            }
                        ],
                        "intranetPeeringAddress": "xxx.xxx.x.xxx:xxx",
                        "intranetPeeringPort": 2881,
                        "intranetPeeringDomain": "pay-core-peering.oceanbase.example.com",
                        "intranetPeeringAddressStatus": "ONLINE",
                        "intranetPeeringMaxConnectionNum": 10000,
                        "peeringDstVpcId": "vpc-peer****",
                        "peeringDstCidrList": "10.1.0.0****",
                        "peeringId": "pcx-xxxx****",
                        "intranetPeeringProxyClusterId": "proxy-12****",
                        "intranetRagPort": 8080,
                        "internetRagPort": 8080,
                        "internetRagAddress": "pay-core-rag-public.oceanbase.example.com",
                        "enableRagHttp": false,
                        "isVirtualServerGroup": false,
                        "isMigrated": 0,
                        "userFormatConnStatus": "ONLINE",
                        "userFormatConnUnsupportedReason": "2881"
                    }
                ],
                "tenantZones": [
                    {
                        "name": "Data Source Name",
                        "replicaType": "FULL",
                        "region": "ap-guangzhou",
                        "role": "READWRITE",
                        "tenantZoneReplicas": [
                            {
                                "zoneReplicaType": "FULL",
                                "zoneNodes": 1,
                                "logicZoneName": "cn-hangzhou-i",
                                "copyId": 1,
                                "fullCopyId": 1,
                                "readOnlyCopyId": 1,
                                "tenantZoneRole": "cn-hangz****",
                                "readOnlyReplicaType": "xxxxxx",
                                "unitInfoList": [
                                    {}
                                ]
                            }
                        ]
                    }
                ],
                "tenantResource": {
                    "cpu": "xxxxxx",
                    "memory": "xxxxxx",
                    "disk": "xxxxxx",
                    "unitNum": 1
                },
                "enableBinlogService": true,
                "readonlyConnectionAddable": "ADDABLE",
                "readwriteConnectionAddable": "ADDABLE",
                "timeZone": "+08:00",
                "charset": "utf8mb4",
                "collation": "utf8mb4_general_ci",
                "lowerCaseTableNamesParam": 1,
                "parameterTemplate": "oltp",
                "tagList": [
                    {
                        "tagKey": "env",
                        "tagValue": "prod"
                    }
                ],
                "tenantCompatibilityMode": "xxxxxx",
                "dataMergeTime": "02:00",
                "enableProxyPublicLink": false,
                "enableProxyPeeringLink": false,
                "odpDefaultVersion": "4.2.1",
                "enableProxyService": true,
                "globalAddressAddable": "ADDABLE",
                "enableStandbyReadWriteSplit": "ENABLED",
                "instanceZoneReplicas": [
                    {
                        "logicalZone": "ap-beijing-3-ro-z0",
                        "replicaType": "FULL",
                        "zoneRegionName": "test-name",
                        "zoneLogicalId": 1,
                        "zoneId": "cn-hangz****",
                        "status": "ONLINE",
                        "nodeNum": 3,
                        "readonlyInstanceId": "obcluster-*****-ro",
                        "replicaResource": {
                            "cpu": "xxxxxx",
                            "memory": "xxxxxx",
                            "diskSize": "xxxxxx"
                        },
                        "readOnlyReplicaType": "xxxxxx"
                    }
                ],
                "zones": [
                    {
                        "zoneId": "cn-hangz****",
                        "region": "ap-guangzhou",
                        "zoneDisk": "200",
                        "logicZoneId": "resource****",
                        "replicaType": "FULL",
                        "nodes": [
                            {
                                "nodeId": "xxxxxx",
                                "serverIp": "xxx.xxx.x.xxx:xxx",
                                "nodeCopyId": 1,
                                "nodeStatus": "ONLINE",
                                "replicaType": "FULL",
                                "fullCopyId": 1,
                                "readOnlyCopyId": 1,
                                "logicalZone": "ap-beijing-3-ro-z0",
                                "readOnlyReplicaType": "xxxxxx",
                                "nodeResource": "xxxxxx"
                            }
                        ]
                    }
                ],
                "tenantMaxConnections": 1,
                "ragCluster": {
                    "gmtCreate": "2026-02-25 15:40:43+00:00",
                    "gmtModified": "2026-02-26 10:40:43+00:00",
                    "ragClusterId": "obcluster-*****",
                    "ragClusterArn": "acs:oceanbase:cn-hangzhou:200006001999:rag/rag-123456",
                    "instanceId": "obcluster-*****",
                    "tenantId": "t4louaeei****",
                    "region": "ap-guangzhou",
                    "zone": "cn-hangzhou-i",
                    "version": "2.2.52",
                    "cloudProvider": "xxxxxx",
                    "status": "ONLINE",
                    "resourceAccount": "3",
                    "uid": "20000600****"
                },
                "enableRag": false,
                "iops": 1000,
                "aiFunctionStatus": "ENABLED",
                "privateLinkExisted": true,
                "tenantCompatibilityControl": "xxxxxx",
                "unitLogDisk": 100,
                "directConnectionAddable": "ADDABLE",
                "directConnectionAddableReasonType": "INSTANCE_LEVEL",
                "instanceType": "DEDICATE****",
                "tenantType": "xxxxxx",
                "odpAddressStatus": "ONLINE"
            }
        ],
        "total": 100.0,
        "hasMore": true
    },
    "cost": 1.0,
    "server": "xxx.xxx.x.xxx:xxx",
    "requestId": "d04eabba****",
    "totalCount": 100.0,
    "extra": "{}"
}

Previous topic

SwitchoverInstance - Perform a primary/standby switchover
Last

Next topic

DescribeTenant - Query Information of a Specified Tenant in a Specified Cluster
Next
on this page
Overview
API details
Constraints
Request path
Request parameters
Response parameters
Examples
Request example
Response example