4 ms·

I've never seen this database used by anyone in real life.

traderj0e 2y ago
I'm skeptical of this kind of multi-master horizontal DBMS to begin with. Never used Cockroach but have used Spanner, and even besides the $, you pay with complexity, slowness, and limitations. Even the in-betweens like Citus have their issues. As far as I can tell, the world runs on traditional DBMSes like Postgres, maybe with HA. If you're big, you run multiple and shard at the application level. I don't think there's a better option yet. Btw, Spanner and Cockroach both have fully serializable transactions. Even single-node Postgres doesn't do that by default (though it can) because they didn't think the performance tradeoff was worthwhile. Read-committed is good enough.
dilyevsky 2y ago
Is Netflix[0] real life enough? [0] - https://www.cockroachlabs.com/blog/netflix-at-cockroachdb/ https://www.cockroachlabs.com/blog/netflix-at-cockroachdb/
- redwood 2y ago
  That's impressive. I'm genuinely surprised they have users at this scale. Are there others?
  - dilyevsky 2y ago
    I heard that doordash ran a cluster serving >1M qps, there maybe still a setup at square/block where the team originated from
    - redwood 2y ago
      I guess most of the larger deployments are self-managed rather than their SaaS offering... Do you think this is mostly running on top of hyperscaler infrastructure? Or in traditional enterprise data centers? I'm just surprised because I never see it
      - dilyevsky 2y ago
        It looks like[0] DoorDash is running theirs self-hosted and just on their cloud, not in the DC. At former gig we ran our much smaller clusters (largest one was ~10T and 20k qps) on kubernetes on cloud. Deployment/updates and what not wasn't difficult - the biggest difficulty was not accidentally overloading the DB from the application layer as always. [0] - https://www.youtube.com/watch?time_continue=97&v=jCjrfpF64Kc https://www.youtube.com/watch?time_continue=97&v=jCjrfpF64Kc

I'm skeptical of this kind of multi-master horizontal DBMS to begin with. Never used Cockroach but have used Spanner, and even besides the $, you pay with complexity, slowness, and limitations. Even the in-betweens like Citus have their issues. As far as I can tell, the world runs on traditional DBMSes like Postgres, maybe with HA. If you're big, you run multiple and shard at the application level. I don't think there's a better option yet. Btw, Spanner and Cockroach both have fully serializable transactions. Even single-node Postgres doesn't do that by default (though it can) because they didn't think the performance tradeoff was worthwhile. Read-committed is good enough.

dilyevsky 2y ago

Is Netflix[0] real life enough? [0] - https://www.cockroachlabs.com/blog/netflix-at-cockroachdb/ https://www.cockroachlabs.com/blog/netflix-at-cockroachdb/

redwood 2y ago
That's impressive. I'm genuinely surprised they have users at this scale. Are there others?
- dilyevsky 2y ago
  I heard that doordash ran a cluster serving >1M qps, there maybe still a setup at square/block where the team originated from
  - redwood 2y ago
    I guess most of the larger deployments are self-managed rather than their SaaS offering... Do you think this is mostly running on top of hyperscaler infrastructure? Or in traditional enterprise data centers? I'm just surprised because I never see it
    - dilyevsky 2y ago
      It looks like[0] DoorDash is running theirs self-hosted and just on their cloud, not in the DC. At former gig we ran our much smaller clusters (largest one was ~10T and 20k qps) on kubernetes on cloud. Deployment/updates and what not wasn't difficult - the biggest difficulty was not accidentally overloading the DB from the application layer as always. [0] - https://www.youtube.com/watch?time_continue=97&v=jCjrfpF64Kc https://www.youtube.com/watch?time_continue=97&v=jCjrfpF64Kc