Crash Recovery and Media Recovery in InnoDB

Architecture and Technology
Location: Ballroom C Level: Intermediate
Average rating: ****.
(4.50, 4 ratings)

InnoDB provides a reliable, true-and-tested automatic crash recovery for MySQL database users. It is based on a redo log and write-ahead logging, two techniques that are used in most of the leading database engines in the world. We will explain these techniques in depth, and present some benchmarks of the crash recovery time.

InnoDB’s media recovery is done from a (hot) backup of a database, using the MySQL binlog to replay the transactions just as they happened originally. We will explain the difference between MySQL’s statement-based and row-based replication and binlogging, and how they should be used to ensure a successful replay of transactions.

Heikki Tuuri

Innobase / Oracle Corp.

Heikki Tuuri is the creator of the InnoDB transactional storage engine in MySQL. He founded Innobase Oy in 1995 and is the CEO of the company. Prior to founding Innobase Oy, Tuuri worked at the University of Helsinki, from which he also received a Ph.D, degree in mathematical logic in 1990.

Comments on this page are now closed.


Picture of Sheeri K. Cabral
Sheeri K. Cabral
07/30/2009 4:39am PDT

Actually, the video is on YouTube now:

Picture of Sheeri K. Cabral
Sheeri K. Cabral
07/06/2009 10:29am PDT

Download the 151 Mb .mov file at or, if you are more patient, wait (15-20 min) for the streaming to occur at

Co-presented By:

O'Reilly Media MySQL/Sun Microsystems
  • Kickfire
  • Virident
  • Infobright, Inc
  • JasperSoft
  • Intel
  • Advanced Micro Devices
  • BIRT Exchange by Actuate
  • Calpont
  • Canonical
  • Continuent
  • Dolphin Interconnect Solutions
  • Facebook
  • HiT Software, Inc.
  • IBM
  • iDashboards
  • Oracle
  • Pentaho
  • R1Soft
  • Schooner Information Technology
  • SQLstream
  • Ticketmaster
  • Zmanda, Inc.
  • Linux Journal

Sponsorship Opportunities

For information on exhibition and sponsorship opportunities at the conference, contact Sharon Cordesse at

Download the MySQL Sponsor/Exhibitor Prospectus

Media Partner Opportunities

Download the Media & Promotional Partner Brochure (PDF) for information on trade opportunities with O'Reilly conferences or contact mediapartners@

Press and Media

For media-related inquiries, contact Maureen Jennings at

MySQL Conference Newsletter

To stay abreast of conference news and to receive email notification when registration opens, please sign up for the MySQL Conference newsletter.

Contact Us

View a complete list of MySQL contacts.