Re: PostgreSQL on a Cluster

From: cbbrowne(at)cbbrowne(dot)com
To: Devrim GUNDUZ <devrim(at)gunduz(dot)org>
Cc: pgsql-hackers(at)PostgreSQL(dot)org
Subject: Re: PostgreSQL on a Cluster
Date: 2003-04-14 01:37:56
Message-ID: 20030414013756.A73FA5A118@cbbrowne.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

> 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?

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...

The approach we take is that all of the transactional activity takes
place on the "master" system, that being any activity that either
performs updates, or which requires authoritative information.

Things that are more oriented towards "reporting" take place on the
duplicate server. Some observations about this:

-> It takes load off the main server;
-> Reports commonly don't have to be "up-to-the-instant accurate."

The question of where processing should take place may be assessed by
asking two questions:

-> Does the query update information? If so, it needs to hit the
master.

-> Does a query forcibly require the data to be _absolutely_ up to
date? If it's good enough to be "within the nearest five minutes,"
then it's acceptable to hit a secondary server, but if not, it
has to hit the master.

The vital point here is that it's a one-way data flow from the master to
slave servers. Data never flows in the other direction.
--
If this was helpful, <http://svcs.affero.net/rm.php?r=cbbrowne> rate me
http://cbbrowne.com/info/rdbms.html
"You think you know when you can learn, are more sure when you can
write, even more when you can teach, but certain when you can
program." -- Alan Perlis

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Chris Cox 2003-04-14 01:42:44 Index/Seq Scan Problem
Previous Message Andy Catcher 2003-04-13 20:47:19 none

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2003-04-14 03:10:33 Re: compile warnings in CVS HEAD
Previous Message Neil Conway 2003-04-14 00:26:39 compile warnings in CVS HEAD