Why does Facebook timeline use MySQL?

Why does Facebook timeline use MySQL?
First, please understand the fact that Facebook timeline is not well known to everyone: it uses the MySQL database, A database management system originally designed to manage a few machines used by a small number of applications. How can we achieve this compared to a social networking website with over 0.8 billion users?
A report from wired and Serkan paintino, which will take over Facebook's New York Engineering Institute, revealed that Facebook uses MySQL to help time series address memory, because time series work completely different from News subscription.
Because the timeline is more focused on organizing data than displaying updates in a timely manner, MySQL is suitable for processing such applications. Although data is stored in a place where it is not connected over the network, it is managed by MySQL rather than nosql or hadoop hbase (hadoophbase is part of the apachehadoop project, see http://developer.51cto.com/art/201006/203661.htm ).
Paintino told Wired: "Many people are surprised by the new feature of Facebook timeline. We also use MySQL. In fact, we use MySQL as a common data processing engine. And use it as a data storage engine. In fact, MySQL is very efficient .".
Although piantino uses it as an option, it sometimes exceeds some requirement. MySQL has become an ideal data storage solution for small systems since it was open-source, but Facebook is considered to be too dependent on MySQL for a social networking website (Facebook) created by Harvard students in their bedroom) this looks perfect.
However, MySQL is not suitable as a database platform for real-time information of large digital companies. In an article on the gigaom website, Derrick Harris listed a series of problems related to Facebook's dependency on MySQL. At the same time, the database authority Micheal stonebreaker on the gigaom website said this would make Facebook's fate worse than death.
Facebook has been committed to improving its MySQL usage. There are even pages dedicated to related issues, and they are very active, with more than 74000 participants.
What do you think of Facebook's use of MySQL, especially the timeline? This is a time bomb that will explode, or a reasonable use of existing technologies. Please leave a comment to let us know what you think.
 
Original article:
Why Facebook uses MySQL for timeline

A little-known fact about Facebook timeline: it relies on MySQL, A database-management system that was originally designed to be used in small-scale applications on just one or a few machines-a far cry from the 800 + million users of the world's largest social
Network. What gives?

In this report from wired, Serkan piantino, who will be in charge of Facebook's New York Engineering Office, reveals that Facebook turned to MySQL to help address the memory needs of timeline, since it works in a fundamentally different way from the news feed.

Since timeline is more concerned about organizing data neatly than shooting out updates in real time, MySQL is well suited for the app. although the data is aggregated in the same location as the data is kept (I. e. not over a network connection), that data
Is managed by MySQL, and not an alternative like nosql or hadoop hbase.

"A lot of people are surprised that for this shiny new thing for Facebook, we're using MySQL," piantino told Wired. "We treat [MySQL] as a generic engine for data manipulation. we use it as a storage engine. and it's really efficient."

Although piantino frames it as a choice, it coshould have been made out of necessity. facebook is thought to rely heavily on MySQL, Which is ideal for a small system since it's open source and free. perfect for an ambitious Harvard student starting a social network
In his dorm room.

However, MySQL isn' t something a massive digital company wocould pick as its go-to database platform. derrick Harris expertly lays out the larger issues of Facebook relying on MySQL in this article at gigaom, where database guru Micheal stonebreaker callit
A "fate worse than death ."

Facebook is constantly working on improving its MySQL implementation, however, and even has a page dedicated to the issue. It's quite active, and has over 74,000 members.

What do you think of Facebook's use of MySQL, and with timeline specifically? Is it a time bomb waiting to happen, or a savvy use of existing technology? Let us know in the comments.

The translation does not fully adopt literal translation. Due to the rush of time and the limited ability of myself, please note if there is an error.

For more technical articles, visit thinkblog.sinaapp.com.