How can we have distributed locks so that NoSQL databases can have login functionality?

[rishabhpoddar]

❓ Questions and Help

• Ask the user to have a SQL database only used for advisory locking
• Use another service like redis for locks only.
• This would require an interface for locks to be provided by the core so that the APIs can use them
• Is there a way to build your own locks across the SuperTokens cluster?

This issue is related to: supertokens/supertokens-plugin-interface#3

[rishabhpoddar]

Essentially locking can be achieved by consensus across cores. We can achieve consensus by having an ordered queue in the database (using ordered UUIDs). Core1 would insert some UUID, Core2 would insert something else. They both would read both the UUIDs, and order them, and if Core1's UUID is "first", then Core1 knows it is the winner.

• This approach may not work since core1 can generate a UUID whose value is lesser than core2's UUID, but end up writing that value in the db much later than core2. This could lead to core2 having read that it's the only one who has inserted a UUID and then both will take a lock.