Replication Using Local Deployment

When replicating using a local deployment, the Oracle GoldenGate instance runs on the database server using a local connection to the database, as shown in the following diagram.


Oracle GoldenGate Deployments in a Multi-Hub Configuration

In this diagram, two Oracle GoldenGate deployments are set up on two different database servers, which are connected over the network. Consider, Data Center 1 as the source and Data Center 2 as the target. Both the deployment are local to their respective database server. However, the databases reside in different regions or servers and use a Distribution Service / Receiver Service pair to send the trail files across the network.

The following diagram displays the workflow of an Oracle GoldenGate deployment in a database server within a local hub.


Hub-based configuration for a local Oracle GoldenGate deployment.

This diagram is described using the following points:

  • 1: Capture of committed transactions that can be filtered as they occur by reading the transaction keys)

  • 2: Trail is sent using canonical, secure and wire protocol for data transaction and events.

  • 3: Distribution/Receiver Services send and receive data across the service mesh.

  • 4: Route transactions are compressed, encrypted for routing to targets

  • 5: Delivery applies data with transaction integrity