Re:Some opinionated thoughts on SQL databases
by slt2021 on Tuesday March 30, 2021 @09:38PM
(#26642616)
is it true that MySQL scales much better than postgres?
for example ServiceNow is using customized mysql engine to store and search all data for all its clients.
Doing something like that in pg is probably extremely hard. Would love to hear people's thoughts on this
[ Parent
| on HN ]
Re:Some opinionated thoughts on SQL databases
by skunkworker on Tuesday March 30, 2021 @11:40PM
(#26643267)
This depends what you mean by "scaling". Postgres can easily handle 10s of Terabytes on a single server (though this is dependent upon your use case), but when it comes to multiple host sharded databases at the moment MySQL has some more mature options like Vitess [1], where your options in Postgres are things like Citus [2] which just recently open sourced their shard mover, but still have the HA and replication feature behind expensive enterprise pricing.
For most people not dealing with the multiple terabyte database size, Postgres is what I would definitely recommend. But once you get above that, then there are no easy answers and you would need to look at what YouTube did with Vitess [3]