dbtrail -

all mysql time-travel data recovery dba mariadb featured data restore bintrail restore verification proxysql audit

Latest · dbtrail

DB Trail World Tour – Sept 2026

Amsterdam, The Netherlands: https://perconalive.com/2026-amsterdam/talks/mysql-time-travel-practical-row-level-recovery-with-open-source-tools Montevideo, Uruguay: https://percona.university/event/percona-university-montevideo-uruguay/ Buenos Aires, Argentina: https://nerdearla.com/en/argentina/schedule/poor-mans-lakehouse-analytics-historicas-y-recovery-sobre-mysql-con-duckdb-parquet/ Sao Paulo, Brasil: https://mysqlbrconf.com.br/speakers/daniel-guzman-burgos

September 7, 2026 1 min

Read the entry

August 4, 2026 6 min

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…

July 28, 2026 10 min

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…

July 15, 2026 7 min

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…

July 2, 2026 10 min

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…

June 22, 2026 19 min

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…

June 15, 2026 8 min

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:…

June 2, 2026 13 min

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…

May 25, 2026 11 min

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…

May 7, 2026 10 min

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…

The trail