Introduction

Oracle Cloud Infrastructure (OCI) GoldenGate is a cloud-native service designed for real-time data replication, integration, and streaming across heterogeneous environments. It enables enterprises to build mission-critical architectures for high availability, disaster recovery, analytics, and cloud migrations.

Oracle MySQL HeatWave is a fully managed, in-memory query accelerator for MySQL, designed to boost performance for analytics and mixed workloads. It eliminates the need for complex ETL processes by enabling real-time analytics directly on transactional data. Key benefits include superior performance (up to 5400x faster queries than standard MySQL), cost-efficiency (eliminating the need for separate analytics databases), and simplicity (fully managed with automated scaling and optimization). It’s an ideal solution for businesses looking to combine OLTP and OLAP workloads seamlessly in the cloud.

In this blog, we will explore OCI GoldenGate’s features, use cases, licensing options and how to set up Bidirectional Replication between two Oracle Heatwave MySQL managed instances using OCI GoldenGate.

OCI GoldenGate:

Key Features and Use cases

  1. Cloud-Native Service: Managed and fully optimized for Oracle Cloud Infrastructure, reducing the need for infrastructure management.
  2. Real-Time Data Replication: Supports high-throughput, low-latency replication between heterogeneous databases, including Oracle, MySQL, Oracle Heatwave MySQL, PostgreSQL, SQL Server, and many more with minimal or no downtime.By continuously streaming data from OLTP databases to analytics platforms like Oracle Autonomous Data Warehouse, organizations gain real-time insights without impacting source systems.
  3. Multi-Cloud and Hybrid Deployments: Facilitates data movement between on-premises, OCI, and other cloud environments such as AWS, Azure, and Google Cloud.
  4. Automatic Scaling and High Availability: Designed for enterprise-grade availability and scalability without the need for manual intervention.
  5. Event-Driven Architectures & Streaming Pipelines: OCI GoldenGate integrates with Apache Kafka and OCI Streaming for real-time event processing and microservices-based architectures.
  6. Comprehensive Monitoring: Built-in dashboards provide insights into replication lag, throughput, and performance metrics.
  7. Security and Compliance: Provides end-to-end encryption, role-based access control, and compliance with enterprise security standards.
  8. Disaster Recovery & High Availability: GoldenGate allows continuous data replication between primary and standby databases, ensuring business continuity and failover readiness.

Licensing and Pricing Model

OCI GoldenGate follows a Pay-As-You-Go (License Included) or BYOL subscription model, eliminating the need for upfront infrastructure investment.

  • Pay-As-You-Go (License Included): Charged based on usage (per hour/per OCPU) without long-term commitments.
  • BYOL: Customers can also bring their existing on-premises GoldenGate licenses to use with OCI GoldenGate.
  • On-Premises Licensing: Traditional GoldenGate licensing still applies for on-prem deployments with an option to connect to OCI GoldenGate.

Pricing is determined by the number of vCPUs/OCPUs utilized, with additional costs for advanced features such as Kafka integration and high-throughput replication.

Efficiency & Performance

OCI GoldenGate is designed for high efficiency and minimal overhead, ensuring optimal performance in real-time replication:

  1. Low-Latency Data Replication: Delivers sub-second replication lag for transactional consistency.
  2. Optimized for Cloud Performance: Uses OCI-native services for enhanced throughput and fault tolerance.
  3. Parallel Processing: Supports multi-threaded replication for high-speed data movement.
  4. Automated Scaling: Dynamically scales up or down based on workload demand, optimizing cost and performance.
  5. Efficient Data Compression & Filtering: Reduces network bandwidth usage by filtering and compressing data before transmission.

Oracle Heatwave MySQL:

Key Features

  1. A fully managed database service.
  2. Interactive console for managing resources, running queries, and monitoring performance.
  3. OCI Database Management for HeatWave MySQL to proactively detect performance issues and to forecast consumption.
  4. Very secured with Asymmetric encryption with key generation and digital signatures, data masking and Database firewall to prevent SQL injections.
  5. Massive Parallel scale processing where data is partitioned across nodes.
  6. Enables you to run real-time analytics on data in MySQL Database and object storage without extract, transform, and load (ETL) duplication.
  7. In-database machine learning (ML), you don’t need to move data to a separate ML service.
  8. HeatWave Lakehouse lets you query data in object storage, MySQL databases, or a combination of both with record speed.
  9. Real-time elasticity lets you increase or decrease the size of your HeatWave cluster by any number of nodes without incurring any downtime or read-only time.

Next Steps

Set up Oracle MySQL HeatWave GoldenGate replication, check out my detailed tutorial Set up Bidirectional Replication Between Two Oracle Heatwave MySQL managed instances using OCI GoldenGate. It walks you through the entire process, from configuration to real-time data replication, ensuring high availability and seamless data movement. Whether you’re migrating, building a disaster recovery setup, or enabling real-time analytics, this guide has you covered.