Fri Aug 20 09:09:40 PDT 2004
- Previous message: [Slony1-general] multi-master
- Next message: [Slony1-general] multi-master
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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
- Previous message: [Slony1-general] multi-master
- Next message: [Slony1-general] multi-master
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list