Golden Gate Overview

Source: Internet
Author: User

Overview:

  1. What is it? Oracle GoldenGate provides real-time, low-impact capture, routing, transformation, and delivery of transactional data across heterogeneous environments.
    1. Non-intrusive:
      1. No triggers, no intermediate tables, no delta tags or timestamp fields
      2. Do not query data on the source table
    2. Low impact:
      1. CPU utilization <3%, low memory and network bandwidth requirements when directly deployed and running on the source-side data server
    3. High Real-time:
      1. Single data synchronization link can maintain >160gb/hours of database log processing capacity, synchronization delay within 10 seconds
    4. Heterogeneous sources and targets:
      1. Wide range of different database types and versions under heterogeneous hardware platforms and operating systems, including file and Message Queuing
    5. Reliability and transactional Integrity:
      1. Ensure transactional integrity and sequencing
      2. Automatically recovers from breakpoints after failure, data is not duplicated, not omitted
  2. Application Scenarios:
    1. Heterogeneous sources:
      1. Log-based, real-time crawling
      2. Message Bus
    2. Goal:
      1. 0 Downtime migration upgrade, disaster recovery emergency: New Db/os/hw/app
      2. Flexible high Availability: a fully active distribution database
      3. Query Offload/split: Reporting Database
      4. Oracle's ETL scenario, ODI
      5. Real-time bi/real-time Dw:edw
      6. Data distribution: Multiple data centers
      7. Soa/eda:message BUS:BPM/BAM/CEP
    3. Characteristics:
      1. Standardized, single technology to address a wide range of different needs
      2. Domestic: The main scenario is used for the continuous availability of the system and the requirements of real-time data access for reporting/BI systems.
      3. High added value, high flexibility, good stuff!
      4. If you apply the specification on the basis of an in-depth understanding of OGG, you will avoid frequent abend.
  3. Fundamentals: Real-time incremental data integration based on log capture technology
    1. Capture extract: The transaction log is read to capture (or filter) committed transactions when a transaction occurs. Any non-actual transactions are not copied to the target, and no propagation errors are guaranteed.
    2. Queue Trail: Prepares the data to queue the data for routing. This is also called Trail file.
    3. Transfer pump: Distributes data for routing to destinations, enabling multiple deliveries to be captured at once.
    4. Routing Tcpip: Compresses, encrypts data for routing to destinations, minimizes bandwidth consumption. (1/10 higher compression ratio)
    5. Delivery Replicat: Ensure transactional data integrity and transform data as needed.
  4. Reliability:
    1. Ensure transactional integrity
    2. Goldegate of The Fault
      1. Process automatic restart with process failure
      2. Trail File Failure ––> Checkpoint
    3. Faults outside of Goldengate
      1. Server/db/Network fault –> Checkpoint
  5. Flexibility: Data processing, flexible topology, heterogeneous support, flexible installation configuration
    1. Components that can be configured with Filter/map and translation rules
      1. Capture
      2. DataPump
      3. Replicat
    2. The installation of each component is flexible and different from other products;
    3. The configuration of each component is also flexible, as long as trail files, checkpoint information in, how to play on how to play!
  6. Topological structure
    1. Analytical type:
      1. One-way, query shunt
      2. Merge, real-time bi, three-to-one
      3. integration, integration, real-time Data Warehouse ods--"EDW; three pairs one on one. Oltp-ods-edw
    2. Operation Type:
      1. Bidirectional, 1 to 1
      2. Broadcast, 1 to many
      3. Equivalence, load balancing, triangular bidirectional
      4. Cascade, distributed business; one to one, then to three.
  7. Product line:
      1. Oracle Goldengate (all installations require LICENSE,RAC each node requires license)
      2. Management Pack for Goldengate
        1. Director
        2. Monitor
        3. EM12C Plug-in
      3. Goldengate Veridata (cannot be separated from the OGG environment)
      4. Goldengate Application Adapter
  8. Product Download:
      1. support.oracle.com-11g Patch is the installation package (12c not)

Golden Gate Overview

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.