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 0E7E88B9EA0 for ; Sun, 6 Feb 2005 16:43:13 +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 32571-01 for ; Sun, 6 Feb 2005 16:43:05 +0000 (GMT) Received: from smtp106.mail.sc5.yahoo.com (smtp106.mail.sc5.yahoo.com [66.163.169.226]) by svr1.postgresql.org (Postfix) with SMTP id 5F63A8B9E09 for ; Sun, 6 Feb 2005 16:43:04 +0000 (GMT) Received: from unknown (HELO jupiter.black-lion.info) (janwieck@68.80.245.191 with login) by smtp106.mail.sc5.yahoo.com with SMTP; 6 Feb 2005 16:43:02 -0000 Received: from [172.21.8.128] ([192.168.192.101]) (authenticated bits=0) by jupiter.black-lion.info (8.12.10/8.12.9) with ESMTP id j16GglL3022148; Sun, 6 Feb 2005 11:42:52 -0500 (EST) (envelope-from JanWieck@Yahoo.com) Message-ID: <42064901.7000702@Yahoo.com> Date: Sun, 06 Feb 2005 11:42:41 -0500 From: Jan Wieck User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.7.1) Gecko/20040707 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Jean-Max Reymond Cc: =?ISO-8859-1?Q?Herv=E9_Piedvache?= , pgsql-performance@postgresql.org Subject: Re: PostgreSQL clustering VS MySQL clustering References: <200501201503.31241.herve@elma.fr> <4b09a0c05012006236b40489d@mail.gmail.com> In-Reply-To: <4b09a0c05012006236b40489d@mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.321 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200502/90 X-Sequence-Number: 10419 On 1/20/2005 9:23 AM, Jean-Max Reymond wrote: > On Thu, 20 Jan 2005 15:03:31 +0100, Hervé Piedvache wrote: > >> We were at this moment thinking about a Cluster solution ... We saw on the >> 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, and >> 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... >> > > forget mysql cluster for now. Sorry for the late reply. I'd second that. I was just on the Solutions Linux in Paris and spoke with MySQL people. There were some questions I had around the new NDB cluster tables and I stopped by at their booth. My question if there are any plans to add foreign key support to NDB cluster tables got answered with "it will definitely be in the next version, which is the one containing NDB cluster, so yes, it will support foreign key from the start". Back home I found some more time to investigate and found this forum article http://lists.mysql.com/cluster/1442 posted by a MySQL AB senior software architect, where he says exactly the opposite. I don't know about your application, but trust me that maintaining proper referential integrity on the application level against a multimaster clustered database isn't that easy. So this is in fact a very important question. Jan -- #======================================================================# # It's easier to get forgiveness for being wrong than for being right. # # Let's break this rule - forgive me. # #================================================== JanWieck@Yahoo.com #