Automating Hermitage to see how transactions differ in MySQL and MariaDB
Summary
The Consensus investigates how transaction isolation levels affect correctness and visibility of writes across MySQL and MariaDB, using an open-source testing tool called Monastery and a hands-on dirty-writes/reads thought experiment. The article provides a reproducible setup with a shoes table to illustrate how two concurrent transactions can yield inconsistent results, highlighting ANSI SQL isolation ambiguities and practical database behavior differences.