Название: Oracle Cloud Infrastructure (OCI) GoldenGate: Real-world Examples
Автор: Y V Ravi Kumar, Raghavendra S, Ankur Goel
Издательство: Apress
Год: 2024
Страниц: 243
Язык: английский
Формат: pdf, epub
Размер: 13.3 MB

This book focuses on the utilization of GoldenGate Services (GGS) in conjunction with a microservices architecture on the Oracle cloud (OCI), primarily for data migration and integration across various data sources and targets.

The book begins with a practical example of utilizing GGS on a Marketplace VM, progressively advancing to in-depth discussions on implementing GoldenGate as a Service on OCI. The book offers illustrative guides for data replication between RDBMSs (such as Oracle, Postgres, and big data targets such as Kafka). Additionally, it explores monitoring techniques using Enterprise Manager and Grafana dashboards. A comparative analysis is presented between traditional VM-based GoldenGate installations and the OCI service model. Special attention is given to Zero Downtime Migration (ZDM) and leveraging GGS for database migration from on-premises to OCI. Some chapters address multi-cloud replication using OCI GGS and include real-life case studies.

By the end of this book you will have gained comprehensive insights into the architectural design of GoldenGate Services and will be adept at replicating data using GGS, enabling you to replicate setups in your own environments.

Microservices constitute a software architecture that organizes an application into a set of small, independent, and loosely interconnected services. Each microservice corresponds to a distinct business feature and operates as an individual process or container. These services communicate via well-defined APIs (application programming interfaces), collaborating cohesively to provide the application’s complete functionality.

Oracle GoldenGate Microservices Architecture (OGG MA) is a modern and flexible way to deploy and manage Oracle GoldenGate, a data replication and integration tool provided by Oracle Corporation. GoldenGate Microservices Architecture was introduced in Oracle GoldenGate version 12.3 and is designed to meet the evolving needs of organizations dealing with real-time data integration, replication, and data streaming across various platforms.

Oracle GoldenGate (OGG) is a software solution for real-time data integration and replication. It allows organizations to capture, transform, and move transactional data from one database to another, across different platforms and data environments, with minimal latency and impact on system performance. This ensures that databases remain synchronized, facilitating high availability, data migration, and real-time analytics.

What You Will Learn:
Set up GoldenGate Services for high availability (HA), disaster recovery (DR), migration of data to cloud, and moving data into the data lake or lakehouse
Perform logical migration of data to the cloud using the ZDM tool (ZDM uses GoldenGate internally).
Replicate data to big data targets
Monitor GGS using Enterprise Manager and Grafana
Replicate data in a multi-cloud environment

Who This Book Is For:
Oracle database administrators who want to replicate data or use Oracle GoldenGate Services for migration and setup of high availability (HA) and disaster recovery (DR); and data engineers who want tobuild the data warehouse, data lake, data lakehouse to push data in near real-time