Using postgresql in a HA/load balancing environment?

From: Rasmus Resen Amossen <rasmus(at)resen(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: Using postgresql in a HA/load balancing environment?
Date: 2006-03-21 13:48:09
Message-ID: dvp06i$1ap3$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Consider a service based on several terabytes of data, suffering from a
very high load. Can postgresql be used as database backend in a cluster
system in which both of the following is achieved?

a) Load balancing among a (large) number of cluster nodes
b) High availability (if any node in the cluster melts down,
another one takes over)

ClusterDB [1] is one solution, but it seems that both a) and b) is
achieved by simply multiplying the database installations and
distributing the load "cleverly" among these installations. This is
problematic for two reasons:

* Having N terabytes of data, and a need for 10 cluster nodes in order
to achieve a sufficient load balancing would require 10*N terabytes
of storage. This kind of waste of storage.

* All queries are isolated to a single node instead of beeing
parallelized into multiple nodes in order to gain performance.

Can postgresql be setup in a clustering environment with N "computing
nodes" using some sort of shared file system among them (such as lustre
[2]) and still achive HA and proper load balancing?

[1] http://pgcluster.projects.postgresql.org
[2] http://www.lustre.org

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2006-03-21 13:49:18 Re: [GENERAL] A real currency type
Previous Message William ZHANG 2006-03-21 13:16:03 Re: How I can get the real data type result instead of