Master Data Mover — Oracle GoldenGate (Part 1 of 2)
In this 2 series blog, I am going to talk about Oracle GoldenGate.
Part 1 is about quick introduction and tells us about Oracle GoldenGate capabilities.
Preface
Data availability and Data Dissemination have become quintessential need of today’s world where everything needs to be known and made available in real-time to stay ahead of the game.
While data remains the most significant objective, the number and variety of data sources has increased exponentially in recent years. In order to accomplish the same job, there are just too many options available and one is confronted by the problem of plenty. So, one needs to make a choice of what makes the most sense for one to meet an objective.
Adding a layer of complexity is the choice of where to host a given service/application. Is it cloud, hybrid or on-premise??
Apologies for stirring the pot too much but that’s what the usual situation is.
Major dimensions of data to be considerate about:
Data Availability (all time)
Data Variety (Heterogeneous)
Data Sharing (in real-time)
Data Hosting (sources, targets and their locations — cloud, on-premise..)
I am going to focus on the aspect of making data available in real-time between systems of heterogenous types and that too hosted in disparate places.
And that Single Master (Yes, you read is right; it’s not Jack) of all trades is none other than Oracle GoldenGate.
What is Oracle GoldenGate?
Oracle GoldenGate is a comprehensive software package for real-time data integration and replication. It enables high availability solutions, real-time data integration, transactional change data capture, data replication, transformations, and verification between operational and analytical enterprise systems.
Why Oracle GoldenGate?
Enterprise data is typically distributed across the enterprise applications (on-premise, multi-cloud) in heterogeneous databases and other modern day big data platforms. To get data between different data sources, one can use Oracle GoldenGate to load, distribute, and filter transactions within the enterprise in real-time and enable migrations between different databases in near zero-downtime.
Where to use Oracle GoldenGate?
What I should be aware of when thinking of Oracle GoldenGate?
- Use of Oracle GoldenGate in Oracle and non-Oracle databases is to reduce the Recovery Time Objective (RTO) duration when used for Active-Active / Active-Live Standby scenarios of bi-directional replication.
- While used as a data replication tool, it is not to be confused with a disaster recovery tool for Zero Data loss addressing the Recovery Point Objective (RPO) requirement. Best practices of Maximum Availability Architecture need to be followed.
- Oracle GoldenGate moves only committed transactions to enable consistency and improve performance.
- Deployment choices for GoldenGate software (Local, Hub, cloud, on-premise) are available depending on the topology/hosting of systems to be integrated.
- Oracle GoldenGate can work with other products like Oracle Data Integrator (ODI) and become part of a bigger data pipeline.
- For a well tuned data model, replication speed upwards of 1TB/hour achieved in relational databases.
- Oracle GoldenGate is in sync with the modern day architectural patterns with adoption of –
a. Microservices Architecture
b. Containerization Capabilities
Truly an Enterprise Integration Tool
Recent Journey of Oracle GoldenGate
Important Links:
Oracle GoldenGate Blogs
https://blogs.oracle.com/dataintegration/goldengate-solutions-and-news
https://blogs.oracle.com/dataintegration/goldengate-technical-features/page/3
Oracle GoldenGate Introduction & Getting Started
Oracle GoldenGate Microservices Architecture in 19c
Oracle GoldenGate Auto CDR
Oracle GoldenGate Microservices Architecture with Oracle Real Application Clusters Configuration Best Practices
Please stay tuned for the Part 2 of my blog series on Oracle GoldenGate wherein I would speak about an interesting use-case around High Availability using Oracle GoldenGate…
Disclaimer: I am currently an employee of Oracle Corporation. All views expressed in this article are in my personal capacity and do not necessarily reflect my employer’s views.
