Oceanbase Cloud Platform OCP Documentation- Database Management Tool

OceanBase Cloud Platform

V4.0.0Community Edition

Document Overview
Product Introduction
- What is OceanBase Cloud Platform?
- System architecture
- Features
- Limits
  - System requirements
  - Dependencies
Deployment Guide
- Overview
- Installation process
- Installation planning
  - User planning
  - Host planning
  - Disk and directory planning
  - Port planning
- Prepare for the installation
- Modify the configuration file
- Deploy OCP
- Upgrade OCP
- Check after deployment or update
- Appendix
  - Install Docker
  - Uninstall OCP
  - Restart OCP
User Guide
- OCP overview
- Log on to the OCP 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
  - Monitoring
    - Drill-down monitoring
  - System management
    - Alert overview
    - View tasks
    - Log service
    - Security overview
    - View system parameters
  - Personal center
    - Specify personal information
    - Change your logon password
    - Alert subscription configuration
    - Password box
    - 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 service
      - Stop an OBServer process
      - Replace an OBServer
      - Delete an OBServer
    - Upgrade the version of an OceanBase cluster
    - Change the password
    - Download logs
    - Disable SQL collection
    - View the SQL collection history
  - View the topology of a cluster
  - Overview of cluster tenant management
  - Performance monitoring
  - Cluster resource management
    - View unit distribution
    - View resource usage
  - Major compaction management
    - Modify the major compaction settings of a cluster
    - Details of major compaction
    - Major freeze statistics
    - Perform a major compaction
  - Backup and recovery
    - Create a backup strategy
    - Back up now
    - Cluster backup and recovery
    - Initiate a recovery task
  - 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
    - Lock a tenant
    - Copy a tenant
    - Delete a tenant
    - Create a replica
    - Change the password of the SYS tenant
    - Edit a tenant replica in a zone
    - Delete a tenant replica from a zone
    - Modify zone priorities
    - Modify the whitelist
  - View the topology of a tenant
  - Database management
  - User management under a tenant
  - Performance monitoring
  - Tenant resource management
  - SQL diagnostics
    - TopSQL diagnostics
    - SlowSQL diagnostics
    - View SQL statement details
    - View the SQL collection enable/disable history
  - Tenant major compaction management
    - Modify major compaction settings of a tenant
    - Details of tenant major compaction
    - Perform a major compaction
  - Manage sessions
    - View tenant sessions
    - View session statistics
  - 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
- Manage software packages
  - Upload a software package
  - Download a software package
  - Delete a software package
- Manage OBProxies
  - Create an OBProxy cluster
  - 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
- 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
  - Manage tasks
  - Query logs
- User center management
  - Create a connection
  - Export connection credentials
  - Import connection credentials
  - Share connection credentials
  - Edit connection credentials
  - Delete connection credentials
  - Batch operations on connection credentials
  - Accept a connection
  - Ignore a connection
- FAQ
- Appendix
  - OCP configuration parameters
  - SQL performance module
  - OCP resource unit specifications
  - OCP error codes
  - 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
  - Install dependent software
  - Use OCP-Agent to push time-series monitoring data
Alert Reference
- Alert Reference
- 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_expired_trans_exist
  - ob_tenant_long_trans_exist
  - ob_host_task_timeout
  - ob_tenant_log_disk_usage_high
  - ob_tenant_no_compaction
  - ob_tenant_no_frozen
  - ob_tenant_compaction_error
- 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 Inter-Connector
  - vpc_connect_failed
  - node_load1_peak
- OAS alerts
  - os_cpu_irq_error
  - os_tsar_cpu_sys_abnormal
  - os_observer_fd_usage
  - os_tsar_cpu_util_full
  - os_tsar_cpu_util_hwm
  - os_kernel_io_hang
  - os_tsar_sda_ioawait
  - os_tsar_nvme_ioawait
  - os_tsar_traffic_drop
  - os_tsar_traffic_error
  - os_observer_not_exist
  - os_observer_core_dump
  - os_nic_1000m_full
  - os_nic_1000m_hwm
  - os_tsar_traffic_overload
  - node_file_root_usage
  - node_file_inode_usage
  - os_kernel_ntp_down
  - os_kernel_ntp_delay
  - node_memory_peak
  - os_home_file_usage
  - node_file_data1_usage
  - node_file_datalog1_usage
- 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
  - Tables managed by the daemon
  - 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
  - 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
  - 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
- 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
  - Query recovery tasks of 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