Search Postgresql Archives

Re: anyone got any suggestions for clustering?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi,

On Tue, 2006-12-19 at 16:47 +1000, CARMODA wrote:
> I am currently investigating the preferred method of clustering a 
> postgresql database on Redhat?
<snip>
> we already have licences for Redhat Enterprise Linux ES v4, i was 
> wondering if Redhat's Cluster Manager is a candidate? 

Using RHEL + RHCS + GFS, you can setup an active/passive clustering. I
have presented this setup in PostgreSQL Summit:

http://www.gunduz.org/download.php?dlid=142

> or if either PGCluster or Slony1 have advantages or drawbacks etc.

Slony-I is also a good choice for replication. You can use pgpool as a
frontend to Slony-I, if you want. I don't think that pgCluster will act
well under high load (well, it is more than a "thought"...) So, I'd
ignore pgCluster for now and go on with Slony-I and/or RHCS.

Also you may want to take a look at this:

http://www.postgresql.org/docs/current/static/high-availability.html

Regards,
-- 
The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/




Attachment: signature.asc
Description: This is a digitally signed message part


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux