• Configuring NGinx to act as a Reverse Proxy for PHPMyAdmin

    In a previous post, I detailed how to Use NGinx to serve static files and Apache for dynamic as well as the minor tweaks you need to make to have it work nicely with Joomla.

    One thing I didn't cover, though, is setting up PHPMyAdmin. This documentation isn't going to go into the detail of installing and configuring PHPMyAdmin as there's plenty of that available elsewhere on the web. What we will discuss, though, is the NGinx configuration changes you need to make to have the connection reverse proxied to Apache.

    These steps only really apply if you've gone for a system-wide installation of PMA. If you've unpacked into a web-accessible directory then you probably don't need to make any changes!

  • 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.