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 how to migrate on-premise MySQL v5.7.44 database to OCI Oracle HeatWave MySQL v8.4.4 using OCI GoldenGate. The same steps are applicable to any version of MySQL with the exception that DDL replication is not possible in versions 5.7 because the binlog_row_metadata parameter is not available in this version.  DDL replication is only possible from versions 8.0.

GoldenGate 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.

Migration steps:

For detail steps please refer to tutorial Migrate On-Premise MySQL to Oracle Heatwave MySQL on OCI using OCI GoldenGate.  

Limitations:

  • Auto increment column issues.
  • If a table has one column and that is not primary key or unique key then mapping fails because the combination of all columns for that table is same on source and target.
  • Data types, DDL and other feature limitations.
  • DDL replication is not possible when source is on version 5.7.* . It is only possible for versions 8.0.* and above. Use MySQL Audit Plugin To Capture Only DDL Changes in 5.7.13+ (Doc ID 2151281.1).
  • When using Active-Active replication, the time zones must be the same on both systems so that timestamp-based conflict resolution and detection can operate.