Oracle GoldenGate supports two architectures, the Classic Architecture and the Microservices Architecture (MA).
A static extraction of data records from one database and the loading of those records to another database.
Continuous extraction and replication of transactional Data Manipulation Language (DML) operations and data definition language (DDL) changes (for supported databases) to keep source and target data consistent.
Extraction from a database and replication to a file outside the database.
Oracle GoldenGate Architectures Overview
The following table describes the two Oracle GoldenGate architectures and when you should use each of the architectures.
X | Classic Architecture | Microservices Architecture |
---|---|---|
What is it? |
Oracle GoldenGate classic architecture provides the processes and files required to effectively move data across a variety of topologies. These processes and files form the main components of the classic architecture and was the product design until this release. |
Oracle GoldenGate Microservices Architecture is a new microservices architecture that provides REST-enabled services as part of the Oracle GoldenGate environment. The REST-enabled services provide remote configuration, administration, and monitoring through HTML5 web pages, command line, and APIs. |
When should I use it? |
Oracle GoldenGate can be installed and configured to use the Oracle GoldenGate classic architecture for the following purposes:
|
Oracle GoldenGate can be installed and configured to use the Oracle GoldenGate Microservices Architecture for the following purposes:
|
Which databases are supported? |
Classic Architecture supports all supported databases as per the certification matrix. |
MA only supports the Oracle database. |
Configure the Oracle Database for Oracle GoldenGatereplication.
Parent topic: Getting Started with Oracle GoldenGate
Set the STREAMS_POOL_SIZE
to at least 1200 MB.
Load Oracle GoldenGate sharding PL/SQL packages prior to deploying, which in turn adds the ggadmin
schema.
Install a client wallet for database to communicate through the PL/SQL utl_http
routines with Oracle GoldenGate service endponits.
You can set the MA-specific environment variables while performing the deployment tasks:
Oracle GoldenGate Configuration Assistant (OGGCA)
SSL/TLS Security (Optional)
The following environment variables are set for the Oracle GoldenGate Configuration Assistant, oggca.sh
:
ORACLE_HOME
export ORACLE_HOME=database_install_location
OGG_HOME
export OGG_HOME=ogg_install_location
LD_LIBRARY_PATH
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH
TNS_ADMIN
export TNS_ADMIN=$ORACLE_HOME/network/admin
PATH
export PATH=$OGG_HOME/bin:$PATH
Oracle_SID
An additional environment variable is required to set up a secure deployment:
For more information about the corresponding directories, see What are the Key Microservices Architecture Directory Directories?.
Note:
For using any command line utility, you must set up theOGG_HOME
, OGG_VAR_HOME
, and OGG_ETC_HOME
variables correctly in the environment.Parent topic: Getting Started with Oracle GoldenGate
There are a number of tasks you must perform to set up data replication.
Task | Description |
Run the Oracle GoldenGate Configuration Assistant (oggca) to create and configure secure and non-secure deployments | See Setting Up Secure and Non-Secure Deployment |
Login to Service Manager | When you log in to Service Manager, you can see the status of other servers (Administration Server, Distribution Server, Performance Metrics Server, and Receiver Server). See How to Connect to Service Manager |
Add Credential Store | Set up the user id and password to connect to the database before you create an Extract. See How to Add Database Credentials. You can also set up your domain alias while setting up the Credentials configuration. |
Add Extracts | How to Add Extracts |
Register the Extract | You need to register an Extract when creating an Integrated Extract. See How to Add Extracts. |
Add Distribution Path | See How to Add a Distribution Path |
Add Replicats | See How to Add Replicats |
Register the Replicat | See How to Add Replicats |
Start the Extract | See How to Add an Extract |
Start the Distribution Path | See How to Add a Distribution Path |
Start the Replicat | See How to Add a Replicat |
Check the Receiver Server for path details | See Monitoring Paths |
Monitor Extracts and Replicats | See Monitoring Paths and Tuning Network Parameters and Monitoring Server Performance |
Monitor the Performance Metrics | See Monitoring Performance |
Parent topic: Getting Started with Oracle GoldenGate