A little-known fact about
Facebook Timeline
: It relies onMySQL
, 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 toldWired
. “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 could 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 would 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 calls it 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.
分享到:
相关推荐
TimeMachine Timeline Generation for Knowledge-Base Entities
TimeLine TimeLine TimeLine TimeLine TimeLine TimeLine
我们从这个名称就能看出,它与Facebook的Timeline功能大概也脱不了干系。只是此处的Timeline可以包括进更多的信息,包括来自Twitter、YouTube、Flickr、Vimeo、Google Maps和SoundCloud等网站的内容。 开发者计划让...
Timeline-View ...For information : checkout Sample App Code in repository. Quick Setup 1. Include library Using Gradle dependencies { compile 'com.github.vipulasri:timelineview:1.0.5' } Us
unity TimeLine 入门教程 unity TimeLine 入门教程unity TimeLine 入门教程
微信小程序timeLine时间线代码片段示例
Jquery timeline 时间轴
TimeLineView Android Timeline View Library demonstrate the the power of ConstraintnLayout and RecyclerView. Showcase Quick Setup 1. Include library Using Gradle TimelineView is currently...
Laravel开发-timeline 此包用于时间线。
echarts3中如何使用timeline,官方的事例代码不是很容易看懂,所以写示例希望也能帮助你搞定timeline,原文地址 http://blog.csdn.net/kebi007/article/details/60882367
Android-Timeline-View Android timeline to display horizontal sliding cards in recycler view, group by Day, Month or Year. Demo Video Apps using the library: Gourmet (http://thegourmet.app) Play...
自己收集的timeline,需要的可以下载看看,不需要积分
TimeLine_writtenej2_C#_timeline_timelineeditc#_timelinec#_源码.zip
Project timeline1.xlsx
timeline control, from visjs, great for specific purposes
利用TimeLine和Cinemachine实现过场动画的效果
Echarts 代码 timeline 实例 Echarts 代码 timeline 实例
然后打开timeline软件打开,选择"timeline 3d"--注册,把邮箱和产生的code全都复制进去(code双击就复制了)如果出现“使用模式”就对了,如果不对的话会出现“pirated registration"之类的话。 然后再打开网络就没...
1.6MySQL时间线(Timeline)29 1.7MySQL的开发模式32 1.8总结33 第2章MySQL基准测试35 2.1为什么需要基准测试35 2.2基准测试的策略37 2.2.1测试何种指标38 2.3基准测试方法40 2.3.1设计和规划基准测试41 ...