3 ms·
"passable clustering" you talk about PG which has nothing, so when you start to re-implement sharding yourself you're in trouble. Fortnite uses MongoDB for eve
by Thaxll 8y ago
"passable clustering" you talk about PG which has nothing, so when you start to re-implement sharding yourself you're in trouble.
Fortnite uses MongoDB for everything, they have a huge load ( 7.5M CCU is insane ) and don't have more problems than if they choose something else.
MongoDB gets bad press on Reddit / HN probably because of past marketing campaigns, but nowdays it's a very solid solution.
- mbell 8y ago> "passable clustering" you talk about PG which has nothing, so when you start to re-implement sharding yourself you're in trouble. Or you can just use Citus.
- Thaxll 8y agoWhich is not PG anymore.
- stingraycharles 8y agoIt's dead easy to migrate an existing PostgreSQL install to Citus (application code can all stay the same), so it's a great way to scale your application when you need it, and at the same time just use PostgreSQL for when you don't need scale yet (99% of all apps).
- GordonS 8y agoI thought it was implemented as an extension, rather than a separate product? I'd say that's still "Postgres"
- manigandham 8y agoCitus is an extension to Postgres. It is still PG, and has the same scaling semantics as a MongoDB replica set that that point for distributed tables.
- matthewmacleod 8y agoYou can use Citus, as others have mentioned, or something like BDR – but bear in mind that vanilla Postgres will happily do big pile of hot standby servers for scaling reads, and will scale vertically very well. You might have a case in which you need something faster – I'd argue that there are still better solutions, but YMMV.
- chrshawkes 8y agoCompass is a solid product shipping with Mongo these days as well. I missed having something like that many years ago when first trying Mongo.