Received: from maia.hub.org (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id A4EE66335DD for ; Wed, 14 Apr 2010 17:14:44 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 60982-06 for ; Wed, 14 Apr 2010 20:14:29 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-yx0-f177.google.com (mail-yx0-f177.google.com [209.85.210.177]) by mail.postgresql.org (Postfix) with ESMTP id E67CA632B11 for ; Wed, 14 Apr 2010 17:14:33 -0300 (ADT) Received: by yxe7 with SMTP id 7so146213yxe.19 for ; Wed, 14 Apr 2010 13:14:32 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:in-reply-to:references :date:received:message-id:subject:from:to:cc:content-type; bh=ks8u0IBJIDDsfijPkCFnU/R6TbFnf2Eqbv49ipJPgUI=; b=LA8X+c86SOcsDeHJWBkq3tctdo0DPs23G462InXzoqjUQAuduVE26Ukug2eRlDoi9c rHNeQTbgXmRVEE5sG0g3ObGVG2gBBzWmfjREJCjfx42+G8LffoGlGMkXg1zF+609Jevp Q9Uc1FcG1HHoBh2EjDUh2JjobTjQXc6BAo80w= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :cc:content-type; b=VWuVkoYLa6k/dSYDlcgyhn50ZAU8LjXQaSCwY9VTfZgGgxjxMJQrTiiRsPDfID3YZ1 NqWZZ8CO8dKHa7tg/zz/bpgIYqfOFmItnwJb0BCWrDjDbwZlKK7SvkpHMGAG8hc9fxxa BsYZWEEGmL+odZb4/RQQWO8TscCiEIivc8uUM= MIME-Version: 1.0 Received: by 10.151.10.4 with HTTP; Wed, 14 Apr 2010 13:14:31 -0700 (PDT) In-Reply-To: References: Date: Wed, 14 Apr 2010 14:14:31 -0600 Received: by 10.150.120.33 with SMTP id s33mr6947306ybc.50.1271276071815; Wed, 14 Apr 2010 13:14:31 -0700 (PDT) Message-ID: Subject: Re: autoscale cluster From: Scott Marlowe To: Jesus arteche Cc: pgsql-admin@postgresql.org Content-Type: text/plain; charset=ISO-8859-1 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-2.092 tagged_above=-10 required=5 tests=AWL=-0.192, BAYES_00=-1.9 X-Spam-Level: X-Archive-Number: 201004/176 X-Sequence-Number: 34270 On Wed, Apr 14, 2010 at 10:22 AM, Jesus arteche 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.