Tuesday, July 1, 2025

HeatWave MySQL Disaster Recovery with Bi-Directional Replication

HeatWave MySQL is a MySQL database service that is part of Oracle Cloud Infrastructure (OCI). It's a fully managed database service that allows you to run MySQL workloads in the cloud.


Replication with MySQL is Asynchronous in nature.  It is uni-directional.   HeatWave has Channel to define the in-bound Replication from another "MySQL" or  "HeatWave".     If we have 2 HeatWave DB Systems in different Region, Replication Channel is a good use to define replication between the Regions.

To setup HeatWave Channel between Regions, please refer to the following URL for more information

Ref : https://docs.oracle.com/en/learn/oci-mysql-dr-copy/index.html


Although Replicatoin is uni-directional, people might want to define Bi-directional Replication between the TWO DB Systems.   It is the TWO Replication Channels, where each DB System is defined with a Channel pointing each other.