Everyone wants to prevent database downtime by being proactive, but are measures such as inspecting logs and analyzing SQL really proactive? Although these are worthwhile, they almost always identify problems that already exist. To be truly proactive, one must prevent problems, which requires studying and understanding the reasons for downtime. This white paper is the companion to our earlier paper on preventing production emergencies in MySQL.
Our MySQL white papers are free. They are released under the Creative Commons Attribution-Noncommercial-No Derivative Works 3.0 license.