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

…

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.

read more

This week, Sarah's off, and Sheeri interviews Brian Aker of Data Differential, mostly about the MySQL Ecosystem.

Among the topics discussed are whether the MySQL Ecosystem has peaked yet, the exciting talks coming up at the O'Reilly MySQL Conference including the state of the community keynote, and when the Drizzle software is going GA.

Some parts of the MySQL Ecosystem that were mentioned:
phpmyadmin
Percona Server
Percona free InnoDB hot backup tool

read more

Show Notes:
[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"]

read more

OpenDatabaseCamp, also known as OpenSQLCamp - http://planet.mysql.com/entry/?id=26922 will be held in Sardinia, Italy on May 6-7-8, 2011.
Google Group for OurSQLCamp: http://groups.google.com/group/opensqlcamp

Manual chapter for subqueries in MySQL - http://dev.mysql.com/doc/refman/5.1/en/subqueries.html

The WorkLog entries for “subquery” http://forge.mysql.com/worklog/search.php?t=tds&k=subquery&v=0&s=0&p=0
All are low/medium priority. out of 29 worklog items, 9 are complete, almost all are scheduled for 6.0. Of the remaining 20, 1 is in progress, 4 are …

Show notes for Episode 28:

Some feedback from previous podcasts:
Percona *is* releasing a 5.5 version - http://www.mysqlperformanceblog.com/2010/12/20/mysql-5-5-8-and-percona-s...
Also, the performance schema is persistent (stored on disk) according to Giuseppe Maxia, the Datacharmer.
* Update 1/6/2011 14:17 Eastern time - according to Mark Leith, only the setup_ tables are persistent, so only some of the data makes it to disk and is persistent.

read more …

We talk about HandlerSocket with special guest Patrick Galbraith of Blue Gecko, have some Ear Candy and talk about OSCon and the Strata Conferences

The HandlerSocket announcement blog post from Yoshinori Matsunobu of DeNA: http://yoshinorimatsunobu.blogspot.com/2010/10/using-mysql-as-nosql-stor...

HandlerSocket in Percona's build: http://www.mysqlperformanceblog.com/2010/12/14/percona-server-now-both-s...

PBXT has had it for years: http://pbxt.blogspot.com/2010/12/handlersocket-why-did-out-version-did.h...

sample MySQL settings using HandlerSocket from Patrick:
First you …

Show notes for Episode 26: Zombies!

Question:
We wondered: Is enterprise backup still using myisamhotcopy for myisam tables?

From MySQL Product Manager Mike Frank, who is in charge of MySQL Enterprise Backup:
"As of today, there is a new mysqlbackup.exe that replaces the perl script innobackup and the myisamhotcopy from InnoDB Hot Backup. This is needed so we can do proper streaming and other media manager integration. Perl doesn't lend itself to that and is a problem on Windows in general as well. We kept the arguments compatible so it is easy to move over and the innobackup perl script is still included -- only for the sake of making transition more seamless."

read more

In this first Drizzle Podcast, Sheeri K. Cabral and Jay Pipes talk about what Drizzle is and how Drizzle is different from MySQL both technically and from a community standpoint.

• The main web page for Drizzle is http://drizzle.org/.
  
• The main project page for Drizzle is at Launchpad: https://launchpad.net/drizzle.
  
• The Drizzle mailing list is at https://launchpad.net/~drizzle-discuss.
  
• The Drizzle wiki, including documentation, is at http://drizzle.org/wiki/

  read more

At the Red Hat Summit I was able to grab sometime with Chander Kant, CEO of open source back-up provider, Zmanda.

I had previously met Chander at the MySQL conference where they were named a partner of the year, but we didn't get a chance to talk much.  It was pretty cool to hear about how he originally identified the opportunity for Zmanda and then built a business around it.

My interview with Chander (13:27)  Listen ( …