Effective MySQL Backup and Recovery

INTRODUCTION

Disaster is inevitable. Total failure is avoidable.

While many organizations plan, practice, and invest for scalability, few plan and practice for business resilience as the result of a disaster or a “Choas Monkey*”. One of the most critical tasks of an operational database administrator (DBA) is to perform, test, document, and verify adequate backup and recovery procedures to ensure business continuity. While this may be considered a much loathed and less prioritized task, this is the single most comforting element in a well functioning and stable production environment. Backups are not just used for recovery. Other uses of backups that can be incorporated into daily operations to assist in the verification process can include additional ...