isocheck

isocheck

Tests which transaction isolation level a Postgres or MySQL database actually provides, using the same method as Jepsen's Elle.

go install github.com/salw2e/isocheck@latest
isocheck -isolation serializable postgres://user@localhost:5432/db
isocheck -isolation repeatable-read mysql://root@localhost:3306/db

It creates a table called isocheck in the database. Exit code is 1 if the level isn't met.

read-committed       yes
snapshot-isolation   yes
repeatable-read      no   G2-item
serializable         no   G2-item

Results