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

Dogison id:Dogison

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

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

replication
ãƒªãƒ³ã‚¯
å®ŸéŒ²ã€ã»ã¼ç„¡åœæ¢ãª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
Dogison 2009/11/12
replication

mysql

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

mysql

recovery
ãƒªãƒ³ã‚¯
MySQL ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®è¨å®š - ã¨ã¿ãžãƒ¼ãƒŽãƒ¼ãƒˆ
1.2 ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®å‹•ä½œãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã§ã¯æœ€åˆã«DBã®å†…å®¹ã‚’åŒæœŸã•ã›ãŸå¾Œã€Masterã‚µãƒ¼ãƒãƒ¼ã§å®Ÿè¡Œã•ã‚ŒãŸæ›´æ–°ç³»ã®ã‚¯ã‚¨ãƒª(UPDATEã¨ã‹)ã‚’Slaveã«æ¸¡ã—ã¦Slaveã§ã‚‚åŒã˜ã‚¯ã‚¨ãƒªã‚’å®Ÿè¡Œã—ã¦ã„ãã“ã¨ã§ã€DBã‚’åŒæœŸã•ã›ã¦ã„ã‚‹(å›³1)ã€‚ Masterå´ã§å®Ÿè¡Œã•ã‚ŒãŸæ›´æ–°ç³»ã‚¯ã‚¨ãƒªã¯ãƒã‚¤ãƒŠãƒªãƒã‚°ã«è“„ãˆã‚‰ã‚Œã¦ãŠã‚Šã€Slaveå´ãŒæŽ¥ç¶šã—ã¦ããŸã‚‰ã€å‰å›žã®æŽ¥ç¶šã‹ã‚‰ã®å¤‰æ›´åˆ†ã‚’Slaveå´ã«é€ä¿¡ã™ã‚‹ã€‚Slaveå´ã¯å—ã‘å–ã£ãŸã‚¯ã‚¨ãƒªã‚’ä¸€æ—¦ãƒªãƒ¬ãƒ¼ãƒã‚°ã«è“„ãˆã¦é †æ¬¡ã‚¯ã‚¨ãƒªã‚’å®Ÿè¡Œã—ã¦DBã‚’åŒæœŸã•ã›ã¦ã„ãã€‚ãƒªãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³å‹•ä½œã«ã¯BinlogDump,I/O,SQLã®3ã¤ã®ã‚¹ãƒ¬ãƒƒãƒ‰ãŒé€£æºã—ã¦å‹•ä½œã™ã‚‹ã€‚ 2.è¨å®šæ‰‹é † (Master-Slaveæ§‹æˆ) 2.1 Masterå´ã®è¨å®šã®ç¢ºèªMasterå´ã§ã¯ãƒã‚¤ãƒŠãƒªãƒã‚°ã‚’æŽ¡å–ã—ã¦ãŠãå¿…è¦ãŒã‚ã‚‹ã®ã§ã€Masterå´ã®my.cnfã«log-binã®è¨å®šãŒå…¥ã£ã¦ã„ã‚‹ã“ã¨ã‚’ç¢º
Dogison 2009/07/15
mysql

replication

performance
ãƒªãƒ³ã‚¯
MySQL :: MySQL 8.0 ãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ãƒžãƒ‹ãƒ¥ã‚¢ãƒ« :: 17 ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³
ã‚¹ã‚±ãƒ¼ãƒ«ã‚¢ã‚¦ãƒˆã‚½ãƒªãƒ¥ãƒ¼ã‚·ãƒ§ãƒ³ - è¤‡æ•°ã®ãƒ¬ãƒ—ãƒªã‚«ã«è² è·ã‚’åˆ†æ•£ã—ã¦ã€ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã‚’å‘ä¸Šã•ã›ã¾ã™ã€‚ ã“ã®ç’°å¢ƒã§ã¯ã€ã™ã¹ã¦ã®æ›¸è¾¼ã¿ãŠã‚ˆã³æ›´æ–°ãŒã‚½ãƒ¼ã‚¹ã‚µãƒ¼ãƒãƒ¼ã§å®Ÿè¡Œã•ã‚Œã‚‹å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚ ãŸã ã—ã€1 ã¤ã¾ãŸã¯è¤‡æ•°ã®ãƒ¬ãƒ—ãƒªã‚«ã§èªã¿å–ã‚ŠãŒè¡Œã‚ã‚Œã‚‹å ´åˆãŒã‚ã‚Šã¾ã™ã€‚ ã“ã®ãƒ¢ãƒ‡ãƒ«ã§ã¯ã€(ã‚½ãƒ¼ã‚¹ãŒæ›´æ–°å°‚ç”¨ã§ã‚ã‚‹ãŸã‚) æ›¸è¾¼ã¿ã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã‚’å‘ä¸Šã•ã›ã‚‹ä¸€æ–¹ã§ã€ãƒ¬ãƒ—ãƒªã‚«ã®æ•°ã®å¢—åŠ ã«ä¼´ã£ã¦èªå–ã‚Šé€Ÿåº¦ã‚’å¤§å¹…ã«å‘ä¸Šã•ã›ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ ãƒ‡ãƒ¼ã‚¿ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ - ãƒ¬ãƒ—ãƒªã‚«ã¯ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ãƒ—ãƒã‚»ã‚¹ã‚’ä¸€æ™‚åœæ¢ã§ãã‚‹ãŸã‚ã€å¯¾å¿œã™ã‚‹ã‚½ãƒ¼ã‚¹ãƒ‡ãƒ¼ã‚¿ã‚’ç ´æã•ã›ã‚‹ã“ã¨ãªããƒ¬ãƒ—ãƒªã‚«ã§ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã‚µãƒ¼ãƒ“ã‚¹ã‚’å®Ÿè¡Œã§ãã¾ã™ã€‚ ã‚¢ãƒŠãƒªãƒ†ã‚£ã‚¯ã‚¹ - ãƒ©ã‚¤ãƒ–ãƒ‡ãƒ¼ã‚¿ã¯ã‚½ãƒ¼ã‚¹ã§ä½œæˆã§ãã¾ã™ãŒã€æƒ…å ±ã®åˆ†æžã¯ã‚½ãƒ¼ã‚¹ã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã«å½±éŸ¿ã‚’ä¸Žãˆã‚‹ã“ã¨ãªããƒ¬ãƒ—ãƒªã‚«ã§å®Ÿè¡Œã§ãã¾ã™ã€‚ é•·è·é›¢ãƒ‡ãƒ¼ã‚¿åˆ†æ•£ - ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’ä½¿ç”¨ã™ã‚‹ã¨ã€ã‚½ãƒ¼ã‚¹ã«æ°¸ç¶šçš„ã«ã‚¢ã‚¯ã‚»ã‚¹
Dogison 2009/07/15
replication

mysql

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

mysql

performance

reference
ãƒªãƒ³ã‚¯
1