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…
Your database knows what happened. You just can’t ask it. Every MySQL database with binary logging enabled already records every data change internally. But that history…
