From: Hervé Piedvache <herve@elma.fr>
To: Jeff <threshar@torgo.978.org>
Cc: Christopher Kings-Lynne <chriskl@familyhealth.com.au>
Cc: pgsql-performance@postgresql.org
Subject: Re: PostgreSQL clustering VS MySQL clustering
Date: Thu, 20 Jan 2005 15:54:23 +0100
Message-ID: <200501201554.23462.herve@elma.fr> (raw)
In-Reply-To: <4C477AFA-6AF2-11D9-9D52-000D9366F0C4@torgo.978.org>
References: <200501201503.31241.herve@elma.fr>
<200501201536.08656.herve@elma.fr>
<4C477AFA-6AF2-11D9-9D52-000D9366F0C4@torgo.978.org>
Le Jeudi 20 Janvier 2005 15:48, Jeff a écrit :
> On Jan 20, 2005, at 9:36 AM, Hervé Piedvache wrote:
> > Sorry but I don't agree with this ... Slony is a replication solution
> > ... I
> > don't need replication ... what will I do when my database will grow
> > up to 50
> > Gb ... I'll need more than 50 Gb of RAM on each server ???
>
> Slony doesn't use much ram. The mysql clustering product, ndb I believe
> it is called, requires all data fit in RAM. (At least, it used to).
> What you'll need is disk space.
Slony do not use RAM ... but PostgreSQL will need RAM for accessing a database
of 50 Gb ... so having two servers with the same configuration replicated by
slony do not slove the problem of the scalability of the database ...
> As for a cluster I think you are thinking of multi-master replication.
No I'm really thinking about a Cluster solution ... having several servers
making one big virtual server to have several processors, and many RAM in
many boxes ...
> You should look into what others have said about trying to partiition
> data among several boxes and then join the results together.
??? Who talk about this ?
> Or you could fork over hundreds of thousands of dollars for Oracle's
> RAC.
No please do not talk about this again ... I'm looking about a PostgreSQL
solution ... I know RAC ... and I'm not able to pay for a RAC certify
hardware configuration plus a RAC Licence.
Regards,
--
Hervé Piedvache
Elma Ingénierie Informatique
6 rue du Faubourg Saint-Honoré
F-75008 - Paris - France
Pho. 33-144949901
Fax. 33-144949902
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: herve@elma.fr, threshar@torgo.978.org, chriskl@familyhealth.com.au
Subject: Re: PostgreSQL clustering VS MySQL clustering
In-Reply-To: <200501201554.23462.herve@elma.fr>
* 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