Whither CockroachDB?

#1

Post by hasheddan » Fri, Aug 16, 2024, 4:47 PM UTC

Whither CockroachDB?
rfd.shared.oxide.computer

Re: Whither CockroachDB?

#2

Post by SamInTheShell » Fri, Aug 16, 2024, 4:50 PM UTC

Some of the raft failure modes for CockroachDB suck to recover from. In testing I've had better results with Yugabyte. If licensing is such a big deal though, CockroachDB loses over Dgraph and Yugabyte.

I doubt anyone will really do anything worth-while in maintaining CockroachDB when it's latest version eventually does falls into Apache licensing.

Re: Whither CockroachDB?

#3

Post by ezekg » Fri, Aug 16, 2024, 8:22 PM UTC

Context: https://news.ycombinator.com/item?id=41258843

Re: Whither CockroachDB?

#4

Post by [deleted] » Fri, Aug 16, 2024, 8:50 PM UTC

[deleted]

Re: Whither CockroachDB?

#5

Post by eYrKEC2 » Fri, Aug 16, 2024, 9:27 PM UTC

@bcantril,

Although it sounds like migrating to another DB is not a good choice for Oxide _today_, why didn't you start with yugabyte db? If you were starting from scratch today, which one would you choose for your situation?

Re: Whither CockroachDB?

#6

Post by bcantrill » Fri, Aug 16, 2024, 10:24 PM UTC

eYrKEC2 wrote: post #5

@bcantril, Although it sounds like migrating to another DB is not a good choice for Oxide _today_, why didn't you start with yugabyte db? If you were starting from scratch today, which one would you choose for your situation?

There were several factors moving us away from YugabyteDB, not least some worrisome Jepsen results.[0]

[0] https://jepsen.io/analyses/yugabyte-db-1.3.1

Re: Whither CockroachDB?

#7

Post by rpaik » Fri, Aug 16, 2024, 10:32 PM UTC

eYrKEC2 wrote: post #5

@bcantril, Although it sounds like migrating to another DB is not a good choice for Oxide _today_, why didn't you start with yugabyte db? If you were starting from scratch today, which one would you choose for your situation?

Following up on this...

@bcantril, what were your initial reasons for choosing CockroachDB?

Re: Whither CockroachDB?

#8

Post by bcantrill » Fri, Aug 16, 2024, 10:52 PM UTC

rpaik wrote: post #7

eYrKEC2 wrote: post #5

@bcantril, Although it sounds like migrating to another DB is not a good choice for Oxide _today_, why didn't you start with yugabyte db? If you were starting from scratch today, which one would you choose for your situation?

Following up on this... @bcantril, what were your initial reasons for choosing CockroachDB?

We outlined that in detail in RFD 110.[0]

[0] https://rfd.shared.oxide.computer/rfd/0110

Re: Whither CockroachDB?

#9

Post by h_tbob » Sat, Aug 17, 2024, 9:57 AM UTC

I don’t mind paying for software but… for a business with 10mm annual revenue the idea is that for them it’s cheaper to use the best database vs hire an employee to manage a worse one.

So for us solo devs it seems nightmarish. But I think at the enterprise level they say: “hire 2 employees to manage X or buy cockroach”. So they buy if software cheaper.

That’s why it’s so expensive I think.

Note: never worked in corporate so I don’t know.

Re: Whither CockroachDB?

#10

Post by compton93 » Sat, Aug 17, 2024, 10:58 AM UTC

SamInTheShell wrote: post #2

Some of the raft failure modes for CockroachDB suck to recover from. In testing I've had better results with Yugabyte. If licensing is such a big deal though, CockroachDB loses over Dgraph and Yugabyte. I doubt anyone will really do anything worth-while in maintaining CockroachDB when it's latest version eventually does falls into Apache licensing.

Clock sync issues also sucked, we had a recurring issue which would cause the cluster to become unstable due to clock syncs and support would throw it in the to hard basket.