Re: [GENERAL] [PERFORM] Postgres Clustering

2009-07-07 Thread Tim Uckun
2009/5/28 Eddy Ernesto Baños Fernández eeba...@estudiantes.uci.cu: Try Cybercluster I looked into that. There is one piece of documentation that is less than ten pages long. There is no users group, no listserve, no community that I can discern. Do you have experience with it and if so

Re: [GENERAL] [PERFORM] Postgres Clustering

2009-05-27 Thread Scott Mead
On Wed, May 27, 2009 at 1: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

Re: [GENERAL] [PERFORM] Postgres Clustering

2009-05-27 Thread Daniel van Ham Colchete
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

Re: [GENERAL] [PERFORM] Postgres Clustering

2009-05-27 Thread Eddy Ernesto Baños Fernández
Try Cybercluster -Mensaje original- De: pgsql-performance-ow...@postgresql.org [mailto:pgsql-performance-ow...@postgresql.org] En nombre de Alan McKay Enviado el: miércoles, 27 de mayo de 2009 13:57 Para: pgsql-performa...@postgresql.org; pgsql-general@postgresql.org Asunto: [PERFORM]

Re: [GENERAL] [PERFORM] Postgres Clustering

2009-05-27 Thread Kevin Kempter
On Wednesday 27 May 2009 12:55:51 Eddy Ernesto Baños Fernández wrote: Try Cybercluster -Mensaje original- De: pgsql-performance-ow...@postgresql.org [mailto:pgsql-performance-ow...@postgresql.org] En nombre de Alan McKay Enviado el: miércoles, 27 de mayo de 2009 13:57 Para:

Re: [GENERAL] [PERFORM] Postgres Clustering

2009-05-27 Thread Alan McKay
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. So can the same be said for

Re: [GENERAL] [PERFORM] Postgres Clustering

2009-05-27 Thread Kevin Kempter
On Wednesday 27 May 2009 13:33:55 Alan McKay wrote: 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

Re: [GENERAL] [PERFORM] Postgres Clustering

2009-05-27 Thread Dimitri Fontaine
Hi, Le 27 mai 09 à 19:57, Alan McKay a écrit : 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

Re: [GENERAL] [PERFORM] Postgres Clustering

2009-05-27 Thread Alan McKay
Depending on your exact needs, which the terminology you're using only allow to guess about, you might enjoy this reading:  http://wiki.postgresql.org/wiki/Image:Moskva_DB_Tools.v3.pdf Thanks. To be honest I don't even know myself what my needs are yet. I've only been on the job here for a