From: Jim C. Nasby <decibel@decibel.org>
To: Joshua D. Drake <jd@commandprompt.com>
Cc: Herv? Piedvache <herve@elma.fr>
Cc: Christopher Kings-Lynne <chriskl@familyhealth.com.au>
Cc: Jeff <threshar@torgo.978.org>
Cc: pgsql-performance@postgresql.org
Subject: Re: PostgreSQL clustering VS MySQL clustering
Date: Thu, 20 Jan 2005 19:39:22 -0600
Message-ID: <20050121013922.GM67721@decibel.org> (raw)
In-Reply-To: <41EFCA6A.1080802@commandprompt.com>
References: <200501201503.31241.herve@elma.fr>
<41EFC722.2050401@familyhealth.com.au>
<41EFC8B5.9040902@commandprompt.com>
<200501201607.51659.herve@elma.fr>
<41EFCA6A.1080802@commandprompt.com>
On Thu, Jan 20, 2005 at 07:12:42AM -0800, Joshua D. Drake wrote:
>
> >>then I was thinking. Couldn't he use
> >>multiple databases
> >>over multiple servers with dblink?
> >>
> >>It is not exactly how I would want to do it, but it would provide what
> >>he needs I think???
> >>
> >>
> >
> >Yes seems to be the only solution ... but I'm a little disapointed about
> >this ... could you explain me why there is not this kind of
> >functionnality ... it seems to be a real need for big applications no ?
> >
> >
> Because it is really, really hard to do correctly and hard
> equals expensive.
To expand on what Josh said, the expense in this case is development
resources. If you look on the developer site you'll see a huge TODO list
and a relatively small list of PostgreSQL developers. To develop a
cluster solution similar to RAC would probably take the efforts of the
entire development team for a year or more, during which time very
little else would be done.
I'm glad to see your persistance in wanting to use PostgreSQL, and there
might be some kind of limited clustering scheme that could be
implemented without a great amount of effort by the core developers. In
that case I think there's a good chance you could find people willing to
work on it.
--
Jim C. Nasby, Database Consultant decibel@decibel.org
Give your computer some brain candy! www.distributed.net Team #1828
Windows: "Where do you want to go today?"
Linux: "Where do you want to go tomorrow?"
FreeBSD: "Are you guys coming, or what?"
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: decibel@decibel.org, jd@commandprompt.com, herve@elma.fr, chriskl@familyhealth.com.au, threshar@torgo.978.org
Subject: Re: PostgreSQL clustering VS MySQL clustering
In-Reply-To: <20050121013922.GM67721@decibel.org>
* 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