The second book of the Effective MySQL series provides the reader with the tools, knowledge and tips necessary for a successful MySQL Backup and Recovery Schedule. Included in this book are examples of mysqldump, LVM snapshots, mylvmbackup, MySQL Enterprise Backup (MEB), Xtrabackup and mydumper. Advanced options including compression, incremental backups, partial backups and remote capabilities are discussed and examples provided with an example 5GB database. 
Chapters
- The Five Minute DBA – Download Sample Chapter (PDF)
- Understanding Backup Options
- Understanding Business Requirements
- Using Replication
- Understanding Recovery Options
- MySQL Configuration Options
- Disaster Scenarios
- Optimizing Backup & Recovery
- MySQL in the Cloud
All links in the book can be referenced in links.txt
Order Now
This title is available print, and ebook formats.
Kindle Version from Amazon & PDF version from McGraw-Hill.
 |
 |
Related Articles
Other Titles
See other titles in our series including:
Related Presentations
You may also like these related presentations:
Well, I have issued a REPLACE INTO statement on the master thinking it will solve a data shift problem in one of the slaves only to later figure out that it had deleted all the records in tables that were related to it. I later spent the night recovering all deleted data by parsing the binlogs (used row-basedd replication) with grep, sed, and a makeshift parser written in python