Hermitage: Testing the “I” in ACID

Re:Hermitage: Testing the “I” in ACID by a-priori on Tuesday November 25, 2014 @05:00PM (#8659986)

In case it's interesting to people, here's a blog post I made earlier this year on the topic of what exactly transaction isolation means:

http://www.michaelmelanson.net/2014/03/20/transactions/

[ Parent | on HN ]

Re:Hermitage: Testing the “I” in ACID by martinkl on Tuesday November 25, 2014 @05:36PM (#8660189)

Nice example of a bug caused by weak isolation. FWIW, Postgres has an interesting implementation of "serializable" which takes far fewer locks than MySQL, so may give you better performance while retaining the same isolation level.

[ Parent | on HN ]

Re:Hermitage: Testing the “I” in ACID by fdr on Tuesday November 25, 2014 @06:40PM (#8660455)

Yes: it is the relatively new approach by Cahill et al in 2008, known as SSI: https://courses.cs.washington.edu/courses/cse444/08au/544M/R...

Which, as far as production-common database implementations go, is lightspeed for implementing new academic work (9.1, the first version with the feature, was released in 2011).

[ Parent | on HN ]