[B! é‹ç”¨] uokadaã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

uokada id:uokada

é‹ç”¨ã«é–¢ã™ã‚‹uokadaã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (6)

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

ï¼œãƒã‚§ãƒƒã‚¯è¡¨ï¼žWEBã‚µãƒ¼ãƒ“ã‚¹ã‚’ç«‹ã¡ä¸Šã’ã‚‹ã¾ã§ã«ã‚„ã‚‰ãªã‘ã‚Œã°ãªã‚‰ãªã„ã“ã¨ - ãƒ—ãƒã‚°ãƒ©ãƒžãƒ¼å¹¸ç¦è«–
WEBã‚µãƒ¼ãƒ“ã‚¹ã‚’ç«‹ã¡ä¸Šã’ã‚‹ã¾ã§ã«ã€ã‚„ã‚‰ãªã‘ã‚Œã°ãªã‚‰ãªã„ã“ã¨ã‚’è‡ªåˆ†ç”¨ã«ã¾ã¨ã‚ã¦ã¿ã¾ã—ãŸã€‚å°‘äººæ•°ã§ã‚„ã£ã¦ã„ã‚‹ã¨ã€ã„ã‚ã„ã‚ã‚„ã‚‰ãªã‘ã‚Œã°ãªã‚‰ãªã„ã“ã¨ãŒå¤šãã¦ã¤ã„å¿˜ã‚Œã¦ã—ã¾ã„ãŒã¡ã§ã™ã‚ˆãã€‚ 1) ã‚µãƒ¼ãƒ“ã‚¹åæ±ºå®š ã‚µãƒ¼ãƒ“ã‚¹åã¨ã‚ãƒ£ãƒãƒ•ãƒ¬ãƒ¼ã‚ºã ã‘ã¯ã€æœ€åˆã«æ±ºå®šã—ã¦ãŠã„ãŸæ–¹ãŒã„ã„ã§ã™ã€‚æ€ã„ã¤ã‹ãªã„å ´åˆã¯ã€TOPãƒšãƒ¼ã‚¸ã®ãƒ¯ã‚¤ãƒ¤ãƒ•ãƒ¬ãƒ¼ãƒ ã‚’æ›¸ããªãŒã‚‰è€ƒãˆãŸã‚Šã—ã¾ã™ã€‚ã¾ãŸã€ã‚µã‚¤ãƒˆåã‚’ Google ãªã©ã§æ¤œç´¢ã—ã¦ã¿ã¦ã€ãƒ¦ãƒ‹ãƒ¼ã‚¯ãªåå‰ã§ã‚ã‚‹ã‹ã‚’èª¿ã¹ã¦ãŠã‹ãªã„ã¨å¾Œã§å¾Œæ‚”ã—ãŸã‚Šã—ã¾ã™ã€‚ 2) ãƒ‰ãƒ¡ã‚¤ãƒ³å–å¾—ï¼DNSåæ˜ ã‚µãƒ¼ãƒ“ã‚¹åãŒæ±ºå®šã—ãŸã‚‰ã€ãƒ‰ãƒ¡ã‚¤ãƒ³ãŒåˆ©ç”¨å¯èƒ½ã‹èª¿ã¹ã¾ã™ã€‚ æœ€è¿‘ã§ã¯ã€.in ã‚„ .me ãªã©ã‚’ä½¿ã£ãŸé¢ç™½ã„ãƒ‰ãƒ¡ã‚¤ãƒ³åã‚‚ã‚ã‚Šã¾ã™ã‚ˆãã€‚ãªã‚‹ã¹ãçŸãã€è¦šãˆã‚„ã™ã„ãƒ‰ãƒ¡ã‚¤ãƒ³åã«ã—ã¾ã™ã€‚ 3) ã‚µãƒ¼ãƒãƒ¼ ã‚µãƒ¼ãƒ“ã‚¹ã‚’é…ç½®ã™ã‚‹ã€ã‚¯ãƒ©ã‚¦ãƒ‰ã‚„ãƒ¬ãƒ³ã‚¿ãƒ«ã‚µãƒ¼ãƒãƒ¼ãªã©ã‹ã‚‰ã‚µãƒ¼ãƒãƒ¼ã‚’é¸ã³ã¾ã™ã€‚ ç‰¹æ®Šãªãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ãªã©ãŒå¿…
uokada 2011/04/23
è¨å®š

ã¾ã¨ã‚

webåˆ¶ä½œ

development

é‹ç”¨
ãƒªãƒ³ã‚¯
ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã—ã¦ã‚‹MySQLã§ã€ãƒžã‚¹ã‚¿ã‚„ã‚¹ãƒ¬ãƒ¼ãƒ–ãŒéšœå®³åœæ¢ã—ãŸå ´åˆã®ãƒªã‚«ãƒãƒªãƒ—ãƒ©ãƒ³ - ï¼ˆã²ï¼‰ãƒ¡ãƒ¢
MySQLã§ã€ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ãƒ™ãƒ¼ã‚¹ã®HAãªæ§‹æˆã«ã¤ã„ã¦è€ƒãˆãŸãƒ¡ãƒ¢ã§ã™ã€‚ 3å°(ã¨ã„ã†ã‹2å°ï¼‹1å°)ãŒã„ã„ã‹ãªãã¨æ€ã£ã¦ã„ã¦ã€å‰åŠã¯ãã®ç†ç”±ã‚’ã€å¾ŒåŠã§ã¯{ãƒžã‚¹ã‚¿,ã‚¹ãƒ¬ãƒ¼ãƒ–}ãŒ{å†èµ·ä¸èƒ½ã«ãªã£ãŸ,ã¡ã‚‡ã£ã¨ãƒ€ã‚¦ãƒ³ã—ã¦ã™ãå¾©å¸°ã—ãŸ}å ´åˆã®ãƒªã‚«ãƒãƒªãƒ—ãƒ©ãƒ³ã«ã¤ã„ã¦æ›¸ãã¾ã™ã€‚ ä»Šã®ã¨ã“ã‚ã¯ã“ã‚ŒãŒãƒ™ã‚¹ãƒˆã‹ãªã¨æ€ã£ã¦ã„ã‚‹ã®ã§ã™ãŒã€ã€Œã“ã†ã—ãŸã»ã†ãŒã„ã„ã¨æ€ã†ï¼ã€ã€Œã“ã“ãŒãŠã‹ã—ã„ï¼ã€ãªã©ãªã©ã®ã”æ„è¦‹ã¯ã‚³ãƒ¡ãƒ³ãƒˆã€TBãªã©ã§ã„ãŸã ã‘ã‚‹ã¨ã†ã‚Œã—ã„ã§ã™ã€‚ ã‚´ãƒ¼ãƒ« ãƒžã‚¹ã‚¿ãŒè½ã¡ã¦ã‚‚ããƒ¼ã™ã‹å¯ã¦ã„ã‚‰ã‚Œã‚‹ã‚ˆã†ã«ã—ãŸã„ ãƒªã‚«ãƒãƒªã®ä½œæ¥ã¯ã§ãã‚‹ã ã‘å˜ç´”ã«ã€ã‹ã¤ã€çŸæ™‚é–“ã§å®Œäº†ã™ã‚‹ã‚ˆã†ã«ã—ãŸã„ ã‚ã‚“ã©ãã•ã„ã®ã¯ã„ã‚„ åŸºæœ¬æ§‹æˆã€æ–¹é‡ 2å°ï¼‹1å° ã‚µãƒ¼ãƒ“ã‚¹ã§ä½¿ã†ã®ã¯2å° (db1, db2) ã‚‚ã†1å°ã¯ç®¡ç†ç”¨ (db3) ã‚¹ãƒ¬ãƒ¼ãƒ–ã‚’å¤šæ•°ä¸¦ã¹ã‚‹æ§‹æˆã«ã¯ã—ãªã„ å°æ•°å¢—ãˆã‚‹ã¨ç®¡ç†ã‚³ã‚¹ãƒˆãŒä¸ŠãŒã‚‹ ãƒžã‚¹ã‚¿ãƒ€ã‚¦ãƒ³æ™‚ã®ãƒ•ã‚§ã‚¤ãƒ«ã‚ªãƒ¼ãƒã¨ãã®ãƒ•ã‚§ã‚¤ãƒ«ãƒ
uokada 2011/04/06
mysql

DB

ã‚µãƒ¼ãƒ

é‹ç”¨
ãƒªãƒ³ã‚¯
mixiã®ç”Ÿã¿ã®è¦ªâ€œãƒã‚¿ãƒ©æ°â€ãŒèªžã‚‹MySQLã®æ„å¤–ãªåˆ©ç”¨æ³• ï¼ TechTargetã‚¸ãƒ£ãƒ‘ãƒ³
æ—¥è¨˜ã ã‘ã§4å„„ä»¶ã®ãƒ‡ãƒ¼ã‚¿ ãƒŸã‚¯ã‚·ã‚£ãŒé‹å–¶ã™ã‚‹SNSã€Œmixiã€ã¯ã€2007å¹´7æœˆæœ«æ®µéšŽã§ãƒ¦ãƒ¼ã‚¶ãƒ¼æ•°ãŒ1110ä¸‡äººã€‚äººãŒ12äººé›†ã¾ã‚Œã°ã€1äººã¯mixiãƒ¦ãƒ¼ã‚¶ãƒ¼ã¨ã„ã†ã‚ã‘ã ã€‚ãƒ¦ãƒ¼ã‚¶ãƒ¼ã®ã‚¢ã‚¯ãƒ†ã‚£ãƒ–çŽ‡ï¼ˆãƒã‚°ã‚¤ãƒ³é–“éš”ãŒ3æ—¥ä»¥å†…ï¼‰ã¯ç´„62ï¼…ã¨é«˜ãã€2007å¹´4æœˆã‹ã‚‰6æœˆã®æœˆé–“å¹³å‡ãƒšãƒ¼ã‚¸ãƒ“ãƒ¥ãƒ¼ã¯117.5å„„ã«é”ã—ãŸã€‚æ—¥è¨˜ã ã‘ã§ã‚‚4å„„ä»¶ä»¥ä¸Šã«ä¸Šã‚‹ãªã©ã€è“„ç©ã™ã‚‹ãƒ‡ãƒ¼ã‚¿é‡ã‚‚èŽ«å¤§ã€‚2004å¹´3æœˆã®ã‚µãƒ¼ãƒ“ã‚¹é–‹å§‹ã‹ã‚‰ã€ã‚ãšã‹3å¹´åŠã§ç¾åœ¨ã®å·¨å¤§ã‚³ãƒŸãƒ¥ãƒ‹ãƒ†ã‚£ãƒ¼ã¸ã¨ç™ºå±•ã—ãŸã®ã ã€‚ ãƒŸã‚¯ã‚·ã‚£ã¯ã€ã€ŒLAMPï¼ˆOSã®Linuxã€Webã‚µãƒ¼ãƒã®Apacheã€DBMSã®MySQLã€é–‹ç™ºè¨€èªžã®Perlã€PHPã€Pythonï¼‰ã€ã¨å‘¼ã°ã‚Œã‚‹Webã‚·ã‚¹ãƒ†ãƒ å‘ã‘ã®æ¨™æº–çš„ãªã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ï¼ˆä»¥ä¸‹ã€OSSï¼‰ã§ã‚·ã‚¹ãƒ†ãƒ ã‚’è‡ªç¤¾é–‹ç™ºã—ã€å®‰ä¾¡ãªPCã‚µãƒ¼ãƒã‚’1000å°ä»¥ä¸Šé€£ãã‚‹è¶…åˆ†æ•£æ§‹æˆã§mixiã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’æ”¯ãˆã¦ã„ã‚‹ï¼ˆåºƒå‘Šé…ä¿¡ãªã©å‘¨è¾ºæ©Ÿèƒ½ã§ã¯
uokada 2011/03/11
mixi

MySQL

é‹ç”¨

ã‚ã¨ã§èªã‚€

è² è·åˆ†æ•£

scalability
ãƒªãƒ³ã‚¯
å¤§äººã®ãŸã‚ã®InnoDBãƒ†ãƒ¼ãƒ–ãƒ«ã¨ã®æ£ã—ã„ä»˜ãåˆã„æ–¹ã€‚
InnoDBé–¢é€£ã§ã‚ˆãã‚ã‚‹è³ªå•ã®ã²ã¨ã¤ã«ã€Œãƒ†ãƒ¼ãƒ–ãƒ«ã®ãƒ¡ãƒ³ãƒ†ãƒŠãƒ³ã‚¹ã¯ä½•ã‚’ã™ã‚Œã°ã„ã„ã‚“ã§ã™ã‹ï¼Ÿã€ã¨ã„ã†ã‚‚ã®ãŒã‚ã‚‹ã€‚InnoDBã¯MySQL 5.5ã§ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã¨ãªã‚‹ãŸã‚ã€InnoDBã®ãƒ†ãƒ¼ãƒ–ãƒ«ãƒ¡ãƒ³ãƒ†ãƒŠãƒ³ã‚¹è¨ˆç”»ã‚’ç«‹ã‚ˆã†ã¨æ€ã†æ©Ÿä¼šã‚‚å¢—ãˆã‚‹ã“ã¨ã ã‚ã†ã€‚ãã“ã§ã€ä»Šæ—¥ã¯InnoDBã®ãƒ†ãƒ¼ãƒ–ãƒ«ãƒ¡ãƒ³ãƒ†ãƒŠãƒ³ã‚¹ã®å„ç¨®æ–¹æ³•ã¨ãªãœãã†ã—ãªã‘ã‚Œã°ã„ã‘ãªã„ã‹ã¨ã„ã†ç†ç”±ã‚’è§£èª¬ã—ã‚ˆã†ã¨æ€ã†ã€‚ ANALYZE TABLEãƒ†ãƒ¼ãƒ–ãƒ«ãƒ¡ãƒ³ãƒ†ãƒŠãƒ³ã‚¹ã®ä»£åè©žã¨ã„ãˆã°ã€ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹çµ±è¨ˆæƒ…å ±ã®æ›´æ–°ã§ã¯ãªã‹ã‚ã†ã‹ã€‚é‹ç”¨ã‚’ç¶šã‘ã‚‹ã†ã¡ã«ã€çŸ¥ã‚‰ãšçŸ¥ã‚‰ãšã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹çµ±è¨ˆæƒ…å ±ãŒç‹‚ã£ã¦ã—ã¾ã„ã€æ€ã†ã‚ˆã†ãªæ€§èƒ½ãŒå‡ºãªã„ã€‚RDBMSã«ã¯ãã®ã‚ˆã†ãªå•é¡ŒãŒã¤ãã‚‚ã®ã§ã‚ã‚‹ãŒã€InnoDBã®å ´åˆã€ANALYZE TABLEã¯ä¸è¦ã§ã‚ã‚‹ã€‚ãªãœãªã‚‰ã€InnoDBãŒè‡ªç™ºçš„ã«çµ±è¨ˆæƒ…å ±ã‚’æ›´æ–°ã™ã‚‹ã‹ã‚‰ã ã€‚InnoDBã¯ä»¥ä¸‹ã®æ¡ä»¶ã«é©åˆã™ã‚‹ã¨ã€ANALYZE T
uokada 2010/12/16
MySQL

InnoDB

performance

é‹ç”¨

ã¾ã¨ã‚

Tips
ãƒªãƒ³ã‚¯
Scalable System Design Patterns
Looking back after 2.5 years since my previous post on scala ble system design techniques, I've observed an emergence of a set of commonly used design patterns. Here is my attempt to capture and share them. Load Balancer In this model, there is a dispatcher that determines which worker instance will handle the request based on different policies. The application should best be "stateless" so any wo
uokada 2010/12/06
é‹ç”¨

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

ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£

ãƒ‡ã‚¶ã‚¤ãƒ³ãƒ‘ã‚¿ãƒ¼ãƒ³
ãƒªãƒ³ã‚¯
ã‚µãƒ¼ãƒè² è·åˆ†æ•£æ¦‚è«– - KLablabWiki
ç‰¹é›†ã®ã¯ã˜ã‚ã« æœ¬ç‰¹é›†ã®ãƒ¡ã‚¤ãƒ³ãƒ†ãƒ¼ãƒžã¯ã€Žã‚µãƒ¼ãƒè² è·åˆ†æ•£ã€ã§ã™ã€‚ è² è·åˆ†æ•£ã¨ã„ã†ã¨ ã‚€ãšã‹ã—ãã† æ©Ÿå™¨ãŒé«˜ä¾¡ å¤§è¦æ¨¡å‘ã‘ ã¨ã„ã†ã‚¤ãƒ¡ãƒ¼ã‚¸ãŒå…ˆè¡Œã—ã¦ã€æ•¬é ã—ã¦ã„ã‚‹äººã¯å¤šã„ã®ã§ã¯ãªã„ã‹ã¨æ€ã„ã¾ã™ã€‚ å®Ÿã¯ã€ä»Šå›žã®ç‰¹é›†ã¯ãã‚“ãªã‚ãªãŸã®ãŸã‚ã«æ›¸ãã¾ã—ãŸã€‚ æœ¬ç‰¹é›†ã‚’èªã¿çµ‚ãˆãŸã‚ã¨ã€ãã£ã¨ãã®å°è±¡ã¯ ãŠã‚‚ã—ã‚ãã† å®‰ã„ æ‰‹è»½ã«ä½¿ãˆã‚‹ ã«å¤‰ã‚ã£ã¦ã„ã‚‹ã§ã—ã‚‡ã†ã€‚ ã§ã¯ã§ã¯ã•ã£ããæœ¬é¡Œã«å…¥ã‚Šã¾ã—ã‚‡ã†ã€‚ã¾ãšæœ¬ç« ã§ã¯ã€Œã‚µãƒ¼ãƒè² è·åˆ†æ•£ã€ä¸€èˆ¬ã«ã¤ã„ã¦ã–ã£ã¨èª¬æ˜Žã—ã€æ¬¡ç« ä»¥é™ã§ã‚ˆã‚Šå…·ä½“çš„ãªå®Ÿç¾æ–¹æ³•ã‚’è§£èª¬ã—ã¦ã„ããŸã„ã¨æ€ã„ã¾ã™ã€‚ ãªãœã‚µãƒ¼ãƒè² è·åˆ†æ•£ã‚’ã™ã‚‹ã®ã‹ï¼Ÿ ã€Žã‚µãƒ¼ãƒè² è·åˆ†æ•£ã€[1]ã‚’ã²ã¨ã“ã¨ã§ã„ã†ã¨ã€ã€Œ1ã¤ã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’è¤‡æ•°ã®ã‚µãƒ¼ãƒã§è¡Œã†ã“ã¨ã€ã§ã™ã€‚ã§ã¯ã€ã©ã†ã—ã¦è¤‡æ•°ã®ã‚µãƒ¼ãƒã§ã‚µãƒ¼ãƒ“ã‚¹ã—ãŸã„ã®ã§ã—ã‚‡ã†ã‹ï¼Ÿ ã©ã‚“ãªåˆ©ç‚¹ãŒã‚ã‚‹ã®ã§ã—ã‚‡ã†ã‹ï¼Ÿ å¤§åˆ¥ã™ã‚‹ã¨ãã‚Œã¯2ã¤ã‚ã‚Šã¾ã™ã€‚[2] æ€§èƒ½ ã¾ãš1ã¤ã‚ã®åˆ©ç‚¹ã¯æ€§èƒ½å‘ä¸Šã§ã™ã€‚ ä¾‹
uokada 2010/11/13
è² è·åˆ†æ•£

ã‚µãƒ¼ãƒãƒ¼

é‹ç”¨

network
ãƒªãƒ³ã‚¯
1