MySQL Time-Travel with near-ZERO overhead: How bintrail skips the write load
Four operations questions about Time Travel SQL: multi-TB tables, retention, monitoring and partitioning.
Four operations questions about Time Travel SQL: multi-TB tables, retention, monitoring and partitioning.
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.
Survive used to be physical: disk, memory, replication. With agents that definition is too small. Five things change.
Something deleted thirty thousand rows overnight, and the binlog only says app_user. MySQL cannot tell who the agent is.
Sooner or later you will recover data because of something an agent did. The three most common shapes that day takes.
A database makes three promises: it executes queries, manages relationships, and survives its machine. Reread for the agent era.