Could you tell me about the failover and failback procedures?

[MARUBUN SUPPORT]

Hi Team,

Questions:
Could you tell me about the failover and failback procedures?

1. recovery of the primary database
   The primary database failed and became inaccessible, Failover occurred and the secondary database was promoted to master.
   From the time of failure to the time of maintenance, the secondary database was operated as a single system.
   
   After this, what is the recovery procedure to set the primary database as master and the secondary database as slave and start replication?
   
   
2. Restoration of Secondary Database
   A failure occurred in the secondary database, making it inaccessible.
   From the time of the failure to the time of maintenance, the primary database was operated as a single system.
   
   What is the recovery procedure to set the secondary database as a slave and start replication after this?

Thanks,

[Talha.Siddiqui]

Assuming no data consistency errors appear, MySQL replication is able to recover itself in both cases. This article shows how to re-initialize replication.