pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Joshua D. Drake <jd@commandprompt.com>
To: Adile Abbadi <adile@minitdrugs.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Load Balancing/Multiple Postgres Machines
Date: Mon, 29 Nov 2004 11:30:16 -0800
Message-ID: <41AB78C8.2070605@commandprompt.com> (raw)
In-Reply-To: <NDEDLIMJNEEMMAFHLEEGAEBHCJAA.adile@minitdrugs.com>
References: <NDEDLIMJNEEMMAFHLEEGAEBHCJAA.adile@minitdrugs.com>

Adile Abbadi wrote:
> Hi all,
> 
> Not sure if this has been asked before - it probably has been - but I figure
> its probably just easier if I ask so my question is this:
> 
> How easy is it - or rather is it possible to create multiple instances of
> the same db on multiple machines?
> 
> We are currently running a very highly used postgres db (Ver 7.2) that eats
> up a lot of cpu time when its heavily used. We recently bought some very
> powerful equipment to accommodate this high use, (currently its on a single
> CPU, 1GB of Ram SCSI server - upgraded to a dual CPU, 4GB of ram SCSI
> server) but my fear is over time this issue is going to haunt me again and
> hardware can only be upgraded so much.

Well you have a very long way to go before you get to that "too much" stage.

Within your current platform it should be possible to upgrade to 8GB of 
ram and you can almost always add more hard drives.

> So is it possible to do some level of load balancing in postgres - I would
> love a situation where I could have multiple machines running multiple
> instances of the same db (that are all synced in real-time), where there is
> some smart level of load balancing happening.

You may want to look at pgpool, slony or Mammoth Replicator.


> 
> So if it is possible is there some instruction info out there to help me
> along my way. Any help or insight would be greatly appreciated.

Sincerely,

Joshua D. Drake




> 
> All the best
> 
> Adile
> 
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.801 / Virus Database: 544 - Release Date: 11/24/04
> 


-- 
Command Prompt, Inc., home of PostgreSQL Replication, and plPHP.
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - jd@commandprompt.com - http://www.commandprompt.com
Mammoth PostgreSQL Replicator. Integrated Replication for PostgreSQL

Attachments:

jd.vcf (text/x-vcard, 638B) download begin:vcard fn:Joshua D. Drake n:Drake;Joshua D. org:Command Prompt, Inc. adr:;;PO Box 215;Cascade Locks;Oregon;97014;USA email;internet:jd@commandprompt.com title:Consultant tel;work:503-667-4564 tel;fax:503-210-0334 note:Command Prompt, Inc. is the largest and oldest US based commercial PostgreSQL support provider. We provide the only commercially viable integrated PostgreSQL replication solution, but also custom programming, and support. We authored the book Practical PostgreSQL, the procedural language plPHP, and adding trigger capability to plPerl. x-mozilla-html:FALSE url:http://www.commandprompt.com/ version:2.1 end:vcard

view thread (11+ messages)  latest in thread

Message-ID: <41AB78C8.2070605@commandprompt.com>
Permalink:  ../41AB78C8.2070605@commandprompt.com/
Also on:    postgresql.org/message-id/41AB78C8.2070605@commandprompt.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: jd@commandprompt.com, adile@minitdrugs.com
  Subject: Re: Load Balancing/Multiple Postgres Machines
  In-Reply-To: <41AB78C8.2070605@commandprompt.com>
  References: <NDEDLIMJNEEMMAFHLEEGAEBHCJAA.adile@minitdrugs.com> <41AB78C8.2070605@commandprompt.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox