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.mckay@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-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance