Hacker News Reader

HNHacker News

Top New Best Ask Show Jobs

Comment by xordon | Hacker News Reader

Full thread

xordon·

Surely there must be an easier way?

View on HN

I'm sure this will be a built in feature in PostgreSQL 9.4 and it is easier than using an external tool like pgpool II

PostgresXL (http://www.postgres-xl.org) is one alternative solution.

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...

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.

Good luck finding a simple package. We met failover and cross-site replication requirements by using Pacemaker controlling pgsql.

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?

Reply on news.ycombinator.com