"chris smith" <dmagick@xxxxxxxxx> 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 ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
