Oracle Cloud Infrastructure Documentation

Preparing MySQL HeatWave DB System for Disaster Recovery

Perform the following prerequisites before adding MySQL DB System to the disaster recovery topology.

Ensure that you have access to the OCI console and you meet all the requirements to create a Disaster Recovery Protection Group.

  1. Network Connectivity: Establish a secure and reliable network connectivity between the source and target regions by using OCI's Dynamic Routing Gateway (DRG) and remote peering connections for seamless data transfer.
  2. Security Lists and Routing: Configure security lists, network security groups, and routing tables to allow traffic between the MySQL DB Systems across regions.
  3. SSL/TLS Configuration: If you plan to use SSL/TLS for secure replication, ensure that both the MySQL instances are properly configured with the necessary certificates.
  4. MySQL DB Systems: Create a primary MySQL DB systems in the primary region.
  5. Backup Creation: Manually create a backup of the MySQL database in the primary region.
  6. Backup Copying: Transfer this manual backup to the standby region using the Copy Backup feature.
  7. Database Restoration: In the standby region, use the copied backup to create a new DB system. This new DB system will be the standby.
    Note

    After creating the standby DB system, update its Database Mode from Read/Write to Read Only.
  8. Replication Channel: From the standby DB system, create a replication channel that connects to the primary DB system.