V4.2.2
OCP V4.2.2 officially supports OceanBase Database V4.2.2. It also fully implements the closed-loop management capabilities of the end-to-end tracing module of OceanBase Database, including cluster migration out of OceanBase Database and OBProxy, and takeover and migration out of arbitration services. The completeness of basic O&M capabilities has reached 95%. This version also introduces a major new feature: the monitoring dashboard, which allows users to monitor real-time performance and customize performance monitoring in large-scale promotion scenarios. In terms of backup and restore, it supports Huawei Cloud OBS, further enhancing support for storage media of major domestic cloud service providers. In addition, this version optimizes and enhances 30+ features in areas such as monitoring and alerting, task management, backup and restore, password management, and tag management. It provides 900+ product error codes, significantly improving the ease of use and stability of the product. This version aims to create a more user-friendly and efficient 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 paths:
You can directly upgrade from OCP V3.2.4 and later to the current version.
For OCP V2.3.x and later, but before 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 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 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 Oracle tenant mode of OceanBase Database.
- Added support for GIS data types in Oracle tenant mode of OceanBase Database.
- Added support for granting PL privileges to users with global privileges in MySQL mode of OceanBase Database.
Dashboard
The dashboard provides a comprehensive view of database performance and operational status, supporting scenarios such as monitoring during major events like Double 11. It allows users to compare monitoring data across multiple instances and metrics, link charts, and display data in seven types of charts, including pie charts, tables, and bar charts. For more information, see Dashboard.
Tag management
OCP tags support organization, categorization, quick search and filtering, task and project management, team collaboration, and sharing. This provides a flexible and efficient way 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, enhancing 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.
- Added support for displaying routing diagnostics, connection diagnostics, and error logs for OBProxy services in the log service module.
- Host management
- Added support for checking whether the system parameter current_clocksource=tsc is correctly configured 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, 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 connecting to Prometheus using service discovery, facilitating integration with internal monitoring systems.
- 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 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 as a storage medium for OceanBase Database 3.x, further enhancing compatibility with major domestic cloud storage solutions.
- Added support for table-level restoration in OceanBase Database 3.x (only available in online source cluster scenarios), improving data recovery efficiency.
Feature improvements
Cluster Management
- Added a minimum 1C specification limit for tenants in OceanBase Database 4.x to prevent instability during tenant operation.
- Added support for displaying the real-time status of OBServer services when the cluster is unavailable, making it easier for users to perform O&M operations based on the 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 during OBServer addition, OBServer replacement, zone addition, and distributed cluster expansion.
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 issues.
- Added support for quick copying of cluster and tenant names.
OBProxy Management
- Added status filtering capabilities for OBProxy lists and OceanBase clusters.
- Changed the software version prompt when creating an OBProxy cluster to: Only 1.8.0 and later versions are supported. For security reasons, we recommend that you select 3.1.0 and later versions.
Task Management
- Optimized the task status rotation logic and added operation prompts to help users process tasks and avoid errors that could cause cluster or tenant status anomalies.
- Added support for displaying the number of failed and running tasks in the navigation bar for quick viewing.
Alert Center
- Optimized the alert shielding feature to support the display of status and remarks, making it easier for users to manage alert shielding rules.
- Added a prompt: For the same object, the alert rule in an enabled alert template has higher priority.
- Optimized the organization of hosts by OceanBase/OBProxy clusters to make it easier for users to select objects based on business needs.
Log Service
- Optimized the organization of hosts by OceanBase/OBProxy clusters to make it easier for users to select objects based on business needs.
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 limit 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 provide global password control capabilities.
- Parameter Management
- Removed the entry for setting OceanBase hidden parameters on 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 log archiving delay alerts from standby clusters in OceanBase primary-standby clusters.
- Prohibited log archiving delay alerts from clusters with disabled backup strategies.
- Tenant Management
- Changed the text: Full Chain Diagnosis to Full Chain Tracing.
- Backup & Recovery
- Changed the text: Restore Time in Sampling Task List to Restore Time Point.
Key features
Monitoring Dashboard
The monitoring dashboard meets the needs of users in scenarios such as "monitoring" during Double 11 and allows users to create custom monitoring views. On the monitoring dashboard tab, you can create multiple monitoring dashboard pages. On each monitoring dashboard page, you can add multiple charts to display different metrics and data, such as multi-instance and multi-metric monitoring views, and monitoring metrics for single or multiple clusters. The monitoring dashboard also provides four monitoring comparison modes: year-on-year, day-on-day, week-on-week, and month-on-month, helping you easily detect 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 the data. Additionally, the monitoring dashboard provides grouping functionality, allowing you to organize related metrics into the same group for unified management, making it easier to monitor and analyze 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 operation 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 the OceanBase cluster page, you can tag clusters to assign business meanings to objects, such as system type and manager. You can also use the tag filtering feature 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 fixes 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 the server was restarted. - Fixed the issue where the startup items 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 probability of garbage collection.
- Optimized the access performance of multiple frontend pages, making the access speed faster under the same management scale.
Known issues
No. |
Known issue |
Workaround |
|---|---|---|
| 1 | Custom monitoring allows you to create a large number of charts, but some combinations of conditions do not support data display. Currently, you cannot filter out these unsupported combinations. | Use the product features reasonably and avoid creating charts that are not meaningful for your business. |
| 2 | Performance issues may occur when the tenant scale exceeds 500. | Contact Technical Support if the deployment scale is large. |
| 3 | When an OceanBase cluster cannot be connected, the diagnostic feature is unavailable. | This issue will be fixed in a later version. |
Limitations
Hardware requirements
OCP-Server can be installed on physical servers or in Docker containers. OCP-Server supports multi-node high-availability deployment.
The minimum hardware requirements for OCP-Server nodes are as follows:
Hardware |
Requirements |
|---|---|
| CPU | |
| Memory | 16 GB available memory |
| NIC | 10 GbE NIC |
OCP-Agent consumes very few resources and has no special hardware requirements for the installation node.
Operating system requirements
The operating system requirements for installing OCP-Server (including OCP-Agent) are as follows:
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 web browsers, so the client requirements are as follows:
Browser |
Minimum version |
|---|---|
| Chrome | 88 |
| Firefox | 78 |
| Safari | 14 |
| Edge | 88 |
If you need to access OCP services on iOS devices, the minimum operating system version is as follows:
Operating system |
Minimum version |
|---|---|
| iOS | 10 |
For the best user experience, we recommend using a display with a resolution greater than 1440 x 810.