Thread: Scalability, Clustering

Scalability, Clustering

From
"Valter Mazzola"
Date:
I've searched Mosix, Dipc, Postgres mailing-lists and used google about the 
possibility to cluster ,load balance, Postgresql databases.

Mosix isn't good to clucter Postgresql because of shared memory.

Can be Dipc (http://wallybox.cei.net/dipc/) suitable for this task without 
changing postgres' sources (probably only cpu balancing, no data)?


If PostgreSQL Inc. will do a replication server, will be possible?

And Mariposa (http://mariposa.CS.Berkeley.EDU/download.html) ?

My question isn't an academic one, i (probably WE) really need this feature.

thank you in advance for you reply.

valter
_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

Share information about yourself, create your own public profile at 
http://profiles.msn.com.



Re: Scalability, Clustering

From
Tom Samplonius
Date:
On Sat, 9 Sep 2000, Valter Mazzola wrote:

> If PostgreSQL Inc. will do a replication server, will be possible?
> 
> And Mariposa (http://mariposa.CS.Berkeley.EDU/download.html) ?
> 
> My question isn't an academic one, i (probably WE) really need this feature.
> 
> thank you in advance for you reply.
 Depends on what kind of scalability you need.  Replication does not
usually equal scalability.
 I know that someone was working on a commercial extension to PostgreSQL
to add clustering based on a shared disk system.  Basically he was added a
raw storage manager to PostgreSQL plus a lock manager to co-oridinate
access to the shared disk.  That way the two nodes could co-ordinate
access to the shared disk.  This is very similar to Oracle Parallel
Server.
 Replication is a different beast.

Tom