Alan, here I'm implementing something similar to the Chord protocol [1] on the application level to partition my data across 6 PostgreSQL servers with N+1 replication. Two up sides on this approch:
1 - When one server is down the load is spread between all the other ones, instead of going only to the replication pair. 2 - Adding one more server is easy, you only have to reallocate aprox. 1/n of your data (n=number of servers). Good luck there! Best, Daniel On Wed, May 27, 2009 at 2:57 PM, Alan McKay <alan.mc...@gmail.com> wrote: > Hey folks, > > I have done some googling and found a few things on the matter. But > am looking for some suggestions from the experts out there. > > Got any good pointers for reading material to help me get up to speed > on PostgreSQL clustering? What options are available? What are the > issues? Terminology. I'm pretty new to the whole data-warehouse > thing. And once I do all the reading, I'll even be open to product > recommendations :-) > > And in particular since I already have heard of this particular > product - are there any opinions on Continuent? > > thanks, > -Alan > > -- > “Mother Nature doesn’t do bailouts.” > - Glenn Prickett > > -- > Sent via pgsql-performance mailing list (pgsql-performa...@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-performance >
