3 ms·
and you need that because ...?
by qaq 9y ago
and you need that because ...?
- closeparen 9y agoYou shouldn't go down when one box or VPS falls over?
- oblio 9y agoFor 99% of the situations you just need 2 boxes.
- mbesto 9y agoAnd if you do need more, there's commercial solutions: https://aws.amazon.com/rds/postgresql/ https://aws.amazon.com/rds/postgresql/ https://www.citusdata.com/ https://www.citusdata.com/
- qaq 9y agoRDS is very far from optimal for high load PG
- tracker1 9y agoAnd, I've worked in a few that needed more... million+ simultaneous users, and over 380k requests per second, and 5 nines. There really are times you need more than an SQL server can keep up with. Another, it was the shape of the data, all keyed off a single record, but ancillary tables with additional queries or joins meant over 30 joins, or 15 additional queries to render one resource, which fit into a single "nosql" record and mongo supported the additional indexes needed, it was a good fit for the use case. I'm not advocating nosql for everything... I've seen a few that went mongo that would have been better served with sql. But that isn't to say that a document or column-store database is never a better fit from the start.
- qaq 9y agoYou shouldn't and that is trivial to setup.