[Postgres-xc-general] Composite table types, replicate + distribute.

[Joseph G. <jos...@or...>]

Hey guys,

This is more of a feature request/question regarding how HA could be
implemented with PostgreXC in the future.

Could it be possible to have a composite table type which could
replicate to X nodes and distribute to Y nodes in such a way that
atleast X copies of every row is maintained but the table is shareded
across Y data nodes.

For example in a cluster of 6 nodes one would be able configure at
table with REPLICATION 2, DISTRIBUTE 3 BY HASH etc (I can't remember
what the table definitions look like) as such that the table would be
replicated to 2 sets of 3 nodes.

This is interesting becaues it can provide a flexible tradeoff between
full write scalability (current PostgresXC distribute) and full read
scalability (PostgresXC replicate or other slave solutions)
What is most useful about this setup is using PostgresXC this can be
maintained transparently without middleware and configured to be fully
sync multi-master etc.

Are there significant technical challenges to the above and is this
something the PostgresXC team would be interested in?

Joseph.

-- 
CTO | Orion Virtualisation Solutions | www.orionvm.com.au
Phone: 1300 56 99 52 | Mobile: 0428 754 846