Multiprocessor Record

Question

I have a database that is shared between various different Ruby on Rails processes. To maintain consistency, I would like the record I was working on to be updated.

I hope to solve this problem: process A reads the record, process B reads the same record, the process updates the record (now the record instance in process B is out of date). Since there are several processes, I obviously cannot use any mutexes, etc.

Is there a good way to do this?

Answer 1

I don't have much experience with this, but I would look at transactions and locking.

http://api.rubyonrails.org/classes/ActiveRecord/Transactions/ClassMethods.html

http://api.rubyonrails.org/classes/ActiveRecord/Locking/Optimistic.html

http://api.rubyonrails.org/classes/ActiveRecord/Locking/Pessimistic.html

, .