[B! ãƒã‚¤ãƒŠãƒªãƒã‚°] nullpopopoã®ãƒ

nullpopopo id:nullpopopo

ãƒã‚¤ãƒŠãƒªãƒã‚°ã«é–¢ã™ã‚‹nullpopopoã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (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}}

ã›ã˜ã¾ãã‚“ã®åˆºã•ã‚‰ãªã„è©±ï¼ˆMySQL Slaveå¢—è¨ç·¨ï¼‰ | GREE Engineering
ã¯ã˜ã‚ã¾ã—ã¦ã€‚ãƒ—ãƒ©ãƒƒãƒˆãƒ•ã‚©ãƒ¼ãƒ é–‹ç™ºæœ¬éƒ¨ã®ã›ã˜ã¾ã§ã™ã€‚å¥½ããªã‚‚ã®ã¯Disk I/Oã§ã™ã€‚ ä»Šå›žã¯MySQLï¼ˆon Linuxï¼‰ã®ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã«ã¾ã¤ã‚ã‚‹ã€ã¡ã‚‡ã£ã¨ã—ãŸãŠè©±ã‚’ã•ã›ã¦ã„ãŸã ããŸã„ã¨æ€ã„ã¾ã™ã€‚ ã¯ã˜ã‚ã« MySQL4.0ä»¥é™ã®ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã¯ã€ Masterã®mysqldãŒã€INSERT/UPDATE/DELETEãªã©ã®æ›´æ–°æƒ…å ±ã‚’ã€ãƒã‚¤ãƒŠãƒªãƒã‚°ã«è¨˜éŒ²ã™ã‚‹ã€‚ Slaveã®mysqld(IOã‚¹ãƒ¬ãƒƒãƒ‰)ã¯ã€masterã®mysqldã«æŽ¥ç¶šã—ã€ãƒã‚¤ãƒŠãƒªãƒã‚°ã‚’è»¢é€ã™ã‚‹ã€‚ Slaveã®mysqld(IOã‚¹ãƒ¬ãƒƒãƒ‰)ã¯ã€å—ä¿¡ã—ãŸãƒã‚¤ãƒŠãƒªãƒã‚°å†…å®¹ã‚’ã€ãƒªãƒ¬ãƒ¼ãƒã‚°ã«è¨˜éŒ²ã™ã‚‹ã€‚ Slaveã®mysqld(SQLã‚¹ãƒ¬ãƒƒãƒ‰)ã¯ã€ãƒªãƒ¬ãƒ¼ãƒã‚°ã‚’èªã¿è¾¼ã¿ã€æ›´æ–°å†…å®¹ã‚’slaveã®DBã«åæ˜ ã™ã‚‹ã€‚ ã¨ã„ã£ãŸä»•çµ„ã¿ã«ãªã£ã¦ã„ã¾ã™ã€‚å›³ã«ã™ã‚‹ã¨æ¬¡ã®é€šã‚Šã§ã™(*1)ã€‚ MySQLã®ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã¯ã¨ã¦ã‚‚è‰¯ãã§ããŸä»•çµ„ã¿ãª
nullpopopo 2015/05/19
mysql

ãƒã‚¤ãƒŠãƒªãƒã‚°

ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³
ãƒªãƒ³ã‚¯
MySQLã®ãƒã‚¤ãƒŠãƒªãƒã‚°ã‚’ä½¿ã£ãŸå¾©æ—§æ‰‹é † - Denet Tech Lib.
MySQLã®ãƒã‚¤ãƒŠãƒªãƒã‚°ã‚’ä½¿ã£ãŸå¾©æ—§æ‰‹é †ã«ã¤ã„ã¦ã”ç´¹ä»‹è‡´ã—ã¾ã™ã€‚ ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³æ§‹æˆã‚’å®Ÿæ–½ã•ã‚Œã¦ã„ã‚‹å ´åˆã¯ã€ã‚¹ãƒ¬ãƒ¼ãƒ–â‡’ãƒžã‚¹ã‚¿ãƒ¼æ˜‡æ ¼ã«ã‚ˆã‚Š å¾©æ—§ã•ã‚Œã‚‹ã®ã§ã€ãƒã‚¤ãƒŠãƒªãƒã‚°ã‚’åˆ©ç”¨ã—ãŸãƒãƒ¼ãƒ«ãƒ•ã‚©ãƒ¯ãƒ¼ãƒ‰ã‚’æ‰±ã†äº‹ã¯å°‘ãªã„ã‹ã¨æ€ã„ã¾ã™ã€‚ ãã‚‚ãã‚‚ãƒãƒ¼ãƒ«ãƒ•ã‚©ãƒ¯ãƒ¼ãƒ‰ã¨ã¯ï¼Ÿ ãƒã‚°ãƒ•ã‚¡ã‚¤ãƒ«ã«æ®‹ã£ã¦ã„ã‚‹ãƒã‚§ãƒƒã‚¯ãƒã‚¤ãƒ³ãƒˆå¾Œã®ãƒ‡ãƒ¼ã‚¿ã‚’å…ƒã«å‡¦ç†ã‚’å†ç¾ã—ã€éšœå®³ç™ºç”Ÿã®ç›´å‰ã®çŠ¶æ…‹ã«ã¾ã§æˆ»ã™ã“ã¨ã§ã‚ã‚‹ã€‚ æœ¬ä»¶ã®å‹•ä½œç¢ºèªã¯ã€æ¬¡ã®ç’°å¢ƒã«ã¦è¡Œã„ã¾ã—ãŸã€‚ OS:CentOS6.5 64bit MySQL:5.1.73-3.el65.x8664 éšœå®³ç™ºç”Ÿç›´å‰ã¾ã§ãƒªã‚«ãƒãƒªã‚’å®Ÿæ–½ã™ã‚‹ç‚ºã«ã¯ã€ä¸‹è¨˜ã®ãƒ‡ãƒ¼ã‚¿ãŒå¿…è¦ã§ã™ã€‚ mysqldumpã®å…¨ä½“ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ— å…¨ä½“ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ä»¥é™ã®ãƒã‚¤ãƒŠãƒªãƒã‚° ãƒã‚¤ãƒŠãƒªãƒã‚°ã¯ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã§ã¯ä½œæˆã•ã‚Œãªã„ã®ã§ã€my.cnfã«ã¦è¨å®šã™ã‚‹ [mysqld] log-bin=mysql-binã€€ã€€ã€€â†è¿½è¨˜ ä¸Šè¨˜è¨å®šã«ã‚ˆã‚Š
nullpopopo 2015/05/09
mysql

ãƒã‚¤ãƒŠãƒªãƒã‚°
ãƒªãƒ³ã‚¯
mysqldumpã§ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã‚’ã™ã‚‹æ™‚ã«ã¤ã‘ã‚‹ã‚ªãƒ—ã‚·ãƒ§ãƒ³ - oinume journal
MySQLã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã™ã‚‹éš›ã«mysqldumpã‚’ä½¿ç”¨ã—ã¾ã™ãŒã€å€‹äººçš„ã«ã€Œã“ã‚Œã¯ã¤ã‘ãŸã‚‰ã‚ˆã•ãã†ã€ã¨æ€ã£ã¦ã„ã‚‹ã‚ªãƒ—ã‚·ãƒ§ãƒ³ã‚’ç´¹ä»‹ã—ã¾ã™ã€‚ --opt --quick --add-drop-table --add-locks --extended-insert --lock-tables ã‚’æŒ‡å®šã™ã‚‹ã®ã¨åŒã˜ã§ã™ã€‚ãƒ€ãƒ³ãƒ—ã—ãŸãƒ‡ãƒ¼ã‚¿ã‚’MySQL ã‚µãƒ¼ãƒã«èªã¿è¾¼ã‚€ãŸã‚ã®æœ€é€Ÿãƒ€ãƒ³ãƒ—ã‚’æä¾›ã—ã¾ã™ã€‚(ãƒžãƒ‹ãƒ¥ã‚¢ãƒ«ãã®ã¾ã‚“ã¾) --single-transaction ãƒ€ãƒ³ãƒ—ã™ã‚‹éš›ã«å…ˆé ã«BEGINã‚’ã¤ã‘ã‚‹ãŸã‚ã€ãƒ€ãƒ³ãƒ—æ™‚ã®ãƒ‡ãƒ¼ã‚¿ã®ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã®ä¸€è²«æ€§ã‚’ä¿ã¤ã“ã¨ãŒã§ãã¾ã™ã€‚ãŸã ã—InnoDBãªã©ã®ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ãŒæœ‰åŠ¹ãªã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã§ã¯ãªã„ã¨æ„å‘³ãŒãªã„ã§ã™ã€‚ --flush-logs ãƒ€ãƒ³ãƒ—ã‚’é–‹å§‹ã™ã‚‹å‰ã«ã€MySQL ã‚µãƒ¼ãƒå†…ã®ãƒã‚°ãƒ•ã‚¡ã‚¤ãƒ«ã‚’ãƒ•ãƒ©ãƒƒã‚·ãƒ¥ã—ã¾ã™ã€‚ãƒã‚¤ãƒŠãƒªãƒã‚°ã‚’ä¿å˜ã™ã‚‹ã‚ˆã†
nullpopopo 2015/05/09
mysqldump

ãƒã‚¤ãƒŠãƒªãƒã‚°

ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—

mysql
ãƒªãƒ³ã‚¯
mysqlã§Unsafe statement written to the binary log using statement ã®è¦å‘ŠãŒå‡ºãŸæ™‚ã®å¯¾å‡¦Â |Â ãƒ¬ãƒ³ã‚¿ãƒ«ã‚µãƒ¼ãƒãƒ¼ãƒ»è‡ªå®…ã‚µãƒ¼ãƒãƒ¼è¨å®šãƒ»æ§‹ç¯‰ã®ãƒ’ãƒ³ãƒˆ
mysqlã§Unsafe statement written to the binary log using statement ã®è¦å‘ŠãŒå‡ºãŸæ™‚ã®å¯¾å‡¦
nullpopopo 2015/05/02
mysql

ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³

ãƒã‚¤ãƒŠãƒªãƒã‚°
ãƒªãƒ³ã‚¯
1