Repointing a replica by file and position requires knowing exactly where the old source stopped, and a GTID is a transaction identity that every server agrees on. The…
Wrapping each test in a transaction and rolling back is much faster than migrating between tests, and three things do not survive it. The second connection case is…
Both tools copy a table without a long lock, and the mechanism they use to keep up with concurrent writes has different failure characteristics. The synchronous trigger cost…
InnoDB detects a deadlock, kills one transaction and returns an error, and an application that treats that as a bug will treat a normal event as an outage.…
LAST_VALUE with an ORDER BY and no frame returns the current row rather than the last one, which is correct by the specification and is never what anybody…
A read immediately following a write is the one query that cannot tolerate replication lag, and it is also the query most likely to be written without thinking.…