Replication
От | Just E. Mail |
---|---|
Тема | Replication |
Дата | |
Msg-id | 4A00EBFC.3060702@imwell-usa.com обсуждение исходный текст |
Список | 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.
В списке pgsql-novice по дате отправления: