From owner-freebsd-stable@FreeBSD.ORG Wed Apr 7 10:35:46 2010 Return-Path: Delivered-To: freebsd-stable@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id E3DAC106566B for ; Wed, 7 Apr 2010 10:35:46 +0000 (UTC) (envelope-from dalroi@solfertje.student.utwente.nl) Received: from solfertje.student.utwente.nl (solfertje.student.utwente.nl [130.89.167.40]) by mx1.freebsd.org (Postfix) with ESMTP id 960358FC29 for ; Wed, 7 Apr 2010 10:35:46 +0000 (UTC) Received: from localhost (localhost [127.0.0.1]) by solfertje.student.utwente.nl (Postfix) with SMTP id EAB59804D for ; Wed, 7 Apr 2010 12:35:44 +0200 (CEST) Received: from hollewijn.internal (hollewijn.internal [10.236.150.4]) by solfertje.student.utwente.nl (Postfix) with ESMTP id AE81A8049; Wed, 7 Apr 2010 12:35:36 +0200 (CEST) Mime-Version: 1.0 (Apple Message framework v1078) Content-Type: text/plain; charset=us-ascii From: Alban Hertroys In-Reply-To: <4BBC20BA.6090604@ish.com.au> Date: Wed, 7 Apr 2010 12:35:36 +0200 Content-Transfer-Encoding: 8bit Message-Id: <2009EC16-FAAA-4756-BD8E-5C2A4FCC7660@solfertje.student.utwente.nl> References: <1209800810.33861270466947931.JavaMail.root@dagobah.intersec.pl> <4BBA05A2.40706@intertainservices.com> <4BBA1823.1090305@gausus.net> <4BBA4334.1020506@interazioni.it> <4BBA4478.7030302@gausus.net> <20100405164306.hmy4n8pvs4goc8ks@www.goldsword.com> <4BBA51B9.6010803@gausus.net> <4BBC20BA.6090604@ish.com.au> To: Aristedes Maniatis X-Mailer: Apple Mail (2.1078) X-DSPAM-Result: Innocent X-DSPAM-Processed: Wed Apr 7 12:35:44 2010 X-DSPAM-Confidence: 1.0000 X-DSPAM-Probability: 0.0023 X-DSPAM-Signature: 74,4bbc600010411126416115 X-DSPAM-Factors: 27, References*gausus.net>+<4BBA4334.1020506, 0.40000, helpful, 0.40000, postgres, 0.40000, From*Alban, 0.40000, References*<20100405164306.hmy4n8pvs4goc8ks, 0.40000, anything+available, 0.40000, Mime-Version*Message, 0.40000, Date*Apr, 0.40000, don't+have, 0.40000, References*intertainservices.com>+<4BBA1823.1090305, 0.40000, we+get, 0.40000, Message-Id*BD8E, 0.40000, the+guys, 0.40000, trees, 0.40000, trees, 0.40000, yet+(IMO), 0.40000, you+poll, 0.40000, be+quite, 0.40000, from, 0.40000, Date*12, 0.40000, (see+http, 0.40000, cut, 0.40000, of, 0.40000, _Clustering, 0.40000, org/wiki/Replication, 0.40000, References*<4BBA4478.7030302, 0.40000, Received*ESMTP, 0.40000 Cc: freebsd-stable@freebsd.org, Maciej Jan Broniarz Subject: Re: fault tolerant web servers on freebsd X-BeenThere: freebsd-stable@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Production branch of FreeBSD source code List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 07 Apr 2010 10:35:47 -0000 On 7 Apr 2010, at 8:05, Aristedes Maniatis wrote: > Until we get to 'database' everything is HA and quite easy to build and manage. Having a clustered database solution is expensive and beyond most smallish budgets. mysql and postgresql don't have anything available that is quite ready yet (IMO), so you'll need to be talking to the bigger (expensive) players about their clustered offerings. There are quite a few replication projects for postgres, aren't you writing them off a bit too easily? I know that for example the guys from Skype wrote and maintain one of them, I imagine they'd be quite concerned about HA. And there are a number more (see: http://wiki.postgresql.org/wiki/Replication,_Clustering,_and_Connection_Pooling). I suggest that you poll their mailing list with your problem/requirements if you didn't already. They're usually rather helpful and will certainly confirm if there's no solution to your situation (yet). Alban Hertroys -- If you can't see the forest for the trees, cut the trees and you'll see there is no forest. !DSPAM:74,4bbc600010411126416115!