I have a use case where I would need to read a certain value and update it. This operation can be done by multiple threads in parallel. So, when one thread is updating the value, I do not want the others to update the value. I understand the LWT is one way to achieve this in Cassandra. But at the same time, I understand that LWT is an expensive operation and in some situations may also lead to inconsistent data(where the data got updated but the operation timed out). I also heard(but not 100% sure) that it can go in loops if proposers start proposing a new value frequently.
I wanted to know if there are any other technique to achieve linearizable consistency in Cassandra