Thursday, October 27, 2016

Scaling: How Facebook used MySQL to handle 800million to 1.2 billion users!

From a very old article still quite relevant:
Facebook’s "Domas Mituzas" shared some stats that illustrate the importance of its MySQL user database: MySQL handles pretty much every user interaction: likes, shares, status updates, alerts, requests, etc.

At 2010/11, Facebook had 800 million users; 500 million of them visit the site daily. 350 million mobile users are constantly pushing and pulling status updates. 7 million applications and web sites are integrated into the Facebook platform.

User data sets are made even larger by taking into account both scope and time And, as Mituzas pointed out, everything on Facebook is social, so every action has a ripple effect that spreads beyond that specific user. “It’s not just about me accessing some object,” he said. “It’s also about analyzing and ranking through that include all my friends’ activities.” The result (although Mituzas noted these numbers are somewhat outdated) is 60 million queries per second, and nearly 4 million row changes per second.

At Facebook they used MySQL to manage many petabytes of data, along with the InnoDB storage engine that serves social activities such as likes, comments, and shares. While InnoDB provided them great performance and reliability for a variety of workloads, it seemed to fail on space and write amplification when used with flash storage.

As a result they developed, fully opensource solution MyRocks: A RocksDB storage engine with MySQL, an embeddable, persistent key-value store. It's leveraging stability of MySQL and taking advantage of persistent Key-Value Store for Flash and RAM Storage(RocksDB).

12 comments:

  1. This blog is having the general information. Got a creative work and this is very different one.We have to develop our creativity mind.This blog helps for this. Thank you for this blog. This is very interesting and useful.
    android Training in Chennai

    ReplyDelete
  2. This blog is having the general information. Got a creative work and this is very different one.We have to develop our creativity mind.This blog helps for this. Thank you for this blog. This is very interesting and useful.

    Digital Marketing Company in India

    ReplyDelete
  3. This is an awesome post.Really very informative and creative contents. These concept is a good way to enhance the knowledge.I like it and help me to development very well.Thank you for this brief explanation and very nice information.Well, got a good knowledge.
    Flats Cleaning in Chennai

    ReplyDelete
  4. Thank you for this brief explanation and very nice information. Well, got a good knowledge. Sometimes you just have to yell at people and give them a good shake to get your point across.
    Interior Decorators in Chennai
    Home Interior Designers in Chennai
    Home Interiors in Chennai

    ReplyDelete
  5. Finding the time and actual effort to create a superb article like this is great thing. I’ll learn many new stuff right here! Good luck for the next post buddy..
    AWS Training in Chennai

    ReplyDelete

  6. Its a wonderful post and very helpful, thanks for all this information. You are including better information regarding this topic in an effective way.Thank you so much

    Personal Installment Loans
    Title Car loan
    Cash Advance Loan

    ReplyDelete
  7. this is nice post sql is huge platform in the database this is very interesting to learn.i also studied that database.thanks sharing this wonderful information to us.
    MSBI Training in Chennai

    ReplyDelete
  8. Someone essentially lend a hand to make severely posts I would state. That is the very first time I frequented your website page and thus far? I surprised with the analysis you made to create this particular submit incredible. Fantastic job!
    Industrial Architecture
    Warehouse Architect
    Civil Engineering Consultants
    Office Interiors in Chennai
    Rainwater Harvesting chennai

    ReplyDelete
  9. It’s the best time to make some plans for the future and it is time to be happy. I’ve read this post and if I could I want to suggest you few interesting things or suggestions.You can write next articles referring to this article. I desire to read even more things about it..
    Logistics Software
    Warehouse Management Software
    Logistics management software
    Human resources management software
    Fleet Management Software

    ReplyDelete
  10. The Mobile Accessories is a largest mobile retail Chain dealing in leading international and Indian Brands of mobile phones and accessories headquartered with using special offers and low cost of the latest branded mobile phones. This is amazing offers with some of days.

    Mobile Showrooms in OMR

    ReplyDelete
  11. I must thank you for the efforts you have put in penning this site. I am hoping to check out the same high-grade content by you later on as well. In truth, your creative writing abilities has inspired me to get my own, personal blog now..
    Software Testing Training in Chennai
    SEO Training in Chennai
    Informatica Training in Chennai
    Digital Marketing Training in Chennai

    ReplyDelete