3 ms·
Citus only does sharding, not replication. Either way, this is a fundamental design limitation with traditional single-master relational systems.
by manigandham 8y ago
Citus only does sharding, not replication. Either way, this is a fundamental design limitation with traditional single-master relational systems.
- bsg75 8y agohttp://docs.citusdata.com/en/v8.1/cloud/availability.html http://docs.citusdata.com/en/v8.1/cloud/availability.html
- manigandham 8y agoYea, that's just normal Postgres replication, nothing to do with Citus.
- tpetry 8y agoCitus is doing sharding and replication: Citus will shard your data and place every shard on e.g. 3 servers. So one server dying is no problem because the data is replicated 2 times.
- jbergens 8y agoDo they have ACID transactions around writing to all 3 servers? Doesn't that cause bad performance? You might also end up with a LOT of servers unless you starting sharing servers for different shards (but still with different sets of 3 servers for every shard).
- manigandham 8y agoAh I see that now. However that's not by default and it still only applies to "distributed" tables, not all the data in the database. Combined with a single-master, it's nowhere near the replica functionality provided by natively distributed storage systems.