Hacker News Reader

Comment by gshulegaard | Hacker News Reader

https://www.postgresql.org/docs/9.5/static/high-availability...

https://www.citusdata.com/solutions/infrastructure/high-avai...

Edit: And before someone mentions "Citus" being "third-party" or "closed" or some such: https://www.citusdata.com/blog/2016/03/24/citus-unforks-goes...

View on HN

CitusDB (not Citus Cloud) is not fully automated: You can have only one master node, if this node fails you have to manually elect a new master node. So it really does not gain anything compared to stock postgresql for HA.

There's also CockroachDB, which is wire-compatible with Postgres. Of course, there are also some performance trade-offs to consider, and it is currently missing many SQL and data type features available in Postgres and others.

It's a completely different database, it just happens to support the postgres binary protocol.

Yes, it is. However when I went looking for a "HA Postgres" solution I found it to be a viable alternative for my use case.

CockroachDB employee here - Yes, CockroachDB is a completely different database from PostgreSQL. CockroachDB supports HA from the bottom up with data broken up into ranges that are consistently replicated using Raft. As mentioned earlier in the thread, it uses the PostgreSQL wire protocol and supports a good amount of SQL (but not all since the dialect is quite large if you include extensions). If you are looking for HA with SQL compatibility, it would be worth taking a look at CockroachDB.

s/binary/wire/

Citus by definition is third party.

And whilst it has been recently open sourced it is always a risk to depend on a project that is controlled by one vendor.

Especially when you are looking for enterprise support.

I disagree - I think the one vendor open source thing works well, consider Node, Scala, VS Code, etc.

Completely different situations.

Node and Scala for example are open source projects first then a company comes in and hires engineers and provides support. That model tends to work fine because you still have a rich, diverse community.

It's different when it's a company that open sources a project. It can sometimes be difficult then for that project to have that same diversity of views.

Reply on news.ycombinator.com