pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Scott Marlowe <scott.marlowe@gmail.com>
To: Jesus arteche <chechu.linux@gmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: autoscale cluster
Date: Wed, 14 Apr 2010 14:14:31 -0600
Message-ID: <g2ldcc563d11004141314r19d805a4o66e7ae89e7ef7371@mail.gmail.com> (raw)
In-Reply-To: <u2g6224d8071004140922s7b21039ds979e2339be3ad2d0@mail.gmail.com>
References: <u2g6224d8071004140922s7b21039ds979e2339be3ad2d0@mail.gmail.com>

On Wed, Apr 14, 2010 at 10:22 AM, Jesus arteche <chechu.linux@gmail.com> wrote:
> hi everyone,
>
> I'm looking for info about autoscale a cluster. I mean...with amazon you can
> generate automatically virtual machine as far as you need...if you configure
> that when the machine get 90% busy a new one will be created. The thing is
> that i'd like to do something like that for my database...whem my datbase
> get 90% busy...automatically another machine is created to share the charge.

Auto-creating a new app server is a whole different idea than
autogenerating another database server.

An app server is a relatively independent processing unit.  Requests
go in, get processed, and results are spit back out.  Each request is
independent of the other requests.

A database is a storage engine that ensures that each unit of
information put into it fits within all the proper constraints of all
the other data already in place, and that updates and changes happen
in whole or none at all.

How do you just "throw another db" at a problem?  You cluster it.
That's a complex problem to solve in comparison to app servers.

> I dont know if it is possible..can anyone give some piece of advice???

You can most certainly using clustering to increase db performance for
many work loads.  Whether a certain method works for you or not
depends on what you're doing.  Making it automagically create new
virtual cluster members sounds like a really cool feature that would
make you pull your hair out developing it.



view thread (2+ messages)

Message-ID: <g2ldcc563d11004141314r19d805a4o66e7ae89e7ef7371@mail.gmail.com>
Permalink:  ../g2ldcc563d11004141314r19d805a4o66e7ae89e7ef7371@mail.gmail.com/
Also on:    postgresql.org/message-id/g2ldcc563d11004141314r19d805a4o66e7ae89e7ef7371@mail.gmail.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: scott.marlowe@gmail.com, chechu.linux@gmail.com
  Subject: Re: autoscale cluster
  In-Reply-To: <g2ldcc563d11004141314r19d805a4o66e7ae89e7ef7371@mail.gmail.com>
  References: <u2g6224d8071004140922s7b21039ds979e2339be3ad2d0@mail.gmail.com> <g2ldcc563d11004141314r19d805a4o66e7ae89e7ef7371@mail.gmail.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