Hacker News Reader

Comment by heipei | Hacker News Reader

So what is the alternative? It took me a while to get around the data schema / modelling that a database like Cassandra imposed, but when it finally clicked it really clicked for me, so much so that I wish I could have the same performance footprint of consistent hashing / sharding with other databases.

We are using ScyllaDB, but since they discontinued their Open Source version we're stuck on the last supported version, and reading about the operational headaches of Cassandra does not inspire confidence to give it a go.

View on HN

Drop in with same schematics? It's not going to be easy, I don't have an answer. It's unpopular, but probably I'd architect my software more towards a sharded mongo cluster for write heavy workloads these days, rather than lean on cass/scylla/cockroach.

Mongo bit me a lot pre-wiredtiger and I refused to forgive them for years, but I'm using it again since 8.x and it's really... Boring, Scalable. There are many ways to skin a cat though, and I know not everyone has the luxury of redesigning their apps to fit the persistence layer.

> We are using ScyllaDB, but since they discontinued their Open Source version we're stuck on the last supported version

Do you think you are missing anything by being on scylla oss?

Second that question not only to OP/GP. Comparing Scylla and Cassandra - the choice is obvious, but current offering is a complete no-go.

Also Mongo is catching up in the use case we have and it’s even more scary. We are all the time at the exact edge of Mongo scalability and I’m talking about very good, few-years-invested-in setup on NMVe that is really delicate…

i'd say 99% of usecases will be served fine with Postgres, or a managed instance via AWS

We live in wildly different worlds, I think. How is postgres comparable to 6-12 nodes of cassandra? One really giant one with 200k worth of storage? Is there even a multi-master setup yet? every time i’ve looked it’s just around the corner. multigres from supabase seems promising, but im not touching it for at least a couple years…

I’d love to use postgres, and have in various times in the past and love it (it never broke) — but one machine isn’t nearly big enough for really any of my current applications.

You can use a distributed database like yugabytedb or crdb. They are horizontally scalable, support postgres (yugabytedb has much better postgres compatibility). Yugabytedb also supports the Cassandra API.

cocroach is also open source no anymore.

ydb is not clear if easier to maintain at scale.

>multigres from supabase seems promising

I have high hopes for Neki from Planetscale but then again if you are not stuck on Postgres for whatever reason, Vitess with MySQL is about as battle tested as it gets.

Reply on news.ycombinator.com