PostgreSQL on a Cluster

From: Devrim GUNDUZ <devrim(at)gunduz(dot)org>
To: pgsql-general(at)PostgreSQL(dot)org
Cc: pgsql-hackers(at)PostgreSQL(dot)org
Subject: PostgreSQL on a Cluster
Date: 2003-04-13 20:31:03
Message-ID: Pine.LNX.4.44.0304132303320.23938-100000@emo.org.tr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers


Hi,

I am trying to integrate an Enterprise level application to PostgreSQL.
I need answers to some questions:

This is what we are planning:

+---------------+
+ Storage +
+ Area +
+ Network +
+---------------+
+
+
-----------------
| |
Master Server 2nd Master
with eRServer Server
for load balancing
with eRServer


PostgreSQL can run only one server, right?

The PostgreSQL servers use SAN for storing data.

So let's say we want to do some operation on the database, located at SAN.
When the 1st server wants to update a row, it will lock it. What happens
when the second server wants to access the same row? Does 1st server
"broadcast" that it has locked the row?

Or... does MVCC have something with this?

How do we balance the load? Does eRServer do it; or should we use another
thing?

Maybe I need some documentation about these...

Thanks for reply.

Regards,

--
Devrim GUNDUZ
devrim(at)gunduz(dot)org devrim(dot)gunduz(at)linux(dot)org(dot)tr
http://www.gunduz.org

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andy Catcher 2003-04-13 20:47:19 none
Previous Message Neil Burnett 2003-04-13 17:41:19 Re: newbie going round in circle

Browse pgsql-hackers by date

  From Date Subject
Next Message Neil Conway 2003-04-14 00:09:13 minor bug with latest flex
Previous Message Mike Mascari 2003-04-13 20:17:46 Re: Conformance of PostgreSQL to ANSI/ISO Standard