There’s a lot of focus on negatives in comments. I will say ssris probably saved my life and I have had zero side effects to date. It’s easy to say “just suck it up and power through it”. That advice can kill people
Sure. I always find the more extremist responses (you can find some towards the bottom) confusing because the only side effect I've ever been aware of is not wanting to die.
I just think there's a lot of fud around this and I have friends who have never taken them that were very ready to jump in on the discussion about how they destroy lives.
Same issue we had with cockroach. The oss is lagging and you ultimately need to end up paying the company for support. its really just "kinda oss" in that you can look at source code from 2 years ago but to actually use it, might as well be oracle. If your fork it you are just gonna be in a hostile environment (unless you pay them)
We are a huge production setup where it’s absolutely critical successfully but we use temporal cloud. Hosting it yourself is what makes it miserable. https://temporal.io/resources/on-demand/netflix
That's why their entire business model -- like Astronomer's -- is geared toward cloud hosting. The architecture is so complex it takes a full time team to run it.
Cockroach doesn't offer strict serializability. It has serializability with some limits depending on clock drift. Also CockroachDB does not provide linearizability over the entire database.
You’re describing compare and swap which is a good solution. You’re pushing complexity down to the database, and remember this is distributed locking. When you have a single database it’s simple until the database crashes leaving you in state of not knowing which of your CAS writes took effect. In major systems that demand high availability and multi datacenter backups this becomings pretty complicated with scenarios that break this as well around node failure. Usually some form of paxos transaction log is used. Never assume there is an easy solution in distributed systems… it just always sucks