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 capabilities of the OceanBase full-link tracing module. This includes features such as cluster migration out of OceanBase and OBProxy, as well as takeover and migration out of arbitration services. The completeness of basic O&M features has reached 95%. This version also introduces a powerful feature: the monitoring dashboard, which allows users to monitor in real-time during peak business scenarios and customize performance monitoring. In terms of backup and restore, support for Huawei Cloud OBS has been added, further enhancing support for mainstream cloud storage media in China. Additionally, this version includes over 30 optimizations and enhancements across areas such as monitoring and alerts, task management, backup and restore, password management, and tag management. It provides over 900 product error codes, significantly improving product usability and stability. This version aims to build a more user-friendly and easy-to-use full lifecycle database management platform, helping users better manage OceanBase Database.

Version information

• Version: V4.2.2

• Previous version: V4.2.1 BP1

• Version release date: February 21, 2024

• Supported upgrade path:

• Direct upgrade from OCP V3.2.4 and later to the current version is supported.

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

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

Supported OceanBase Database versions

OCP V4.2.2 supports the following OceanBase Database versions:

• 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 compatibility

• Added monitoring metric: maximum log synchronization delay at the tenant level. For more information, see Log synchronization delay .
• Added compatibility with OceanBase read-only parameter configurations (EDIT_LEVEL='READONLY').
• Added compatibility with the network primary-standby replication role for Oracle tenants in OceanBase Database.
• Added compatibility with GIS data types in Oracle tenants in OceanBase Database.
• Added compatibility with the PL permission for global users in MySQL tenants in OceanBase Database.

Dashboard

The dashboard meets the needs of users in scenarios such as monitoring during major events like Double 11 and allows users to create custom monitoring views. It provides features such as multi-instance and multi-metric monitoring view comparisons, chart interactivity, and support for seven chart types, including pie charts, tables, and bar charts. This helps users monitor the overall performance and operation status of the database system. For more information, see Dashboard.

Tag management

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

Feature enhancements

• Cluster management
  • Added support for migrating out OceanBase clusters, enabling comprehensive lifecycle management of OceanBase Database. For more information, see Migrate out a cluster.
  • Added support for taking over and migrating out arbitration services, improving the lifecycle management of arbitration services. For more information, see Take over an arbitration service and Migrate out an arbitration service.
• OBProxy management
  • Added support for migrating out OBProxy clusters, enabling comprehensive lifecycle management of OBProxy. For more information, see Migrate out an OBProxy cluster.
  • The log service module now displays route diagnostics, connection diagnostics, and error logs for OBProxy services.
• Host management
  • Added support for checking the current_clocksource=tsc configuration when adding a host to avoid performance issues caused by incorrect configurations.
• Alert Center
  • Added support for alerting when OBProxy processes crash.
  • Added support for checking the installation directory, log disk path, and existence of data files for OBServer nodes, helping users detect accidental operations.
  • Added support for alerting when SQL diagnostic monitoring data collection fails.
  • For OceanBase Database 3.x, added support for alerting 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 Monitoring
  • Added support for monitoring OceanBase XA statements, helping users diagnose resource shortages caused by concurrent XA statement growth.
  • Added support for monitoring 4.x Clog delays.
  • Added support for integrating with Prometheus using service discovery mechanisms, facilitating internal monitoring system integration.
  • Added support for monitoring NTP clock offset for host performance, helping users track NTP service status.
  • Added support for monitoring resource usage at the process level for OBServer, OCP Agent, and OBProxy processes, including CPU, memory, and disk I/O.
  • Added support for pushing SQL audit data to Alibaba Cloud SLS in private cloud scenarios.
• Inspection Service
  • Added support for checking whether hidden parameters in OceanBase Database have been modified.
  • Added support for checking whether the cgroup directory has been created in OceanBase Database 4.x clusters.
• Backup & Recovery
  • Added support for Huawei Cloud OBS storage media for OceanBase Database 3.x, further enhancing compatibility with major domestic cloud storage media.
  • Added support for table-level restoration in OceanBase Database 3.x (only available in online source cluster scenarios), improving data restoration efficiency.

Feature enhancements

• Cluster Management

  • Added a minimum 1C specification limit for tenants in OB 4.x to prevent instability during tenant operation.
  • Added the ability to display the actual status of OBServer services when the cluster is unavailable, making it easier for users to perform maintenance based on the OBServer service status.
  • Added quick navigation from the cluster arbitration service page to the arbitration management interface.
  • Added path verification capabilities for installing, data disks, and log disks when adding or replacing OBServer nodes, adding zones, or expanding distributed clusters.

• Arbitration Service

  • Added the ability to jump to the arbitration management interface from the service address in the cluster arbitration service list.

• Cluster/Tenant Management

  • Added alerts for insufficient configurations in single-node, single-zone multi-host, and zone setups to prevent business continuity issues.
  • Added the ability to quickly copy cluster and tenant names.

• OBProxy Management

  • Added status filtering capabilities for OBProxy lists and connected OceanBase clusters.
  • Changed the software version prompt when creating an OBProxy cluster to: Only 1.8.0 and later versions are available. For security reasons, we recommend selecting 3.1.0 and later versions.

• Task Management

  • Optimized task state rotation logic and added operation prompts to help users handle tasks and avoid state anomalies in clusters, tenants, etc., due to errors.
  • Added the ability to display the number of failed and running tasks in the navigation bar for quick viewing.

• Alert Center

  • Optimized the alert suppression feature to support displaying status and notes, making it easier for users to manage alert suppression rules.
  • Added a prompt: For the same object, the alert rules in enabled alert templates have higher priority.
  • Optimized the organization of hosts by OceanBase/OBProxy clusters to help users select objects from a business perspective.

• Log Service

  • Optimized the organization of hosts by OceanBase/OBProxy clusters to help users select objects from a business perspective.

• Performance Monitoring

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

• Backup & Recovery

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

• Stability

  • Optimized the response speed of the backup and restore overview page.
  • Optimized the response speed of the autonomous service overview page.
  • Optimized memory usage for SQL collection under high pressure to avoid memory limit issues.

Product behavior changes

• Cluster Management
  • Added a minimum 1C unit specification requirement for tenants in OceanBase 4.x.
• Monitoring and Alerts
  • Split the monitoring and alerts module into the Alert Center, Performance Monitoring, and Inspection Service.
• Credential Management
  • Changed the password vault to Credential Management to provide global password control capabilities.
• Parameter Management
  • Removed the entry for setting OceanBase hidden parameters on OCP to prevent system stability issues caused by uncontrollable factors.
• Password Management
  • Standardized login account and database password rules to reduce password complexity.
• Monitoring and Alerts
  • Disabled log archive delay alerts for standby clusters in OceanBase primary-standby clusters.
  • Disabled log archive delay alerts for clusters with disabled backup strategies.
• Tenant Management
  • Changed the text: Full-chain diagnostics to Full-chain tracing.
• Backup & Recovery
  • Changed the text: Restore time in sampling inspection task list to Restore time point.

Key feature explanations

Monitoring Dashboard

The monitoring dashboard is designed to meet the needs of users who need to monitor their systems during peak times, such as during major events like Double 11, and those who want to customize their monitoring views. On the monitoring dashboard tab, you can create multiple monitoring dashboard pages. Each dashboard page can include multiple charts to display different metrics and data, such as monitoring multiple instances and metrics, or different metrics across single or multiple clusters. The dashboard also provides four comparison modes: year-over-year, month-over-month, week-over-week, and day-over-day, to help you easily identify data anomalies. You can also choose from seven different chart types, such as line charts, pie charts, and tables, based on your data's characteristics and requirements, to better understand and analyze your data. Additionally, the dashboard supports grouping related metrics for unified management, making it easier to monitor and analyze database performance. The dashboard also offers features like chart dragging, zooming, drilling down (in single-metric scenarios), and chart linking to help you achieve your goals of monitoring the overall performance and operational status of your database system.

Tag Management

OCP allows you to apply tags to five types of objects: OceanBase clusters, arbitration services, tenants, OBProxy clusters, and hosts. You can also create, edit, delete, and modify associated objects. With two different tag styles, you can choose the most suitable display format based on your business needs. On various object management pages, such as the OceanBase cluster management page, you can apply tags to assign business meanings to objects, such as system type or manager. The tag filtering feature helps you organize, search, and manage cluster objects, improving your work efficiency.

Fixed issues

OCP V4.2.2 fixes the following issues:

• Fixed the issue where OceanBase Database V4.2 failed to upgrade due to the EnableRebalance parameter setting.
• Fixed the issue where obproxyd.sh failed to start after a server restart.
• Fixed the issue where startup items did not take effect on Kylin V10.
• Fixed the issue where the resource display ratio on the log disk was abnormal.
• Optimized the monitoring query logic to reduce the occurrence of garbage collection.
• Optimized the access performance of multiple frontend pages, making the access speed faster under the same management scale.

Known issues

Limitations

Hardware requirements

OCP-Server can be installed on a physical server or in a Docker container. OCP-Server supports multi-node high availability deployment.

The following table lists the minimum hardware requirements for OCP-Server nodes.

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

Operating system requirements

The following table lists the operating system requirements for installing OCP-Server (including OCP-Agent).

Client requirements

General users access OCP services through a web browser. The following table lists the client requirements.

If you need to access OCP services from an iOS device, the following table lists the requirements.

For the best experience, we recommend that you use a display with a resolution of 1440 x 810 or higher.