Re: Scalability, Clustering

Lists: Postg토토 꽁 머니SQL
From: "Valter Mazzola" <txian(at)hotmail(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Scalability, Clustering
Date: 2000-09-09 15:34:52
Message-ID: F1740so7VQYAytB6VsE00006283@hotmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

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.


From: Tom Samplonius <tom(at)sdf(dot)com>
To: Valter Mazzola <txian(at)hotmail(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Scalability, Clustering
Date: 2000-09-09 20:25:22
Message-ID: Pine.BSF.4.05.10009091319340.9637-100000@misery.sdf.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: Postg토토 꽁 머니SQL


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