"A database administrator needs to plan for both planned and
unplanned failovers, based on business requirements and service
level agreements with customers. This article runs through the very
basic starting points of a MySQL failover strategy then walks
through a two-node, planned, manual failover.
"In the wonderful world of MySQL, there are many failover
techniques that can be done. Failover techniques range from easy to
slightly more difficult. I guess that "easy" and "difficult" are
relative terms depending on the skill set of the database
administrator and their personal preference.
"In this article I will run through the very basic starting
points of a MySQL failover strategy then walk you through a
two-node, planned, manual failover. Just know that there are many
ways to skin this cat but the idea is pretty much the same wherever
you go, make sure it's right at the end!"