3 ms·

Would it be possible (eventually) to use Citus for sharding within the datacenter, and BDR for master/master replication between datacenters? Or is Citus takin

• mslot 11y ago
  (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.
  • Florin_Andrei 11y ago
    Postgres with sharding and master/master replication would be so awesome.