News for hackers. Stuff that matters.
Re:MySQL InnoDB Cluster GA by gshulegaard on Wednesday April 12, 2017 @03:04PM (#14100745)
Re:MySQL InnoDB Cluster GA by tpetry on Wednesday April 12, 2017 @05:19PM (#14101860)
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.
Re:MySQL InnoDB Cluster GA by Zikes on Wednesday April 12, 2017 @03:18PM (#14100869)
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.
Re:MySQL InnoDB Cluster GA by the_duke on Wednesday April 12, 2017 @03:36PM (#14101006)
It's a completely different database, it just happens to support the postgres binary protocol.
Re:MySQL InnoDB Cluster GA by Zikes on Wednesday April 12, 2017 @03:38PM (#14101017)
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.
Re:MySQL InnoDB Cluster GA by dianasaur323 on Wednesday April 12, 2017 @04:30PM (#14101449)
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.
Re:MySQL InnoDB Cluster GA by anarazel on Wednesday April 12, 2017 @04:28PM (#14101429)
s/binary/wire/
Re:MySQL InnoDB Cluster GA by threeseed on Wednesday April 12, 2017 @04:11PM (#14101286)
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.

Re:MySQL InnoDB Cluster GA by JBReefer on Wednesday April 12, 2017 @05:11PM (#14101793)
I disagree - I think the one vendor open source thing works well, consider Node, Scala, VS Code, etc.
Re:MySQL InnoDB Cluster GA by threeseed on Wednesday April 12, 2017 @11:22PM (#14103886)
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.