Skip to content

GTID_Based_Failover

Jump to bottom Edit New page
bmildren edited this page Jan 27, 2016 · 1 revision

GTID based failover

Starting from MHA 0.56, MHA supported both GTID based failover and traditional relay log based failover. MHA automatically distinguishes which failover to choose. To do GTID based failover, all of the following is needed.

  • Using MySQL 5.6 (or later)
  • All MySQL instances use gtid_mode=1
  • At least one of the instances has Auto_Position enabled
Add a custom footer
Add a custom sidebar
Clone this wiki locally