Facebook scaling and replication with MySQL

January 21, 2008

I was wondering how Facebook handled the massive load they get each week. They receive on average 2 million new users each week – wow! Well with all the existing traffic and the new load just how do they cope?

There is a great blog post by Jason Sobel on the Facebook blog here. Some of the nifty tricks include:

  • Replicating the MySQL databases
  • Multiple data centres. One west coast and the other east cost.
  • Splitting traffic dependent on your location effectively load balancing
  • Caching data using memcached (developed for LiveJournal originally)

Those Facebook engineers are crafty. I remember hearing the guys at Friendster also did some similar things with MySQL. There is case study on the MySQL site.

Do you have any scaling advice when using PHP and MySQL?

Entry Filed under: Software. Tags: , , , , .

Leave a Comment

Required

Required, hidden

Some HTML allowed:
<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <pre> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Trackback this post  |  Subscribe to the comments via RSS Feed


Flickr Photos

Cape Town progress on soccer stadium

inRule Business Rules component circle

Bing in Google Analytics

Search Engine referals in Google Analytics

SAP Web Dispatcher terminating ssl connection

More Photos

del.icio.us

Recent Posts

Blogroll

The choice we all face

a