Crash Recovery and Media Recovery in InnoDB Heikki Tuuri (Innobase / Oracle Corp.) From the official conference page at http://www.mysqlconf.com/mysql2009/public/schedule/detail/6843 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. InnoDBs 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 MySQLs statement-based and row-based replication and binlogging, and how they should be used to ensure a successful replay of transactions.