[B! NoSQL] umiyoshã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

umiyosh id:umiyosh

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

ã‚¿ã‚°ã®çµžã‚Šè¾¼ã¿ã‚’è§£é™¤

NoSQLã«é–¢ã™ã‚‹umiyoshã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (8)

${{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}}

Amebaã®MongoDBæ´»ç”¨äº‹ä¾‹
1. Amebaã®Mongo DB æ´»ç”¨äº‹ä¾‹ æ ªå¼ä¼šç¤¾ã‚µã‚¤ãƒãƒ¼ã‚¨ãƒ¼ã‚¸ã‚§ãƒ³ãƒˆ ã‚¢ãƒ¡ãƒ¼ãƒäº‹æ¥æœ¬éƒ¨ãƒ”ã‚°ãƒ‡ã‚£ãƒ´ã‚£ã‚¸ãƒ§ãƒ³ æ¡‘é‡Žâ€ƒç« å¼˜ 12å¹´8æœˆ24æ—¥é‡‘æ›œæ—¥ 2. ã‚¢ã‚¸ã‚§ãƒ³ãƒ€ nï® Amebaã®ã‚µãƒ¼ãƒ“ã‚¹ nï® ã‚µãƒ¼ãƒ“ã‚¹ç’°å¢ƒã®å¤‰é· nï® ã‚µãƒ¼ãƒ“ã‚¹ã‚’æ”¯ãˆã‚‹Mongo DB nï® å›°ã£ãŸã“ã¨ãªã© nï® é‹ç”¨ã«ã¤ã„ã¦ nï® ã¾ã¨ã‚ 12å¹´8æœˆ24æ—¥é‡‘æ›œæ—¥ 3. è‡ªå·±ç´¹ä»‹ nï® æ¡‘é‡Žç« å¼˜ lï¬ ã‚µã‚¤ãƒãƒ¼ã‚¨ãƒ¼ã‚¸ã‚§ãƒ³ãƒˆ lï¬ Ameba ã‚’é‹å–¶ã—ã¦ã„ã¾ã™ã€‚ lï¬ ãƒ”ã‚°ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ ã®é‹ç”¨ï¼æ§‹ç¯‰ã‚’æ‹…å½“ lï¬ Twitter lï¬ @kuwa_tw lï¬ Blog lï¬ http://d.hatena.ne.jp/akuwano/ 12å¹´8æœˆ24æ—¥é‡‘æ›œæ—¥
umiyosh 2014/01/12
mongodb

nosql
ãƒªãƒ³ã‚¯
MongoDB JP : main
Mongo DBã¯10genã«ã‚ˆã‚Šé–‹ç™º/ã‚µãƒãƒ¼ãƒˆã•ã‚Œã¦ã„ã‚‹C++ã§å®Ÿè£…ã•ã‚ŒãŸã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã§ã™ã€‚ ã„ã‚ã‚†ã‚‹NoSQLã«åˆ†é¡žã•ã‚Œã‚‹ã‚¿ã‚¤ãƒ—ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã§å¯¾éšœå®³æ€§ã¨ã‚¹ã‚±ãƒ¼ãƒ©ãƒ“ãƒªãƒ†ã‚£ã«å„ªã‚Œã€ã¾ãŸNoSQLã§ã¯çã—ãã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’ã‚µãƒãƒ¼ãƒˆã—ã¦ãŠã‚Šè¡¨çµåˆ(JOIN)ã¯å‡ºæ¥ãªã„ãªãŒã‚‰RDBMSã®æ§˜ãªä½¿ã„æ–¹ãŒå‡ºæ¥ã‚‹äº‹ã‚‚å¤§ããªç‰¹å¾´ã§ã™ã€‚ Mongo DBã¯ãƒ¬ãƒ—ãƒªã‚«ã‚»ãƒƒãƒˆã¨å‘¼ã°ã‚Œã‚‹å†—é•·æ§‹æˆï¼ˆã‚¯ãƒ©ã‚¹ã‚¿ï¼‰ã‚’çµ„ã‚€ã“ã¨ãŒã§ãã¾ã™ã€‚ ãƒ¬ãƒ—ãƒªã‚«ã‚»ãƒƒãƒˆã«ã¯å”¯ä¸€ã®ãƒ—ãƒ©ã‚¤ãƒžãƒªãƒŽãƒ¼ãƒ‰(PRIMARY)ã¨ã‚»ã‚«ãƒ³ãƒ€ãƒªãƒŽãƒ¼ãƒ‰(SECONDARY)è¤‡æ•°ã‚’å«ã‚ã‚‹äº‹ãŒã§ãã€ã‚¯ãƒ©ã‚¹ã‚¿ã«å¯¾ã™ã‚‹æ›¸ãè¾¼ã¿ã¯å…¨ã¦PRIMARYã«å¯¾ã—ã¦è¡Œã‚ã‚Œã¾ã™ã€‚ PRIMARYã«å¯¾ã™ã‚‹æ›´æ–°ã¯é€Ÿã‚„ã‹ã«å…¨ã¦ã®SECONDARYã«ã‚³ãƒ”ãƒ¼ã•ã‚Œå®‰å…¨ã«ä¿æŒã•ã‚Œã¾ã™ã€‚ ãƒ¬ãƒ—ãƒªã‚«ã‚»ãƒƒãƒˆã§ã¯ä¸‡ä¸€PRIMARYã‚’å–ªå¤±ã—ãŸå ´åˆã§ã‚‚è‡ªå‹•çš„ã«ãã‚Œã‚’æ¤œçŸ¥ã—ä»»æ„ã®SECONDARY
umiyosh 2014/01/09
mongodb

nosql
ãƒªãƒ³ã‚¯
ç¬¬6å›žã€€ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã¯ã©ã†ãªã®ï¼Ÿ | gihyo.jp
ã“ã®è¡¨ã§ã¯è¨€åŠã—ã¦ã„ã¾ã›ã‚“ãŒã€Consistent Hashingã‚„shardingã«ã‚ˆã£ã¦åˆ†æ•£ã•ã›ã‚„ã™ã„ã¨ã„ã†ã®ã¯ã™ã¹ã¦ã®NoSQLãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãŒå‚™ãˆã¦ã„ã‚‹ç‰¹å¾´ã§ã—ãŸãã€‚ æ¤œè¨¼ç”¨ã‚µãƒ¼ãƒã®æº–å‚™ ã§ã¯å®Ÿéš›ã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã‚’æ¯”è¼ƒã—ã¦ã¿ã¾ã—ã‚‡ã†ã€‚æ¯”è¼ƒã®ãŸã‚ã€10,000ä»¶ã®ãƒ‡ãƒ¼ã‚¿ã®æ›¸è¾¼ã¿/èªè¾¼ã¿ã‚’è¡Œã„ã¾ã™ã€‚å®Ÿè¡Œã«ã‚ãŸã‚Šå„ç¨®ã‚µãƒ¼ãƒã‚’èµ·å‹•ã—ã¾ã™ã€‚ ãƒªã‚¹ãƒˆ1ã€€æ¤œè¨¼ç”¨ã‚µãƒ¼ãƒã®èµ·å‹•ã‚³ãƒžãƒ³ãƒ‰ # memcached memcached -u nobody -d # TokyoTyrant sudo ttserver -pid /var/ttserver/pid -dmn /var/ttserver/bench.tch # Mongo DB mongod --dbpath ~/tmp/mongo db & # HBase sudo /etc/init.d/hadoop-0.20-namenode start su
umiyosh 2014/01/09
nosql
ãƒªãƒ³ã‚¯
CyberAgentã«ãŠã‘ã‚‹MongoDB
2. ã‚¢ã‚¸ã‚§ãƒ³ãƒ€ nï® Amebaã®ã‚µãƒ¼ãƒ“ã‚¹ nï® ã‚µãƒ¼ãƒ“ã‚¹ç’°å¢ƒã®å¤‰é· nï® ã‚µãƒ¼ãƒ“ã‚¹ã‚’æ”¯ãˆã‚‹Mongo DB nï® å›°ã£ãŸã“ã¨ãªã© nï® é‹ç”¨ã«ã¤ã„ã¦ nï® ã¾ã¨ã‚ 13å¹´12æœˆ12æ—¥æœ¨æ›œæ—¥ 3. è‡ªå·±ç´¹ä»‹ nï® æ¡‘é‡Žç« å¼˜ lï¬ ã‚µã‚¤ãƒãƒ¼ã‚¨ãƒ¼ã‚¸ã‚§ãƒ³ãƒˆ lï¬ Ameba ã‚’é‹å–¶ã—ã¦ã„ã¾ã™ã€‚ lï¬ ãƒ”ã‚°ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ ã®é‹ç”¨ï¼æ§‹ç¯‰ã‚’æ‹…å½“ lï¬ Twitter lï¬ @kuwa_tw lï¬ Blog lï¬ http://d.hatena.ne.jp/akuwano/ 13å¹´12æœˆ12æ—¥æœ¨æ›œæ—¥
umiyosh 2013/12/18
mongodb

nosql
ãƒªãƒ³ã‚¯
DB tech showcaseï¼š å™‚ã®MongoDBãã®ç”¨é€”ã¯ï¼Ÿ
19. Mongo DBã®Index å•†å“å ãƒœãƒ¼ãƒ«ãƒšãƒ³ ã‚¿ã‚° å€¤æ®µ æ—¥ç”¨å“, ç†è¨˜ç”¨å…· 198 åŒ…ä¸ æ—¥ç”¨å“, åˆƒç‰©, ã‚ãƒƒãƒãƒ³ 2980 ãƒãƒŠãƒŠ é£Ÿæ–™å“, æžœç‰© 348 ã»ã†ã‚Œã‚“è‰ é£Ÿæ–™å“, é‡Žèœ 98 ç‰›ä¹³ é£Ÿæ–™å“, 148 é£Ÿæ–™å“ã§200ä»¥ä¸‹ã®å•†å“ã‚’å–å¾— 20. Mongo DBã®Index å•†å“å ã‚¿ã‚° å€¤æ®µ ãƒœãƒ¼ãƒ«ãƒšãƒ³ æ—¥ç”¨å“, ç†è¨˜ç”¨å…· 198 åŒ…ä¸ æ—¥ç”¨å“, åˆƒç‰©, ã‚ãƒƒãƒãƒ³ 2980 ãƒãƒŠãƒŠ é£Ÿæ–™å“, æžœç‰© 348 ã»ã†ã‚Œã‚“è‰ é£Ÿæ–™å“, é‡Žèœ 98 ç‰›ä¹³ é£Ÿæ–™å“, 148 å•†å“ãƒ»ãƒ†ãƒ¼ãƒ–ãƒ« CREATE TABLE å•†å“ ( id INT PRIMARY, å•†å“å VARCHAR(100) ); ã‚¿ã‚°ãƒ»ãƒ†ãƒ¼ãƒ–ãƒ« CREATE TABLE ã‚¿ã‚° ( å•†å“id INT, ã‚¿ã‚°å VARCHAR(100), å€¤æ®µ INT, KEY(ã‚¿ã‚°å,å€¤æ®µ) ); é£Ÿæ–™å“ã§200ä»¥ä¸‹ã®å•†å“ å•†å“
umiyosh 2013/12/10
mongodb

NoSQL
ãƒªãƒ³ã‚¯
ã‚°ãƒ¼ã‚°ãƒ«ã€NoSQLè»½é‡ãƒ©ã‚¤ãƒ–ãƒ©ãƒªã€ŒLevelDBã€ã‚’å…¬é–‹ã€‚Chromeãƒ–ãƒ©ã‚¦ã‚¶ã®IndexedDBã¨ã—ã¦æŽ¡ç”¨
LevelDBã¯SQLã‚’ã‚µãƒãƒ¼ãƒˆã›ãšã€ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆï¼ã‚µãƒ¼ãƒåž‹ã§ã‚‚ãªãã€ã‚·ãƒ³ã‚°ãƒ«ãƒ—ãƒã‚»ã‚¹ã‹ã‚‰ã‚¢ã‚¯ã‚»ã‚¹ã•ã‚Œã‚‹ã“ã¨ã‚’æƒ³å®šã—ãŸã„ã‚ã‚†ã‚‹NoSQLã®é«˜é€Ÿãªã‚ãƒ¼ãƒãƒªãƒ¥ãƒ¼åž‹ãƒ‡ãƒ¼ã‚¿ã‚¹ãƒˆã‚¢ã‚’å®Ÿç¾ã™ã‚‹ãŸã‚ã®ãƒ©ã‚¤ãƒˆã‚¦ã‚§ã‚¤ãƒˆãªãƒ©ã‚¤ãƒ–ãƒ©ãƒªã ã¨èª¬æ˜Žã•ã‚Œã¦ã„ã¾ã™ã€‚ Chromeãƒ–ãƒ©ã‚¦ã‚¶ã§HTML5ã®ä»•æ§˜ã¨ã—ã¦ç–å®šä¸ã®IndexedDBã‚’å®Ÿè£…ã™ã‚‹ã‚‚ã®ã¨ã—ã¦é–‹ç™ºã•ã‚ŒãŸã‚ˆã†ã§ã™ï¼ˆãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã«æ˜Žè¨˜ã•ã‚Œã¦ã„ãªã„ã®ã§ã™ãŒï¼‰ã€‚ LevelDBã‚’é–‹ç™ºã—ãŸç†ç”± LevelDBã®Webã‚µã‚¤ãƒˆã«ã‚ˆã‚‹ã¨ã€LevelDBã¯ä»¥ä¸‹ã®ä¸»ãªæ©Ÿèƒ½ã‚’å‚™ãˆã¦ã„ã¾ã™ã€‚ åŸºæœ¬çš„ãªæ“ä½œã¯ã€Put(key,value), Get(key), Delete(key) 1ã¤ã®ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã¨ã—ã¦è¤‡æ•°ã®å¤‰æ›´æ“ä½œãŒå¯èƒ½ ãƒ‡ãƒ¼ã‚¿ã¯è‡ªå‹•çš„ã«åœ§ç¸®ã—ä¿å˜ã•ã‚Œã‚‹ Hacker Newsã®è¨˜äº‹ã«ã‚ˆã‚‹ã¨ã€å½“åˆã¯LevelDBã‚’é–‹ç™ºã™ã‚‹ä»£ã‚ã‚Šã«å¹³æž—å¹¹é›„æ°ãŒé–‹ç™ºã—ãŸTokyo Cabin
umiyosh 2011/05/17
NoSQL

google
ãƒªãƒ³ã‚¯
NoSQLç™»å ´ã®èƒŒæ™¯ã€CAPå®šç†ã€ãƒ‡ãƒ¼ã‚¿ãƒ¢ãƒ‡ãƒ«ã®åˆ†é¡ž
ãã®ä¾‹ã¨ã—ã¦Beckæ°è‡ªèº«ãŒéŽåŽ»ã«å–ã‚Šçµ„ã‚“ã§ããŸç”Ÿå‘½ä¿é™ºä¼šç¤¾ã®ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’ä¾‹ã«æŒ™ã’ã¾ã™ã€‚ãã®ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã§ã¯æ¯Žæ—¥ã®ã‚ˆã†ã«ã‚¹ã‚ãƒ¼ãƒžãŒå¤‰åŒ–ã™ã‚‹ãŸã‚ã€SQLã¨ORM(Object-Relational Mappingï¼‰ã§ã¯å¯¾å¿œã§ããšã€ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®Gemstoneã‚’åˆ©ç”¨ã™ã‚‹ã“ã¨ã§å¯¾å¿œã§ããŸã¨è¿°ã¹ã¦ã„ã¾ã™ã€‚ ã“ã†ã—ãŸSQLã ã‘ã§ã¯æº€ãŸã›ãªã„ã•ã¾ã–ã¾ãªè¦ä»¶ã€ä¸Šè¨˜ã®å›³ã«ã‚ã‚‹ã‚ˆã†ã«ã‚¹ã‚ãƒ¼ãƒžã®å¯å¡‘æ€§ã€ã‚¹ã‚±ãƒ¼ãƒ©ãƒ–ãƒ«ãªãƒ‡ãƒ¼ã‚¿èªã¿è¾¼ã¿ã€æ›¸ãè¾¼ã¿ã€å‡¦ç†ã®æŸ”è»Ÿæ€§ãªã©ã‚’æº€ãŸã™ãŸã‚ã«ã€ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ä»¥å¤–ã®NoSQLãªè£½å“ãŒé–‹ç™ºã•ã‚ŒãŸã€‚ã“ã‚ŒãŒNoSQLã®ç™»å ´ã®èƒŒæ™¯ã«ã‚ã‚‹ã¨Beckæ°ã¯è§£èª¬ã—ã¾ã™ã€‚ä¸€æ–¹ã§ã€ã“ã†ã—ãŸã•ã¾ã–ã¾ãªNoSQLã‚’ã€NoSQLã¨ã„ã†è¨€è‘‰ã§è¡¨ã™ã®ã¯é©å½“ã§ã¯ãªã„ã¨ã„ã†æ†‚æ…®ã‚‚ç¤ºã—ã¦ã„ã¾ã™ã€‚ Here is where the futility of defining NoSQ
umiyosh 2010/03/30
è¦‹ã¦ã‚‹:

DB

NoSQL

EV
ãƒªãƒ³ã‚¯
Twitterã¨DiggãŒNoSQLã®ã€ŒCassandraã€ã‚’é¸ã¶ç†ç”±
ã‚¹ã‚±ãƒ¼ãƒ©ãƒ–ãƒ«ãªãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’å®Ÿç¾ã™ã‚‹æ‰‹æ®µã¨ã—ã¦ã€ŒSharding MySQL plus memcachedã€ãŒã‚ˆãçŸ¥ã‚‰ã‚Œã‚‹æ–¹æ³•ã ã¨ã¯ã€1ã¤å‰ã®è¨˜äº‹ã€ŒMySQL+Memcachedã®æ™‚ä»£ã¯éŽãŽã€ã“ã‚Œã‹ã‚‰ã¯NoSQLãªã®ã‹ã€ã«ã¤ã„ã¦ã®è°è«–ã€ã§ç´¹ä»‹ã—ã¾ã—ãŸã€‚ ã¡ãªã¿ã«ã€ŒShardingã€ï¼ˆã‚·ãƒ£ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ï¼‰ã¨ã¯è¤‡æ•°ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ãƒ‡ãƒ¼ã‚¿ã‚’åˆ†æ•£ã—ã¦é‹ç”¨ã™ã‚‹ã“ã¨ã§ã€ã–ã£ãã‚Šã„ãˆã°Shared Nothingçš„ãªåˆ†æ•£ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹æ§‹æˆã®ã“ã¨ã§ã™ï¼ˆã“ã®è¨˜äº‹ã§ç´¹ä»‹ã™ã‚‹è‹±æ–‡ä¸ã«ã¯ã€ŒShared MySQLã€ï¼ˆå…±æœ‰MySQLï¼‰ã¨ã®è¨˜è¿°ãŒã‚ã‚Šã¾ã™ãŒã€ã“ã‚Œã¯æã‚‰ãã€ŒSharded MySQLã€ï¼ˆShardã•ã‚ŒãŸMySQLï¼‰ã®ãƒŸã‚¹ã‚¹ãƒšãƒ«ã§ã¯ãªã„ã¨æŽ¨æ¸¬ã—ã¾ã™ï¼‰ã€‚ æ—¥æœ¬ã§ï¼ˆãŸã¶ã‚“ï¼‰ã‚‚ã£ã¨ã‚‚MySQLã«ã¤ã„ã¦è©³ã—ãè§£èª¬ã—ã¦ã‚ã‚‹ãƒ–ãƒã‚°ã€Œæ¼¢(ã‚ªãƒˆã‚³)ã®ã‚³ãƒ³ãƒ”ãƒ¥ãƒ¼ã‚¿é“ã€ã®ã‚¨ãƒ³ãƒˆãƒªã€Œã•ã‚‰ã«MySQLã‚’é«˜é€ŸåŒ–ã™ã‚‹7ã¤ã®æ–¹æ³•ã€ã§ã¯ã€Sh
umiyosh 2010/03/10
nosql

cassandra
ãƒªãƒ³ã‚¯
1