Home > Software > Facebook scaling and replication with MySQL

Facebook scaling and replication with MySQL

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?

Categories: Software Tags: , , , ,
  1. eee
    February 18, 2010 at 6:21 pm

    I thought that facebook stored their data on large paper pads, and used highly intelligent youngsters to quickly jot down the information, then type it back into the system as needed.

    I guess not.

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: