News for hackers. Stuff that matters.
Re:Citus Unforks from PostgreSQL, Goes Open Source by ozgune on Thursday March 24, 2016 @12:16PM (#11354030)
(Ozgun from Citus Data)

We're working on making Citus masterless. In all openness, we evaluated two different approaches to this in the past six months, and wrapped up the design for one. This design works well on the cloud, and we already demonstrated a working version: https://youtu.be/_nun2S6EdWo?t=411

For on-premise deployments, the primary challenge is set-up complexity. We're now prototyping one of those designs to know more: https://github.com/citusdata/citus/issues/389

We expect to share all the details and a concrete timeline in April.

Re:Citus Unforks from PostgreSQL, Goes Open Source by Florin_Andrei on Thursday March 24, 2016 @04:33PM (#11356180)
Would it be possible (eventually) to use Citus for sharding within the datacenter, and BDR for master/master replication between datacenters?

Or is Citus taking over the master/master replication? (or is it doing something different?)

Re:Citus Unforks from PostgreSQL, Goes Open Source by mslot on Thursday March 24, 2016 @05:26PM (#11356583)
(Marco from Citus Data)

It seems at least theoretically possible.

Since the Citus master executes distributed queries by sending regular SQL queries to the Citus workers, you could already use BDR servers as workers and replicate the data between pairs of workers in different data centers and copy over the metadata on the master manually. However, some distributed joins and data loading features wouldn't work.

For all features to work, and to replicate the master, you would have to compile Citus against BDR, which probably requires a few code changes.

Re:Citus Unforks from PostgreSQL, Goes Open Source by Florin_Andrei on Thursday March 24, 2016 @05:54PM (#11356783)
Postgres with sharding and master/master replication would be so awesome.
Re:Citus Unforks from PostgreSQL, Goes Open Source by cm3 on Thursday March 24, 2016 @05:07PM (#11356449)
What does "works well on the cloud" mean specifically? Is there some difference when run on your own hardware?
Re:Citus Unforks from PostgreSQL, Goes Open Source by microcolonel on Thursday March 24, 2016 @06:55PM (#11357158)
I imagine it means it tolerates unreliable or higher-ish latency networks, maybe avoids multicast.
Re:Citus Unforks from PostgreSQL, Goes Open Source by batbomb on Thursday March 24, 2016 @02:02PM (#11354937)
Can Citus handle geospatial sharding?
Re:Citus Unforks from PostgreSQL, Goes Open Source by tracker1 on Thursday March 24, 2016 @02:30PM (#11355160)
You could always compute a geohash and use that as a shard key... I'm not familiar enough with Citus' specific approach here, but using a limited geohash would give you close to what you're looking for.
Re:Citus Unforks from PostgreSQL, Goes Open Source by enesunal on Thursday March 24, 2016 @04:15PM (#11356071)
good work! congrats =)

also in Turkish: kolaylıklar dilerim :)

Re:Citus Unforks from PostgreSQL, Goes Open Source by no1youknowz on Thursday March 24, 2016 @12:25PM (#11354116)
Excellent news! Really looking forward to this one! :)