GoldenGate 12.3: announcement, new features and installation

Oracle has release new version of GoldenGate 12.3 in 18 August. This is very long awaited version – it postponed 2 or 3 times because of some very important new features. See some useful links for GoldenGate 12.3:

New Features of GoldenGate 12.3

So there is list in release notes which describes new features of GoldenGate 12.3. Let’s talk a little bit about these features:

Microservices Architecture

The most important and revolutionary feature is Microservices Architecture. Historically GoldenGate has the following architecture

image

Now we are switching to the following architecture:

image

GoldenGate becomes more service oriented and more manageable. Now we can use RESTFul interfaces to manage GG. There is one important point here – now we are in transition period. There are two version of GoldenGate during transition period – common and microservice-based.   Now microservice based version is available for Oracle database only. So we should choose which version to use during installation.

Parallel Replicat

We already have 3 types of replicat – classic, coordinated and integrated. All these replicat types have their own weak and strong sideS:

  • Classic replicat is very simple and scalable but it is hard to manage it for large installations
  • Coordinated replicat is simple to use, easy to manage? scalable but more complex. It doesn’t support schemas where foreign key  are not disabled
  • Integrated replicat is very clever and can work where foreign keys exists but it has some performance limitations especially if system has large transactions

Parallel replicat is a new variant of Replicat that applies transactions in parallel to improve the performance. It takes into account dependencies between transactions, similar to Integrated Replicat. The dependency computation, parallelism of the mapping, and apply is performed outside the database and can be off-loaded to another server. The transaction integrity is maintained in this process. In addition, parallel replicat supports the parallel apply of large transactions by splitting a large transaction into chunks and applying them in parallel. This is supported with Oracle Database only.

So it looks like best variant but only time will tell how weak or strong it is.

Procedural Replication

Integrated Replicat has been enhanced to allow you to replicate certain Oracle supplied PL/SQL procedures that cannot be replicated as DML or DDL. This requires that the source and target databases are Oracle Database 12c Release 2 (12.2) and later.

You can see partial list of PL/SQL packages replicated by GoldenGate.

image

Really GoldenGate doesn’t replicate package itself but replicates its actions. For example, replication of DBMS_DBFS_* will lead to calling same DBFS API commands on target system. Also this is very important for AQ replication – now it should be easy to migrate systems where AQ is used with zero downtime.

Automatic Conflict Detection and Resolution

You can configure and manage Oracle GoldenGate to automate conflict detection and resolution when it is configured in Oracle Database 12c Release 2 (12.2) and later. This feature create invisible columns in the table. This columns is filled automatically by Oracle Database 12.2+. Also Database creates tombstone log to support updates-delete conflicts. This feature is supported by Integrated Extract plus Integrated or Parallel Integrated Replicat.

Leave a Reply

Your email address will not be published. Required fields are marked *