OurSQL Episode 38: Xtrabackup (Backup Series #5)

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.

Percona's Xtrabackup documentation, and docs particularly on the xtrabackup binary and the innobackupex wrapper script.

Xtrabackup on Launchpad including bug/issue tracking

Mailing list for xtrabackup

Ear Candy
You can specify multiple directories for tmpdir to use in a round-robin fashion -- this has been around since MySQL 4.1!

The deadline for the call for papers for the OSCon Data sub-conference has been extended until Monday, March 28th. OSCon is Monday, July 25th - Friday, July 29th in Portland, Oregon. [Note, Sarah stated the July dates incorrectly in the podcast]

Where you can see us
On Thursday, April 7, 2011 at 6:30 PM Giuseppe Maxia will speak at the San Francisco MySQL User Group about "Advanced Replication for the Masses". The topic will cover how to do advanced replication tasks not possible with the standard MySQL build, such as allowing a slave to have more than one master and having a multi-threaded process to apply SQL statements to the slave.

Sheeri will be at Collaborate in Orlando, Florida from Sunday April 10th through Thursday April 14th. She is organizing the Community dinner, eastern US edition on Sunday April 10th at 5 pm at Maggiano's Little Italy near the Convention Center.

Sarah will be at the O'Reilly MySQL Conference in Santa Clara, California from Monday, April 11th through Thursday April 14th, including the community dinner, western US edition on Monday April 11th at 7 pm at Pedro's.

Sheeri will be speaking about monitoring MySQL efficiently with Nagios at the Professional IT Community Conference, otherwise known as PICC, in New Brunswick, New Jersey. The conference is Friday, April 29 – Saturday April 30, 2011.

Sheeri will be at OpenDBCamp, Fri May 6th - Sun May 8th in Sardinia, Italy.

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