I’m : a programmer, writer, podcaster, geek, and coffee enthusiast.

InnoDB Hot Backup

I recognize that this is a slim percentage of my audience, but if you:

  1. run a large MySQL database, and
  2. can afford a few hundred bucks

…you should absolutely license InnoDB Hot Backup. It does exactly what it says — back up InnoDB databases without any locks or downtime — and it does it extremely well (and surprisingly quickly).

Throughout our server migration, this helped tremendously. It’s absolutely required if you need MySQL replication. And it’s going to be our new backup method, too.

Highly recommended.