V4.2.2
OCP V4.2.2 officially supports OceanBase Database V4.2.2 and fully implements the end-to-end management capabilities of the OceanBase full-chain traceability module. It supports features such as cluster migration out of OceanBase Database 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, it supports Huawei Cloud OBS, further enhancing support for storage media of major domestic cloud service providers. Additionally, this version optimizes and enhances 30+ features in monitoring alerts, task management, backup and restore, password management, and tag management. It provides 900+ product error codes, significantly improving product usability and stability, and builds a more simple and user-friendly full-lifecycle database management platform to help 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 paths:
You can directly upgrade from OCP V3.2.4 and later to the current version.
For OCP V2.3.x and later, V3.2.4 and earlier, 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 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 support
- Added monitoring metrics: maximum tenant-level log synchronization delay. For more information, see Clog synchronization delay .
- Added support for OceanBase read-only parameter configurations (EDIT_LEVEL='READONLY').
- Added support for network primary/standby replication roles in OceanBase Oracle tenant mode, simplifying user authorization operations.
- Added support for GIS types in OceanBase Oracle tenant mode.
- Added support for granting PL permissions to global users in OceanBase MySQL mode.
Dashboard
The dashboard is designed to meet the needs of users in scenarios such as monitoring during major events like Double 11 and 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 monitor the overall performance and running status of the database system. For more information, see Dashboard.
Tag management
OCP tags offer organization, categorization, quick search and filtering, task and project management, team collaboration, and sharing capabilities. They provide a flexible and efficient way to help users 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, enhancing the closed-loop management capabilities 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 ensure correct system settings and avoid performance issues.
- 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, 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 memory usage in the STORAGE_SHORT_TERM_META_CTX_ID module exceeds 30% for 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 increased XA statement concurrency.
- 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, 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 if hidden parameters in OceanBase Database have been modified.
- Added support for checking if cgroup directories have 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 support for 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 for tenants in OceanBase Database 4.x to avoid instability issues during tenant operation.
- Added support for displaying the actual status of OBServer services when the cluster is unavailable, facilitating maintenance operations based on OBServer service status.
- Added support for quick navigation to the arbitration management interface from the cluster arbitration service page.
- Added support for checking installation, data disk, and log disk path capabilities when adding or replacing OBServer nodes, adding zones, or expanding distributed clusters.
Arbitration Service
- Added support for jumping to the arbitration management interface from the service address in the cluster arbitration service list.
Cluster/tenant management
- Added alerts for single-node, single-zone multi-host, and zone configurations that do not meet data high availability requirements to prevent business continuity failures.
- Added support for quick copying of 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 that you select 3.1.0 and later versions.
Task management
- Optimized task status rotation logic and added operation prompts to facilitate task processing and avoid state anomalies in clusters, tenants, and other objects due to misoperations.
- Added support for displaying 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 remarks, facilitating alert suppression rule management.
- Added a prompt: For the same object, the alert rule in the enabled alert template has higher priority.
- Optimized the organization of hosts by OceanBase/OBProxy clusters to facilitate object selection from a business perspective.
Log Service
- Optimized the organization of hosts by OceanBase/OBProxy clusters to facilitate object selection from a business perspective.
Performance Monitoring
- Added metric descriptions and units for built-in monitoring metrics in custom monitoring.
Backup & Recovery
- Added backup duration and recoverable time points to the backup set list in data backup.
- Added recovery duration to the restore list in data restoration.
Stability
- Optimized the response speed of the backup and restoration 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 Database 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 box to Credential Management to implement global password control capabilities.
- Parameter Management
- Removed the entry for setting OceanBase hidden parameters from OCP to avoid system stability issues caused by uncontrollable factors.
- Password management
- Standardized login account and database password rules to reduce password complexity.
- Monitoring and alerts
- Prohibited the sending of log archiving delay alerts from the standby cluster in OceanBase primary-standby clusters.
- Prohibited the sending of log archiving delay alerts from clusters with disabled backup strategies.
- Tenant Management
- Changed the text: Full-chain diagnostic to Full-chain tracing.
- Backup & Recovery
- Changed the text: Recovery time in sampling inspection task list to Recovery time point.
Key features
Monitoring dashboard
The monitoring dashboard primarily addresses scenarios such as "monitoring" during events like Double 11 and supports user-defined monitoring views. On the monitoring dashboard tab, you can create multiple monitoring dashboard pages. Each monitoring dashboard page can include multiple charts to display different metrics and data, such as multi-instance and multi-metric monitoring views, as well as different monitoring metrics for single or multiple clusters. The monitoring dashboard also provides four comparison modes: 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, such as line charts, pie charts, and tables, based on the characteristics and requirements of your data to better understand and analyze it. Additionally, the monitoring dashboard supports grouping, allowing you to organize related metrics into the same group for unified management, facilitating better monitoring and analysis of database status. The monitoring dashboard supports features such as chart dragging, chart zooming, drilling down (in single-metric scenarios), and chart linkage, helping you achieve the goal of monitoring the overall performance and operational status of the database system.
Note
A single monitoring dashboard can display up to 32 charts.
Tag management
OCP supports tagging operations for five object types: OceanBase clusters, arbitration services, tenants, OBProxy clusters, and hosts. It also supports management features such as creating, editing, deleting, and modifying associated objects. You can choose from two different styles to display tags based on your business needs. On various object type pages, such as OceanBase clusters, you can tag clusters to assign business meanings, such as system type and manager. You can also use tag filtering capabilities to organize, search, and manage cluster objects, improving your work efficiency.
Note
Only users with the Admin role can manage tags.
Fixed issues
OCP V4.2.2 mainly fixed the following issues:
- Fixed the issue where OceanBase Database V4.2 failed to upgrade due to the
EnableRebalanceparameter setting. - Fixed the issue where the
obproxyd.shscript failed to start after a server restart. - Fixed the issue where the startup item did not take effect on Kylin V10 systems.
- Fixed the issue where the resource display ratio of 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 to improve access speed under the same management scale.
Known issues
No. |
Known issue |
Workaround |
|---|---|---|
| 1 | Custom monitoring can create a large number of charts, but some combinations of conditions do not return data due to unsupported features, and these cannot be filtered out. | Use the product features reasonably to avoid creating charts that are not meaningful for your business. |
| 2 | Performance issues may occur when the tenant scale exceeds 500. | Contact Technical Support for assistance when deploying a large-scale system. |
| 3 | The diagnostic feature is unavailable when an OceanBase cluster cannot be connected. | This issue will be addressed in future versions. |
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.
Hardware |
Requirements |
|---|---|
| CPU | |
| Memory | 16 GB of available memory |
| NIC | 10 GbE |
OCP-Agent consumes very few resources and does not have special requirements for the hardware resources of the installation node.
Operating system requirements
The following table lists the operating system requirements for installing OCP-Server (including OCP-Agent).
Server type |
Operating system |
Supported versions |
|---|---|---|
| x86_64 | RHEL | 7.2 and later |
| x86_64 | CentOS | 7.2 and later |
| x86_64 | AliOS | 7.2 and later |
| x86_64 | openSUSE | 12SP3 and later |
| ARM aarch64 | AliOS | 7.2 and later |
| ARM aarch64 | NeoKylin | 7.6 |
| ARM aarch64 | Huawei EulerOS | 2.0 SP8 |
| x86_64 | Debian | Debian GNU/Linux 11 (bullseye) |
| x86_64 | Ubuntu | Ubuntu 18.04.6 LTS |
Client requirements
General users access OCP services through a web browser. The following table lists the requirements for the client.
Browser |
Minimum version |
|---|---|
| Chrome | 88 |
| Firefox | 78 |
| Safari | 14 |
| Edge | 88 |
If you want to access OCP services from an iOS device, the following table lists the requirements for the operating system.
Operating system |
Minimum version |
|---|---|
| iOS | 10 |
For the best user experience, we recommend that you use a display with a resolution of more than 1440 x 810.