From: | "Just E(dot) Mail" <justemail(at)imwell-usa(dot)com> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | Replication |
Date: | 2009-05-06 01:46:36 |
Message-ID: | 4A00EBFC.3060702@imwell-usa.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
I am setting up Linux Virtual Server (LVS). It is a three layer setup.
The first layer is two Virtual Servers, the second layer is 2+ Real
Servers (CentOS 5.3, Apache, freeRADIUS, mail server, etc.) and the
third layer is 3+ PostgreSQL data servers.
Originally, I started out with two PostgreSQL Data Servers (Master &
Slave). Then I realize that I have no failover capabilities. After
searching the internet, I came across two applications, "pgpool-II" &
"PGCluster" which may solve the Redundancy, Replication, Failover &
Parallel processing. Although it is too big of a system but it will be
fun to do it.
Please give me some guidance as to which of these two packages to use?
Keep in mind that I am not an expert but I try hard.
One thing I notice is that PGCluster has a single load balancing server
which manages the PostgreSQL servers. This is a single point pf failure
and that worries me.
From | Date | Subject | |
---|---|---|---|
Next Message | Lennin Caro | 2009-05-06 14:34:58 | Re: DATA TYPE CONVERTION |
Previous Message | Cliff Nieuwenhuis | 2009-05-05 00:40:58 | Re: hi |