Everyone Records the MySQL Audit Log. Nobody Reads It.
Everyone records audit logs. Almost nobody reads them, because reading them means grep on the database server, a cursor with no WHERE clause, or a log…
Category
dbtrail
MySQL 8.0 to 8.4 upgrade on RDS: how to prove your data survived
Standard support for MySQL 8.0 on RDS ends on July 31. The in-place upgrade to 8.4 takes minutes and there is no way back. Here is…
Time-travel for PostgreSQL: one SELECT vs a full restore vs replaying the WAL
PostgreSQL now lets you ask what a row contained at any moment in the past, using a normal SELECT. This post shows the idea with one…
How DB Trail guarantees a recovery would actually be correct: Data Validation
A backup you never restored is not really a backup, it is a hope. This is how DB Trail checks the whole recovery chain (capture, storage…
The MariaDB approach vs the DB Trail for MySQL approach: Comparing time-travel
Two ways to keep database history: inline system versioning, or an external change-data-capture index on a separate machine. This is not a speed contest. It is…
DB Trail Open Source now has a UI
DB Trail now has a web console. That is the short version 🙂 For as long as dbtrail has existed, you drove it from the command line:…
Rate Limiting (Throttle) for MySQL with ProxySQL and Bintrail
Back in 2020 I wrote about rate limiting writes to MySQL with ProxySQL. The main idea is still valid, but two things changed enough to write…
MySQL Time-Travel with near-ZERO overhead: How bintrail skips the write load
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…
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…
For a Database, survive used to mean “The server stays up”. With AI Agents, that’s not enough anymore
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,…