News for hackers. Stuff that matters.

A comment on Goodbye MongoDB, Hello PostgreSQL (2015). Parent comment

Re:Goodbye MongoDB, Hello PostgreSQL (2015) by srich36 on Thursday March 11, 2021 @02:36AM (#26421331)
There are plenty of modern, distributed RDBMSes that make sharding transparent to the user (E.g. cockroachDB, yugabyte, vitess, many cloud offerings, etc.). Most NoSQL databases end up adding transactions because they are important, and thus the scale advantages for NoSQL systems over relational databases are diminishing, if remaining at all.
[ Parent | on HN ]
Re:Goodbye MongoDB, Hello PostgreSQL (2015) by bushbaba on Thursday March 11, 2021 @02:46AM (#26421402)
Latency at p99 is substantially better at scale with a key value lookup in nosql over postgresql.

Thing is most people don’t have scale these days. You can get a single box with hundreds of logical cores and many hundreds of TiB of locally attached ssd. Until you exceed that you don’t necessarily have scale.

[ Parent | on HN ]
Re:Goodbye MongoDB, Hello PostgreSQL (2015) by threeseed on Thursday March 11, 2021 @03:36AM (#26421701)
> You can get a single box with hundreds of logical cores and many hundreds of TiB of locally attached ssd

And then that box falls over because the entire region fails like just happened yesterday with OVH. Or it just randomly fails like has happened to me with AWS dozens of times.

Vertically scaling a database on your own cloud instances is amateur hour. Either use a cloud-managed database or one that is highly available.

[ Parent | on HN ]
Re:Goodbye MongoDB, Hello PostgreSQL (2015) by bushbaba on Thursday March 11, 2021 @09:49AM (#26424537)
Sure. And those services support some fairly beefy instance types. Such as https://aws.amazon.com/about-aws/whats-new/2019/11/amazon-rd...
[ Parent | on HN ]
Re:Goodbye MongoDB, Hello PostgreSQL (2015) by samlambert on Thursday March 11, 2021 @09:08AM (#26424147)
Well it depends what you consider scale. When you look at the high scale deployments like Slack, YouTube, GitHub, Square, etc they are all using Vitess and MySQL.
[ Parent | on HN ]
Re:Goodbye MongoDB, Hello PostgreSQL (2015) by bushbaba on Thursday March 11, 2021 @09:47AM (#26424524)
YouTube doesn’t use just mysql or vitess these days they migrated to other google databases.

Slack, GitHub both are stupidly shardable. I doubt it’s one RDBMS handling every customer, chat room, git repo. And instead they’ve segmented the workload across multiple instances.

That doesn’t work for every use case

[ Parent | on HN ]
Re:Goodbye MongoDB, Hello PostgreSQL (2015) by samlambert on Thursday March 11, 2021 @10:53AM (#26425324)
Of course they run on multiple instances. It doesn't work for every use case but it works for more than people realize. Too many people vertically scale, or add read replicas which is a ticking time bomb.
[ Parent | on HN ]
Re:Goodbye MongoDB, Hello PostgreSQL (2015) by ZephyrBlu on Thursday March 11, 2021 @02:52AM (#26421447)
Distributed databases like cockroachDB are KV stores.
[ Parent | on HN ]
Re:Goodbye MongoDB, Hello PostgreSQL (2015) by collyw on Thursday March 11, 2021 @05:50AM (#26422611)
MySQL had a Berkley DB engine underneath, that's a KV store too. I wouldn't say that makes /made MySQL a key value store.
[ Parent | on HN ]