How to perform DR Drills using MySQL Replication (Doc ID 2528968.1)

Last updated on FEBRUARY 27, 2020

Applies to:

Goal

Disater Recovery Drills are often performed to check the preparedness to handle disasters. 

This document discusses the DR Drills scenarios and how to handle them from MySQL replication Point of View. 

There are 4 different kind of DR scenarios that we will consider here:

a. Controlled/Maintenance:

        i. Switch-over

        ii. Switch-back

b. Failure Simulation:

        i. Failover

        ii. Fall-back
 

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.