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…
Tag
data recovery
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.
Time-travel SQL for MySQL, finally
MySQL was the only major OLTP database without time-travel queries. Here is how that gap closes, with no fork and no ALTER TABLE storm.