20 ms·

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

by heipei 1mo ago

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.

cyberpunk 1mo ago
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.
rajman187 1mo ago
i'd say 99% of usecases will be served fine with Postgres, or a managed instance via AWS
- cyberpunk 1mo ago
  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.
  - isignal 1mo ago
    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.
    - andriy_koval 1mo ago
      cocroach is also open source no anymore. ydb is not clear if easier to maintain at scale.
  - ksec 1mo ago
    >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.
andriy_koval 1mo ago
> 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?
- misiek08 1mo ago
  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…
- cnlwsu 1mo ago
  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)
ali_alkhazraji 1mo ago
[flagged]

by heipei 1mo ago

cyberpunk 1mo ago

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.

rajman187 1mo ago

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

cyberpunk 1mo ago
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.
- isignal 1mo ago
  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.
  - andriy_koval 1mo ago
    cocroach is also open source no anymore. ydb is not clear if easier to maintain at scale.
- ksec 1mo ago
  >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.

andriy_koval 1mo ago

> 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?

misiek08 1mo ago
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…
cnlwsu 1mo ago
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)

ali_alkhazraji 1mo ago

[flagged]