Version information
Version: V4.2.3
Previous version: V4.2.2 BP1
Version release date: July 2, 2024
Supported upgrade versions:
Versions earlier than OMS V3.2.1 require an upgrade to V3.2.1 first.
OMS V3.2.1 and later can be directly upgraded to OMS V4.2.3.
Note
Due to underlying component integration, DataHub tasks cannot be displayed after OMS is upgraded from V3.2.1 to a later version. If you want to upgrade OMS from V3.2.1 to a later version with a DataHub task involved, contact OMS Technical Support.
New features
Support for public cloud OceanBase data sources
OMS V4.2.3 introduces the support for OceanBase public cloud data sources, enabling the management of OceanBase instances on Alibaba Cloud and OBCloud as public cloud data sources. This update also enhances the functionality by supporting public cloud data sources as both source and target entities. Specifically, when an OceanBase public cloud data source serves as the source, the following optimizations are implemented for schema migration and incremental synchronization:
Schema migration: For OceanBase Database V4.2.x and later, the dependency on sys tenant credentials is removed, and ordinary tenant credentials can be used to obtain the schema information of the source OceanBase Database.
Incremental synchronization: For clusters in OBCloud that support the MySQL compatible mode, incremental data can be obtained from OceanBase Database through Binlog service. For clusters in Alibaba Cloud that support the MySQL compatible mode or the Oracle compatible mode, incremental data can be obtained from OceanBase Database through Logproxy service.
Adaptation for OceanBase Database versions
OMS V4.2.3 now supports the full range of OceanBase Database versions as target entities. For scenarios where these versions serve as the source, the update extends the support to the following OceanBase Database versions:
OceanBase Database V4.2.1.x: supports versions up to and including V4.2.1.6
OceanBase Database V4.2.2.x: supports versions up to and including V4.2.2.1
OceanBase Database V4.2.3.x: supports versions up to and including V4.2.3.0
Ease-of-use improvements
The option to specify a CA key is provided for Kafka data sources.
By default, incremental synchronization from an Oracle database to the Oracle compatible mode of OceanBase Database ignores data in virtual columns and maintains data in these columns based on the logic of the target Oracle database.
Feature matrix of the current version
Note
In the data migration and data synchronization tables, both OB_MySQL and OB_Oracle support physical and public cloud data sources.
Data migration
| Data source | Schema migration | Full migration | Incremental DML | Incremental DDL | Full verification | Reverse incremental migration | Tables without a primary key |
|---|---|---|---|---|---|---|---|
| MySQL -> OB_MySQL | Supported | Supported | Supported | Supported | Supported | Supported | Supported |
| Oracle-> OB_MySQL | Supported | Supported | Supported | Not supported | Supported | Supported | Supported |
| TiDB -> OB_MySQL | Supported | Supported | Supported | Not supported | Supported | Supported | Not supported |
| PostgreSQL -> OB_MySQL | Supported | Supported | Supported | Not supported | Supported | Supported | Not supported |
| Oracle -> OB_Oracle | Supported | Supported | Supported | Supported | Supported | Supported | Supported |
| DB2 LUW -> OB_Oracle | Supported | Supported | Supported | Supported | Supported | Supported | Not supported |
| OB_Oracle -> OB_Oracle | Supported | Supported | Supported | Supported | Supported | Supported | Supported |
| OB_MySQL -> OB_MySQL | Supported | Supported | Supported | Supported | Supported | Supported | Supported (excluding disaster recovery and dual-active scenarios) |
| OB_Oracle -> Oracle | Supported | Supported | Supported | Supported | Supported | Supported | Supported |
| OB_Oracle -> MySQL | Not supported | Not supported | Supported | Not supported | Not supported | Not supported | Not supported |
| OB_MySQL -> MySQL | Supported | Supported | Supported | Supported | Supported | Supported | Not supported |
| OB_Oracle -> DB2 LUW | Supported | Supported | Supported | Supported | Supported | Supported | Not supported |
| DB2 LUW -> OB_MySQL | Supported | Supported | Supported | Supported | Supported | Supported | Not supported |
| OB_MySQL -> DB2 LUW | Supported | Supported | Supported | Supported | Supported | Supported | Not supported |
Data synchronization
| Data source | Schema synchronization | Full synchronization | Incremental DML | Incremental DDL | Tables without primary keys |
|---|---|---|---|---|---|
| OB_MySQL -> Kafka | Supported | Supported | Supported | Supported | Not supported |
| OB_MySQL -> RocketMQ | N/A | Supported | Supported | Not supported | Not supported |
| OB_MySQL -> DataHub (Tuple) | Supported | Supported | Supported | Not supported | Not supported |
| OB_MySQL -> DataHub (Blob) | Supported | Supported | Supported | Supported | Not supported |
| OB_Oracle -> Kafka | Supported | Supported | Supported | Supported | Not supported |
| OB_Oracle -> RocketMQ | N/A | Supported | Supported | Not supported | Not supported |
| OB_Oracle -> DataHub (Tuple) | Supported | Supported | Supported | Not supported | Not supported |
| OB_Oracle -> DataHub (Blob) | Supported | Supported | Supported | Supported | Not supported |
| Oracle -> DataHub (Blob) | Supported | Not supported | Supported | Not supported | Not supported |
| Oracle -> DataHub (Tuple) | Supported | Not supported | Supported | Not supported | Not supported |
| MySQL -> DataHub (Tuple) | Supported | Not supported | Supported | Not supported | Not supported |
| MySQL -> DataHub (Blob) | Supported | Not supported | Supported | Not supported | Not supported |
| ODP -> DataHub (Tuple) | Supported | Supported | Supported | Not supported | Not supported |
| ODP -> DataHub (Blob) | Supported | Supported | Supported | Supported | Not supported |
| IDB -> DataHub (Tuple) | Supported | Supported | Supported | Not supported | Not supported |
| IDB -> DataHub (Blob) | Supported | Supported | Supported | Supported | Not supported |
| ODP -> OB_MySQL | N/A | Supported | Supported | Supported | Not supported |
| IDB -> OB_MySQL | N/A | Supported | Supported | Supported | Not supported |
Database versions supported by the current version
| Feature | OceanBase Database versions | Other data source versions | OCP versions |
|---|---|---|---|
| Data migration | V1.4.79, V2.1.1, V2.2.20, V2.2.30, V2.2.50, V2.2.52, V2.2.70, V2.2.72, V2.2.74, V2.2.75, V2.2.76, V2.2.76BP1, V2.2.77, V3.1.0, V3.1.1, V3.1.2, VV3.2.1, V3.2.2, V3.2.3, V3.2.4, V4.0.0, V4.1.0, V4.2.0, V4.2.1.6, V4.2.2.1, and V4.2.3.0 |
|
|
| Data synchronization | V2.2.20, V2.2.30, V2.2.50, V2.2.52, V2.2.70, V2.2.72, V2.2.74, V2.2.75, V2.2.76, V2.2.76BP1, V2.2.77, V3.1.0, V3.1.1, V3.1.2, VV3.2.1, V3.2.2, V3.2.3, V3.2.4, V4.0.0, V4.1.0, V4.2.0, V4.2.1.6, V4.2.2.1, and V4.2.3.0 |
|
|