How to use mysqlfailover to automate switching from a failed master to the best available slave: https://docs.oracle.com/cd/E17952_01/mysql-utilities-1.5-en/utils-task-autofailover.html
Switching the master when mysqlfailover is not available: https://dev.mysql.com/doc/refman/5.7/en/replication-solutions-switch.html Automatic failover is available since 8.0.22: https://mysqlhighavailability.com/automatic-asynchronous-replication-connection-failover/ Last updated 27 Feb 2021 |
![]() |