backup

OurSQL Episode 160: More Free Hot Backup


24:23 minutes (11.16 MB)

This week we finish our 2-part series on xtrabackup. Ear Candy is changing the sorting behavior of GROUP BY and At the Movies is a talk on performance schema.

Events
DB Hangops - every other Wednesay at noon Pacific time

Upcoming MySQL events

Percona Live London 2013 is happening Monday November 11th and Tuesday November 12th, 2013 at the Millenium Gloucester Conference Center, with a community dinner on the 11th.

OurSQL Episode 159: Free Hot Backup


29:01 minutes (13.44 MB)

This week, we talk about Percona's Xtrabackup. Ear Candy talks about .frm files and how many fields an InnoDB table can have, and At the Movies is a talk about indexes.

Xtrabackup
Episode 38 where we previously talked about Xtrabackup

Installing Percona's Xtrabackup

Operating system permissions and database privileges needed to use xtrabackup

OurSQL Episode 41: Zmanda [backup series #6]


31:43 minutes (14.61 MB)

Previously in the backup series:

Backup Series #1: Backup Glossary
Backup Series #2: Backup Tools You Already Have (mysqlhotcopy and mysqldump)
Backup Series #3: Looking Through the Lenz (snapshots including LVM)
Backup Series #4: Advanced Logical Export Features (advanced mysqldump)
Backup Series #5: Xtrabackup

This week we talk with Chander Kant, CEO of Zmanda, about how Zmanda Recovery Manager makes backup and recovery of MySQL backups very easy, whether you are using storage level snapshots, hot backup tools or even logical backups. Full and incremental backups (and restores!) are made simpler with the community (free) version and with the enterprise (commercial) version.

OurSQL Episode 38: Xtrabackup (Backup Series #5)


17:59 minutes (8.32 MB)

Previous podcasts in the backup series:
Backup Series #1: Backup Glossary
Backup Series #2: Backup Tools You Already Have (mysqlhotcopy and mysqldump)
Backup Series #3: Looking Through the Lenz (snapshots including LVM)
Backup Series #4: Advanced Logical Export Features (advanced mysqldump)

Special Guest Valentine Gostev, QA engineer at Percona, talks about Percona's Xtrabackup, an open source tool for consistent online physical backup of InnoDB and XtraDB.

OurSQL Episode 35: Advanced Logical Export Features (Backup Series #4)


48:21 minutes (22.23 MB)

This week, we discuss advanced mysqldump options, ear candy comparing NOW() vs. SYSDATE(), and the Manga Guide to Databases.

Previous podcasts in the series:
Backup Series #1: Backup Glossary
Backup Series #2: Backup Tools You Already Have (mysqlhotcopy and mysqldump)
Backup Series #3: Looking Through the Lenz (snapshots including LVM)

ERRATA:
Giuseppe Maxia points out via twitter "The mysqldump option to skip table creation is not '--no-create-table' but '--no-create-info' " -- he's right!

OurSQL Episode 33: Looking Through the Lenz (Backup Series #3, mylvmbackup)


45:09 minutes (20.76 MB)

Previous podcasts in the backup series:
Backup Series #1: Glossary
Backup Series #2: Backup Tools You Already Have (mysqlhotcopy and mysqldump)

Show Notes:

This week we have Lenz Grimmer with us to speak about snapshot backups in general, MySQL backups with snapshots, and mylvmbackup, a script Lenz wrote and maintains to easily take consistent MySQL snapshot backups.

Rate/review us in iTunes (website with a link to open in iTunes, or link to iTunes [may not work in Chrome, does work in Firefox]).

OurSQL Episode 32: Backup tools you already have [Backup series #2]


40:32 minutes (18.65 MB)

This week we continue our series on backup tools, we talk about the backup tools that ship with MySQL.

Show notes:

Previous backup series podcast:
Backup glossary [Backup series #1]

Feedback:
In the backup glossary we asked if anyone knew how to get logical data out of physical InnoDB files. Mike Hamrick of Blue Gecko wrote in to say that Percona's InnoDB recovery tool helps to do just that. He writes:

"The 'page_parser' tool will read ibdata files or individual .ibd files and turn them into a series of 16k page files suitable for processing with a tool called 'constraints_parser' which spits out a number of tab separated lines of table data suitable for a LOAD DATA INFILE.

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


42:13 minutes (19.36 MB)

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"]

Backups: A Video Presentation By Keith Murphy From the June 2008 Boston MySQL User Group

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

Radically Simple Backup & Recovery for Live MySQL

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

Video: Performing MySQL Backups Using LVM Snapshots

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

Slides for Shmoocon 2008 Database Security Talk

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