Re: Bigtime scaling of Postgresql (cluster and stuff I suppose)

From: Bill Moran <wmoran(at)potentialtech(dot)com>
To: "chris smith" <dmagick(at)gmail(dot)com>
Cc: "Postgres General" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Bigtime scaling of Postgresql (cluster and stuff I suppose)
Date: 2007-09-01 13:29:35
Message-ID: 20070901092935.0ffb2850.wmoran@potentialtech.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"chris smith" <dmagick(at)gmail(dot)com> wrote:
>
> > Ever read anything on how myspace is laid out? The big ones need
> > replication to handle the traffic.
>
> Actually no.
>
> http://highscalability.com/livejournal-architecture
>
> "Using MySQL replication only takes you so far." (Yeh it's mysql but
> the point is valid regardless).
> "You can't keep adding read slaves and scale."
>
> A lot use sharding now to keep scaling (limiting to "X" users/accounts
> per database system and just keep adding more database servers for the
> next "X" accounts).

I got the impression that they hadn't moved _all_ of their DB needs to
sharding. Just the ones that exceeded the scalability of replication,
but they don't explicitly say, IIRC.

--
Bill Moran
http://www.potentialtech.com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2007-09-01 14:55:37 Re: Error Message: invalid command-line arguments for server process
Previous Message Bill Bartlett 2007-09-01 13:22:37 Re: Export data to MS Excel