Re: Scaling

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: Scaling
Date: 2011-05-12 21:04:48
Message-ID: 4DCC4B70.9020803@commandprompt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On 04/24/2011 03:21 PM, David Hornsby wrote:
> My SMB database is currently running on a HP-UX box running in a master
> - slave slonyI cluster to create a hot spare database. Recently the
> server has be getting hammered and we are consistently hitting our max
> db connections. We have our web CMS and our web apps, our desktop client
> apps, and a couple application servers running off of this database
> server and it is crumbling under the stress. Currently we have been
> doing table partitioning and table archiving to trim the fat off of the
> indexing processes etc.
>
> My project at hand is to upgrade this configuration to a linux cluster
> of servers, 2 - 3. The ideal solution is to just do load balancing
> through DNS requests and have 2 servers in a multi master configuration.
> So far we have not had any hardware issues on our current set up ( knock
> on wood). So in doing this I am not immediately looking for a hot spare
> set up. But in the future am looking at setting up a VPN tunnel to an
> offsite server and sending WAL updates to that.

You are more likely to need one master, two hot standbys and push your
reads to the slaves.

JD
--
Command Prompt, Inc. - http://www.commandprompt.com/
PostgreSQL Support, Training, Professional Services and Development
The PostgreSQL Conference - http://www.postgresqlconference.org/
@cmdpromptinc - @postgresconf - 509-416-6579

In response to

  • Scaling at 2011-04-24 22:21:27 from David Hornsby

Browse pgsql-admin by date

  From Date Subject
Next Message Tim 2011-05-12 22:38:24 Re: Postgres Incremental Bakcup
Previous Message Neal Brown 2011-05-12 20:46:42 cacti graph templates for check_postgres --dbstats