About once a year, there's a blog post from one of the current Tech Unicorns about how they had a big data problem and solved it with a slightly non-standard usage of MySQL. This is a really good thing, because MySQL is an extremely versatile tool. Assembled in a modular

Continuing the discussion around transactions, consistency, and MySQL, we consider transaction isolation levels. Setting the TXIL Per Session Remember in MySQL we have auto-commit=1. When you set the transaction isolation level with a statement, that only lasts one transaction if you don't specify the session keyword, so the TXIL

What's Been Happening Recently Is consistency even important? We know it's contentious. Some people find it extremely important, and we all at least pay lip service to it. But really... how much effort should we put toward making sure we've got it? As you might have noticed, recently we saw