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. For 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

• 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 tenant-level clog synchronization delay.
• Supports the OceanBase read-only parameter configuration item (EDIT_LEVEL='READONLY').
• Adapts to the replication roles of primary and standby databases in the network for OceanBase Oracle-compatible tenants, simplifying user authorization operations.
• Supports GIS types in OceanBase Oracle-compatible tenant mode.
• Adaptation to OceanBase Database in MySQL-compatible mode, which supports granting the PL privilege globally to users.

Monitoring Dashboard

The monitoring dashboard primarily meets user needs such as "monitoring the dashboard" during events like Double 11, and supports 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.

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.

Feature enhancements

• Cluster management
  • Supports the ability to move out an OceanBase cluster, fully realizing closed-loop management capabilities for OceanBase Database.
  • Supports taking over and moving out arbitration services, improving closed-loop management capabilities for arbitration services.
• OBProxy management
  • Supports the ability to move out an OBProxy cluster, fully realizing closed-loop management capabilities for OBProxy.
  • The log service 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 METACTX_ID module exceeds 30% under tenant ID 500, reducing the risk of resource allocation failures.
• Performance Monitoring
  • Added OceanBase XA statement monitoring capability, helping users diagnose resource insufficiency caused by increased concurrency of XA statements.
  • Adapted monitoring for Clog latency in version 4.X.
  • Supports integration with Prometheus based on the service discovery mechanism, facilitating connection to 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, and disk I/O.
  • Supports pushing SQL Audit data to Alibaba Cloud SLS (for private cloud scenarios).
• Inspection Service
  • 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 & Recovery
  • Added support for Huawei Cloud OBS storage media for OceanBase Database V3.X, further improving support for storage media from major domestic cloud providers.
  • Added support for table-level recovery in OceanBase Database V3.X (only supported when the source cluster is online), enhancing 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

  • Service addresses within the cluster arbitration service list support navigation 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 been 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 or Running state 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 host organization at the OceanBase/OBProxy cluster level, facilitating user object selection from a business perspective.

• Log Service

  • Optimized host organization at the OceanBase/OBProxy cluster level, facilitating user object selection from a business perspective.

• Performance Monitoring

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

• Backup & Recovery

  • 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 to set hidden parameters for 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 & Recovery
  • Documentation change: Changed "Restore Time" in the sample inspection task list to "Restore Point".

Key features

Dashboard

The dashboard primarily meets user needs such as "monitoring the market" during events like Double 11 and allows users to customize monitoring views. On the dashboard tab, you can create multiple dashboard pages. On each dashboard page, you can add multiple charts to display different metrics and data, such as multi-instance and multi-metric monitoring views for users, or various monitoring metrics for one or multiple 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 different chart types based on the characteristics and requirements of your data, such as line charts, pie charts, and tables, which helps you better understand and analyze the data. Furthermore, the dashboard supports grouping; you can place related metrics into the same group for unified management, facilitating better monitoring and analysis of database conditions. The dashboard supports various functions such as chart dragging, chart zooming, drilling down (in single-metric scenarios), 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 interfaces of 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. At the same time, the tag filtering capability helps you organize, search, and manage cluster objects, improving your work efficiency.

Fixed issues

OCP V4.2.2 mainly 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 the log disk was abnormal.
• Optimized monitoring query logic to reduce the probability of garbage collection.
• Optimized access performance on multiple frontend pages, making access faster for the same management scale.

Known issues

Version usage restrictions

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 requirement 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 × 810.