Golden Gate concepts and mechanisms

1. What processes does Ogg have?

ÜManger: MangerA process is a control process of goldengate and runs on the source and target terminals respectively. It mainly serves to start, monitor, and restart other goldengate processes, report errors and events, and allocate data storage space, release the threshold report. Note that there is only one manger process on the source and target.

ÜExtract: ExtractThe process runs on the database source and is responsible for capturing data from the source data table or log. The role of extract can be divided into two phases: ① initial data loading phase: In the initial data loading phase, the extract process extracts data directly from the data table at the source end. ② Synchronization change capture phase: After data Initialization is complete, the extract process is responsible for capturing data changes (DML and DDL) at the source end ).

ÜPump: PumpThe process runs on the database source end. It sends the local trail files generated by the source end to the target end in the form of data blocks through the TCP/IP protocol, which is also recommended. The pump process is essentially a special form of extract process. If the trail file is not used, the extract process directly delivers the data to the target end to generate a remote trail file.

ÜCollector: CollectorThe process corresponds to the pump process and runs on the target end. This process does not need to be too concerned, because we do not need to configure it during actual operations, so it is transparent to us. Collector runs on the target end. Its job is to reassemble the data delivered by extract/pump into the path trail file.

ÜReplicat: ReplicatA process is usually called an application process and runs on the target end. It is the last battle of data transmission. It is responsible for reading the content of the trail file on the target end and parsing it into DML and DDL statements, then it is applied to the target database.

 

2. Data Flow Diagram of Ogg Data Replication

 

3. OggData replication mechanism

 

4. Simple Ogg configuration example

4.1Environment on both sides

 

4.2Configure the running environment (Source/target)

 

4.3Install goldengate software (Source/target)

 

 

 

 

4.4Configure the source database

 

 

4.5Configure the target database

 

 

 

4.6Configure the origin goldengate

 

 

 

4.7Configure the destination goldengate

 

 

4.8Start ext1 and rep1 on the source and target, and test the user

 

 

 

 

 

 

Golden Gate concepts and mechanisms