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

giichi6 id:giichi6

mysqlã«é–¢ã™ã‚‹giichi6ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (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}}

download
DBeaver Community 24.2.4 Released on November 3rd 2024 (Milestones). It is free and open source (license). Also you can get it from the GitHub mirror. System requirements. DBeaver PRO 24.2 Released on September 9th, 2024 PRO version website: dbeaver.com Trial version is available. Windows Windows (installer) Windows (zip) Chocolatey (choco install dbeaver) Install from Microsoft Store Mac OS X Mac
giichi6 2018/04/26
Mac

db

mysql
ãƒªãƒ³ã‚¯
FacebookãŒHBaseã‚’å¤§è¦æ¨¡ãƒªã‚¢ãƒ«ã‚¿ã‚¤ãƒ å‡¦ç†ã«åˆ©ç”¨ã—ã¦ã„ã‚‹ç†ç”±ï¼ˆå‰ç·¨ï¼‰
Facebookã¯å¤§è¦æ¨¡ãªãƒ‡ãƒ¼ã‚¿å‡¦ç†ã®åŸºç›¤ã¨ã—ã¦HBaseã‚’åˆ©ç”¨ã—ã¦ã„ã¾ã™ã€‚ãªãœFacebookã¯HBaseã‚’ç”¨ã„ã¦ã„ã‚‹ã®ã‹ã€ã©ã®ã‚ˆã†ã«åˆ©ç”¨ã—ã¦ã„ã‚‹ã®ã§ã—ã‚‡ã†ã‹ï¼Ÿ 7æœˆ1æ—¥ã«éƒ½å†…ã§è¡Œã‚ã‚ŒãŸå‹‰å¼·ä¼šã§ã€Facebookã®ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã§ã‚ã‚‹ã‚¸ãƒ§ãƒŠã‚µãƒ³ãƒ»ã‚°ãƒ¬ã‚¤ï¼ˆJonathan Grayï¼‰æ°ã«ã‚ˆã‚‹è§£èª¬ãŒè¡Œã‚ã‚Œã¾ã—ãŸã€‚ è§£èª¬ã¯ã»ã¼ã‚¹ãƒ©ã‚¤ãƒ‰ã®å†…å®¹ãã®ã¾ã¾ã§ã—ãŸã€‚å½“æ—¥ä½¿ã‚ã‚ŒãŸæ—¥æœ¬èªžè¨³ã•ã‚ŒãŸã‚¹ãƒ©ã‚¤ãƒ‰ãŒå…¬é–‹ã•ã‚Œã¦ã„ã‚‹ã®ã§ã€ãƒã‚¤ãƒ³ãƒˆã¨ãªã‚‹ãƒšãƒ¼ã‚¸ã‚’ç´¹ä»‹ã—ã¾ã—ã‚‡ã†ã€‚ Realtime Apache Hadoop at Facebook ãªãœãƒªã‚¢ãƒ«ã‚¿ã‚¤ãƒ ãƒ‡ãƒ¼ã‚¿ã®åˆ†æžã«ã€Hadoop/HBaseã‚’ä½¿ã†ã®ã‹ï¼Ÿ MySQLã¯å®‰å®šã—ã¦ã„ã‚‹ãŒã€åˆ†æ•£ã‚·ã‚¹ãƒ†ãƒ ã¨ã—ã¦è¨è¨ˆã•ã‚Œã¦ãŠã‚‰ãšã€ã‚µã‚¤ã‚ºã«ã‚‚ä¸Šé™ãŒã‚ã‚‹ã€‚ä¸€æ–¹ã€Hadoopã¯ã‚¹ã‚±ãƒ¼ãƒ©ãƒ–ãƒ«ã ãŒãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°ãŒé›£ã—ãã€ãƒ©ãƒ³ãƒ€ãƒ ãªæ›¸ãè¾¼ã¿ã‚„èªã¿è¾¼ã¿ã«å‘ã„ã¦ã„ãªã„ã€‚ Faceb
giichi6 2013/05/14
mysql

hbase

Hadoop

facebook

nosql

db
ãƒªãƒ³ã‚¯
Pinterestã¯ã„ã‹ã«ã‚¹ã‚±ãƒ¼ãƒ©ãƒ“ãƒªãƒ†ã‚£ã¨æ ¼é—˜ã—ã¦ããŸã®ã‹ï¼ˆå‰ç·¨ï¼‰ã€‚QCon Tokyo 2013
4æœˆ23æ—¥ã«éƒ½å†…ã§é–‹å‚¬ã•ã‚ŒãŸã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢å‘ã‘ã®ã‚¤ãƒ™ãƒ³ãƒˆã€ŒQCon Tokyo 2013ã€ã€‚æ€¥é€Ÿã«äººæ°—ã‚µã‚¤ãƒˆã¸ã¨æˆé•·ã—ãŸPinterestãŒã€ãã®è£ã§ã„ã‹ã«ã‚¹ã‚±ãƒ¼ãƒ©ãƒ“ãƒªãƒ†ã‚£ã¨æ ¼é—˜ã—ã¦ããŸã®ã‹ã‚’Pinterestã®ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢è‡ªèº«ãŒç´¹ä»‹ã™ã‚‹ã‚»ãƒƒã‚·ãƒ§ãƒ³ã€ŒScaling Pinterestã€ãŒè¡Œã‚ã‚Œã¾ã—ãŸã€‚ ã“ã®è¨˜äº‹ã§ã¯ã€ãã®å†…å®¹ã‚’ãƒ€ã‚¤ã‚¸ã‚§ã‚¹ãƒˆã§ç´¹ä»‹ã—ã¾ã—ã‚‡ã†ã€‚ ã¤ãã«ã‚·ã‚¹ãƒ†ãƒ ã®ã©ã“ã‹ãŒå£Šã‚Œã¦ã„ã‚‹ Pinterestã€Marty Weineræ°ã€‚ Pinterestã¯ã‚ªãƒ³ãƒ©ã‚¤ãƒ³ã®ãƒ”ãƒ³ãƒœãƒ¼ãƒ‰ã§ã€ãƒ¦ãƒ¼ã‚¶ãƒ¼ãŒã€Œãƒœãƒ¼ãƒ‰ã€ã‚’ä½œæˆã—ã¦ã€ãã“ã«ç”»åƒãªã©å¥½ããªã‚‚ã®ã‚’ã‚¢ãƒƒãƒ—ãƒãƒ¼ãƒ‰ã—ã¦ã‚·ã‚§ã‚¢ã§ãã‚‹ã¨ã„ã†ã‚‚ã®ã€‚ã€Œãƒ”ãƒ³ã€ã²ã¨ã¤ã²ã¨ã¤ãŒç”»åƒã‚„ãƒªãƒ³ã‚¯ã«ãªã£ã¦ã„ã‚‹ã€‚ ãƒ¦ãƒ¼ã‚¶ãƒ¼ã‚„ãƒœãƒ¼ãƒ‰ã‚’ãƒ•ã‚©ãƒãƒ¼ã™ã‚‹ã“ã¨ã‚‚ã§ãã‚‹ã—ã€å†ãƒ”ãƒ³ã—ãŸã‚Šã‚¤ã‚¤ãƒã—ãŸã‚Šã€ã‚³ãƒ¡ãƒ³ãƒˆã®å…¥åŠ›ã‚‚ã§ãã‚‹ã€‚
giichi6 2013/05/14
mysql

pinterest

scalability
ãƒªãƒ³ã‚¯
MySQL Spiderã‚¨ãƒ³ã‚¸ãƒ³ã‚’ä½¿ã£ã¦ã¿ãŸã€‚ã€œãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚·ãƒ£ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°(sharding)ã¨ã¯ã€œ - æ°—ã¾ã¾ã«æ›¸ã„ã¦ã¿ã¾ã—ãŸæ—¥è¨˜
ã‚‚ã—ã‹ã—ãŸã‚‰ä½¿ã†ã‹ã‚‚ã—ã‚Œãªã„ã®ã§èª¿ã¹ã¦ã¿ãŸã€‚ shard æ—¥æœ¬èªžã«è¨³ã™ã¨(ã‚¬ãƒ©ã‚¹ã‚„è²æ®»ã®) ã€Œç ´ç‰‡ã€ã¨ã„ã£ãŸã‚ˆã†ãªæ„å‘³ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’shardã«åˆ†è§£ã—ã¦è¤‡æ•°ã®ã‚µãƒ¼ãƒã«åˆ†æ•£ã—ã¦é‹ç”¨ã™ã‚‹ã®ãŒDB sharding ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ‹ãƒ³ã‚°ã¨ã‚‚è¨€ãˆã‚‹ã®ã‹ã—ã‚‰ï¼Ÿ å˜ä¸€ã®ã‚µãƒ¼ãƒã®DBãƒ†ãƒ¼ãƒ–ãƒ«ã‚’è¤‡æ•°ã®ãƒ•ã‚¡ã‚¤ãƒ«ã«åˆ†å‰²ã™ã‚‹ã®ã‚’ãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ‹ãƒ³ã‚°ã¨ã‚‚å‘¼ã¶ãŒã€ã€Œãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ‹ãƒ³ã‚°ã€ã¨ã„ã†è¨€è‘‰ã‚’ä½¿ã£ã¦DB shardingã®ã“ã¨ã‚’è¨€ã£ã¦ã„ã‚‹ãƒ–ãƒã‚°ç‰ã‚‚ã¡ã‚‰ã»ã‚‰è¦‹ã‹ã‘ã¾ã™ã€‚ ã‚ˆã‚Šçªã£è¾¼ã‚“ã§ã¿ãŸã„äººã¯ã€Œshared nothingã€ã§ããã£ã¦ãƒã€‚ ãªãœãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’åˆ†æ•£å‡¦ç†ã™ã‚‹ã®ã‹ æ¨ªè»¸ã«ã¯ã‚µãƒ¼ãƒ“ã‚¹é‹ç”¨é–‹å§‹ã‹ã‚‰ã®æ™‚é–“çµŒéŽã‚’è¨å®šã—ã€ç¸¦è»¸ã«ã¯ã€ŒDBã®å¿œç”æ™‚é–“ã€ã€ã€ŒDBã¸ã®å•ã„åˆã‚ã›æ•°ã€ã€ã€ŒDBã‚µã‚¤ã‚ºã€ã®å„æ•°é‡ã‚’ã¨ã‚Šã¾ã™ã€‚ã‚µãƒ¼ãƒ“ã‚¹ãŒé †èª¿ã«åˆ©ç”¨ã•ã‚Œã¦ã„ã£ã¦ã„ã‚‹ã‚‚ã®ã¨ã—ã€ã€ŒDBã‚µã‚¤ã‚ºã€ã‚„ã€ŒDBã¸ã®å•ã„åˆã‚ã›æ•°ã€ã¯æ™‚é–“çµŒ
giichi6 2013/04/17
mysql

spider

sharding
ãƒªãƒ³ã‚¯
1