[B! Facebook][mysql] justoneplanetã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

justoneplanet id:justoneplanet

Facebookã¨mysqlã«é–¢ã™ã‚‹justoneplanetã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (4)

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

${{author_name}}$
{{author_name}}{{created}}
{{ #comment }}{{ comment }}{{ /comment }}
- {{ label }}

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

~mysqlatfacebook/mysqlatfacebook/tools : files for revision 20
justoneplanet 2013/01/18
MySQL

alter table

alter

facebook
ãƒªãƒ³ã‚¯
http://agilecatcloud.com/2012/02/08/facebook-timeline-%E3%81%AF%E3%80%81%E3%83%87%E3%83%BC%E3%82%BF%E3%81%AE%E9%9D%9E%E6%AD%A3%E8%A6%8F%E5%8C%96%E3%81%A8%E3%81%84%E3%81%86%E7%A0%B4%E5%A3%8A%E5%8A%9B%E3%81%A7%E8%AA%98%E3%81%86/
justoneplanet 2012/03/13
facebook

mysql

timeline
ãƒªãƒ³ã‚¯
FacebookãŒå¤§è¦æ¨¡ã‚¹ã‚±ãƒ¼ãƒ©ãƒ“ãƒªãƒ†ã‚£ã¸ã®æŒ‘æˆ¦ã§å¦ã‚“ã ã“ã¨ï¼ˆå¾Œç·¨ï¼‰ï½žã‚ãƒ£ãƒƒã‚·ãƒ¥ãŒæŠ±ãˆã‚‹ã‚¹ã‚±ãƒ¼ãƒ©ãƒ“ãƒªãƒ†ã‚£ã®å•é¡Œã¨ãƒ‡ãƒ¼ã‚¿ã‚»ãƒ³ã‚¿ãƒ¼ã«ã¾ãŸãŒã‚‹ä¸€è²«æ€§
FacebookãŒå¤§è¦æ¨¡ã‚¹ã‚±ãƒ¼ãƒ©ãƒ“ãƒªãƒ†ã‚£ã¸ã®æŒ‘æˆ¦ã§å¦ã‚“ã ã“ã¨ï¼ˆå¾Œç·¨ï¼‰ï½žã‚ãƒ£ãƒƒã‚·ãƒ¥ãŒæŠ±ãˆã‚‹ã‚¹ã‚±ãƒ¼ãƒ©ãƒ“ãƒªãƒ†ã‚£ã®å•é¡Œã¨ãƒ‡ãƒ¼ã‚¿ã‚»ãƒ³ã‚¿ãƒ¼ã«ã¾ãŸãŒã‚‹ä¸€è²«æ€§ å…¨ä¸–ç•Œã§3å„„äººã‚’è¶…ãˆã‚‹ä¼šå“¡ã‚’æŠ±ãˆã€ä¸–ç•Œæœ€å¤§ã®SNSã¨ãªã£ãŸFacebookã€‚åŒç¤¾ã®æŠ€è¡“æ‹…å½“ãƒã‚¤ã‚¹ãƒ—ãƒ¬ã‚¸ãƒ‡ãƒ³ãƒˆ Jeff Rothschildæ°ãŒã€10æœˆ8æ—¥ã«ç±³ã‚«ãƒªãƒ•ã‚©ãƒ«ãƒ‹ã‚¢å¤§å¦ã‚µãƒ³ãƒ‡ã‚£ã‚¨ã‚´æ ¡ã§è¡Œã£ãŸã‚»ãƒŸãƒŠãƒ¼ã€ŒHigh Performance at Massive Scale-Lessons learned at Facebookã€ã®å†…å®¹ã‚’å†æ§‹æˆã—ã¦ç´¹ä»‹ã—ã¾ã™ã€‚ ï¼ˆã“ã®è¨˜äº‹ã¯ã€ŒFacebookãŒå¤§è¦æ¨¡ãªã‚¹ã‚±ãƒ¼ãƒ©ãƒ“ãƒªãƒ†ã‚£ã¸ã®æŒ‘æˆ¦ã§å¦ã‚“ã ã“ã¨ï¼ˆå‰ç·¨ï¼‰ï½ž800å„„æžšã®å†™çœŸãƒ‡ãƒ¼ã‚¿ã¨PHPã®ã‚¹ã‚±ãƒ¼ãƒ©ãƒ“ãƒªãƒ†ã‚£å•é¡Œã€ã®ç¶šãã§ã™ï¼‰ ã‚ãƒ£ãƒƒã‚·ãƒ¥ãŒã‚¹ã‚±ãƒ¼ãƒ©ãƒ“ãƒªãƒ†ã‚£ã«å¤§ããªå½¹å‰²ã‚’æžœãŸã—ã¦ã„ã‚‹ Facebookã®ä¸»ãªå½¹å‰²ã¯ã€ãƒ¦ãƒ¼ã‚¶ãƒ¼ãŒç°¡å˜ã«ï¼ˆå‹äººãŸã¡ã®ï¼‰æƒ…å ±ã‚’é›†ã‚ã‚‹ã“ã¨ãŒã§
justoneplanet 2011/07/04
facebook

Facebook

memcache

MySQL

ã‚¹ã‚±ãƒ¼ãƒ©ãƒ“ãƒªãƒ†ã‚£

ã‚ãƒ£ãƒƒã‚·ãƒ¥
ãƒªãƒ³ã‚¯
FacebookãŒæ–°ã‚µãƒ¼ãƒ“ã‚¹ã®åŸºç›¤ã«ã—ãŸã®ã¯ã€MySQLã§ã‚‚Cassandraã§ã‚‚ãªãã€HBaseã ã£ãŸ
FacebookãŒ15æ—¥ã«ç™ºè¡¨ã—ãŸæ–°ã—ã„ã‚µãƒ¼ãƒ“ã‚¹ã€ŒFacebook Messagesã€ã¯ã€ãƒãƒ£ãƒƒãƒˆã‚„ã¤ã¶ã‚„ãã€ãã—ã¦é›»åãƒ¡ãƒ¼ãƒ«ãªã©ã€è‡ªåˆ†å®›ã®ãƒ†ã‚ã‚¹ãƒˆã‚„ãƒ¡ãƒƒã‚»ãƒ¼ã‚¸ã‚’ã™ã¹ã¦1ã¤ã®ã‚¤ãƒ³ãƒœãƒƒã‚¯ã‚¹ã§ç®¡ç†ã§ãã‚‹ã¨ç™ºè¡¨ã•ã‚Œã¾ã—ãŸã€‚ åŒç¤¾ãŒ15ã‚«æœˆã‹ã‘ã¦é–‹ç™ºã—ã¦ããŸã“ã®æ–°ã‚µãƒ¼ãƒ“ã‚¹ã®ãƒãƒƒã‚¯ã‚¨ãƒ³ãƒ‰ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯ã€ã“ã‚Œã¾ã§åŒç¤¾ãŒå¤§è¦æ¨¡é‹ç”¨ã—ã¦ããŸMySQLã§ã‚‚ã€åŒç¤¾ãŒé–‹ç™ºã—ãŸNoSQLãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®Cassandraã§ã‚‚ãªãã€ã‚°ãƒ¼ã‚°ãƒ«ã®BigTableã‚’ãƒ¢ãƒ‡ãƒ«ã¨ã—ã¦ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã§é–‹ç™ºã•ã‚ŒãŸåˆ†æ•£ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã€ŒHBaseã€ã§ã—ãŸã€‚ Facebookã®ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã€Kannan Muthukkaruppanæ°ãŒFacebookã«ãƒã‚¹ãƒˆã—ãŸè¨˜äº‹ã€ŒThe Underlying Techno logy of Messagesã€ã§ã€ãã®æŠ€è¡“çš„èƒŒæ™¯ãŒç´¹ä»‹ã•ã‚Œã¦ã„ã¾ã™ã€‚ MySQLã¨CassandraãŒè½é¸ã—ãŸç†ç”± H
justoneplanet 2010/11/18
Facebook

MySQL

Cassandra

HBase

hadoop

kvs

mysql

cassandra

hBase

facebook
ãƒªãƒ³ã‚¯
1

ãŠçŸ¥ã‚‰ã›

ã‚‚ã£ã¨èªã‚€

å…¬å¼Twitter

@hatebu
æœ€æ–°ã®äººæ°—ã‚¨ãƒ³ãƒˆãƒªãƒ¼ã®é…ä¿¡

ã‚ãƒ¼ãƒœãƒ¼ãƒ‰ã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆä¸€è¦§

jæ¬¡ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

kå‰ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

lã‚ã¨ã§èªã‚€

eã‚³ãƒ¡ãƒ³ãƒˆä¸€è¦§ã‚’é–‹ã

oãƒšãƒ¼ã‚¸ã‚’é–‹ã

è¨å®šã‚’å¤‰æ›´ã—ã¾ã—ãŸx

ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

ã‚¿ã‚°

é–¢é€£ã‚¿ã‚°ã§çµžã‚Šè¾¼ã‚€ (14)

Facebookã¨mysqlã«é–¢ã™ã‚‹justoneplanetã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (4)

ãŠçŸ¥ã‚‰ã›

ä»Šé€±ã®ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚ãƒ³ã‚°ï¼ˆ2024å¹´12æœˆç¬¬2é€±ï¼‰

ä»Šé€±ã®ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚ãƒ³ã‚°ï¼ˆ2024å¹´12æœˆç¬¬1é€±ï¼‰

æœˆé–“ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚ãƒ³ã‚°ï¼ˆ2024å¹´11æœˆï¼‰

å…¬å¼Twitter

ã‚ãƒ¼ãƒœãƒ¼ãƒ‰ã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆä¸€è¦§

ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

å…¬å¼Twitter

ã¯ã¦ãªã®ã‚µãƒ¼ãƒ“ã‚¹

ã‚¿ã‚°

é–¢é€£ã‚¿ã‚°ã§çµžã‚Šè¾¼ã‚€ (14)

Facebookã¨mysqlã«é–¢ã™ã‚‹justoneplanetã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (4)

~mysqlatfacebook/mysqlatfacebook/tools : files for revision 20

http://agilecatcloud.com/2012/02/08/facebook-timeline-%E3%81%AF%E3%80%81%E3%83%87%E3%83%BC%E3%82%BF%E3%81%AE%E9%9D%9E%E6%AD%A3%E8%A6%8F%E5%8C%96%E3%81%A8%E3%81%84%E3%81%86%E7%A0%B4%E5%A3%8A%E5%8A%9B%E3%81%A7%E8%AA%98%E3%81%86/

FacebookãŒæ–°ã‚µãƒ¼ãƒ“ã‚¹ã®åŸºç›¤ã«ã—ãŸã®ã¯ã€MySQLã§ã‚‚Cassandraã§ã‚‚ãªãã€HBaseã ã£ãŸ

ãŠçŸ¥ã‚‰ã›

ä»Šé€±ã®ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚­ãƒ³ã‚°ï¼ˆ2024å¹´12æœˆç¬¬2é€±ï¼‰

ä»Šé€±ã®ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚­ãƒ³ã‚°ï¼ˆ2024å¹´12æœˆç¬¬1é€±ï¼‰

æœˆé–“ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚­ãƒ³ã‚°ï¼ˆ2024å¹´11æœˆï¼‰

å…¬å¼Twitter

ã‚­ãƒ¼ãƒœãƒ¼ãƒ‰ã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆä¸€è¦§

ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

å…¬å¼Twitter

ã¯ã¦ãªã®ã‚µãƒ¼ãƒ“ã‚¹

é–¢é€£ã‚¿ã‚°ã§çµžã‚Šè¾¼ã‚€ (14)

Facebookã¨mysqlã«é–¢ã™ã‚‹justoneplanetã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (4)

FacebookãŒæ–°ã‚µãƒ¼ãƒ“ã‚¹ã®åŸºç›¤ã«ã—ãŸã®ã¯ã€MySQLã§ã‚‚Cassandraã§ã‚‚ãªãã€HBaseã ã£ãŸ

ãŠçŸ¥ã‚‰ã›

ä»Šé€±ã®ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚ãƒ³ã‚°ï¼ˆ2024å¹´12æœˆç¬¬2é€±ï¼‰

ä»Šé€±ã®ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚ãƒ³ã‚°ï¼ˆ2024å¹´12æœˆç¬¬1é€±ï¼‰

æœˆé–“ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚ãƒ³ã‚°ï¼ˆ2024å¹´11æœˆï¼‰

å…¬å¼Twitter

ã‚ãƒ¼ãƒœãƒ¼ãƒ‰ã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆä¸€è¦§

ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

å…¬å¼Twitter

ã¯ã¦ãªã®ã‚µãƒ¼ãƒ“ã‚¹