Practical Guide to SQL Transaction Isolation

Re:Practical Guide to SQL Transaction Isolation by ellius on Wednesday August 02, 2017 @10:01AM (#14910605)

This was an awesome comment. I've been trying to figure this out but haven't known what I was looking for. Thanks for the advice.

[ Parent | on HN ]

Re:Practical Guide to SQL Transaction Isolation by IgorPartola on Wednesday August 02, 2017 @11:27AM (#14911292)

Just so you know, this isn't the only way to do this. You can use external systems for locks as well. Redis is a good candidate: http://loose-bits.com/2010/10/distributed-task-locking-in-ce...

[ Parent | on HN ]

Re:Practical Guide to SQL Transaction Isolation by skyde on Wednesday August 02, 2017 @01:24PM (#14912648)

I woulds strongly advise against using Redis for lock. Maybe something with a real consensus algorithm like ETCD or Zookeeper but otherwise it's better to keep the lock inside the RDBMS.

[ Parent | on HN ]