News for hackers. Stuff that matters.

A comment on Practical Guide to SQL Transaction Isolation. Parent comment

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 ]