• Recovering from corrupted InnoDB Pages

    I recently encountered an issue with various InnoDB pages becoming corrupted on the database that plays host to my JIRA install. It was - to some extent - a mess of my own making for mixing production and development databases (or more precisely, for hosting that production database on a dev machine).

    Lesson learnt, sure, but I still needed to address the issue so that I could get JIRA up and running again.

    This documentation details the steps to follow - it won't resolve every case of corruption, but it resolved the issues I was seeing

  • Recovering from InnoDB Page Corruption: A Post Mortem

    Recovering from InnoDB Page Corruption: A Post-Mortem

    I recently wrote about how to Repair a database following InnoDB Page corruption.

    This post is a post-mortem of the circumstances that led to the corruption prompting that post. Some of it comes from log observation, other elements are from re-creating the circumstances in a VM.