Re: PostgreSQL clustering VS MySQL clustering

From: Hervé Piedvache <herve(at)elma(dot)fr>
To: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: PostgreSQL clustering VS MySQL clustering
Date: 2005-01-20 15:00:47
Message-ID: 200501201600.47583.herve@elma.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Joshua,

Le Jeudi 20 Janvier 2005 15:44, Joshua D. Drake a écrit :
> Hervé Piedvache wrote:
> >
> >My company, which I actually represent, is a fervent user of PostgreSQL.
> >We used to make all our applications using PostgreSQL for more than 5
> > years. We usually do classical client/server applications under Linux,
> > and Web interface (php, perl, C/C++). We used to manage also public web
> > services with 10/15 millions records and up to 8 millions pages view by
> > month.
>
> Depending on your needs either:
>
> Slony: www.slony.info
>
> or
>
> Replicator: www.commandprompt.com
>
> Will both do what you want. Replicator is easier to setup but
> Slony is free.

No ... as I have said ... how I'll manage a database getting a table of may be
250 000 000 records ? I'll need incredible servers ... to get quick access or
index reading ... no ?

So what we would like to get is a pool of small servers able to make one
virtual server ... for that is called a Cluster ... no ?

I know they are not using PostgreSQL ... but how a company like Google do to
get an incredible database in size and so quick access ?

regards,
--
Hervé Piedvache

Elma Ingénierie Informatique
6 rue du Faubourg Saint-Honoré
F-75008 - Paris - France
Pho. 33-144949901
Fax. 33-144949902

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Hervé Piedvache 2005-01-20 15:02:39 Re: PostgreSQL clustering VS MySQL clustering
Previous Message Christopher Kings-Lynne 2005-01-20 14:58:42 Re: PostgreSQL clustering VS MySQL clustering