pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Jan Wieck <JanWieck@Yahoo.com>
To: Jean-Max Reymond <jmreymond@gmail.com>
Cc: Hervé Piedvache <herve@elma.fr>
Cc: pgsql-performance@postgresql.org
Subject: Re: PostgreSQL clustering VS MySQL clustering
Date: Sun, 06 Feb 2005 11:42:41 -0500
Message-ID: <42064901.7000702@Yahoo.com> (raw)
In-Reply-To: <4b09a0c05012006236b40489d@mail.gmail.com>
References: <200501201503.31241.herve@elma.fr>
	<4b09a0c05012006236b40489d@mail.gmail.com>

On 1/20/2005 9:23 AM, Jean-Max Reymond wrote:

> On Thu, 20 Jan 2005 15:03:31 +0100, Hervé Piedvache <herve@elma.fr> 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 #



view thread (131+ messages)  latest in thread

Message-ID: <42064901.7000702@Yahoo.com>
Permalink:  ../42064901.7000702@Yahoo.com/
Also on:    postgresql.org/message-id/42064901.7000702@Yahoo.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 using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: JanWieck@Yahoo.com, jmreymond@gmail.com, herve@elma.fr
  Subject: Re: PostgreSQL clustering VS MySQL clustering
  In-Reply-To: <42064901.7000702@Yahoo.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