Time-travel SQL for MySQL, finally
A time ago I argued MySQL is the only major OLTP database without time-travel queries. Here’s what’s changed. Last month I mapped out how every major…
Product updates, MySQL deep dives, and database change-tracking insights from the team building time-travel for MySQL.
A time ago I argued MySQL is the only major OLTP database without time-travel queries. Here’s what’s changed. Last month I mapped out how every major…
One of the 3 promise that a database do is: I will Survive. Traditionally it was physical: disk, memory, replication, OOM. The hardware side. With agents,…
You’re still running agents against MySQL. So am I. Last time we walked through what happens when an agent doesn’t understand the query it’s running. This…
You’re running agents against MySQL. So am I. It’s where we are. Sooner or later you’re going to be recovering data because of something one of…
The series: A few time ago I wrote that a database does three things: It executes queries. It manages relationships. It survives the physical machine it…
If you’ve worked on Oracle, you know Flashback. Run a SELECT ... AS OF TIMESTAMP, get the row as it existed yesterday at 2pm. Find who…
Most teams running MySQL in production don’t have a DBA. They have a developer who set up RDS two years ago, automated snapshots they’ve never tested…
Every compliance framework that touches data recovery says some version of the same thing: you need to be able to restore data, prove that you can,…
You’ve got Grafana dashboards. PMM is collecting metrics. Datadog has agents on every host. CloudWatch alarms are set up. You know your CPU is at 34%,…
Someone ran a DELETE without the right WHERE clause. One row gone. One customer record. And I spent the next four hours of my life getting…