Live data from Hacker News

Distributed SQL vs. NewSQL

blog.yugabyte.com

11–20 of 49 posts

Re: Distributed SQL vs. NewSQL

#11
post #7
post #6

I tried Yugabyte a few weeks back, the TServer kept crashing while my backend was creating some very simple tables. I'm stuck with CockroachDB for the time being.

Have you tried comdb2? I've heard good things. Idk why it isn't more popular.

It doesn't have sharding.

Re: Distributed SQL vs. NewSQL

#12
post #10
post #4

Yugabyte has great articles in general and seems almost to be good to be true what I have read. It is just missing a bit of independent third party reviews but it does look interesting. Anyone with hands on experience?

Yugabyte v. Cockroach analysis: https://www.cockroachlabs.com/blog/unpacking-competitive-ben... disclaimer: I work at cockroach

Nice. Seems a bit disingenuous on yugabyte to claim they’re better performant in light of this.

Just want to say that I love your docs. Haven’t used cockroachDB just yet but the docs are clean, easy to follow, devoid of marketing and focused on facts.

Re: Distributed SQL vs. NewSQL

#14

Does anyone have good experiences with seamless sharding at the database layer? I'm old school and I'd be strongly inclined to look for a simple cut that allowed me to shard at the app layer, but I'd love to hear an alternative view.

Vitess is awesome if you're using MySQL.

Re: Distributed SQL vs. NewSQL

#16
post #5
post #4

Yugabyte has great articles in general and seems almost to be good to be true what I have read. It is just missing a bit of independent third party reviews but it does look interesting. Anyone with hands on experience?

https://jepsen.io/analyses/yugabyte-db-1.3.1

From your link:

> 2019-09-05: YugaByte’s blog post states YugaByte DB “passes Jepsen tests”. We feel obligated to state that YugaByte DB’s Jepsen test suite does not pass, though it may in the future. Race conditions in YugaByte DB’s schema system can cause correctness errors. For example, inserting rows into a freshly-created table with DEFAULT values may result in the values for those columns initialized to NULL instead. We can also now confirm that this issue affects all default values, not just DEFAULT NOW(). It also appears that DDL race conditions might, under certain conditions, render tables completely unusable.

Yikes. I understand the need for marketing and making their product look good but it's going a bit too far saying they pass the tests when they didn't. I can easily see potential customers pausing when encountering that kind of attitude from YugabyteDB's developers. "What else are they dishonest about..." kind of idea.

Re: Distributed SQL vs. NewSQL

#17
post #9
post #6

I tried Yugabyte a few weeks back, the TServer kept crashing while my backend was creating some very simple tables. I'm stuck with CockroachDB for the time being.

> I'm stuck with CockroachDB for the time being. Would you care to share any negative experiences you've had with CockroachDB? What is motivating your desire to look elsewhere?

A few weeks back after my attempt to switch to Yugabyte I decided to commit to CockroachDB in a dedicated cluster with TLS, my backend runs migrations including creating the database but only admins and root are able to create databases but because TLS was enabled my root user didn't work anymore. I was not able to create more admin users because that's part of the RBAC Enterprise offering. The database was there but the authorization system triggers before IF NOT EXISTS condition, so I had to make changes to make it work in production. I honestly thought that if I stayed away from Enterprise features then I would be fine, but no: it seems like if I wanted to deploy my backend on-premise, the deployment process would have to include an step to run the CREATE DATABASE script out of band either before enabling TLS or via localhost(?) in a database node, otherwise I'm fucked unless the client buys CRDB Enterprise to smooth out the deployment process. That's a very extreme case of Open-Core money-squeezing shit I would like to stay away from.

CockroachDB Core is fine as a product, the docs are up to date and it's not hard to operate, all that is appreciated it. I just don't think I'm the target user, unless you make a shit ton of money as you scale it will be hard to operate without:

- Distributed Backups(Enterprise)

- Follower Reads(Enterprise) (no, follow-the-workload doesn't cut it)

- RBAC(Enterprise)

Yugabyte offers all that in their open-source license, which is why I'm rooting for them, that in addition to Change Data capture(Enterprise offering in CockroachDB) is also included.

Re: Distributed SQL vs. NewSQL

#18
post #12
post #10

Earlier quoted context omitted.

Yugabyte v. Cockroach analysis: https://www.cockroachlabs.com/blog/unpacking-competitive-ben... disclaimer: I work at cockroach

Nice. Seems a bit disingenuous on yugabyte to claim they’re better performant in light of this. Just want to say that I love your docs. Haven’t used cockroachDB just yet but the docs are clean, easy to follow, devoid of marketing and focused on facts.

Second that, the CockroachDB documentation is excellent. All the DDL and DML statements are clearly documented and with examples, that's really cool.

Re: Distributed SQL vs. NewSQL

#19
post #16
post #5

Earlier quoted context omitted.

https://jepsen.io/analyses/yugabyte-db-1.3.1

From your link: > 2019-09-05: YugaByte’s blog post states YugaByte DB “passes Jepsen tests”. We feel obligated to state that YugaByte DB’s Jepsen test suite does not pass, though it may in the future. Race conditions in YugaByte DB’s schema system can cause correctness errors. For example, inserting rows into a freshly-created table with DEFAULT values may result in the values for those columns initialized to NULL in…

I don’t know the case at yugabyte but, in general, the outright lies by sales has nothing to do with the integrity of the developers.

Re: Distributed SQL vs. NewSQL

#20
post #7
post #6

I tried Yugabyte a few weeks back, the TServer kept crashing while my backend was creating some very simple tables. I'm stuck with CockroachDB for the time being.

Have you tried comdb2? I've heard good things. Idk why it isn't more popular.

I didn't know it was used outside of Bloomberg...
Post reply on HN