MySQL Backup & Recovery

Speaker Info (Who am I?)

MySQL at Yahoo!

Outline

Goals

Quick Survey

Required Knowledge

Why Backup?

Considerations

Dump or Raw Backup

On-line or Off-line

Table Types & Consistency

Storage Requirements

Replication

Tools and Techniques

mysqldump

mysqlhotcopy

mysqlsnapshot

innodb2myisam

InnoDB on-line Backup

Off-line Backups

Filesytem Snapshot

Roll your Own

For More Info…

Shameless Book Plug

Questions and Answers