database

MySQL Concurrency

I'm spending quite a lot of time at the moment working on performance optimisations for Analytics SEO, and learning much more about the subtle differences between the different MySQL storage engines.

The importance of testing database restore processes

It's been said before, but good judgement comes with experience, but experience comes from bad judgement

We all know the golden rules on database backups:

  1. do backups
  2. test that you can restore from those backups

But how many of us actually do that second part? I've recently gained some experience (ahem!) on the importance of step 2.

Syndicate content