Re: [Postgres-xc-general] Node redundancy

[Josh B. <jo...@ag...>]

On 05/26/2014 05:10 PM, Tim Uckun wrote:
> Would it be possible to keep the shards in multiple data nodes so that if
> one data node failed you'd just replace it when you can get around to it.

Right, that's what I was describing.  It's the standard way to deal with
redundancy in any parallel sharded database.

The drawback is that it increases write times, because you can't count a
write as saved unless all shards return.  This is why some databases
(e.g. Cassandra) go one step further and have, say, each shard in 3
places and only 2 need to return.  That gets way complicated though.

-- 
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com