Jeremy D. Zawodny, Yahoo! Inc.
Track: Databases
Date: Wednesday, July 24
Time: 1:45pm - 2:30pm
Location: Grande Ballroom B
Given MySQL's reputation for speed and reliability, users often neglect to setup any sort of backup plan for their data.
In this session, we'll investigate the tools available for backing up MySQL data and discuss the pitfalls of writing your own. What are the speed/space tradeoffs for each method? We'll also discuss the properties that make transactional tables, such as InnoDB, challenging to backup properly.
Once you've chosen a technique for backing up your data, how can you automate the process? And how can you select the right backup frequency? Having backups isn't terribly useful unless you can use them. We'll also dig into testing and using backups.
Download presentation file
