Oracle_GG

Concept: real-time data synchronization between user OLTP and OLAP, originally developed by a company in San Francisco, acquired and promoted by Oracle, with high performance; subsecond delay; TPS can be thousands

Heterogeneity: supports data synchronization between different types of databases

Transactional: supports replication of completed transactions

Typical scenarios: one-way, two-way, circular, many-to-one, one-to-many, etc.

Management tools: Golden Gate dierctor (graphical management tool); Golden Gate veridata (data comparison)

Price: official price $20000/CPU, mainframe $100000/CPU, etc.

Working mode: 1. Online (synchronization of change data) 2. Batch (for synchronization of initial data)

Components: 1. Extract (process, read changes in the log) 2.data pump (process, can be used to filter, many-to-one, one-to-many) 3.replicat (process, read the contents of the trail file applied to the target library) 4 trail (file used to store a series of change data) 5 checkpoints 6 manager 7.collector (process, collect change data, write to trail file)

Process groups: processes and their associated parameter files, checkpoint files, trail files, etc.

The difference from other replication technologies: 1. Only transmit changing data, the amount of data is small, support compression at the same time, multi-thread concurrency performance is better 2. Support for heterogeneous 3. Easy to install