pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: m <postgres@markreid.org>
To: Adile Abbadi <adile@minitdrugs.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Load Balancing/Multiple Postgres Machines
Date: Tue, 30 Nov 2004 11:03:55 -0800
Message-ID: <41ACC41B.3050206@markreid.org> (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.
>  
> 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.
>  
> 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.
>  
> All the best
>  
> Adile
>  

Hello,

I read an interesting paper on this a while ago, you can find it here:
http://www.cnds.jhu.edu/pub/papers/cnds-2003-3.pdf

It's called "On the Performance of Consistent Wide-Area Database 
Replication", and presents an analysis of a Postgres-based replication 
system.

Unfortunately, the implementation wasn't made available, but the ideas 
may be worth investigating for someone with more free time than myself.

-Mark.



view thread (11+ messages)  latest in thread

Message-ID: <41ACC41B.3050206@markreid.org>
Permalink:  ../41ACC41B.3050206@markreid.org/
Also on:    postgresql.org/message-id/41ACC41B.3050206@markreid.org

 · 

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: postgres@markreid.org, adile@minitdrugs.com
  Subject: Re: Load Balancing/Multiple Postgres Machines
  In-Reply-To: <41ACC41B.3050206@markreid.org>
  References: <NDEDLIMJNEEMMAFHLEEGAEBHCJAA.adile@minitdrugs.com> <41ACC41B.3050206@markreid.org>

* 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