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

sotarok id:sotarok

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

GT Nitro: ã‚«ãƒ¼ãƒ¬ãƒ¼ã‚·ãƒ³ã‚°ãƒ»ãƒ‰ãƒ©ãƒƒã‚°ãƒ¬ãƒ¼ã‚·ãƒ³ã‚°ã‚²ãƒ¼ãƒ - Google Play ã®ã‚¢ãƒ—ãƒª
GT Nitro: Car Game Drag Raceã¯ã€å…¸åž‹çš„ãªã‚«ãƒ¼ã‚²ãƒ¼ãƒ ã§ã¯ã‚ã‚Šã¾ã›ã‚“ã€‚ã“ã‚Œã¯ã‚¹ãƒ”ãƒ¼ãƒ‰ã€ãƒ‘ãƒ¯ãƒ¼ã€ã‚¹ã‚ãƒ«å…¨é–‹ã®ã‚«ãƒ¼ãƒ¬ãƒ¼ã‚¹ã‚²ãƒ¼ãƒ ã§ã™ã€‚ãƒ–ãƒ¬ãƒ¼ã‚ã¯å¿˜ã‚Œã¦ã€ã“ã‚Œã¯ãƒ‰ãƒ©ãƒƒã‚°ãƒ¬ãƒ¼ã‚¹ã€ãƒ™ã‚¤ãƒ“ãƒ¼ï¼å¤å…¸çš„ãªã‚¯ãƒ©ã‚·ãƒƒã‚¯ã‹ã‚‰æœªæ¥çš„ãªãƒ“ãƒ¼ã‚¹ãƒˆã¾ã§ã€æœ€ã‚‚ã‚¯ãƒ¼ãƒ«ã§é€Ÿã„è»Šã¨ã‚«ãƒ¼ãƒ¬ãƒ¼ã‚¹ã§ãã¾ã™ã€‚ã‚¹ãƒ†ã‚£ãƒƒã‚¯ã‚·ãƒ•ãƒˆã‚’ãƒžã‚¹ã‚¿ãƒ¼ã—ã€ãƒ‹ãƒˆãƒã‚’è³¢ãä½¿ã£ã¦ç«¶äº‰ã‚’æ‰“ã¡ç ´ã‚‹å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚ã“ã®ã‚«ãƒ¼ãƒ¬ãƒ¼ã‚¹ã‚²ãƒ¼ãƒ ã¯ãã®ãƒªã‚¢ãƒ«ãªç‰©ç†å¦ã¨ç´ æ™´ã‚‰ã—ã„ã‚°ãƒ©ãƒ•ã‚£ãƒƒã‚¯ã‚¹ã§ã‚ãªãŸã®å¿ƒã‚’çˆ†ç™ºã•ã›ã¾ã™ã€‚ã“ã‚Œã¾ã§ãƒ—ãƒ¬ã‚¤ã—ãŸã“ã¨ã®ãªã„ã‚ˆã†ãªã‚‚ã®ã§ã™ã€‚ GT Nitroã¯ã€ãƒªãƒ•ãƒ¬ãƒƒã‚¯ã‚¹ã¨ã‚¿ã‚¤ãƒŸãƒ³ã‚°ã‚’è©¦ã™ã‚«ãƒ¼ãƒ¬ãƒ¼ã‚¹ã‚²ãƒ¼ãƒ ã§ã™ã€‚æ£ã—ã„çž¬é–“ã«ã‚®ã‚¢ã‚’ã‚·ãƒ•ãƒˆã—ã€ã‚¬ã‚¹ã‚’æ€ã„åˆ‡ã‚Šè¸ã‚€å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚ã¾ãŸã€å¤§ç‰©ãŸã¡ã¨ç«¶ã„ã¤ã¤ã€è»Šã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã¨ã‚¢ãƒƒãƒ—ã‚°ãƒ¬ãƒ¼ãƒ‰ã‚‚è¡Œã‚ãªã‘ã‚Œã°ãªã‚Šã¾ã›ã‚“ã€‚ä¸–ç•Œä¸ã§æœ€é«˜ã®ãƒ‰ãƒ©ã‚¤ãƒãƒ¼ã¨è»Šã¨ã‚«ãƒ¼ãƒ¬ãƒ¼ã‚¹ã«æŒ‘ã‚€ã“ã¨ã«ãªã‚Šã€ãƒ‰ãƒ©ãƒƒã‚°ãƒ¬ãƒ¼ã‚¹ã®çŽ‹å†
sotarok 2010/04/21
mysql

database

spider
ãƒªãƒ³ã‚¯
ã¾ã‚‹ã§é”æ³•ã®ã‚ˆã†ãªã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ï¼Ÿï¼ŸVP for MySQLã«ã‚ˆã‚‹é©šæ„•ã®ãƒ†ãƒ¼ãƒ–ãƒ«æ“ä½œãƒ†ã‚¯ãƒ‹ãƒƒã‚¯ã€‚
å…ˆæ—¥ã€SPIDERã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã«ã¤ã„ã¦2åº¦ã«æ¸¡ã‚Šæœ¬ãƒ–ãƒã‚°ã§ç´¹ä»‹ã—ãŸï¼ˆãã®ï¼‘ï¼šNot Only NoSQL!! é©šç•°çš„ãªã¾ã§ã«WRITEæ€§èƒ½ã‚’ã‚¹ã‚±ãƒ¼ãƒ«ã•ã›ã‚‹SPIDERã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã€ãã®ï¼’ï¼šå¿«é©ã‚¹ã‚±ãƒ¼ãƒ«ã‚¢ã‚¦ãƒˆç”Ÿæ´»ã¸ã®ç¬¬ä¸€æ©ã€‚SPIDERã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã‚’ä½¿ã£ã¦ã¿ã‚ˆã†ï¼ï¼‰ãŒã€SPIDERã®ä½œè€…ã§ã‚ã‚‹æ–¯æ³¢æ°ã¯ã€å®Ÿã¯ã‚‚ã†ä¸€ã¤é©šãã¹ãã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã‚’é–‹ç™ºã—ã¦ã„ã‚‹ã€‚ãã®åã‚‚ã€VPã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã ã€‚ã¡ã‚‡ã£ã¨åœ°å‘³ãªåå‰ã ãŒã€VPã¨ã¯ã€Vertical Partitioningï¼ˆåž‚ç›´ãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ‹ãƒ³ã‚°ï¼‰ã®ç•¥ã§ã€è¤‡æ•°ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã®ä¸Šã«VPã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã‚’è¢«ã›ã¦ã€åž‚ç›´ãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ‹ãƒ³ã‚°ï¼ˆã‚«ãƒ©ãƒ ã”ã¨ã«ãƒ‡ãƒ¼ã‚¿ã‚’æ ¼ç´ã™ã‚‹é ˜åŸŸã‚’åˆ†ã‘ã‚‹ï¼‰ã‚’å®Ÿç¾ã™ã‚‹ã¨ã„ã†ã‚‚ã®ã ã€‚ä»–ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã®ä¸Šã«è¢«ã›ã‚‹ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ã‚’ã¨ã£ã¦ã„ã‚‹ã¨ã„ã†ç‚¹ã§ã¯ã€VPã¨SPIDERã®ç™ºæƒ³ã¯åŒã˜ã§ã‚ã‚‹ã€‚ä»¥ä¸‹ã¯ã€VPã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã®å‹•ä½œ
sotarok 2010/04/21
mysql

database

vp
ãƒªãƒ³ã‚¯
Kazuho@Cybozu Labs: Pacific ã¨ã„ã†åå‰ã®åˆ†æ•£ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚’ä½œã‚Šå§‹ã‚ãŸä»¶
å¤§è¦æ¨¡ãªã‚¦ã‚§ãƒ–ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®ãƒœãƒˆãƒ«ãƒãƒƒã‚¯ãŒãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã§ã‚ã‚‹ã¨ã„ã†ç‚¹ã«ã¤ã„ã¦ã¯ã€å¤šãã®åŒæ„ãŒå¾—ã‚‰ã‚Œã‚‹ã¨ã“ã‚ã ã¨æ€ã„ã¾ã™ã€‚è§£æ±ºç–ã¨ã—ã¦ã¯ã€åŒã˜ç¨®é¡žã®ãƒ‡ãƒ¼ã‚¿ã‚’è¤‡æ•°ã® RDBMS ã«ä¿å˜ã™ã‚‹ã€Œshardingã€ (åˆ¥åï¼šã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ãƒ¬ãƒ™ãƒ«ãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ‹ãƒ³ã‚°ï¼ãƒ¬ãƒ™ãƒ«ï¼’åˆ†æ•£æ³¨1) ãŒä¸€èˆ¬çš„ã§ã™ãŒã€æœ€è¿‘ã§ã¯ã€åˆ†æ•£ã‚ãƒ¼ãƒãƒªãƒ¥ãƒ¼ã‚¹ãƒˆã‚¢ (åˆ†æ•£ KVS) ã‚’ä½¿ãŠã†ã¨ã™ã‚‹è©¦ã¿ã‚‚ã¿ã‚‰ã‚Œã‚‹ã‚ˆã†ã«ãªã£ã¦ãã¦ã„ã¾ã™ã€‚ åˆ†æ•£ KVS ãŒ RDBMS sharding ã«å¯¾ã—ã¦å„ªã‚Œã¦ã„ã‚‹è¦ç´ ã¨ã—ã¦ã¯ã€äº‹å‰ã®åˆ†å‰²è¨è¨ˆãŒä¸è¦ã§ã€å‹•çš„ãªãƒŽãƒ¼ãƒ‰è¿½åŠ ï¼ˆã¨ãã‚Œã«ã¨ã‚‚ãªã†è² è·ã®å†åˆ†æ•£ï¼‰ãŒå®¹æ˜“ã€ã¨ã„ã£ãŸç‚¹ãŒæŒ™ã’ã‚‰ã‚Œã‚‹ã¨æ€ã„ã¾ã™ã€‚ä¸€æ–¹ã§ã€Kai ã‚„ Kumofs ã®ã‚ˆã†ãªæœ€è¿‘ã®å®Ÿè£…ã§ã¯ eventually consistent ã§ã“ãç„¡ããªã£ã¦ãã¦ã„ã‚‹ã‚‚ã®ã®ã€ãƒãƒƒã‚·ãƒ¥ãƒ™ãƒ¼ã‚¹ã®åˆ†æ•£ KVS ã¯ã€ãƒ¬ãƒ³ã‚¸ã‚¯ã‚¨ãƒªãŒã§ããªã‹ã£ãŸã‚Š (ä¾‹:
sotarok 2009/06/22
mysql

database
ãƒªãƒ³ã‚¯
ãƒ•ãƒªãƒ¼ã§ä½¿ãˆã‚‹DBã®ãƒ¢ãƒ‡ãƒªãƒ³ã‚°ãƒ„ãƒ¼ãƒ«ã¾ã¨ã‚
æ£®å·ã§ã™ã€‚ å··ã§ã¯ã‚¨ã‚¤ãƒ—ãƒªãƒ«ãƒ•ãƒ¼ãƒ«ãƒã‚¿ãŒãŠã•ã‹ã‚“ã§ã™ãŒã€æ™®é€šã«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ãƒ¢ãƒ‡ãƒªãƒ³ã‚°ãƒ„ãƒ¼ãƒ«ã®ç´¹ä»‹ã§ã™ï¼ˆã‚¨ã‚¤ãƒ—ãƒªãƒ«ãƒ•ãƒ¼ãƒ«ãƒã‚¿ãŒæ€ã„ã¤ã‹ãªã„â€¦ï¼‰ã€‚ æ™®æ®µMySQLãªã‚‰DBDesigner4ã€PostgreSQLãªã‚‰Clayã‚’ä½¿ç”¨ã—ã¦ã„ã‚‹ã®ã§ã™ãŒã€ä»–ã«ä½•ã‹ã‚ˆã„ãƒ„ãƒ¼ãƒ«ã¯ãªã„ã‚‚ã®ã‹ã¨èª¿ã¹ã¦ã¿ã¾ã—ãŸã€‚ Clay è¨€ã‚ãšã¨çŸ¥ã‚ŒãŸï¼Ÿãƒ¢ãƒ‡ãƒªãƒ³ã‚°ãƒ„ãƒ¼ãƒ«ã§ã™ã€‚Eclipseã®ãƒ—ãƒ©ã‚°ã‚¤ãƒ³ã§ã€ç„¡å„Ÿã§ã‚‚ä½¿ç”¨å¯èƒ½ã§ã™ã€‚MySQLã€PostgreSQLã§ä½¿ç”¨å¯èƒ½ã§ã™ã€‚ ç„¡å„Ÿç‰ˆã§ã¯ER-å›³ã‚„ã€DBå®šç¾©æ›¸ã‚’å‡ºåŠ›ã§ãã¾ã›ã‚“ã€‚å¯¾å¿œã™ã‚‹DBãŒå°‘ãªã‹ã£ãŸã‚Šã‚‚ã—ã¾ã™ã€‚ å€‹äººçš„ã«ã¯ã€PostgreSQLã‚’ä½¿ç”¨ã™ã‚‹å ´åˆã«ã‚ˆãä½¿ã„ã¾ã™ã€‚å¤–éƒ¨ã‚ãƒ¼åˆ¶ç´„ãªã©ã«ã‚‚å¯¾å¿œã—ã¦ã„ã‚‹ã®ã§ãã‚Œã»ã©å›°ã‚Šã¾ã›ã‚“ã€‚ ãƒªãƒãƒ¼ã‚¹ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ãƒªãƒ³ã‚°ã«å¯¾å¿œã—ã¦ã„ã‚‹ã®ã‚‚æ°—ã«å…¥ã£ã¦ã„ã‚‹ç†ç”±ã®ä¸€ã¤ã§ã™ã€‚ ã¡ãªã¿ã«ã€ãƒªãƒãƒ¼ã‚¹ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ãƒªãƒ³ã‚°ã‚’ã™ã‚‹ã«ã‚ãŸã£ã¦PostgreSQLã®J
sotarok 2008/04/02
ã¾ã¨ã‚

mysql

database
ãƒªãƒ³ã‚¯
1