InnoDB for the fast. DuckDB for the heavy. Same connection for both.
Use InnoDB and DuckDB at the same time, on the MySQL you already run. Reports ran 10 times faster. Open source, no migration, no DuckDB to…
Archive
Introducing the MySQL Analytical Replica (Parquet + DuckDB)
Your reports run on your production MySQL. DBTrail keeps a copy of your tables as Parquet files and lets you query it with DuckDB.
DB Trail World Tour – Sept 2026
Four talks this September: Amsterdam, Montevideo, Buenos Aires and São Paulo. Where to find DB Trail.
Everyone Records the MySQL Audit Log. Nobody Reads It.
Almost nobody reads the audit log, because reading it is painful. There is a cheaper shape: keep the answer, not the log.
MySQL 8.0 to 8.4 upgrade on RDS: how to prove your data survived
The upgrade to 8.4 takes minutes and there is no way back. How I checked, on a real RDS instance, that it did not change a…
Time-travel for PostgreSQL: one SELECT vs a full restore vs replaying the WAL
PostgreSQL can now tell you what a row contained at any past moment, with a normal SELECT. One example, against restore and WAL replay.
How DB Trail guarantees a recovery would actually be correct: Data Validation
A backup you never restored is a hope. How DB Trail checks the whole recovery chain, and how to wire that check into CI.
The MariaDB approach vs the DB Trail for MySQL approach: Comparing time-travel
Two ways to keep database history. Not a speed contest: what survives a real incident, and what history costs you every day.
DB Trail Open Source now has a UI
DB Trail now has a web console. You no longer need to remember command flags to find which rows a bad query touched.
Rate Limiting (Throttle) for MySQL with ProxySQL and Bintrail
The 2020 post, rewritten for ProxySQL 3.0 and MySQL 8.4. Not only whether to throttle, but which writes to throttle.