Replication Server 7.0.0 release notes v7

Released: 01 Dec 2021

Note

The 7.0 version is backward compatible with 6.2.x and provides a non-breaking upgrade path for the existing cluster deployments. However, it is strongly recommended to verify it in a staging or nonproduction environment before applying the upgrade in a production environment.

New features, enhancements, bug fixes, and other changes in Replication Server 7.0 include the following:

TypeDescription
New featureThe Publication and Subscription Server configuration options can be modified and applied without requiring a server restart. The CLI now exposes a new command reloadconf to reload the updated configuration values at runtime.
New featureReplication Server is enhanced to support replication from EDB Postgres Advanced Server (non-redwood mode) and PostgreSQL to Oracle.
EnhancementReplication Server is certified to support PostgreSQL v14 and EDB Postgres Advanced Server v14.
EnhancementTable-level parallel data loading significantly improves initial Snapshot data replication time for large size Publication tables. The benchmarks reveal 3X to 30X performance improvement for a given workload and related options.
EnhancementRow-level Filtering capability is enhanced to allow inclusion/exclusion of data based on a sub-query [1284035].
EnhancementThe CLI command addtablesintopub is enhanced to expose an option to enable row-level filter for the target Subscription (SMR)/Master (MMR) nodes [1321993].
EnhancementThe CLI commands createpub and addtablesintopub now support a new option to allow the users to add all the tables to a Publication without requiring individual table identification [1273701].
EnhancementThe CLI commands createpub and addtablesintopub are enhanced to allow the user specify a single custom conflict resolution option applicable for multiple tables [731271].
EnhancementTable(s) can be added into an existing Publication by skipping schema replication [926058].
EnhancementThe Replication GUI displays additional replication stats on the Real-time Monitor tab to monitor the status of the cluster [795247].
EnhancementReplication of the HASH partition table is now supported from Oracle to EDB Postgres Advanced Server.
EnhancementIncremental replication of CLOB, BLOB, and XMLType is now supported from Oracle to EDB Postgres Advanced Server.
EnhancementSupport added for replication of JSON data type from PostgreSQL and EDB Postgres Advanced Server to Oracle.
Bug fixFixed an issue where replication from EDB Postgres Advanced Server to SQL Server fails for UUID data type [73835].
Bug fixThe CLI reports an error on Publication removal if one or more Subscriptions are associated with the Publication [72194].
Big fixFixed an issue where replication history cleanup job fails when Oracle is the active Controller database [72626].
Big fixFixed an issue where the filter clause fails when applied for a table list with more than 10 tables.
Bug fixFixed an issue where the add filter command picked the incorrect table index for the filter clause in the WAL mode replication.
Bug fixIn a hybrid replication cluster, the cleanup shadow table routine is subject to remove unprocessed changes.
Bug fixFixed an issue where synchronize failed for an SMR cluster during replication from PostgreSQL to Oracle 12.1 when using the JSON datatype.
Bug fixFixed an issue where the initial Snapshot fails in a WAL-based MMR cluster while adding the third database.
Bug fixFixed an issue where running yum install ppas-xdb skips ppas-xdb-libs dependency.
Bug fixFixed an issue where the Synchronize operation failed to replicate NULL for a BLOB type for EPAS to Oracle.
Bug fixFixed an issue where the Synchronize operation fails for one of the target Subscriptions for EPAS to Oracle replication cluster.