X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id C4B953A18CF for ; Thu, 20 Jan 2005 14:23:14 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 06147-06 for ; Thu, 20 Jan 2005 14:23:00 +0000 (GMT) Received: from rproxy.gmail.com (rproxy.gmail.com [64.233.170.203]) by svr1.postgresql.org (Postfix) with ESMTP id E029C3A4783 for ; Thu, 20 Jan 2005 14:23:02 +0000 (GMT) Received: by rproxy.gmail.com with SMTP id b11so15882rne for ; Thu, 20 Jan 2005 06:23:03 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:references; b=NmRteGupmrM2Y3JpMNIu/wK+IIYQdenDKihidho1P+joj/Cp7H6XHWZTW/0GanoHxAx1odL0TwP8VarZpm9EfYcSCVJ0tiWfmMRk/LCVeBLQBA9Ksd4NHAKeW2NEVBrfznl2EqNl/JnF3M+ZEDGX0ZcvGoTW3jH3TLAtYtK+NLI= Received: by 10.38.4.61 with SMTP id 61mr60323rnd; Thu, 20 Jan 2005 06:23:03 -0800 (PST) Received: by 10.38.149.21 with HTTP; Thu, 20 Jan 2005 06:23:03 -0800 (PST) Message-ID: <4b09a0c05012006236b40489d@mail.gmail.com> Date: Thu, 20 Jan 2005 15:23:03 +0100 From: Jean-Max Reymond Reply-To: Jean-Max Reymond To: =?ISO-8859-1?Q?Herv=E9_Piedvache?= Subject: Re: PostgreSQL clustering VS MySQL clustering Cc: pgsql-performance@postgresql.org In-Reply-To: <200501201503.31241.herve@elma.fr> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable References: <200501201503.31241.herve@elma.fr> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.024 tagged_above=0 required=5 tests=RCVD_BY_IP X-Spam-Level: X-Archive-Number: 200501/269 X-Sequence-Number: 9959 On Thu, 20 Jan 2005 15:03:31 +0100, Herv=E9 Piedvache wrote= : > We were at this moment thinking about a Cluster solution ... We saw on th= e > Internet many solution talking about Cluster solution using MySQL ... but > nothing about PostgreSQL ... the idea is to use several servers to make a > sort of big virtual server using the disk space of each server as one, an= d > having the ability to use the CPU and RAM of each servers in order to > maintain good service performance ...one can imagin it is like a GFS but > dedicated to postgreSQL... >=20 forget mysql cluster for now. We have a small database which size is 500 Mb. It is not possible to load these base in a computer with 2 Mb of RAM and loading the base in RAM is required. So, we shrink the database and it is ok with 350 Mb to fit in the 2 Gb RAM. First tests of performance on a basic request: 500x slower, yes 500x. This issue is reported to mysql team but no answer (and correction) Actually, the solution is running with a replication database: 1 node for write request and all the other nodes for read requests and the load balancer is made with round robin solution. --=20 Jean-Max Reymond CKR Solutions Nice France http://www.ckr-solutions.com