Hacker News new | ask | show | jobs
by majorsc2noob 4308 days ago
That does not have automatic failover. I really want to use Postgres at work but every time I start reading about failover, load balancing, sharding and so on it seems like such a mess with PG.

I just want sharding with automatic failover to separate datacenter in a simple package...
3 comments
dc2447 4308 days ago
I'm not sure there is actually something in the open source space that is ACID compliant and offers all those features.

Sharding is a problem in Postgres and I am sure they will fix the disconnect between how the data is inserted and how it's read pretty soon.

Automatic failover and datacentre awareness are not typical features in Open Source RDBMS, although you some NOSQL solutions may do this for you.

I'm willing to overlook many weaknesses in PG as we get blistering performance and amazing stability combined with features like hot schema upgrades.

link
devonnulled 4308 days ago
Good luck finding a simple package. We met failover and cross-site replication requirements by using Pacemaker controlling pgsql.
link
mlakewood 4308 days ago
AFAIK the only solution to this in the MySQL world is MHA. And that seems not that much better than the way Postgres does it. Which Relational databases are you referring to that do have this?
link