This week, we start a series on backups by talking about backup concepts.
[note: about 11 minutes in, Sarah's audio gets a little noisier, and our audio engineer simply could not get rid of all the noise]
A slave is not a backup, although a slave can be used to get backups more easily.
You don't test backups, you test restores.
logical vs. physical
cold vs. hot vs. warm
consistent vs. inconsistent
strings(1) - Linux man page
"A foolish consistency is the hobgoblin of little minds" - Ralph Waldo Emerson [note: Sheeri misquotes this as "Consistency is the hobgoblin of little minds"]
ACID compliance - Atomicity, Consistency, Isolation, Durability
MTtR - mean time to recovery
RPO - Recovery point objective
This is the first in a series of podcasts about backups, and future backups will go in depth into different backup solutions and how they can be used to get the backups you want. Currently on our list are mysqldump, mysqlhotcopy, LVM/ZFS snapshots, MySQL Enterprise Backup, XtraBackup and the Zmanda backup manager. If there are other solutions or products you’d like us to discuss, let us know...
Where you can see us:
Wed January 26 - Lenz Grimmer speaks about High Availability Solutions with MySQL at the San Francisco meetup
Fri/Sat/Sun January 28-30 - She’s Geeky
T/W/Th February 1-3 - Strata conference