Version information
Version: V4.2.3
Previous version: V4.2.2 BP1
Release date: July 2, 2024
Upgrade path:
OceanBase Migration Service (OMS) of a version earlier than V3.2.1 must be first upgraded to V3.2.1.
OMS V3.2.1 and later can be directly upgraded to 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-based OceanBase data sources
OMS V4.2.3 supports public cloud-based OceanBase data sources. You can incorporate OceanBase Database instances deployed on Alibaba Cloud or OceanBase Cloud into OMS for management. You can use a public cloud-based OceanBase data source as the source or target. OMS provides the following optimizations for schema migration and incremental synchronization when a public cloud-based OceanBase data source serves as the source:
Schema migration: In OceanBase Database of a version earlier than V4.2.x, you must use an account of the
systenant to obtain the schema information of the source OceanBase database. In OceanBase Database V4.2.x and later, you can use an account of a user tenant to do so.Incremental synchronization: For a MySQL-compatible tenant of an OceanBase cluster deployed on OceanBase Cloud, you can obtain the incremental data of the OceanBase cluster by using the binlog service. For a MySQL-compatible or Oracle-compatible tenant of an OceanBase cluster deployed on Alibaba Cloud, you can obtain the incremental data of the OceanBase cluster by using the oblogproxy service.
Versions of OceanBase Database that support incremental synchronization
OMS V4.2.3 supports OceanBase Database of all versions as the target. Apart from the versions that are already supported as the source in incremental synchronization, OMS V4.2.3 supports the following OceanBase Database V4.2.x versions as the source:
OceanBase Database V4.2.1.x: V4.2.1.6 and earlier
OceanBase Database V4.2.2.x: V4.2.2.1 and earlier
OceanBase Database V4.2.3.x: V4.2.3.0 and earlier
Ease-of-use improvements
The CA key option is provided for Kafka data sources.
During incremental synchronization from an Oracle database to an Oracle-compatible tenant of OceanBase Database, virtual column data is ignored by default. The virtual column data is maintained by the virtual column logic of the target.
Feature matrix
Note
The OB_MySQL and OB_Oracle data sources in the following tables can be physical data sources and public cloud-based data sources.
Data migration
| Data source | Schema migration | Full migration | Incremental DML | Incremental DDL | Full verification | Reverse incremental migration | Table 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 (not supported in active-active disaster recovery 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 | Table without a primary key |
|---|---|---|---|---|---|
| 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 |
Supported database versions
| Transmission feature | OceanBase Database version | Version of other data terminals | OCP version |
|---|---|---|---|
| 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, V3.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.76 BP1, V2.2.77, V3.1.0, V3.1.1, V3.1.2, V3.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 |
|
|
Component versions
| Component | Version |
|---|---|
| Connector | oboms-connector-v2-3.0.56-20240621113309 |
| Supervisor | oboms-supervisor-2.1.14-20240531162539 |
| Store | oboms-xlog-store-5.9.4-20240627121253 |
| Checker | ant-light-checker-1.2.62-20230518133733 |
| Full-Verification | oboms-verifier-2.1.1-20240621173737 |
| ddl-ecology | oboms-ddl-ecology-1.0.3-20230420202616 |
| CM | oboms-cm-1.1.70-20240530125403 |
| DBCat | obtools-dbdiff-2.1.1-SNAPSHOT |