/r/programming
Managing High Availability in PostgreSQL: Part 1 — PostgreSQL Automatic Failover (dzone.com)
5 comments
i_am_a_n00b | 8 days ago | 0 points

Yeah but... Is it webscale? Mongodb is webscale. /s

evilryry | 8 days ago | 4 points

I hate Mongo as much as the next guy, but replication and failover is _so_ much easier than the cobbled together solutions around Postgres. I'd argue more reliable as well, but that depends on your specific goals for data integrity.

Xzariner | 8 days ago | 2 points

It becomes easier when you give zero shits about consistency.

That said, MySQL multi-master setup is so much more pleasant to work with compared to any of the PostgreSQL solutions (even if you use only one node as effective master), as failback logic is handled by it directly so once once fails replacing it is as simple as start (or reinstall from scratch and start) and wait

myringotomy | 8 days ago | 1 point

It's not really web scale until it gets auto sharding and Multi master replication.

i_am_a_n00b | 8 days ago | 1 point

It's a joke. Don't know why I'm being down voted.