Re: Bigtime scaling of Postgresql (cluster and stuff I suppose) - Mailing list pgsql-general

From Bill Moran
Subject Re: Bigtime scaling of Postgresql (cluster and stuff I suppose)
Date
Msg-id 20070901092935.0ffb2850.wmoran@potentialtech.com
Whole thread Raw
In response to Re: Bigtime scaling of Postgresql (cluster and stuff I suppose)  ("chris smith" <dmagick@gmail.com>)
List pgsql-general
"chris smith" <dmagick@gmail.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

pgsql-general by date:

Previous
From: "Bill Bartlett"
Date:
Subject: Re: Export data to MS Excel
Next
From: Tom Lane
Date:
Subject: Re: Error Message: invalid command-line arguments for server process