OceanBase logo

OceanBase

A unified distributed database ready for your transactional, analytical, and AI workloads.

DEPLOY YOUR WAY

OceanBase Cloud

The best way to deploy and scale OceanBase

OceanBase Enterprise

Run and manage OceanBase on your infra

TRY OPEN SOURCE

OceanBase Community Edition

The free, open-source distributed database

OceanBase seekdb

Open source AI native search database

Customer Stories

Real-world success stories from enterprises across diverse industries.

View All
BY USE CASES

Mission-Critical Transactions

Global & Multicloud Application

Elastic Scaling for Peak Traffic

Real-time Analytics

Active Geo-redundancy

Database Consolidation

Resources

Comprehensive knowledge hub for OceanBase.

Blog

Live Demos

Training & Certification

Documentation

Official technical guides, tutorials, API references, and manuals for all OceanBase products.

View All
PRODUCTS

OceanBase Cloud

OceanBase Database

Tools

Connectors and Middleware

QUICK START

OceanBase Cloud

OceanBase Database

BEST PRACTICES

Practical guides for utilizing OceanBase more effectively and conveniently

Company

Learn more about OceanBase – our company, partnerships, and trust and security initiatives.

About OceanBase

Partner

Trust Center

Contact Us

International - English
中国站 - 简体中文
日本 - 日本語
Sign In
Start on Cloud

A unified distributed database ready for your transactional, analytical, and AI workloads.

DEPLOY YOUR WAY

OceanBase Cloud

The best way to deploy and scale OceanBase

OceanBase Enterprise

Run and manage OceanBase on your infra

TRY OPEN SOURCE

OceanBase Community Edition

The free, open-source distributed database

OceanBase seekdb

Open source AI native search database

Customer Stories

Real-world success stories from enterprises across diverse industries.

View All
BY USE CASES

Mission-Critical Transactions

Global & Multicloud Application

Elastic Scaling for Peak Traffic

Real-time Analytics

Active Geo-redundancy

Database Consolidation

Comprehensive knowledge hub for OceanBase.

Blog

Live Demos

Training & Certification

Documentation

Official technical guides, tutorials, API references, and manuals for all OceanBase products.

View All
PRODUCTS
OceanBase CloudOceanBase Database
ToolsConnectors and Middleware
QUICK START
OceanBase CloudOceanBase Database
BEST PRACTICES

Practical guides for utilizing OceanBase more effectively and conveniently

Learn more about OceanBase – our company, partnerships, and trust and security initiatives.

About OceanBase

Partner

Trust Center

Contact Us

Start on Cloud
编组
All Products
    • Databases
    • iconOceanBase Database
    • iconOceanBase Cloud
    • iconOceanBase Tugraph
    • iconInteractive Tutorials
    • iconOceanBase Best Practices
    • Tools
    • iconOceanBase Cloud Platform
    • iconOceanBase Migration Service
    • iconOceanBase Developer Center
    • iconOceanBase Migration Assessment
    • iconOceanBase Admin Tool
    • iconOceanBase Loader and Dumper
    • iconOceanBase Deployer
    • iconKubernetes operator for OceanBase
    • iconOceanBase Diagnostic Tool
    • iconOceanBase Binlog Service
    • Connectors and Middleware
    • iconOceanBase Database Proxy
    • iconEmbedded SQL in C for OceanBase
    • iconOceanBase Call Interface
    • iconOceanBase Connector/C
    • iconOceanBase Connector/J
    • iconOceanBase Connector/ODBC
    • iconOceanBase Connector/NET
icon

OceanBase Cloud Platform

V3.3.0Enterprise Edition

  • Document Overview
  • Product Introduction
    • What is OceanBase Cloud Platform?
    • System architecture
    • Features
    • Limits
      • System requirements
      • Dependencies
  • Deployment Guide
    • Product Introduction
      • What is OceanBase Cloud Platform?
      • System architecture
    • Deployment
      • Overview
      • Deploy OCP on a single node
      • Deploy OCP clusters in the multi-cluster mode
    • Plan resources
      • OCP-Server specifications
      • MetaDB resources
      • MonitorDB resources
      • Host resources
    • Prepare the deployment environment
      • Standardize a host
      • Check the environment
    • Deploy OCP on a single node
      • Prepare installation media
      • Generate a configuration file
      • Deploy OCP
      • Register an OCP cluster
      • Initialize system parameters
    • Check after deployment
    • Deployment FAQ
      • Optimize MonitorDB parameters
      • F5 Big-IP LTM and alert configuration
        • Connect OBProxy to F5 Big-IP LTM
        • Connect OCP-Console to F5 Big-IP LTM
        • Monitor the OCP service health
      • Ubuntu deployment FAQ
      • EulerOS deployment FAQ
      • Client requirements
      • Start and stop OCP
  • Quick Start
    • OCP operations
    • Upload a software package
    • Add a host
    • Create a cluster
    • Create a tenant
    • Create a user
    • Create an OBProxy cluster
  • User Guide
    • OCP overview
    • Log on to the OceanBase Cloud Platform console
    • Features
      • Clusters
        • Cluster management
        • Cluster overview
        • Overview of the cluster details page
      • Tenants
        • Tenant and resource management
        • Tenant overview
        • Overview of the Tenant Details page
      • Hosts
        • Host overview
        • Host details
      • Packages
      • OBProxy
        • OBProxy management overview
        • OBProxy overview
        • OBProxy cluster overview
      • Backup and recovery
        • Overview
        • Backup and recovery overview
        • Backup overview
        • Restoration overview
        • Services
      • Monitoring
        • Drill-down monitoring
      • Diagnostics
        • Overview of SQL diagnostics
        • Overview of transaction diagnostics
      • System management
        • Alert overview
        • View tasks
        • Inspection
        • Security overview
        • View system parameters
        • Historical events
        • OCP multi-cluster mode
        • Multi-zone overview
      • Personal center
        • Specify personal information
        • Change your logon password
        • Configure alert subscription
        • Password box
          • Manage connection credentials of an OceanBase cluster
          • Manage connection credentials of an OBProxy
          • Manage connection credentials of a host
        • Log off the OCP console
    • Manage clusters
      • Cluster management operations
      • Basic cluster operations
        • Take over a cluster
        • Create a cluster
        • Delete a cluster
        • Stop a cluster
        • Restart a cluster
        • Manage zones of a cluster
          • Create a zone
          • Restart a zone
          • Stop a zone
          • Delete a zone
        • Manage OBServers of a cluster
          • Add an OBServer
          • Restart an OBServer
          • Stop an OBServer
          • Replace an OBServer
          • Delete an OBServer
        • Upgrade the version of an OceanBase cluster
        • Change the password
        • Create a standby cluster
        • Routine primary/standby cluster switchover
        • Primary/Standby cluster switchover for disaster recovery
        • Decouple a standby cluster from the primary cluster
        • Enable automatic detection of deadlocks
        • Disable automatic detection of deadlocks
        • Download logs
        • Disable SQL collection
        • View the SQL collection history
        • Start the original primary cluster in read-only mode after a failover
      • View the topology of a cluster
      • Overview of cluster tenant management
      • Performance monitoring
      • Performance report
      • Cluster resource management
        • View unit distribution
        • View resource usage
      • Health inspection
      • Major compaction management
        • Modify major freeze configurations
        • Major compaction details
        • Major freeze statistics
        • Perform a major compaction
      • Cluster backup and recovery
      • Manage parameters
        • View parameters
        • Modify parameters
        • Parameter types
        • View the history of parameter changes
      • Manage cluster parameter templates
    • Manage tenants
      • Tenant management operations
      • Basic tenant operations
        • Create a tenant
        • Unit specification management
        • Create a user under an Oracle tenant
        • Lock a tenant
        • Copy a tenant
        • Delete a tenant
        • Add a replica
        • Change the password of the SYS tenant
        • Edit a tenant replica of a zone
        • Delete a tenant replica from a zone
        • Modify zone priorities
        • Modify the whitelist
      • View a tenant topology
      • Database management
      • User management under a MySQL tenant
      • User management under an Oracle tenant
        • User overview under an Oracle tenant
        • Create a user under an Oracle tenant
        • Change the password of a user under an Oracle tenant
        • Delete a user under an Oracle tenant
        • Create a role under an Oracle tenant
        • Manage users
        • Manage roles
      • Performance monitoring
      • Tenant resource management
      • Transaction diagnostics
      • SQL diagnostics
        • Suspicious SQL diagnostics
        • TopSQL diagnostics
        • SlowSQL diagnostics
        • ParallelSQL diagnostics
        • View SQL statement details
        • View the SQL collection enable/disable history
        • View outlines
        • View SQL request analysis
      • Tenant backup and recovery
      • Manage sessions
        • View tenant sessions
        • View session statistics
        • View deadlock analysis
        • Manage ASH report
      • Manage parameters
        • View the parameters
        • Modify a parameter
        • View the parameter modification history
      • Manage tenant parameter templates
    • Manage hosts
      • Host management operations
      • Add a host
      • Modify a host
      • Restart OCP Agent
      • Reinstall OCP Agent
      • Host monitoring
    • Manage software packages
      • Upload a software package
      • Download a software package
      • Delete a software package
    • Manage OBProxies
      • Create an OBProxy cluster
      • Take over an OBProxy
      • Delete an OBProxy
      • Restart an OBProxy
      • Upgrade an OBProxy
      • Add an OBProxy
      • Refresh OBProxy configurations
      • Monitor OBProxy cluster performance
      • OBProxy cluster parameter management
      • Add a connectable OceanBase cluster
      • Delete an OBProxy cluster
      • Upgrade all OBProxies in an OBProxy cluster
      • Restart all OBProxies in an OBProxy cluster
      • Delete a connected OceanBase cluster
    • Use backup and recovery
      • Backup and recovery management operations
      • Backup and recovery guide
      • Create a backup strategy
      • Back up now
      • Create a sampling strategy for recovery
      • Initiate a recovery task
      • Install a service
      • Add a node
      • Upgrade the version of a service
      • Update service configurations
      • Copy a service
      • Delete a service
      • Stop a service on a node
      • Restart a service on a node
      • View operation and maintenance tasks
      • Uninstall a service on a node
    • Manage alerts
      • Alert-related concepts
      • Create an alert item
      • View alert items
      • Copy an alert item
      • Edit an alert item
      • Delete an alert item
      • Alert groups
      • Create an alert channel
      • View alert channels
      • Edit an alert channel
      • Delete an alert channel
      • View alert events
      • View the alert notification history
      • Create a blocking condition
      • Edit a blocking condition
      • Delete a blocking condition
      • Add a filtering keyword
      • Modify the expiration time of a filter keyword
      • Delete a filter keyword
      • Create an alert subscription
      • Manage alert subscriptions
    • Use system management
      • Role overview
      • Create a role
      • Manage roles
      • Copy a role
      • Create a user
      • View users
      • Edit a user
      • Copy a user
      • Change a user password
      • Delete a user
      • Logon history
      • Manage system parameters
      • Query logs
      • Manage tasks
      • Use the inspection feature
        • Initiate an inspection
        • Create an inspection rule
        • Modify inspection scheduling
        • Modify an inspection rule
        • Delete an inspection rule
        • View inspection rules
    • Manage OCP clusters in the multi-cluster mode
      • Register an OCP cluster
      • Leader & Follower Details
      • Manage OCP cluster parameters
      • Switch an OCP cluster in daily maintenance
      • Switch an OCP cluster in a failover
      • Delete a faulty follower OCP cluster
      • Unbind a leader and a follower OCP cluster
    • Manage OCP in multi-zone mode
      • View details of multiple zones
      • Manage parameters in multi-zone mode
    • Appendix
      • OCP configuration parameters
      • OCP resource unit specifications
      • OCP error table
      • OCP alert template variables
      • Call an alert API
      • OCP background tasks
      • Monitoring metrics
      • Examples of alert channel configuration
      • OBProxy startup parameters
      • System privileges in a MySQL tenant
      • Component listening port list
      • OCP-Agent processes
      • Enable the OCP multi-cluster mode
      • PAM permission denied
      • Failed to upload the software package
      • Check the sudo permissions of a user
      • Default OCP roles
      • FAQ about multi-zone mode
      • FAQ about OBProxy takeover
      • Diagnose XA transactions and suspended transactions
  • Metric reference
    • Overview of metrics
    • OceanBase cluster
      • QPS
      • Query response time
      • TPS
      • Transaction response time
      • Request queue time
      • Number of sessions
      • TPS
      • Number of transaction logs
      • Transaction log volume
      • Time consumed by transaction logs
      • IOPS
      • Time consumed by I/O operations
      • I/O throughput
    • OceanBase Database tenant
      • QPS
      • Response time
      • Sessions
      • SQL execution plan types
      • Wait events
      • Time consumed by waiting events
      • Request queue
      • Request queue time
      • CPU utilization
      • MemStore usage
      • Time consumed by RPC packets
      • RPC packet throughput
      • opened_cursors
      • Clog synchronization delay
      • TPS
      • Transaction response time
      • Number of transaction logs
      • Transaction log volume
      • Time consumed by transaction logs
      • Lock waits
      • Time consumed by lock waits
      • TPS
      • MemStore
      • IOPS
      • Time consumed by I/O operations
      • I/O throughput
      • Cache size
      • Cache hit rates
      • Number of cache requests
    • OBProxy cluster
      • TPS
      • Requests per second
      • Client connections
      • Server connections
      • Average response time for each SQL statement
      • Average error packets per second
      • Average route table queries per second
      • Average bytes in a network request or response
    • Host
      • Linux system load
      • CPU utilization
      • IOPS
      • Time consumed by I/O operations
      • I/O throughput
      • Network throughput
      • Memory
      • Disk
  • Troubleshooting
    • Failed to register a follower OCP cluster
    • Failed to add credentials to the password box
    • Restricted OCP logon
    • Failed to view logs in OCP
    • Failed to upload the software package
    • Do IO Bench error
    • Check the sudo permissions of a user
    • PAM permission denied
    • Resolve the problem of no sudo permissions when adding a host
    • Questions about OCP-Agent
      • Exceptions of the ocp_agent processes
      • System resource constraints and PAM
    • Appendix
      • Processes
      • OCP-Agent O\&M script
  • Alert Reference
    • Overview
    • OceanBase alerts
      • ob_cannot_connected
      • ob_cluster_rs_not_same
      • ob_cluster_status_check_failed
      • ob_cluster_exists_inactive_server
      • ob_cluster_exists_index_fail_table
      • ob_cluster_frozen_version_delta_over_threshold
      • ob_cluster_merge_error
      • ob_cluster_merge_timeout
      • ob_cluster_no_frozen
      • ob_cluster_no_merge
      • ob_cluster_operation_info
      • ob_cluster_sync_failed
      • ob_cpu_assigned_percent_over_threshold
      • ob_cpu_percent_over_threshold
      • ob_host_connection_percent_over_threshold
      • ob_host_disk_readonly
      • ob_tenant_expired_trans_exist
      • ob_host_load1_per_cpu_over_threshold
      • ob_host_partition_count_over_threshold
      • ob_log_alarm
      • ob_mem_assigned_percent_over_threshold
      • ob_server_sstable_percent_over_threshold
      • ob_tenant_long_trans_exist
      • ob_tenant_operation_info
      • ob_tenant500_mem_hold_over_threshold
      • ob_tenant500_mem_hold_percent_over_threshold
      • ob_zone_sstable_percent_over_threshold
      • tenant_active_memstore_percent_over_threshold
      • tenant_cpu_percent_over_threshold
      • tenant_memstore_percent_over_threshold
      • obproxy_process_dead
      • obproxyd_process_dead
      • obproxy_cannot_connected
      • ob_cluster_sync_delay_time_too_long
      • ob_host_data_disk_percent_over_threshold
      • ob_host_log_disk_percent_over_threshold
      • ob_host_install_disk_percent_over_threshold
      • ob_tenant_exists_expired_xa_trans
      • ob_cluster_active_session_count_over_threshold
      • ob_tenant_active_session_count_over_threshold
      • ob_host_active_session_count_over_threshold
      • ob_tenant_full_clog_sync_delay
      • ob_tenant_readonly_clog_sync_delay
      • ob_tenant_logonly_clog_sync_delay
      • ob_tenant_slow_sql_exists
      • ob_tenant_large_trans_exist
      • same_alarm_rule_detect_too_many_targets
      • ob_tenant_task_timeout
      • ob_tenant_memtable_release_timeout
    • Application alerts
      • ob_cluster_inspection_not_passed
      • ob_host_ssd_wear_indicator_over_threshold
      • ob_host_mem_percent_over_threshold
      • ob_host_net_recv_percent_over_threshold
      • ob_host_net_send_percent_over_threshold
      • ob_host_tcp_retrans_percent_over_threshold
      • ob_host_cpu_percent_over_threshold
      • no_enough_exporter
      • inc_backup_delay
      • base_backup_fail
      • base_backup_too_long_time_no_one_success_task
      • backup_process_dead
      • backup_storage_capacity_over_threshold
      • backup_storage_capacity_retry_times_exceeded
      • backup_storage_capacity_timeout_or_interrupted
      • ocp_remote_server_time_diff_too_large
      • monitor_exporter_unavaliable
      • system_obproxy_unavailable
      • host_unavailable
      • host_ntp_offset_too_large
      • host_ntp_service_not_exist
      • host_agent_res_memory_over_threshold
      • host_agent_open_fd_count_over_threshold
      • host_agent_goroutine_count_over_threshold
      • partition_create_failed
      • obagent_dead
      • host_disk_readonly
      • ic_server_connect_failed
      • vpc_connect_failed
    • Appendix
      • Set an alert-blocking condition
      • Modify alert thresholds
      • Exception handling for OceanBase cluster compaction
      • OCP-Agent script
      • Apply throttling to an OceanBase cluster
      • Network troubleshooting
      • Examples of alert channel configuration
  • API Reference
    • Overview
    • API call description
    • Cluster information
      • Query clusters
      • Create an OceanBase cluster
      • Delete an OceanBase cluster
      • Stop an OceanBase cluster
      • Start an OceanBase cluster
      • Restart an OceanBase cluster
      • Upgrade an OceanBase cluster
      • Query zones of an OceanBase cluster
      • Create a zone for an OceanBase cluster
      • Delete a zone from an OceanBase cluster
      • Stop a zone in an OceanBase cluster
      • Start a zone in an OceanBase cluster
      • Restart a zone in an OceanBase cluster
      • Add an OBServer
      • Delete multiple OBServers at a time
      • Stop an OBServer
      • Start an OBServer
      • Restart an OBServer
      • Replace an OBServer
      • Change the password of an OceanBase cluster
      • Query the parameter metadata of an OceanBase cluster
      • Query parameters of an OceanBase cluster
      • Modify parameters of an OceanBase cluster
      • Query servers
      • Query servers in a zone
    • Tenant information
      • Query tenants of a cluster
      • Query all tenants
      • Query details about a tenant
      • Create a tenant
      • Delete a tenant
      • Lock a tenant
      • Unlock a tenant
      • Query units of a tenant
      • Delete a unit from a tenant
      • Add a replica for a tenant
      • Delete a replica of a tenant
      • Modify a replica of a tenant
      • Modify zone priorities of a tenant
      • Change the administrator password of a tenant
      • Modify the whitelist of a tenant
      • Query parameters of a tenant
      • Modify parameters of a tenant
      • OceanBase database management
        • Query databases
        • Create a database
        • Modify a database
        • Delete a database
    • Hosts
      • Query regions
      • Query details about a region
      • Add a region
      • Delete a region
      • Query IDCs
      • Query details about an IDC
      • Add an IDC
      • Delete an IDC
      • Query host types
      • Query details about a host type
      • Add a host type
      • Delete a host type
      • Query hosts
      • Query details about a host
      • Add multiple hosts at a time
      • Delete a host
      • Delete multiple hosts at a time
    • Software packages
      • Query software packages
      • Upload a software package
      • Delete a software package
    • OBProxy management
      • Create an OBProxy cluster
      • Delete an OBProxy cluster
      • Query OBProxy clusters
      • Query details about an OBProxy cluster
      • Update configurations of an OBProxy cluster
      • Add an OBProxy
      • Take over an OBProxy
      • Delete an OBProxy
      • Restart an OBProxy
      • Upgrade an OBProxy
      • Add a connectable OceanBase cluster for an OBProxy cluster
      • Remove a connectable OceanBase cluster from an OBProxy cluster
      • Query the parameter metadata of an OBProxy
      • Query parameters of an OBProxy cluster
    • Monitoring
      • Query the metadata of a monitoring metric
      • Query monitoring data
      • Query monitoring data and attach a tag to the data
    • Alerts
      • Alert events
        • Query the alert event list
        • Query alert events
      • Alert notifications
        • Query alert notifications
    • Task management
      • Query tasks
      • Query details about a task
      • Retry a task
      • Roll back a task
      • Query logs of a subtask instance
      • Retry a subtask
      • Skip a subtask
      • Cancel a subtask
    • OCP event history
      • Query event history
    • OceanBase user and privilege management
      • Query database user details
      • Query database user details
      • Create a database user
      • Delete a database user
      • Change the password of a database user
      • Lock a database user
      • Unlock a database user
      • Query the database role details
      • Query database role details
      • Create a database role
      • Delete a database role
      • Query database objects
      • Grant global privileges to a user
      • Revoke global privileges of a user
      • Change global privileges of a user
      • Grant global privileges to a role
      • Revoke global privileges of a role
      • Change global privileges of a role
      • Grant roles to a user
      • Revoke roles of a user
      • Change roles of a user
      • Grant roles to a role
      • Revoke roles of a role
      • Change roles of a role
      • Grant database privileges to a user
      • Revoke database privileges of a user
      • Change database privileges of a user
      • Grant object privileges to a user
      • Revoke object privileges of a user
      • Change object privileges of a user
      • Grant object privileges to a role
      • Revoke object privileges of a role
      • Change object privileges of a role
    • OCP Agent management
      • Query OCP Agent details on a host
      • Stop basic OCP Agent processes on a host
      • Batch stop basic OCP Agent processes on a host
      • Restart basic OCP Agent processes on a host
      • Batch restart basic OCP Agent processes on a host
      • Query OCP Agent processes on a host
      • Restart OCP Agent processes on a host
      • Stop OCP Agent processes on a host
    • SQL performance
      • Query performance indicators of an SQL statement
      • Query the performance indicator trend of an SQL statement
      • Query SQL text
      • Query performance indicators of an execution plan
      • Query the performance indicator trend of an execution plan
      • Query the operator structure of an execution plan
    • Backup and recovery
      • Query backup capabilities of a cluster
      • Create a backup strategy for a cluster
      • Modify the backup strategy of a cluster
      • Delete the backup strategy of a cluster
      • Query the backup strategy of a cluster
      • Query the backup overview of a cluster
      • Query data backup tasks of a cluster
      • Query log backup tasks of a cluster
      • Query recovery tasks of a cluster
      • Immediately back up a cluster
      • Parse cluster backup data
      • Initiate tenant recovery
    • Others
      • Query the basic information of an OCP application
      • Query OCP server time
      • Query OCP application status
    • Appendix
      • Task information
      • View alerts through APIs
  • FAQ
    • FAQ on deployment
    • FAQ on upgrade
    • FAQ on monitoring
      • FAQ on monitoring metrics
      • FAQ on SQL monitoring
      • FAQ about resource usage
    • FAQ on alerts
    • FAQ on O&M
      • FAQ on accounts and passwords
      • FAQ on host management
      • FAQ on OceanBase clusters
      • FAQ on OceanBase tenants
      • FAQ on OBProxy
      • FAQ on the OCP software package
      • FAQ on backup and recovery
    • FAQ on the OCP system
    • OCP multi-cluster FAQ

Download PDF

Document Overview What is OceanBase Cloud Platform? System architecture Features System requirements Dependencies What is OceanBase Cloud Platform? System architecture Overview Deploy OCP on a single node Deploy OCP clusters in the multi-cluster mode OCP-Server specifications MetaDB resources MonitorDB resources Host resources Standardize a host Check the environment Prepare installation media Generate a configuration file Deploy OCP Register an OCP cluster Initialize system parameters Check after deployment Optimize MonitorDB parameters Ubuntu deployment FAQ EulerOS deployment FAQ Client requirements Start and stop OCP OCP operations Upload a software package Add a host Create a cluster Create a tenant Create a user Create an OBProxy cluster OCP overview Log on to the OceanBase Cloud Platform console Packages Cluster management operations View the topology of a cluster Overview of cluster tenant management Performance monitoring Performance report Health inspection Cluster backup and recovery Manage cluster parameter templates Tenant management operations View a tenant topology Database management User management under a MySQL tenant Performance monitoring Tenant resource management Transaction diagnostics Tenant backup and recovery Manage tenant parameter templates Host management operations Add a host Modify a host Restart OCP Agent Reinstall OCP Agent Host monitoring Upload a software package Download a software package Delete a software package Create an OBProxy cluster Take over an OBProxy Delete an OBProxy Restart an OBProxy Upgrade an OBProxy Add an OBProxy Refresh OBProxy configurations Monitor OBProxy cluster performance OBProxy cluster parameter management Add a connectable OceanBase clusterDelete an OBProxy cluster Upgrade all OBProxies in an OBProxy cluster Restart all OBProxies in an OBProxy cluster Delete a connected OceanBase cluster Backup and recovery management operations Backup and recovery guide Create a backup strategy Back up now Create a sampling strategy for recovery Initiate a recovery task Install a service Add a node Upgrade the version of a service Update service configurations Copy a service Delete a service Stop a service on a node Restart a service on a node View operation and maintenance tasks Uninstall a service on a node Alert-related concepts Create an alert item View alert items Copy an alert item Edit an alert item Delete an alert item
OceanBase logo

The Unified Distributed Database for the AI Era.

Follow Us
Products
OceanBase CloudOceanBase EnterpriseOceanBase Community EditionOceanBase seekdb
Resources
DocsBlogLive DemosTraining & Certification
Company
About OceanBaseTrust CenterLegalPartnerContact Us
Follow Us

© OceanBase 2026. All rights reserved

Cloud Service AgreementPrivacy PolicySecurity
Contact Us
Document Feedback
  1. Documentation Center
  2. OceanBase Cloud Platform
  3. V3.3.0
iconOceanBase Cloud Platform
V 3.3.0Enterprise Edition
  • V 4.3.6
  • V 4.3.5
  • V 4.3.4
  • V 4.3.3
  • V 4.3.2
  • V 4.3.1
  • V 4.3.0
  • V 4.2.2
  • V 4.0.0 and earlier

Add multiple hosts at a time

Last Updated:2023-08-15 11:20:54  Updated
share
What is on this page
Description
Call description
Prerequisite
Request path
Request parameters
Response parameters
Examples
Sample request
Sample response

folded

share

Description

You can call this operation to add multiple hosts at a time.

Call description

Prerequisite

You have the HOST_MANAGER permissions.

Request path

POST /api/v2/compute/hosts/batchCreate

Request parameters

Parameter Type Required Example value Description
hostBasicDataList ObjectArray Yes -- The HostBasicData array, which contains basic information of the host.
sshPort Integer Yes 22 The SSH port number of the host.
kind String Yes DEDICATED_PHYSICAL_MACHINE The type of the host. Valid values: * DEDICATED_PHYSICAL_MACHINE * DEDICATED_CONTAINER
publishPorts StringArray No 8080:8080,8090,8090 The port mapping. When kind is set to DEDICATED_CONTAINER, the port mapping between the container and the physical machine must be specified.
idcId Long Yes 100 The ID of the IDC.
typeId Long Yes 1001 The ID of the host type.
credentialId Long Yes 1001 The ID of the credential, which is used to access the host over SSH.
alias String No Server 1 The alias of the host. You can set an alias only when you add a single host.
description String No Test server The description of the host.

Data structure of HostBasicData

Parameter Type Required Example value Description
innerIpAddress String Yes 192.168.0.1 The IP address of the host.
serialNumber String No 6CU4120W67 The serial number of the host.

Response parameters

Parameter Type Description
data Object The requested data.
├─ contents Array The TaskInstance array. For more information about the data structure, see the following table.
successful Boolean Indicates whether the request was successful.
timestamp Datetime The timestamp when the server completed the request.
duration Integer The time taken by the server to process the request, in milliseconds.
status Integer An HTTP status code.
traceId String The trace ID of the request. This trace ID is used for troubleshooting.
server String The address of the application server that responded to the request.

Data structure of TaskInstance

Parameter Type Description
id Long The ID of the software package.
name String The name of the software package.
clusterId Long The ID of the cluster.
tenantId Long The ID of the tenant.
hostId Long The ID of the host.
type String The type of the task. Valid values: * MANUAL: indicates a manually initiated task. * SYS_ONECE: indicates a one-time task executed by the system. * SCHEDULED: indicates a non-built-in scheduled task. * SYS_SCHEDULED: indicates a built-in scheduled task.
status Integer The status of the task. Valid values: * RUNNING * FAILED * SUCCESSFUL
creator String The username of the task creator.
operation String The operation performed by the task. Valid values: * EXECUTE * RETRY * ROLLBACK * SKIP * CANCEL
executor String The IP address of the node that executed the task.
createTime String The time when the task was created.
startTime String The start time of the task.
finishTime String The end time of the task.
prohibitRollback Boolean Indicates whether rollback was supported by the task.
subtasks ObjectArray The SubtaskInstance array, which contains the information of all subtasks.

Data structure of SubtaskInstance

Parameter Type Description
id Long The ID of the subtask instance.
name String The name of the subtask.
seriesId Long The serial number of the subtask.
description String The description of the subtask.
timeout Integer The timeout period of the subtask, in seconds.
status String The status of the subtask. Valid values: * PENDING * READY * RUNNING * CANCELING * FAILED * SUCCESSFUL
operation String The operation performed by the subtask. Valid values: * EXECUTE * RETRY * ROLLBACK * SKIP * CANCEL
executor String The node that executed the subtask.
runTime Integer The number of executions of the subtask.
createTime String The time when the subtask was created.
startTime String The start time of the subtask.
finishTime String The end time of the subtask.
nodeType String The node type, for example, JAVA_TASK.
paralleIdx Integer The index of a parallel subtask. -1 indicates that the subtask is not a parallel subtask.
upstreams LongArray The IDs of upstream subtasks.
downstream LongArray The IDs of downstream subtasks.
prohibitRollback Boolean Indicates whether rollback was supported by the subtask.

Examples

Sample request

POST /api/v2/compute/hosts/batchCreate

curl --user <username>:<password> -X POST 'http://<IP>:<PORT>/api/v2/compute/hosts/batchCreate' \
-H 'Content-Type: application/json' \
--data-raw '{"hostBasicDataList":[{"innerIpAddress":"192.168.0.1"}],"sshPort":22,"typeId":1,"idcId":1000002,"kind":"DEDICATED_PHYSICAL_MACHINE","credentialId":2000001}' \

Sample response

{
  "data": {
    "contents": [
      {
        "creator": "admin",
        "executor": "xx.xx.xx.xx",
        "hostId": 4000002,
        "id": 35006655,
        "name": "Prepare host",
        "operation": "EXECUTE",
        "startTime": "2021-08-25T19:48:49.604+08:00",
        "status": "RUNNING",
        "subtasks": [
          {
            "description": "Update host status",
            "downstreams": [],
            "id": 13006993,
            "name": "Update host status",
            "nodeType": "JAVA_TASK",
            "operation": "EXECUTE",
            "parallelIdx": -1,
            "prohibitRollback": false,
            "runTime": 1,
            "seriesId": 4,
            "status": "PENDING",
            "timeout": 1800,
            "upstreams": [
              13006994
            ]
          },
          {
            "description": "Uninstall legacy ocp agent",
            "downstreams": [
              13006994
            ],
            "id": 13006990,
            "name": "Uninstall legacy ocp agent",
            "nodeType": "JAVA_TASK",
            "operation": "EXECUTE",
            "parallelIdx": -1,
            "prohibitRollback": false,
            "runTime": 1,
            "seriesId": 2,
            "status": "PENDING",
            "timeout": 600,
            "upstreams": [
              13006991
            ]
          },
          {
            "description": "Pre check for create host",
            "downstreams": [
              13006991
            ],
            "id": 13006992,
            "name": "Pre check for create host",
            "nodeType": "JAVA_TASK",
            "operation": "EXECUTE",
            "parallelIdx": -1,
            "prohibitRollback": false,
            "runTime": 1,
            "seriesId": 1,
            "status": "READY",
            "timeout": 1800,
            "upstreams": []
          },
          {
            "description": "Install ocp agent",
            "downstreams": [
              13006993
            ],
            "id": 13006994,
            "name": "Install ocp agent",
            "nodeType": "JAVA_TASK",
            "operation": "EXECUTE",
            "parallelIdx": -1,
            "prohibitRollback": false,
            "runTime": 1,
            "seriesId": 0,
            "status": "PENDING",
            "timeout": 5400,
            "upstreams": [
              13006990
            ]
          },
          {
            "description": "Uninstall legacy obagent",
            "downstreams": [
              13006990
            ],
            "id": 13006991,
            "name": "Uninstall legacy obagent",
            "nodeType": "JAVA_TASK",
            "operation": "EXECUTE",
            "parallelIdx": -1,
            "prohibitRollback": false,
            "runTime": 1,
            "seriesId": 3,
            "status": "PENDING",
            "timeout": 2100,
            "upstreams": [
              13006992
            ]
          }
        ],
        "type": "MANUAL"
      }
    ]
  },
  "duration": 1118,
  "server": "192.168.0.1",
  "status": 200,
  "successful": true,
  "timestamp": "2021-08-25T19:48:49.639+08:00",
  "traceId": "93c00223847c4e0a"
}

Previous topic

Query details about a host
Last

Next topic

Delete a host
Next
What is on this page
Description
Call description
Prerequisite
Request path
Request parameters
Response parameters
Examples
Sample request
Sample response