|
From: Joseph G. <jos...@or...> - 2012-07-04 05:57:03
|
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 |