Re: [PERFORM] Postgres Clustering

On Wednesday 27 May 2009 12:55:51 Eddy Ernesto Baños Fernández wrote:
> Try Cybercluster....
>
> -----Mensaje original-----
> De: pgsql-performance-owner(at)postgresql(dot)org
> [mailto:pgsql-performance-owner(at)postgresql(dot)org] En nombre de Alan McKay
> Enviado el: miércoles, 27 de mayo de 2009 13:57
> Para: pgsql-performance(at)postgresql(dot)org; pgsql-general(at)postgresql(dot)org
> Asunto: [PERFORM] Postgres Clustering
>
> 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?

Continuent works (AFAIK) like pgpool clustering, it sends the same statements
to both/all servers in the cluster but it has no insight to the servers beyond
this, so if via a direct connection server A becomes out of sync with server B
then continuent is oblivious.

Other tools to look at:
- EnterpriseDB's GridSQL
- SLONY
- Command Prompt's PG Replicator

>
> thanks,
> -Alan
>
> --
> “Mother Nature doesn’t do bailouts.”
> - Glenn Prickett
>
> --
> Sent via pgsql-performance mailing list (pgsql-performance(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-performance