OurSQL Episode 30: Backup Glossary (Backup Series #1)

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...

Ear Candy

>tee 'file_name'

The tee/notee command manual page

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

Send us feedback via:
Facebook group
e-mail: podcast at technocation.org
voicemail using phone/Skype: +1-617-674-2369
twitter: @oursqlcast
or Tweet about @oursqlcast