[B! replication] k_37toã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

k_37to id:k_37to

replicationã«é–¢ã™ã‚‹k_37toã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (12)

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

å®ŸéŒ²ã€ã»ã¼ç„¡åœæ¢ãªMySQLã®ãƒ•ã‚§ã‚¤ãƒ«ã‚ªãƒ¼ãƒ (å‹•ç”»ã‚‚ã‚ã‚‹ã‚ˆ) - ï¼ˆã²ï¼‰ãƒ¡ãƒ¢
ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã—ã¦ã‚‹MySQLã§ã€ãƒžã‚¹ã‚¿ã‚„ã‚¹ãƒ¬ãƒ¼ãƒ–ãŒéšœå®³åœæ¢ã—ãŸå ´åˆã®ãƒªã‚«ãƒãƒªãƒ—ãƒ©ãƒ³ ã§ã‚‚æŽ²ã’ãŸã‚´ãƒ¼ãƒ«ã§ã‚ã‚‹ã€ã€Œãƒžã‚¹ã‚¿ãŒè½ã¡ã¦ã‚‚ããƒ¼ã™ã‹å¯ã¦ã„ã‚‰ã‚Œã‚‹ã‚ˆã†ã«ã—ãŸã„ã€ãŒã»ã¼ã§ããŸã®ã§ã€ã»ã¨ã‚“ã©ã‚µãƒ¼ãƒ“ã‚¹ãŒåœæ¢ã™ã‚‹ã“ã¨ãªãã€ãƒ•ã‚§ã‚¤ãƒ«ã‚ªãƒ¼ãƒã™ã‚‹æ§˜ã‚’ã‚¹ã‚¯ãƒªãƒ¼ãƒ³ã‚ãƒ£ã‚¹ãƒˆã«åŽã‚ã¾ã—ãŸã€‚ åŸ‹ã‚è¾¼ã¿ãƒ—ãƒ¬ã‚¤ãƒ¤ãƒ¼ã ã¨ã€å°ã•ãã¦ã‚ã‹ã‚‰ãªã„ã¨æ€ã†ã®ã§ã€ãƒªãƒ³ã‚¯ç›´æŽ¥ã§ã¿ã¦ãã ã•ã„ã€‚ http://www.irori.org/pub/mysql-mm.mov ç™»å ´ã™ã‚‹ãƒ›ã‚¹ãƒˆ ç™»å ´ã™ã‚‹ãƒ›ã‚¹ãƒˆã¯2å°ã€db 901ã¨db902ã§ã™ã€‚ æœ€åˆã¯ã€db 901ãŒæ›´æ–°ç³»ã‚¯ã‚¨ãƒªã‚’å—ã‘ã‚‹ãƒ—ãƒ©ã‚¤ãƒžãƒªã§db900ã®æµ®å‹•IPã‚¢ãƒ‰ãƒ¬ã‚¹ã‚’æŒã£ã¦ã„ã¾ã™ã€‚ ç”»é¢åˆ†å‰² ç”»é¢ã¯5åˆ†å‰²ã—ã¦ã„ã¾ã™ã€‚ å·¦ä¸Š = ã€Œselect sysdate(),@@server_idã€ã‚’db900ã«å¯¾ã—ã¦(sleep 1ã—ãªãŒã‚‰)å»¶ã€…ã¨å®Ÿè¡Œã—ã¾ãã‚Šã‚“ã å³ä¸Š = ping -n
k_37to 2009/11/16
MySQL

replication

Tips
ãƒªãƒ³ã‚¯
MySQL ã‚¹ãƒ¬ãƒ¼ãƒ–ã‚’ä¾¿åˆ©ã«ä½œã‚‹ãŸã‚ã®ã‚¹ã‚¯ãƒªãƒ—ãƒˆ | Carpe Diem
MySQL ã‚¹ãƒ¬ãƒ¼ãƒ–ã‚’å¢—ã‚„ã™ã«ã¯ã€/var/lib/mysql ãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªã‚’ã‚³ãƒ”ãƒ¼ã™ã‚‹æ–¹æ³•ãŒä¸€èˆ¬çš„ã‹ã‚‚ã—ã‚Œãªã„ã‘ã‚Œã©ã€å€‹äººçš„ã«ã¯æ¯Žæ—¥ mysqldump ã—ã¦ã„ã‚‹ SQL ã‚’æµã—ãŸã„ã€‚ãã“ã§ã€æ¬¡ã®ã‚ˆã†ãªã‚¹ã‚¯ãƒªãƒ—ãƒˆã‚’ä½œã£ã¦ã¿ãŸã€‚ã“ã®ã‚¹ã‚¯ãƒªãƒ—ãƒˆã¯ã€ã€Œãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å_mysql-bin.ãƒã‚°ãƒ•ã‚¡ã‚¤ãƒ«å_ãƒã‚°ãƒã‚¸ã‚·ãƒ§ãƒ³.sqlã€ã¨ã„ã†åå‰ã® mysqldump ã—ãŸ SQL ãƒ•ã‚¡ã‚¤ãƒ«ã‚’æµã—ã¦ Slave ã‚’ä½œã‚‹ã ã‘ã®ç°¡å˜ãªã‚·ã‚§ãƒ«ã‚¹ã‚¯ãƒªãƒ—ãƒˆã€‚(puppet template ãªã®ã§ä¸€éƒ¨ãŠã‹ã—ã„ã§ã™ãŒã€æœ€åˆã®å¤‰æ•°å®šç¾©ã ã‘ã§ã™) #!/bin/sh DATABASE=<%= mysql_database_name %> MASTER_HOST=<%= mysql_master_host %> MASTER_USER=<%= mysql_repl_user %> MASTER_PASSWORD=<%=
k_37to 2009/04/29
MySQL

slave

replication
ãƒªãƒ³ã‚¯
MySQL Statement-based-replicationã§ã®å®‰å…¨ãªé–¢æ•° - ã¾ã„ãƒ»ã¯ã†ã™
k_37to 2009/04/29
MySQL

replication

function

Tips
ãƒªãƒ³ã‚¯
MySQLãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’å®‰å…¨ã«åˆ©ç”¨ã™ã‚‹ãŸã‚ã®10ã®ãƒ†ã‚¯ãƒ‹ãƒƒã‚¯
MySQLã®ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã¯éžå¸¸ã«ç°¡å˜ã«ä½¿ãˆã‚‹å‰²ã«ã¯å¿œç”¨ã®å¹…ãŒåºƒã„ã®ã§éžå¸¸ã«äººæ°—ã®ã‚ã‚‹æ©Ÿèƒ½ã®ä¸€ã¤ã§ã‚ã‚‹ã€‚ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®å¿œç”¨åˆ†é‡Žã¯ä¾‹ãˆã°ã€ ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ— å‚ç…§ç³»ã®è² è·åˆ†æ•£ HAï¼ˆé«˜å¯ç”¨æ€§ï¼‰ ãƒ‡ã‚£ã‚¶ã‚¹ã‚¿ãƒªã‚«ãƒãƒªï¼ˆã‚µã‚¤ãƒˆé–“ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ï¼‰ BIï¼ˆãƒ¬ãƒãƒ¼ãƒ†ã‚£ãƒ³ã‚°etcï¼‰ ã¨ã„ã†é¢¨ã«ã¨ã¦ã‚‚å¤šãã®ãƒãƒªã‚¨ãƒ¼ã‚·ãƒ§ãƒ³ãŒã‚ã‚‹ã€‚ã“ã®ãƒ–ãƒã‚°ã‚’èªã‚“ã§é ‚ã„ã¦ã„ã‚‹çš†ã•ã‚“ã®ä¸ã«ã‚‚ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’ä½¿ã£ã¦ã„ã‚‹æ–¹ã¯å¤šã„ã®ã§ã¯ãªã„ã ã‚ã†ã‹ã€‚ã”è¦§ã®é€šã‚ŠMySQLã®ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³æ©Ÿèƒ½ã¯ãƒŸãƒƒã‚·ãƒ§ãƒ³ã‚¯ãƒªãƒ†ã‚£ã‚«ãƒ«åˆ†é‡Žã§ã‚‚åˆ©ç”¨ã•ã‚Œã¦ã„ã‚‹ãŒã€ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®ä½¿ã„æ–¹ãŒé©åˆ‡ã§ãªã„ã¨ã‚·ã‚¹ãƒ†ãƒ ã®å®‰å®šç¨¼åƒã«æ”¯éšœã‚’æ¥ã—ã¦ã—ã¾ã£ã¦DBAã‚„ã‚·ã‚¹ãƒ†ãƒ ç®¡ç†è€…ã®è‚‰ä½“çš„ã€ç²¾ç¥žçš„è² æ‹…ãŒå¢—å¤§ã—ã¦ã—ã¾ã†ã€‚é€†ã«ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’å …ç‰¢ã«é‹ç”¨ã™ã‚‹ã“ã¨ãŒå‡ºæ¥ã‚Œã°ãƒžã‚¯ãƒ©ã‚’é«˜ãã—ã¦çœ ã‚Œã‚‹ã¨ã„ã†ã‚‚ã®ã ã€‚ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã¯MySQLã®ä»£è¡¨çš„ãªæ©Ÿèƒ½ã§ã‚ã‚‹ã®ã§ã€ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³
k_37to 2009/04/10
MySQL

replication

tips
ãƒªãƒ³ã‚¯
æœ€å¼·ã®MySQL HAåŒ–æ‰‹æ³• - Semi-Synchronous Replication
MySQL 6.0ã§æè¼‰ã•ã‚Œã‚‹äºˆå®šã®æ©Ÿèƒ½ã®ä¸€ã¤ã«ã€Semi-Synchronous Replicationã¨ã„ã†ã‚‚ã®ãŒã‚ã‚‹ã€‚ã‚³ã‚¤ãƒ„ã‚’ä½¿ã†ã¨ã¨ã‚“ã§ã‚‚ãªãå‡„ã„HAåŒ–ãŒã§ãã‚‹ã®ã§ã€ä»Šæ—¥ã¯ãã®æ–¹æ³•ã‚’ç´¹ä»‹ã—ã‚ˆã†ã€‚ ã¾ãšã¯Semi-Synchronous Replicationã®æ©Ÿèƒ½èª¬æ˜Žã‹ã‚‰ã€‚ãã‚‚ãã‚‚Semi-Synchrounousã£ã¦ãƒŠãƒ‹ï¼Ÿã©ã†ã—ã¦å®Œå…¨ãªåŒæœŸã§ã‚‚ãªãéžåŒæœŸã§ã‚‚ãªãSemi-Synchronousãªã®ï¼Ÿã¨ã„ã†ç–‘å•ã‚’ã¾ãšã¯è§£æ¶ˆã—ãŸã„ã¨æ€ã†ã€‚ã•ã£ããæ¬¡ã®å›³ã‚’è¦‹ã¦æ¬²ã—ã„ã€‚ ã“ã‚Œã¯Semi-Synchronous Replicationã®å‹•ä½œã‚’å›³ã§è¡¨ã—ãŸã‚‚ã®ã§ã‚ã‚‹ã€‚å›³ã ã‘ã§ã¯ãªã‚“ã ã‹ã‚ˆãåˆ†ã‹ã‚‰ãªã„ã¨æ€ã†ã®ã§ã€ä»¥ä¸‹ã«å„ã‚¹ãƒ†ãƒƒãƒ—ã®è©³ç´°ã‚’èª¬æ˜Žã™ã‚‹ã€‚ ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ï¼ˆã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆï¼‰ã‹ã‚‰ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã‚’COMMITè¦æ±‚ã‚’å‡ºã™ã€‚ ãƒã‚¤ãƒŠãƒªãƒã‚°ã‚’æ›´æ–°ã™ã‚‹ã€‚ ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ï¼ˆãƒ†ãƒ¼ãƒ–ãƒ«ï¼‰ã‚’æ›´æ–°ã™ã‚‹ã€‚
k_37to 2009/04/02
MySQL

6.0

replication
ãƒªãƒ³ã‚¯
P2Påˆ†æ•£ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã€ŒCagraã€ - Blog by Sadayuki Furuhashi
id:nyaxtæ°ã¨ã®å…±åŒé–‹ç™ºã®åˆ†æ•£ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã€ŒCagraã€ï¼ˆã‹ãã‚‰ï¼‰ã®ã‚¢ãƒ«ãƒ•ã‚¡ç‰ˆã‚’ãƒªãƒªãƒ¼ã‚¹ã—ã¾ã—ãŸã€‚ cagra Î±3ãƒªãƒªãƒ¼ã‚¹ cagra ãƒ†ã‚¯ãƒ‹ã‚«ãƒ«ãƒ‡ãƒ¢ Î±ï¼’ãƒªãƒªãƒ¼ã‚¹ åˆ†æ•£ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ãƒ†ã‚¯ãƒ‹ã‚«ãƒ«ãƒ‡ãƒ¢ã€€Î±ç‰ˆãƒªãƒªãƒ¼ã‚¹ cagraã®Î±ç‰ˆè©¦ã—ã¦ã¿ãŸã‚ˆ - takumalog Cagraã¯ä»¥ä¸‹ã®ã‚ˆã†ãªç‰¹å¾´ã‚’æŒã£ãŸï¼ˆç›®æŒ‡ã—ãŸï¼‰P2Påˆ†æ•£ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã§ã™ã€‚ Zeroconf ãƒžãƒ«ãƒãƒžã‚¹ã‚¿ã§ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã™ã‚‹Write é«˜é€Ÿãªåˆ†æ•£Read ã‚ªãƒ—ã‚·ãƒ§ãƒ³ã§é«˜é€ŸãªéžåŒæœŸWrite ã‚¤ãƒ³ã‚¿ãƒ¼ãƒãƒƒãƒˆãƒ¬ãƒ™ãƒ«ã‚ˆã‚Šã‚‚LANãƒ¬ãƒ™ãƒ«ã®ãƒžã‚·ãƒ³å°æ•°ã«ç‰¹åŒ– å·¨å¤§ãƒ‡ãƒ¼ã‚¿ã‚µãƒãƒ¼ãƒˆ é«˜é€Ÿã‚¤ãƒ™ãƒ³ãƒˆé§†å‹•ã‚·ã‚¹ãƒ†ãƒ ã‚³ãƒ¼ãƒ«ï¼‹è»½é‡ã‚¹ãƒ¬ãƒƒãƒ‰ è¶…ã‚¢ã‚¸ãƒ£ã€œã‚¤ãƒ«ãªé–‹ç™ºä½“åˆ¶ ã¾ã Î±ç‰ˆã§å…¨éƒ¨ãŒå®Ÿè£…ã•ã‚Œã¦ã„ã‚‹ã‚ã‘ã§ã¯ãªã„ã§ã™ãŒã€ã¨ã‚Šã‚ãˆãšå‹•ãã¾ã™ã€‚ Zeroconf UDPãƒžãƒ«ãƒã‚ãƒ£ã‚¹ãƒˆã§ãƒŽãƒ¼ãƒ‰ã‚’è‡ªå‹•çš„ã«ç™ºè¦‹ã™ã‚‹ã®ã§ã€ä¸€åˆ‡è¨å®šãƒ•ã‚¡ã‚¤ãƒ«ã‚’æ›¸ã‹ãšã«å‹•ä½œã›ã‚‹
k_37to 2008/05/07
p2p

storage

replication
ãƒªãƒ³ã‚¯
ã€ãƒ¬ãƒãƒ¼ãƒˆã€‘Facebookã®ãƒ‡ãƒ¼ã‚¿ã‚»ãƒ³ã‚¿ãƒ¼ã«è¦‹ã‚‹MySQLæ´»ç”¨äº‹ä¾‹ - MySQLã‚«ãƒ³ãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ (1) ç†±æ°—ã«æº€ã¡ãŸ4æ—¥é–“ - MySQL Conference and Expo | ã‚¨ãƒ³ã‚¿ãƒ¼ãƒ—ãƒ©ã‚¤ã‚º | ãƒžã‚¤ã‚³ãƒŸã‚¸ãƒ£ãƒ¼ãƒŠãƒ«
4æœˆ14æ—¥ã‹ã‚‰17æ—¥ã¾ã§ã®4æ—¥é–“ã€ç±³ã‚«ãƒªãƒ•ã‚©ãƒ«ãƒ‹ã‚¢å·žã‚µãƒ³ã‚¿ã‚¯ãƒ©ãƒ©ã«ãŠã„ã¦ã€MySQL Conference and Expo(ä»¥ä¸‹ã€MySQLã‚«ãƒ³ãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹)ãŒé–‹å‚¬ã•ã‚ŒãŸã€‚MySQLé–¢é€£ã®æœ€å¤§ã®ã‚¤ãƒ™ãƒ³ãƒˆã§ã‚ã‚‹ã€‚ã‚»ãƒƒã‚·ãƒ§ãƒ³ã¯æœ‰æ–™ã§ã€æ—¥æœ¬å††ã§10ä¸‡å††ã‚’è¶…ãˆã‚‹é‡‘é¡ã«ã‚‚ã‹ã‹ã‚ã‚‰ãšã€å‚åŠ ç™»éŒ²è€…æ•°ã¯2,000äººè¿‘ãã«é”ã—â€»ã€æ—¥æœ¬ã‹ã‚‰ã‚‚å¤šãã®ãƒ¦ãƒ¼ã‚¶ãƒ¼ãŒå‚åŠ ã—ã¦ã„ãŸã€‚ â€» ã‚»ãƒƒã‚·ãƒ§ãƒ³å‚åŠ ã®ã§ããªã„ã€å±•ç¤ºä¼šå ´ã®ã¿ã®ç”³ã—è¾¼ã¿è€…ã‚‚å«ã‚€ã€‚ ä»Šå›žã®MySQLã‚«ãƒ³ãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ã§ã¯ã€è¤‡æ•°ãƒ‡ãƒ¼ã‚¿ã‚»ãƒ³ã‚¿ãƒ¼ã«ã¾ãŸãŒã£ã¦MySQLã‚’æ´»ç”¨ã™ã‚‹ã‚ˆã†ãªå¤§è¦æ¨¡äº‹ä¾‹ã€ãƒšã‚¿ãƒã‚¤ãƒˆç´šã®è¦æ¨¡ã«æŒ‘æˆ¦ã™ã‚‹äº‹ä¾‹ã€MySQL Clusterã®äº‹ä¾‹ã€Heartbeat + DRBDã«ã‚ˆã‚‹é«˜å¯ç”¨æ€§ã®äº‹ä¾‹ãªã©ã€ã•ã¾ã–ã¾ãªäº‹ä¾‹ãŒç™ºè¡¨ã•ã‚ŒãŸã€‚ã¨ãã«Facebookã¯ã€1ä¸‡å°ã®Webã‚µãƒ¼ãƒã€800å°ã®ã‚ãƒ£ãƒƒã‚·ãƒ¥ã‚µãƒ¼ãƒ(memcached)ã€ãã—ã¦1,800å°ã®My
k_37to 2008/04/30
MySQL

memcached

replication

facebook

case

example
ãƒªãƒ³ã‚¯
[ThinkIT] ç¬¬6å›žï¼šãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®è² è·åˆ†æ•£ã¨ã¾ã¨ã‚ (3/3)
ã“ã®ã‚ªãƒ³ãƒ¡ãƒ¢ãƒªãƒ‡ãƒ¼ã‚¿ã«ã‚ˆã‚‹é«˜é€Ÿãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®æ§‹ç¯‰æ–¹æ³•ã§ã™ãŒã€æ‰‹é †ã¯ãƒªã‚¹ãƒˆ5ã®é€šã‚Šã§ã™ã€‚ ãƒªã‚¹ãƒˆ5ï¼štmpfsã‚’ãƒžã‚¦ãƒ³ãƒˆ $ sudo mkdir -p /shm/mysql/bookmark $ sudo mount -t tmpfs -o size=2048m tmpfs /dev/shm $ sudo mount -t tmpfs -o size=2048m /dev/shm /shm/mysql/bookmark ã¾ãšã€tmpfsã‚’ä½œæˆã—ã€é©å½“ãªãƒžã‚¦ãƒ³ãƒˆãƒã‚¤ãƒ³ãƒˆã«ãƒžã‚¦ãƒ³ãƒˆã—ã¾ã™ã€‚ã“ã“ã§ã¯/shm/mysql/bookmarkã¨ã„ã†ãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªã‚’ä½œã‚Šã€ãã“ã«2048MBã®tmpfsã‚’ãƒžã‚¦ãƒ³ãƒˆã—ã¦ã„ã¾ã™ã€‚ æ¬¡ã«ã€MySQLã®ãƒ‡ãƒ¼ã‚¿ã‚’å…ƒã€…ã‚ã‚‹å ´æ‰€ã‹ã‚‰ã‚³ãƒ”ãƒ¼ã—ã¦ç§»å‹•ã—ã¾ã™ï¼ˆãƒªã‚¹ãƒˆ6ï¼‰ã€‚ ãƒªã‚¹ãƒˆ6ï¼šãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’tmpfsã«ã‚³ãƒ”ãƒ¼
k_37to 2008/03/30
mysql

replication

tmpfs
ãƒªãƒ³ã‚¯
Repcached
repcachedã«ã¤ã„ã¦ repcachedã¨ã¯ã€memcachedã«ãƒ‡ãƒ¼ã‚¿ã®ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³æ©Ÿèƒ½ã‚’è¿½åŠ å®Ÿè£…ã—ãŸã‚‚ã®ã§ã™ã€‚ memcachedã¯ã€ä»¥ä¸‹ã®ã‚ˆã†ãªã¨ã“ã‚ã«ã‚ˆãä½¿ã‚ã‚Œã‚‹ã¨æ€ã„ã¾ã™ã€‚ ä¸€æ™‚çš„ãªãƒ‡ãƒ¼ã‚¿ã®ä¿å˜å ´æ‰€ã¨ã—ã¦ ã‚ãƒ£ãƒƒã‚·ãƒ¥ã‚’ä¿å˜ã™ã‚‹å ´æ‰€ã¨ã—ã¦ RDBMSã®ãƒ‡ãƒ¼ã‚¿ã®ã‚ãƒ£ãƒƒã‚·ãƒ¥ ç”Ÿæˆã—ãŸãƒšãƒ¼ã‚¸ãƒ‡ãƒ¼ã‚¿ã®ã‚ãƒ£ãƒƒã‚·ãƒ¥ ã„ãšã‚Œã®å ´åˆã‚‚æ¶ˆãˆã¦ã„ã„ãƒ‡ãƒ¼ã‚¿ãªã®ã§ã€ä¸‡ãŒä¸€memcachedãŒãƒ€ã‚¦ãƒ³ã—ã¦ã‚‚å•é¡Œã¯ãªã„ã¯ãšã§ã™ã€‚ ã—ã‹ã—ã€å½±éŸ¿ãŒå…¨ããªã„ã‚ã‘ã§ã¯ã‚ã‚Šã¾ã›ã‚“ã€‚ ä¾‹ãˆã°ã€MySQLã®ãƒ‡ãƒ¼ã‚¿ã‚’memcachedã§ã‚ãƒ£ãƒƒã‚·ãƒ¥ã—ã¦ã„ã‚‹å ´åˆã€memcachedãŒãƒ€ã‚¦ãƒ³ã—ã¦ã„ã‚‹é–“ã¯ç›´æŽ¥MySQLã«ã‚¢ã‚¯ã‚»ã‚¹ãŒã„ãã“ã¨ã«ãªã‚ŠDBã‚µãƒ¼ãƒã®è² è·ãŒä¸ŠãŒã‚Šã¾ã™ã€‚ã¾ãŸã€memcachedã‚’å†èµ·å‹•ã—ã¦ã‚ãƒ£ãƒƒã‚·ãƒ¥ãŒå¤±ã‚ã‚ŒãŸå ´åˆã¯ã€å†ã³ã‚ãƒ£ãƒƒã‚·ãƒ¥ãŒæºœã¾ã‚‹ã¾ã§ã¯DBã‚µãƒ¼ãƒã«è² è·ãŒã‹ã‹ã‚‹ã“ã¨ã«ãªã£ã¦ã—ã¾ã„ã¾ã™ã€‚ ã“ã®ã‚ˆã†ã«
k_37to 2007/11/22
memcached

scalability

replication
ãƒªãƒ³ã‚¯
CodeZineï¼šDeNAã®äººæ°—ã‚µã‚¤ãƒˆã«å¦ã¶ LAMPã«ã‚ˆã‚‹Web-DBã‚·ã‚¹ãƒ†ãƒ æ§‹ç¯‰/é‹ç”¨ã®æ¥µæ„ï¼ˆå‰ç·¨ï¼‰ï¼ˆãƒ¢ãƒã‚ªã‚¯, ãƒ¢ãƒã‚²ãƒ¼ï¼‰
ã‚·ãƒ³ã‚°ãƒ«ãƒžã‚¹ã‚¿ã®éžåŒæœŸãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³æ©Ÿèƒ½ã§ã¯ã€ãƒžã‚¹ã‚¿ã‚µãƒ¼ãƒãƒ¼ãŒ1å°ã«é™å®šã•ã‚Œã€ãƒžã‚¹ã‚¿ã‹ã‚‰ã‚¹ãƒ¬ãƒ¼ãƒ–ã¸ã®è¤‡è£½ã¯éžåŒæœŸã§è¡Œãªã‚ã‚Œã‚‹ãŸã‚é…å»¶ãŒç”Ÿã˜ã€çŸæ™‚é–“ã®ã‚¹ã‚±ãƒ¼ãƒ«ã§è¦‹ã‚‹ã¨å…¨ã‚¹ãƒ¬ãƒ¼ãƒ–ã¨ã®åŒæœŸãŒä¿è¨¼ã•ã‚Œãªã„ã€‚ã—ã‹ã—ã€ãã®åé¢ã‚¹ãƒ¬ãƒ¼ãƒ–ã®å°æ•°ã‚’å¢—åŠ ã•ã›ã¦ã„ã£ã¦ã‚‚ãƒžã‚¹ã‚¿ã‚µãƒ¼ãƒãƒ¼ã®æ›´æ–°è² è·ã¯å¤§ãããªã‚‰ãšã€ã‚¹ã‚±ãƒ¼ãƒ©ãƒ“ãƒªãƒ†ã‚£ã‚’ç¶æŒã§ãã‚‹ã¨ã„ã†åˆ©ç‚¹ãŒã‚ã‚‹ã€‚DeNAã«ã‚ˆã‚‹é‹ç”¨å®Ÿç¸¾ã§ã‚‚ã€ãƒžã‚¹ã‚¿ã¨ã‚¹ãƒ¬ãƒ¼ãƒ–é–“ã®é…å»¶ã¯é€šå¸¸æ•°ç§’ç¨‹åº¦ä»¥å†…ã«åŽã¾ã‚‹ã€‚ã€€ã“ã®ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’åˆ©ç”¨ã™ã‚‹å ´åˆã€ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³å´ã§ã¯ãƒ‡ãƒ¼ã‚¿æ›´æ–°æ™‚ã«ã¯ãƒžã‚¹ã‚¿ã‚µãƒ¼ãƒãƒ¼ã¸æŽ¥ç¶šã—ã€ãƒ‡ãƒ¼ã‚¿å‚ç…§ã®ã¿ã‚’è¡Œãªã†å ´åˆã¯ã‚¹ãƒ¬ãƒ¼ãƒ–ã‚µãƒ¼ãƒãƒ¼ã¸æŽ¥ç¶šã™ã‚‹ã‚ˆã†ã«ä½œæˆã™ã‚‹å¿…è¦ãŒã‚ã‚‹ã€‚ã€€Webã‚„æºå¸¯é›»è©±å‘ã‘ã‚µãƒ¼ãƒ“ã‚¹ã®å ´åˆã€å°ã•ãªè¦æ¨¡ã§å§‹ã‚ã¦ãƒ¦ãƒ¼ã‚¶ãƒ¼è¦æ¨¡ã€ãƒ‡ãƒ¼ã‚¿è¦æ¨¡ã€ãƒšãƒ¼ã‚¸ãƒ“ãƒ¥ãƒ¼æ•°ã‚’å¾ã€…ã«å¢—åŠ ã•ã›ã¦ã„ãã“ã¨ãŒå¤šã„ã€‚å°ã•ãªè¦æ¨¡ã®ãŸã‚DBã®è² è·åˆ†æ•£ãŒä¸è¦ãªå ´åˆã§ã‚‚ã€ãƒžã‚¹ã‚¿ã‚µãƒ¼ãƒãƒ¼1å°ã€ã‚¹ãƒ¬ãƒ¼
k_37to 2007/08/04
webdav

dena

dns

round

MySQL

replication

case

example
ãƒªãƒ³ã‚¯
Open Tech Press | MySQLãƒ‡ãƒ¼ã‚¿ã®ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—æ–¹æ³•
2007å¹´5æœˆ31æ—¥10:53 Tom-Adelsteinã€Bill-Lubanovicï¼ˆ2007å¹´5æœˆ29æ—¥ï¼ˆç«ï¼‰ï¼‰ ãƒ•ã‚¡ã‚¤ãƒ«ã‚„ãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªã®ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã¯æ¯”è¼ƒçš„ç°¡å˜ã ãŒã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã¨ãªã‚‹ã¨ã€ã„ãã¤ã‹ç‰¹åˆ¥ãªå·¥å¤«ã‚’æ–½ã™å¿…è¦ãŒã‚ã‚‹ã€‚ã“ã“ã§ã¯MySQLã‚’å–ã‚Šä¸Šã’ã¦ã„ã‚‹ãŒã€åŒã˜åŽŸç†ã¯PostgreSQLã‚„ãã®ä»–ã®ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ã‚‚ã‚ã¦ã¯ã¾ã‚‹ã€‚ æœ¬ç¨¿ã¯ã€æœ€è¿‘Oâ€™Reillyã‹ã‚‰å‡ºç‰ˆã•ã‚ŒãŸæ›¸ç±ã€Ž Linux System Administration ã€ã®æŠœç²‹ã€‚ MySQLã‚µãƒ¼ãƒã‚’ä¼‘ã¿ãªãç¨¼åƒã•ã›ç¶šã‘ã‚‹å¿…è¦ãŒãªã„ãªã‚‰ã€ä»¥ä¸‹ã«ç¤ºã™ã‚ˆã†ãªåœ§ç¸®ãªã—ã®ã‚ªãƒ•ãƒ©ã‚¤ãƒ³ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—æ‰‹æ³•ãŒæ‰‹ã£ã¨ã‚Šæ—©ã„ã€‚ MySQLã‚µãƒ¼ãƒã‚’åœæ¢ã•ã›ã‚‹ã€‚ # /etc/init.d/mysqld stop MySQLã®ãƒ‡ãƒ¼ã‚¿ãƒ•ã‚¡ã‚¤ãƒ«ãŠã‚ˆã³ãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªã‚’ã‚³ãƒ”ãƒ¼ã™ã‚‹ã€‚ä¾‹ãˆã°ã€MySQLã®ãƒ‡ãƒ¼ã‚¿ãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒª/var
k_37to 2007/06/02
MySQL

backup

sample

replication
ãƒªãƒ³ã‚¯
ç¾å ´æŒ‡å‘ã®ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³è©³èª¬
ã“ã®æ–‡æ›¸ã¯ã€æŠ€è¡“è©•è«–ç¤¾åˆŠã€ŽWEB+DB PRESS Vol.22ã€ã«åŸ·ç†ã—ãŸè¨˜äº‹ã‚’æŠ€è¡“è©•è«–ç¤¾ã® è¨±å¯ã‚’å¾—ã¦WWWã§å…¬é–‹ã—ã¦ã„ã‚‹ã‚‚ã®ã§ã™ã€‚ ã“ã®WWWç‰ˆã¯æ ¡æ£å‰ã®åŽŸç¨¿ã‚’å…ƒã«ã—ã¦ã„ã‚‹ç‚¹ã€WWWå…¬é–‹å¾Œã«å¿…è¦ãŒã‚ã‚Œã°ä¿®æ£ã™ã‚‹ç‚¹ã§ã€é›‘èªŒç‰ˆã®æ–‡ç« ã¨ã¯ç•°ãªã‚‹éƒ¨åˆ†ãŒã‚ã‚Šã¾ã™ã€‚ã¾ãŸã€å›³è¡¨ã‚‚é›‘èªŒç‰ˆã¨ã¯ç•°ãªã‚Šã¾ã™ã€‚ äºˆã‚ã”äº†æ‰¿ãã ã•ã„ã€‚ ã¾ãŸã€ã“ã®æ–‡ç« ãŒå¯¾è±¡ã—ã¦ã„ã‚‹ã®ã¯MySQL 4.0ç³»ãªã®ã§ã€æœ€æ–°ã®ãƒªãƒªãƒ¼ã‚¹ç‰ˆã¨æ¯”ã¹ã‚‹ã¨èª¬æ˜Žä¸è¶³ãªç‚¹ãªã©ãŒå¤šã€…ã‚ã‚‹ã¨æ€ã„ã¾ã™ã€‚ ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®åŸºæœ¬ã‚’ãŠã•ãˆã‚‹ã«ã¯ã€ã“ã®æ–‡æ›¸ã¯ã¾ã æœ‰ç›Šã ã¨æ€ã„ã¾ã™ãŒã€è¨å®šãƒ¬ãƒ™ãƒ«ã®èª¬æ˜Žã¯æœ€æ–°ã®ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã‚’å‚ç…§ã™ã‚‹ã‚ˆã†ã«ã—ã¦ãã ã•ã„ã€‚
k_37to 2006/11/03
mysql

Tips

replication
ãƒªãƒ³ã‚¯
1