Linux Today: Linux News On Internet Time.
Search Linux Today
Linux News Sections:  Developer -  High Performance -  Infrastructure -  IT Management -  Security -  Storage -
Linux Today Navigation
LT Home
Contribute
Contribute
Link to Us
Linux Jobs


Top White Papers

More on LinuxToday


Two Node Planned Manual Failover for the MySQL Database Administrator

Jul 06, 2010, 20:33 (0 Talkback[s])
(Other stories by Chris Schneider)

"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!"

Complete Story

Related Stories: