Re: How to run three PostgreSQL redunant
Hi Raúl,
Am 2005-11-14 19:57:27, schrieb Raúl Alexis Betancor Santana:
> For PostgreSQL with clustering support, you must either patch the 7.x version
> or upgrade to 8.x and the pgCluster patch, that will let you do multi-master
> replication between the servers.
I asume, the pgCluster patch is not in Debian. Can it properly
applied to the debianized version of 7.4 (Sarge) or 8.0 (Etch)?
> > And second, I need something, which can redirect Database Requests
> > to one of the two others if a server is overloaded.
>
> For that you need a pool-controller/loadbalancer with replication support or
> without replication and a backend pool of PostgreSQL servers with
> multi-master replication.
pool-controller? - any suggestions?
> I have more or least 10.000 users on a 4 machine email cluster, running
> GNU/Debian with qmail, courier-imap, dspam, squirrelmail and postgreSQL in
> multi-master mode as a backend to dspam, and all of them run with a 6Mbs + 4
> Mbs FR lines, more than 280.000 messages a day in average.
>
> But all of that depends on the apps you run on the servers.
Very the same as you, but additionaly Apache 1.3 and php5
> Best regards
Greetings
Michelle
--
Linux-User #280138 with the Linux Counter, http://counter.li.org/
Michelle Konzack Apt. 917 ICQ #328449886
50, rue de Soultz MSM LinuxMichi
0033/3/88452356 67100 Strasbourg/France IRC #Debian (irc.icq.com)
Reply to: