Product updates, MySQL deep dives, and database change tracking insights.
A reader asked four operations-grade questions about Time Travel SQL. Here is how bintrail handles multi-TB tables, retention, monitoring, and partitioning – and how it differs from MariaDB system-versioned tables.
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 OLTP except…
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, that definition…
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 week, what…
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 them did.…
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 runs on.…
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 touched it…
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 a restore…
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, and show…
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%, your queries…
