backup

The Boston MySQL User Group was lucky enough to get Keith Murphy to speak at the June User Group meeting, about backups. Links referred to in the presentation: MyLVMBackup by Lenz Grimmer http://lenz.homelinux.org/mylvmbackup/ InnoDB Hot Backup: Prices are at: http://www.innodb.com/hot-backup/order/ and at the time of this writing are: 1-Year License € 390 USD$ 605 per server Perpetual License € 990 USD$ 1540 per server Zmanda prices are at: http://network.zmanda.com/shop/home.php?cat=1,3 Current prices are between the range of $100-$450, and a license is needed for each server and each client. So if you have 1 server and 3 clients, you need 4 licenses. Online Backup This is interesting reading about online backup, an article about how the online backup works at: http://blogs.mysql.com/peterg/2008/05/19/mysql-60-feature-2-online-backup/ This page (at the bottom, under "Replication") states that the desired behavior is that the binary log does not log the restore or the backup. However, it does state that this is not implemented yet, nor even decided upon. There's also a great page on Online Backup at the MySQL Forge: http://forge.mysql.com/wiki/OnlineBackup And if you're short on time, the manual has a short page at http://www.nongnu.org/rdiff-backup/ duplicity: http://duplicity.nongnu.org/ It was mentioned that some people use a code repository to backup their database: http://krow.livejournal.com/593424.html

At the 2008 MySQL Conference and Expo, Chander Kant of Zmanda delivered a keynote on "Radically Simple Backup & Recovery for Live MySQL". Get the slides on the Forge at http://forge.mysql.com/wiki/MySQLConf2008ThursdayNotes#Radically_Simple_Backup_.26_Recovery_for_Live_MySQL

At the 2008 MySQL User Conference and Expo, Lenz Grimmer spoke about "Performing MySQL Backups Using LVM Snapshots". Download the slides, see people's notes, and more on the MySQL Forge Wiki at http://forge.mysql.com/wiki/MySQLConf2008WednesdayNotes#Performing_MySQL_Backups_Using_LVM_Snapshots

The slides for today's presentation at Shmoocon are here:

http://technocation.org/files/doc/2008_02_SecuringDBs.pdf

Just a note so folks at the conference can download them whenever they want. Folks not at the conference can, too but the slides don't give away the whole talk so I don't know how useful they're going to be.....