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