Introduction
Oracle HeatWave MySQL is a fully managed database service, and the cloud service built on MySQL Enterprise Edition, with advanced security features for encryption, data masking, authentication, and a database firewall. HeatWave improves MySQL query performance by orders of magnitude and enables you to get real-time analytics on your transactional data in MySQL—without the complexity, latency, risks, and cost of extract, transform, and load (ETL) duplication to a separate analytics database. It’s an ideal solution for businesses looking to combine OLTP and OLAP workloads seamlessly in the cloud.
Setup of DR copy for Production Heatwave MySQL Database Service in OCI
There are 2 ways to sync the databases in-order to setup DR copy for a production MySQL Database service in OCI.
1) OCI Console level cross region Backup and Restore
2) MySQL Shell Utilities (util.copyInstance, util.dumpinstance, etc..)
With the first Approach, one can easily Sync the primary and DR database with OCI Console level cross region Backup and Restore and then create in-bound replication channel in DR Database to sync the databases. This approach performs better than the MySQL shell utilities for larger databases.
Next Steps
If you want to setup the OCI Console level cross region DR, Check out my detailed tutorial Set up Cross-Region Oracle Heatwave MySQL Disaster Recovery Copy in OCI. It walks you through the entire process of setting up cross region DR for production MySQL database services along with configuration to real-time data replication, ensuring high availability and seamless data movement.