dan goldsounds
Fri Aug 20 09:09:40 PDT 2004
Hi,

I'm a newbie to slony1 as well, but it seems to me that it's designed
more for a round-robin type clustering system than beowulf-type
clustering. That is, each system replicates the entire database on its
local storage rather than handling a small part of larger queries that
are spread over the whole cluster, and all the hosts are read-only.

The tablespaces functionality in Postgresql 8 by Fujitsu may be a step
towards what you're looking for - it allows for different tables to
reside on separate file-systems or hosts and be transferred amongst
these different locations without interrupting service.

One thing I would suggest to get clustering-type effects is that you
have INSERTs/UPDATEs only go to the master host, but queries are
round-robined. Writes are generally much more rare than reads, so this
allows you to have the load-balancing of a cluster without the expense
of Oracle ;-)

Regards,
Dan

On Thu, 19 Aug 2004 11:23:02 -0400, Roberto Melo Cavalcante
<zerok at semad.am.gov.br> wrote:
> Hi everybody!
> 
> I'm a newbie on postgreSQL. I read the archive of this list and saw
> Slony does not make multi-master such as oracle does. I'd like to know
> if is it possible to install postgreSQL on computer cluster such as beowulf?
> My goal is to take advantage of processor power and RAM memory.
> 
> Thanks
> 
> Roberto M. Cavalcante
> Manaus Cityhall
> Amazon-Brazil
> _______________________________________________
> Slony1-general mailing list
> Slony1-general at gborg.postgresql.org
> http://gborg.postgresql.org/mailman/listinfo/slony1-general
> 


-- 
"Mono... d'oh!" - HJS


More information about the Slony1-general mailing list