OCP V4.2.2

V4.2.2

OCP V4.2.2 officially supports OceanBase Database V4.2.2 and fully implements the closed-loop management capability of OceanBase's end-to-end tracing module. This includes support for migrating OceanBase/OBProxy clusters out, as well as arbitration service takeover/migration functions, achieving a basic O&M feature completion rate of up to 95%. Additionally, this version introduces a significant new capability: the monitoring dashboard, which supports real-time monitoring and customized performance monitoring in promotional scenarios. In terms of backup and recovery, it now supports Huawei Cloud OBS, further enhancing support for storage media from major domestic cloud providers. Furthermore, this version includes over 30 optimizations and enhancements in areas such as monitoring and alerting, task management, backup and recovery, password management, and tag management. It provides over 900 product error codes, focusing on improving product usability and stability to create a simpler and more user-friendly full-lifecycle database management platform, helping users better manage OceanBase databases.

Version information

• Version: V4.2.2

• Previous version: V4.2.1 BP1

• Version release date: February 21, 2024

• Supported upgrade path:

• Currently, only direct upgrades from OCP V3.2.4 and later versions to the current version are supported.

• For OCP V2.3.x and later, but earlier than V3.2.4, you must first upgrade to OCP V3.3.4.

• For OCP versions earlier than V2.3.0, you must first upgrade to OCP V2.3.x and then to OCP V3.3.4.

Supported OceanBase Database versions

OCP V4.2.2 supports the following versions of OceanBase Database.

• OceanBase V1.4.x

• OceanBase V2.1.x

• OceanBase V2.2.x

• OceanBase V3.1.x

• OceanBase V3.2.x

• OceanBase V4.x

New features

OceanBase V4.x adaptation

• Added a new monitoring metric: maximum log synchronization latency at the tenant level. For more information, see clog synchronization latency .
• Supports OceanBase read-only parameter configuration (EDIT_LEVEL='READONLY').
• Adapts to the primary/standby replication roles of networked primary/standby databases in OceanBase Oracle-compatible tenant mode, simplifying user authorization operations.
• Supports GIS data types in OceanBase Oracle-compatible tenant mode.
• Supports granting the PL privilege to users globally in OceanBase Database in MySQL-compatible mode.

Monitoring Dashboard

The monitoring dashboard primarily meets user needs such as "monitoring the situation" during events like Double 11 and for custom monitoring views. It provides features like monitoring data comparison for multiple instances and metrics, chart linkage, and supports seven chart display types including pie charts, tables, and bar charts. This helps users monitor the overall performance and operational status of the database system. For more information, see Monitoring dashboard.

Tag Management

Tags in OCP provide organization, classification, quick search and filtering, task and project management, team collaboration, and sharing capabilities. They offer a flexible and efficient way to help users organize, search for, and manage various database objects, thereby enhancing team collaboration. For more information, see Manage tags.

Feature enhancements

• Cluster management
  • Supports the ability to move out an OceanBase cluster, fully realizing closed-loop management capabilities for OceanBase Database. For details, see Move out a cluster.
  • Supports taking over and moving out arbitration services, improving closed-loop management capabilities for arbitration services. For details, see Take over an arbitration service and Move out an arbitration service.
• OBProxy management
  • Supports the ability to move out an OBProxy cluster, fully realizing closed-loop management capabilities for OBProxy. For details, see Move out an OBProxy cluster.
  • The log search module now displays routing diagnostics, connection diagnostics, and error logs for the OBProxy service.
• Host management
  • When adding a host, it now supports checking whether the system parameter current_clocksource=tsc is correctly configured, avoiding performance issues caused by incorrect configurations.
• Alert Center
  • Added alert capability for OBProxy process exceptions and crashes.
  • Added checks for the installation directory, log disk path, and data file existence of OBServer nodes, helping users promptly identify abnormal behaviors such as misoperations.
  • Added alert capability for failed SQL diagnostic monitoring data collection.
  • For OceanBase Database V3.x, added an alert when the memory usage of the STORAGE_SHORT_TERM_META_CTX_ID module exceeds 30% under tenant ID 500, reducing the risk of resource allocation failures.
• Performance
  • Added OceanBase XA statement monitoring capability, helping users diagnose resource insufficiency caused by increased concurrency of XA statements.
  • Adapted to monitoring Clog latency in version 4.X.
  • Supports connecting to Prometheus based on the service discovery mechanism, facilitating integration with internal monitoring systems.
  • Added NTP clock skew monitoring for host performance, helping users stay informed about the operational status of the NTP service.
  • Added process-level resource usage monitoring for host resources: OBServer, OCP Agent, OBProxy: such as CPU, memory, disk I/O, etc.
  • Supports pushing SQL Audit data to Alibaba Cloud SLS (for private cloud scenarios).
• Inspections
  • Supports checking whether hidden parameters of OceanBase Database have been modified.
  • Supports checking whether the cgroup directory has been created in an OceanBase Database V4.x cluster.
• Backup & Restore
  • Added support for Huawei Cloud OBS storage media for OceanBase Database V3.X, further enhancing support for storage media from major domestic cloud vendors.
  • Added support for table-level recovery in OceanBase Database V3.X (only supported when the source cluster is online), improving user data recovery efficiency.

Feature optimizations

• Cluster management

  • Added a minimum of 1 CPU core requirement for OB 4.x tenant specifications to avoid issues such as unstable tenant operation.
  • Supports displaying the actual status of the OBServer service when the cluster is unavailable, facilitating maintenance operations based on the OBServer service status.
  • Supports quick navigation to the arbitration management interface from the cluster arbitration service page.
  • Added path check capabilities for installation, data disk, and log disk during scenarios such as adding an OBServer, replacing an OBServer, adding a zone, or scaling a distributed cluster.

• Arbitration Service

  • The service addresses in the cluster arbitration service list support redirecting to the arbitration management interface.

• Cluster/Tenant Management

  • Added prompts for single-node, single-zone multi-host, and zone configurations that do not meet data high availability requirements, to prevent business continuity failures.
  • Supports quick copying of cluster and tenant names.

• OBProxy Management

  • Added status filtering capabilities for the OBProxy list and for connecting to OceanBase clusters.
  • When creating an OBProxy cluster, the software version prompt has changed to: You can only select software packages of version 1.8.0 or later. For security reasons, it is recommended that you choose a package of version 3.1.0 or later.

• Task Management

  • Optimized the task status rotation logic and added some operation prompts to facilitate user task process handling and avoid abnormal object statuses such as clusters or tenants caused by misoperations.
  • The navigation bar now supports displaying the number of tasks in the Failed and Running states for quick viewing.

• Alert Center

  • Optimized the alert muting feature to support displaying information such as status and remarks, making it easier for users to manage alert muting rules.
  • Added a prompt: For the same alert rule on the same object, the alert template with a higher priority takes effect first.
  • Optimized the organization of hosts at the OceanBase/OBProxy cluster level, making it easier for users to select objects from a business perspective.

• Log Services

  • Optimized the organization of hosts at the OceanBase/OBProxy cluster level, making it easier for users to select objects from a business perspective.

• Performance Monitoring

  • Added metric descriptions and units for built-in monitoring metrics within custom monitoring.

• Backup

  • Added backup duration and recoverable time points to the backup set list for data backup.
  • Added restore duration to the restore list for data recovery.

• Stability

  • Optimized the page response speed of the Backup and Recovery Overview page.
  • Optimized the page response speed of the Autonomous Service Overview page.
  • Optimized the memory usage of SQL collection under high pressure to avoid exceeding memory limits.

Product Behavior Changes

• Cluster Management
  • Added a requirement that tenants on OceanBase Database V4.x must select unit specifications of 1C or higher.
• Monitoring and Alerts
  • The monitoring and alerts module has been split into the Alert Center, Performance Monitoring, and Inspection Service.
• Credential Management
  • The original Password Box has been changed to Credential Management, implementing global password control capabilities.
• Parameter Management
  • Removed the entry for setting hidden parameters of OceanBase Database from OCP to avoid system stability issues caused by uncontrollable factors.
• Password Management
  • Standardized login account and database password rules, reducing password complexity.
• Monitoring and Alerts
  • Prohibited the sending of log archiving delay alerts from standby clusters in OceanBase primary/standby clusters.
  • Prohibited the sending of log archiving delay alerts from clusters with backup strategies disabled.
• Tenant Management
  • Documentation change: Changed "End-to-end Diagnostics" to "End-to-end Tracing".
• Backup & Restore
  • Documentation change: Changed "Restoration Time" in the sampling task list to "Restore Time Point".

Key feature overview

Dashboard

The dashboard is designed for scenarios such as "monitoring the market" during Double 11 and for custom monitoring view requirements. On the dashboard tab, you can create multiple dashboard pages. On each page, you can add various charts to display different metrics and data, such as multi-instance and multi-metric monitoring views for users, or different monitoring metrics for one or more clusters. Additionally, the dashboard provides four comparison methods: year-over-year, day-over-day, week-over-week, and month-over-month, helping you easily identify data anomalies. You can also choose from seven chart types, including line charts, pie charts, and tables, based on your data characteristics and needs, which helps you better understand and analyze the data. Furthermore, the dashboard supports grouping, allowing you to place related metrics into the same group for unified management, facilitating better monitoring and analysis of database conditions. The dashboard supports features like chart dragging, zooming, drilling down (for single metrics), and chart linking, helping you achieve the goal of monitoring the overall performance and operational status of the database system.

Tag management

OCP supports tagging five object types: OceanBase clusters, arbitration services, tenants, OBProxy clusters, and hosts. It also supports management functions such as creating, editing, deleting, and modifying associated objects. With two different styles, you can choose the appropriate tag display format based on your business situation. On the interface for various object types, such as an OceanBase cluster, you can perform tagging operations to assign business meanings to objects, such as system type or manager. Additionally, the tag filtering capability helps you organize, search, and manage cluster objects, improving your work efficiency.

Bug fixes

OCP V4.2.2 primarily fixes the following issues:

• Fixed the issue where version upgrade failed in OceanBase Database V4.2 due to incorrect parameter EnableRebalance settings.
• Fixed the issue where obproxyd.sh failed to start after a machine restart.
• Fixed the issue where startup items did not take effect upon system boot on Kylin V10.
• Fixed the issue where the resource usage display ratio for log disks was abnormal.
• Optimized monitoring query logic to reduce the likelihood of garbage collection.
• Optimized access performance on multiple frontend pages, making access faster under the same management scale.

Known issues

Version requirements

Hardware requirements

OCP-Server can be installed on physical servers or run in Docker containers. OCP-Server supports high-availability deployment across multiple nodes.

The minimum hardware requirements for an OCP-Server node are listed in the following table.

OCP-Agent consumes very few resources and has no specific hardware requirements for the installation node.

Operating system requirements

The operating system requirements for installing the OCP server (including OCP-Agent) are listed in the following table.

Client requirements

Users typically access OCP services through a web browser. The client requirements are as follows.

If you need to access OCP from a device running iOS, the version requirements are listed in the following table.

For the best user experience, we recommend using a display with a resolution greater than 1440 x 810.