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
data restore
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…
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…