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
copy link · copy postgr.es
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