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…
Tag
time-travel
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…
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…