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

aki77 id:aki77

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

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

é–‹ç™ºç’°å¢ƒã®ãƒ‡ãƒ¼ã‚¿ã‚’ã§ãã‚‹ã ã‘æœ¬ç•ªã«è¿‘ã¥ã‘ã‚‹ - ã‚¯ãƒƒã‚¯ãƒ‘ãƒƒãƒ‰é–‹ç™ºè€…ãƒ–ãƒã‚°
ã“ã‚“ã«ã¡ã¯ã€‚æŠ€è¡“éƒ¨ã®å‰å·ã§ã™ã€‚ ä»Šå›žã¯ã‚¯ãƒƒã‚¯ãƒ‘ãƒƒãƒ‰ã®é–‹ç™ºç’°å¢ƒæ§‹æˆã€ç‰¹ã«é–‹ç™ºç”¨ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®æ§‹æˆã«ã¤ã„ã¦ã”ç´¹ä»‹ã—ã¾ã™ã€‚ é–‹ç™ºç’°å¢ƒã®æ§‹æˆ ã‚¯ãƒƒã‚¯ãƒ‘ãƒƒãƒ‰ã®ã‚·ã‚¹ãƒ†ãƒ ç’°å¢ƒã¯ä»¥ä¸‹ã®ã‚ˆã†ãªãƒ•ã‚§ã‚¤ã‚ºã«åˆ†ã‹ã‚Œã¦ã„ã¾ã™ã€‚ â€» ã“ã‚Œã¯cookpad.comã®æ§‹æˆã§ã€ã‚µãƒ–ã‚·ã‚¹ãƒ†ãƒ ã‚„å€‹åˆ¥ã®ã‚µãƒ¼ãƒ“ã‚¹ã¯ãã®è¦æ¨¡ã‚„ç‰¹æ€§ã«å¿œã˜ã¦æ§‹æˆãŒç•°ãªã‚Šã¾ã™ã€‚ development é–‹ç™ºè€…ãŒå®Ÿéš›ã«é–‹ç™ºã‚’è¡Œã†ç’°å¢ƒã§ã™ã€‚ã‚¯ãƒƒã‚¯ãƒ‘ãƒƒãƒ‰ã§ã¯ä»®æƒ³ç’°å¢ƒã¯ç”¨ã„ãšã€æ‰‹å…ƒã®ãƒžã‚·ãƒ³ã§Railsã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’å‹•ã‹ã—ã¦é–‹ç™ºã‚’è¡Œã£ã¦ã„ã¾ã™ã€‚ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯ãƒãƒ¼ã‚«ãƒ«ã§ã¯ãªãã€é–‹ç™ºè€…å…¨ä½“ã§å…±é€šã®é–‹ç™ºç”¨ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«æŽ¥ç¶šã—ã¦ã„ã¾ã™ã€‚ test æ‰‹å…ƒã§ãƒ†ã‚¹ãƒˆã‚’å®Ÿè¡Œã™ã‚‹å ´åˆã¯ã€ãƒãƒ¼ã‚«ãƒ«ãƒžã‚·ãƒ³ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’åˆ©ç”¨ã—ã¾ã™ã€‚CIï¼ˆrrrspecï¼‰ãªã©ã®å ´åˆã‚‚åŒæ§˜ã§ã€ãƒ†ã‚¹ãƒˆå®Ÿè¡Œã‚µãƒ¼ãƒãƒ¼ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãŒåˆ©ç”¨ã•ã‚Œã¾ã™ã€‚ staging stagingã¨ã„ãˆã°æº–æœ¬ç•ªç’°å¢ƒã¨ã—ã¦ã€æœ¬
aki77 2014/10/03
cookpad

mysql

dev

replication
ãƒªãƒ³ã‚¯
MySQL 5.6 ã§ã®ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³é…å»¶ã¯å±é™º : DSASé–‹ç™ºè€…ã®éƒ¨å±‹
MySQL 5.6 ã®æ¤œè¨¼ä¸ã« MySQL 5.5 ã¨ã¯é•ã†ã‚¿ã‚¤ãƒ—ã®ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³é…å»¶ã‚’è¦‹ã¤ã‘ãŸã®ã§ç´¹ä»‹ã—ã¾ã™ã€‚ MySQL ã®ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®ãŠã•ã‚‰ã„ MySQL ã®ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã¯æ¬¡ã®ã‚ˆã†ãªä»•çµ„ã¿ã§å‹•ä½œã—ã¦ã„ã¾ã™ã€‚ ãƒžã‚¹ã‚¿ãƒ¼ã®æ›´æ–°ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ãŒ binlog ã‚’æ›¸ã ã‚¹ãƒ¬ãƒ¼ãƒ–ã® I/O ã‚¹ãƒ¬ãƒƒãƒ‰ãŒãƒžã‚¹ã‚¿ãƒ¼ã«æŽ¥ç¶šã—ã€ binlog ã‚’å–å¾—ã—ã€ relaylog ã‚’æ›¸ã. ãƒžã‚¹ã‚¿ãƒ¼å´ã¯ã‚¹ãƒ¬ãƒ¼ãƒ–ã‹ã‚‰ã®æŽ¥ç¶šã‚’å—ã‘ä»˜ã‘ã‚‹ã¨(dump ã‚¹ãƒ¬ãƒƒãƒ‰)ã€æŒ‡å®šã•ã‚ŒãŸå ´æ‰€ã‹ã‚‰æœ€æ–°ã¾ã§ã® binlog ã‚’è»¢é€ã™ã‚‹ binlog ãŒè¿½è¨˜ã•ã‚Œã‚‹ã®ã‚’å¾…ã£ã¦ã•ã‚‰ã«ã‚¹ãƒ¬ãƒ¼ãƒ–ã«é€ã‚‹ ã‚¹ãƒ¬ãƒ¼ãƒ–ã®SQLã‚¹ãƒ¬ãƒƒãƒ‰ãŒ relaylog ã‚’å†ç”Ÿã™ã‚‹ MySQL 5.5 ã§ã‚ˆãã‚ã£ãŸãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³é…å»¶ ãƒžã‚¹ã‚¿ãƒ¼ã¯ä¸¦åˆ—ã—ã¦ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã‚’å‡¦ç†ã—ã¦ã€æœ€çµ‚çš„ã«ã‚³ãƒŸãƒƒãƒˆã—ãŸé †ã§åæ˜ ã•ã‚Œã‚Œã°å•é¡Œãªã„ã‚ˆã†ã«ãªã£ã¦ã„ã¾ã™ã€‚ ä¸€æ–¹ã€ã‚¹
aki77 2014/07/23
mysql

replication
ãƒªãƒ³ã‚¯
MySQLãƒ€ãƒ³ãƒ—ã‹ã‚‰ã®ç„¡åœæ¢ã‚¹ãƒ¬ãƒ¼ãƒ–ä½œæˆ - Sudix's Blog
ã‚ˆãè¡Œã†ã®ã§ãƒ¡ãƒ¢ã€‚ ãƒžã‚¹ã‚¿ã¨ã‚¹ãƒ¬ãƒ¼ãƒ–ã®ãƒ›ã‚¹ãƒˆåã‚’ä»¥ä¸‹ã¨ä»®å®šã™ã‚‹ã€‚ ãƒžã‚¹ã‚¿ï¼š masterdb ã‚¹ãƒ¬ãƒ¼ãƒ–ï¼š slavedb ã¾ãŸã€ã‚¹ãƒ¬ãƒ¼ãƒ–å¯¾è±¡ã®DBã¯ä»¥ä¸‹ã¨ã™ã‚‹ã€‚ some_db_production ãƒžã‚¹ã‚¿ä¸Šã®MySQLã§ã®ä½œæ¥ ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ç”¨ãƒ¦ãƒ¼ã‚¶ãƒ¼ã®ä½œæˆ ã¾ã ç„¡ã‘ã‚Œã°ä½œã£ã¦ãŠãã€‚ã“ã®ä¾‹ã ã¨ã©ã®ãƒ›ã‚¹ãƒˆã‹ã‚‰ã§ã‚‚æŽ¥ç¶šã§ãã‚‹ã®ã§ã€ å¿…è¦ã«å¿œã˜ã¦IPã‚¢ãƒ‰ãƒ¬ã‚¹ã§ã®åˆ¶é™ã‚’ã‹ã‘ã‚‹ã“ã¨ã€‚ 1 2 mysql> GRANT REPLICATION SLAVE ON *.* TO repl_user@"%" IDENTIFIED BY 'hogehoge'; mysql> FLUSH PRIVILEGES; ã‚¹ãƒŠãƒƒãƒ—ã‚·ãƒ§ãƒƒãƒˆã®ä½œæˆ(å–å¾—ã—ã¤ã¤ã‚¹ãƒ¬ãƒ¼ãƒ–ã¸é€ã‚‹ï¼‰ ãƒ€ãƒ³ãƒ—ã‚’å–ã‚ŠãªãŒã‚‰åœ§ç¸®ã—ã‚¹ãƒ¬ãƒ¼ãƒ–DBã«é€ã‚Šè¾¼ã‚€ã€‚ãƒ‡ãƒ¼ã‚¿ãŒå¤šã„ã¨æ•°æ™‚é–“ã‹ã‹ã‚‹ã€‚ ã“ã“ã§ã¯è»¢é€é€Ÿåº¦ã‚’å„ªå…ˆã•ã›ã‚‹ãŸã‚ã€æš—å·åŒ–æ–¹å¼ã‚’è»½é‡ã®ã‚‚ã®ã—ã¦ã„ã‚‹ã€‚
aki77 2014/04/04
mysql

replication
ãƒªãƒ³ã‚¯
MySQL 5.6ã®ã‚¯ãƒ©ãƒƒã‚·ãƒ¥ã‚»ãƒ¼ãƒ•ãªãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®ä»•çµ„ã¿
MySQL 5.6ã®nutshellã‚’èªã‚€ã¨ã€`ã‚¯ãƒ©ãƒƒã‚·ãƒ¥ã‚»ãƒ¼ãƒ•ãªãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’å®Ÿç¾ã™ã‚‹ãŸã‚ã«ã¯master_info_repositoryã¨relay_log_info_repositoryã‚’TABLEã«è¨å®šã—ãªï¼ ãŠã£ã¨ã€relay_log_recoveryã‚‚1ã«ã—ã¦ãŠãã‚“ã ãœ'ã¿ãŸã„ã“ã¨ãŒæ›¸ã„ã¦ã‚ã‚‹ã€‚ ã§ã€ã“ã®ãƒã‚°ãƒ¬ãƒãƒ¼ãƒˆã‚’è¦‹ãŸæ™‚ã‹ã‚‰ãšã£ã¨ã€sync_master_infoã®æš—é»™ã®ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆ10000ã®ã¾ã‚“ã¾ã˜ã‚ƒã‚¯ãƒ©ãƒƒã‚·ãƒ¥ã‚»ãƒ¼ãƒ•ã˜ã‚ƒãªããï¼Ÿ sync_master_info= 1å¿…é ˆï¼Ÿ ãã‚Œã¯ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹çš„ã«æ»ãã‚‹ã€‚ã¨ã„ã†æ„Ÿã˜ã§ãƒ¢ãƒ¤ãƒ¢ãƒ¤ã—ã¦ã„ãŸã®ã ãŒã€ã‚„ã£ã¨åˆç‚¹ãŒã„ã£ãŸã®ã§ãƒ¡ãƒ¢ã—ã¨ãã¾ã™ã€‚ master_info_repository FILEã®å ´åˆã€å¾“æ¥ã©ãŠã‚Šmaster.infoãƒ•ã‚¡ã‚¤ãƒ«ã«æ›¸ãã€‚ ãƒ•ã‚¡ã‚¤ãƒ«åã¯master_info_fileã«ã‚ˆã‚Šå¯å¤‰ã€‚ æ›´æ–°ãŒã‚ã‚‹ãŸã³(ãƒã‚¤
aki77 2013/11/25
mysql

replication
ãƒªãƒ³ã‚¯
redisã®master-slaveæ§‹æˆã§è€ƒãˆã‚‹ã¹ãã“ã¨ã®è©± - diary
çµè«– Redisã¯2.6ã‚’ä½¿ãŠã† master-slaveæ§‹æˆã‚’å–ã‚‹å ´åˆã¯client-output-buffer-limitã‚’ã¡ã‚ƒã‚“ã¨æ„è˜ã™ã‚‹ã¹ã æ¦‚è¦ redisã¯ã‚¨ãƒƒã‚¸ãƒˆãƒªã‚¬åž‹ã®non-blocking I/Oã‚’ç”¨ã„ã¦ã‚·ãƒ³ã‚°ãƒ«ã‚¹ãƒ¬ãƒƒãƒ‰ã§ã‚½ã‚±ãƒƒãƒˆã®èªã¿æ›¸ãã‚’ã¶ã‚“å›žã™æ§‹é€ ã§æ›¸ã‹ã‚Œã¦ã„ã¾ã™ã€‚ ã‚ˆã£ã¦clientã‚„slaveã¸å¯¾ã—ã¦ã®replyã‚’è¡Œã†éš›ã‚‚ã€ã‚½ã‚±ãƒƒãƒˆè‡ªä½“ã®é€ä¿¡ãƒãƒƒãƒ•ã‚¡ãŒæº¢ã‚ŒãŸéš›(EAGAINãŒå¸°ã£ãŸéš›)ã«ã¯ä¸€åº¦ã‚¤ãƒ™ãƒ³ãƒˆãƒ«ãƒ¼ãƒ—ã«å‡¦ç†ã‚’æˆ»ã—ã€ã¾ãŸã‚½ã‚±ãƒƒãƒˆãŒæ›¸ãè¾¼ã¿å¯èƒ½ã«ãªã£ã¦ã‚¤ãƒ™ãƒ³ãƒˆãƒ«ãƒ¼ãƒ—ãŒè‡ªåˆ†ã‚’å‘¼ã‚“ã§ãã‚ŒãŸæ™‚ã«ç¶šãã‚’writeã—ã¾ã™ã€‚ ã¾ã‚non-blocking I/Oãªã‚“ã ã‹ã‚‰å½“ãŸã‚Šå‰ãªã‚“ã§ã™ãŒã€é€ä¿¡å‡¦ç†ã‚’å†å…¥å¯èƒ½ã«ã™ã‚‹ãŸã‚ã«redisã¯ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ãƒ¬ãƒ™ãƒ«ã§å‡ºåŠ›ãƒãƒƒãƒ•ã‚¡ã‚’æŒã£ã¦ã„ã¾ã™ã€‚ ã“ã‚Œã¯é€ä¿¡ãŒçµ‚ã‚ã‚Šæ¬¡ç¬¬é©å®œè§£æ”¾ã•ã‚Œã‚‹ã‚‚ã®ã®ã€writeè‡ªä½“ãŒé–“ã«åˆã‚ãªããªã‚‹ã¨è©°ã¾ã£ã¦
aki77 2013/11/16
redis

replication
ãƒªãƒ³ã‚¯
MySQL :: MySQL 8.4 Reference Manual :: 19.5.1.36 Replication and Triggers
Binary Log File Position Based Replication Configuration Overview
aki77 2013/11/01
mysql

replication
ãƒªãƒ³ã‚¯
ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³æ™‚ã®RESET MASTERã¨RESET SLAVE â€“ OpenGroove
ã•ã£ããä¸€éƒ¨è¿½è¨˜ï¼ˆ2010/04/14)ã€‚ MySQLãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã«ãŠã„ã¦ç™ºè¡Œã™ã‚‹ã‚³ãƒžãƒ³ãƒ‰ã€RESET MASTERã¨RESET SLAVEã€ ãã‚Œãžã‚Œã®å‹•ä½œãƒ»æŒ™å‹•ã«ã¤ã„ã¦ã†ã£ã™ã‚‰ã¨ã¾ã¨ã‚ã¦ãŠãã€‚ãªãŠã€ã©ã¡ã‚‰ã‚‚ã‚¹ãƒ¬ãƒ¼ãƒ–å´ã§ å®Ÿè¡Œã™ã‚‹ã¨ã„ã†å‰æã§è©±ã‚’é€²ã‚ã‚‹ã€‚ RESET MASTER RESET MASTERæ–‡ã¯ã‚¹ãƒ¬ãƒ¼ãƒ–ãŒãƒžã‚¹ã‚¿ã«æ˜‡æ ¼ã™ã‚‹ãƒ•ã‚§ã‚¤ãƒ«ã‚ªãƒ¼ãƒãƒ¼æ™‚ã«ç™ºè¡Œã™ã‚‹ã€‚ ã“ã‚Œã«ã‚ˆã‚Šã€ã‚¹ãƒ¬ãƒ¼ãƒ–ã¯ãƒžã‚¹ã‚¿ã®ãƒã‚¤ãƒŠãƒªãƒã‚°ã‚’èªã¿ã«è¡Œãã®ã‚’ã‚¹ãƒˆãƒƒãƒ—ã™ã‚‹ã€‚ å…·ä½“çš„ã«ã¯ä»¥ä¸‹ã®çŠ¶æ…‹ã«ãªã‚‹ã€‚ ãƒã‚¤ãƒŠãƒªãƒã‚°ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ãƒ•ã‚¡ã‚¤ãƒ«ã‚’ç©ºç™½ã«ãƒªã‚»ãƒƒãƒˆã€‚ ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ãƒ•ã‚¡ã‚¤ãƒ«ã«ãƒªã‚¹ãƒˆã•ã‚ŒãŸã™ã¹ã¦ã®ãƒã‚¤ãƒŠãƒªãƒã‚°ã‚’å‰Šé™¤ã€‚ ãƒã‚¤ãƒŠãƒªãƒã‚°ãŒã™ã¹ã¦æ¶ˆãˆã¦ãªããªã‚‹ã®ã§ã¯ãªãã€ä¾‹ãˆã°bin-log.000019ã¾ã§ã‚ã£ãŸ ãƒã‚¤ãƒŠãƒªãƒã‚°ã¯ãƒªã‚»ãƒƒãƒˆã•ã‚Œã€bin-log.000001ã®ã¿ãŒå˜åœ¨ã™ã‚‹çŠ¶æ…‹ã«ãªã‚‹ã€‚ RESET SLAVE RES
aki77 2013/08/19
mysql

replication
ãƒªãƒ³ã‚¯
MySQLã®ã‚¹ãƒ¬ãƒ¼ãƒ–ã‚µãƒ¼ãƒã‚’åˆ¥ã‚µãƒ¼ãƒã«ç§»è¨ã™ã‚‹æ™‚ã«æ³¨æ„ã™ã‚‹ã“ã¨ Â· ã•ã‚ˆãªã‚‰ã‚¤ãƒ³ã‚¿ãƒ¼ãƒãƒƒãƒˆ
August 12, 2013 ç§»è¨å…ƒã®ã‚¹ãƒ¬ãƒ¼ãƒ–ã‚µãƒ¼ãƒã®MySQLãŒåœæ¢ã§ãã‚‹å ´åˆ ç§»è¨å…ˆã®ã‚¹ãƒ¬ãƒ¼ãƒ–ã‚µãƒ¼ãƒã§ CREATE DATABASEã—ã¦ master.infoã‹ã‚‰replãƒ¦ãƒ¼ã‚¶ä½œæˆã—ã¦ dumpãƒ•ã‚¡ã‚¤ãƒ«ã‚’ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã‚µãƒ¼ãƒã‹ã‚‰æŒã£ã¦ãã¦ã€œ ãªã©ã®ä½œæ¥ã‚’è¡Œã‚ãªãã¦ã‚‚SLAVE STOPã— MySQLã‚’è½ã¨ã—å¤‰æ›´ãŒèµ°ã‚‰ãªã„çŠ¶æ…‹ã«ã—ã¦ MySQLã®ãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªã‚’ç§»è¨å…ˆã«rsyncã§æ¸¡ã—ãŸæ–¹ãŒæ‰‹é–“ã‚‚å‡¦ç†é€Ÿåº¦ã‚‚é¥ã‹ã«é€Ÿã„ã€‚ ãŸã ã—ã€ç§»è¨å…ˆã§MySQLã‚’èµ·å‹•ã—ã¦SLAVE STARTã‚’ã™ã‚‹ã¨ Could not find target log during relay log initialization rellay.log ã“ã®ã‚ˆã†ã«relay_logãŒè¦‹ã¤ã‹ã‚‰ãªã„ã‚ˆã€‚ã¨ã„ã†ã‚¨ãƒ©ãƒ¼ãŒç™ºç”Ÿã™ã‚‹ã€‚ 16.2.2.1. The Slave Relay Log / MySQL 5.1 Refer
aki77 2013/08/13
mysql

replication
ãƒªãƒ³ã‚¯
MySQLãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã«ãŠã‘ã‚‹ãƒ•ã‚§ã‚¤ãƒ«ã‚ªãƒ¼ãƒãƒ¼ â€“ OpenGroove
MySQLãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã«ãŠã„ã¦ã€ã‚¹ãƒ¬ãƒ¼ãƒ–ã‚’ãƒžã‚¹ã‚¿ã¨ã—ã¦ãƒ•ã‚§ã‚¤ãƒ«ã‚ªãƒ¼ãƒãƒ¼ã•ã›ã‚‹æ™‚ã« ã‚„ã‚‹ã“ã¨ã‚’ã–ã£ãã‚Šã¾ã¨ã‚ã¦ã¿ãŸã€‚ ãƒžã‚¹ã‚¿ã§ã¯éšœå®³ç‰ã«ã‚ˆã‚ŠMySQLã‚¤ãƒ³ã‚¹ã‚¿ãƒ³ã‚¹ãŒåœæ¢ã—ã¦ã„ã‚‹ã“ã¨ãŒå‰æã€‚ ãƒžã‚¹ã‚¿1:ã‚¹ãƒ¬ãƒ¼ãƒ–1æ§‹æˆã®å ´åˆ 1.ãƒžã‚¹ã‚¿ã«æ˜‡æ ¼ã™ã‚‹ã‚¹ãƒ¬ãƒ¼ãƒ–ã«STOP SLAVEã‚’ç™ºè¡Œã€‚ 2.ãƒžã‚¹ã‚¿ã«æ˜‡æ ¼ã™ã‚‹ã‚¹ãƒ¬ãƒ¼ãƒ–ã«RESET MASTERã‚’ç™ºè¡Œã€‚ 3.ã‚¹ãƒ¬ãƒ¼ãƒ–ã«é™æ ¼ã™ã‚‹ãƒžã‚·ãƒ³ã§CHANGE MASTER ã‚’å®Ÿè¡Œã—ã€ START SLAVEã™ã‚‹ã€‚ ã‚‚ã†å°‘ã—è©³ã—ãæ›¸ãã¨ã€‚ 1.ã‚¹ãƒ¬ãƒ¼ãƒ–å´ã§IOã‚¹ãƒ¬ãƒƒãƒ‰ã§ã®ãƒã‚¤ãƒŠãƒªãƒã‚°å—ã‘æ¸¡ã—ãŒå®Œäº†ã™ã‚‹é ƒã‚’è¦‹è¨ˆã‚‰ã£ã¦ã€ STOP SLAVE IO_THREAD ã‚’ç™ºè¡Œã€‚ mysql > STOP SLAVE IO_THREAD; â€œHas read all relay logâ€ã‚’ç¢ºèªã§ãã¾ã‚‹ã¾ã§ã€SHOW PROCESSLIST ã®å‡ºåŠ›çµæžœã‚’ãƒã‚§ãƒƒã‚¯ã™ã‚‹ã€‚ 2.ã‚¹
aki77 2013/08/06
mysql

replication
ãƒªãƒ³ã‚¯
yrmcds 0.9.0 ãƒªãƒªãƒ¼ã‚¹ - Cybozu Inside Out | ã‚µã‚¤ãƒœã‚¦ã‚ºã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®ãƒ–ãƒã‚°
@ymmt2005 ã“ã¨å±±æœ¬æ³°å®‡ã§ã™ã€‚ ä»Šå›žã¯ memcached äº’æ›ã§å†—é•·æ§‹æˆã‚’ç°¡å˜ã«çµ„ã‚ã‚‹è‡ªç¤¾è£½ KVS ã§ã‚ã‚‹ yrmcds ã®ãƒªãƒªãƒ¼ã‚¹ã‚’ã”æ¡ˆå†…ã—ã¾ã™ã€‚ ... ã“ã® Redis å…¨ç››ãªã”æ™‚ä¸–ã«ãªã‚“ã§ï¼Ÿã¨ã‹ã€repcached ã‚„ Kyoto Tycoon ãŒã‚ã‚‹ã˜ã‚ƒãªã„ã€ã¨ã„ã£ãŸãƒ„ãƒƒã‚³ãƒŸã®åµãŒèžãˆã¦ããã†ã§ã™ã€‚ã‚ã‹ã£ã¦ã¾ã™ã€ã‚ã‹ã£ã¦ã¾ã™ã‹ã‚‰ç‰©ã‚’æŠ•ã’ãªã„ã§ï¼ é †ã‚’è¿½ã£ã¦èª¬æ˜Žã—ã¾ã™ã®ã§ã€æ‰¹åˆ¤ã¯ãã‚Œã‹ã‚‰ã«ã—ã¦ãã ã•ã„ï¼ ä½•ãŒæ¬²ã—ã„ã®ã‹ ç§ã¯æ—¥é ƒ cybozu.com ã®ã‚¤ãƒ³ãƒ•ãƒ©ã§å‹•ä½œã™ã‚‹ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã‚’é–‹ç™ºã—ã¦ã„ã¾ã™ã€‚ãƒªãƒªãƒ¼ã‚¹å¾Œã‚‚ã†ã™ãï¼’å¹´ã«ãªã‚Šã¾ã™ãŒã€ãŠè”æ§˜ã§ 4,000 ç¤¾ä»¥ä¸Šã«ã”åˆ©ç”¨ã„ãŸã ãã¾ã§ã«ãªã‚Šã¾ã—ãŸã€‚å•†å£²ç¹ç››ã§å¬‰ã—ã„ã®ã§ã™ãŒã€é‹ç”¨å´ã¯æ—¥ã€…å¢—ãˆã‚‹ãƒ‡ãƒ¼ã‚¿ã¨ã‚¢ã‚¯ã‚»ã‚¹ã‚’æŒãã¹ãå¥®é—˜ã—ã¦ã„ã¾ã™ã€‚ ã“ã“ã®ã¨ã“ã‚å•é¡Œã«ãªã£ã¦ã„ãŸã®ãŒã€MySQL ã«ä¿å˜ã—ã¦ã„ã‚‹ã‚»ãƒƒã‚·ãƒ§ãƒ³æƒ…å ±ã§ã—ãŸã€‚ã‚¢ãƒ—ãƒª
aki77 2013/07/09
memcached

replication
ãƒªãƒ³ã‚¯
ã¾ã™ã¾ã™é€²åŒ–ã—ãŸMySQL-5.6ã®ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³çŠ¶æ³å‡ºåŠ›ï¼ˆSHOW SLAVE STATUSæ§‹æ–‡ï¼‰ã‚’MySQL-5.0ã¨æ¯”è¼ƒã™ã‚‹ - Y-Ken Studio
MySQL-5.6ã§ã¯SHOW SLAVE STATUS;ã®å‡ºåŠ›ãŒå¤§å¹…ã«å¤‰ã‚ã‚Šã¾ã—ãŸã€‚ å¬‰ã—ã„ãƒã‚¤ãƒ³ãƒˆã¨ã—ã¦ã¯ã€Last_SQL_Error_Timestampã¨ã„ã†ã‚«ãƒ©ãƒ ãŒå¢—ãˆãŸã“ã¨ã§ã™ã€‚ ã“ã‚Œã¯ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚¨ãƒ©ãƒ¼ãŒèµ·ããŸéš›ã€ãã‚ŒãŒä½•æ™‚ä½•åˆ†ã«èµ·ããŸã®ã‹ãŒåˆ†ã‹ã‚‹ã®ã§ã™ã€‚ å¾“æ¥ã§ã‚ã‚Œã°ã‚µãƒ¼ãƒã®mysqld.logã‚’ç¢ºèªã™ã‚‹å¿…è¦ãŒã‚ã‚Šã¾ã—ãŸãŒã€ãã®å¿…è¦ã¯ã‚ã‚Šã¾ã›ã‚“ã€‚ ã¾ã™ã¾ã™é€²åŒ–ã—ãŸMySQL-5.6ã®SHOW SLAVE STATUSæ§‹æ–‡ã®å‡ºåŠ›çµæžœã‚’è¿½ã£ã¦ã¿ã¾ã—ã‚‡ã†ï¼ ã©ã†å¤‰ã‚ã£ãŸã‹ MySQL-5.0ã§ã¯SHOW SLAVE STATUSã®çµæžœã¯33è¡Œã§ã—ãŸã€‚ MySQL-5.1/5.5ã‚’çµŒã¦ã€5.6ã§ã¯54è¡Œã«ã‚‚å¢—ãˆã¾ã—ãŸã€‚ æ–°ã—ã„21ã®ã‚«ãƒ©ãƒ ç§ãŒæ³¨ç›®ã™ã‚‹ã€4ã¤ã®æ–°æ©Ÿèƒ½ã‹ã‚‰ç´¹ä»‹ã—ã¾ã™ã€‚ é…å»¶ã‚¹ãƒ¬ãƒ¼ãƒ–ã®å‹•ä½œçŠ¶æ³ãŒè¦‹ãˆã‚‹ SQL_Delay SQL_Rem aining_Delay De
aki77 2013/05/29
mysql

replication
ãƒªãƒ³ã‚¯
MySQL :: MySQL 8.4 Reference Manual :: 19.4.11 Delayed Replication
Binary Log File Position Based Replication Configuration Overview
aki77 2013/05/28
slaveã®ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’æ„å›³çš„ã«é…å»¶

replication

mysql
ãƒªãƒ³ã‚¯
MySQL5.6ã®ãƒžã‚¹ã‚¿ãƒ¼ã«MySQL5.5(ã¨ãã‚Œä»¥å‰)ã®ã‚¹ãƒ¬ãƒ¼ãƒ–ã‚’ã¶ã‚‰ä¸‹ã’ã‚‹ã¨ã‚¨ãƒ©ã‚‹
ã±ã£ã¨è¦‹ã€èª°ã‚‚æ›¸ã„ã¦ãªã•ãã†ãªã®ã§ã€‚ MySQL 5.6ã§ã¯ãƒã‚¤ãƒŠãƒªãƒã‚°ã®ãƒã‚§ãƒƒã‚¯ã‚µãƒ (binlog_checksum)ãŒè¿½åŠ ã•ã‚Œã€ ã—ã‹ã‚‚ãã‚ŒãŒ5.6.5ä»¥é™ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã§æœ‰åŠ¹ã«ãªã£ã¦ã„ã‚‹ã®ã§ã€ 5.5ã‚’ã‚¹ãƒ¬ãƒ¼ãƒ–ã«ã—ã¦æ§‹æˆã™ã‚‹ã¨I/O ThreadãŒErr:1236ã§æ¢ã¾ã‚‹ã€‚ mysql55> SHOW SLAVE STATUS\G *************************** 1. row *************************** Slave_IO_State: Master_Host: localhost Master_User: replicator Master_Port: 64056 Connect_Retry: 60 Master_Log_File: bin.000007 Read_Master_Log_Pos: 4 Relay_Log_File: re
aki77 2013/05/28
mysql

replication
ãƒªãƒ³ã‚¯
rowãƒ™ãƒ¼ã‚¹ã®ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³æ™‚ã«ã‚¹ãƒ†ãƒ¼ãƒˆãƒ¡ãƒ³ãƒˆã‚‚ãƒã‚¤ãƒŠãƒªãƒã‚°ã«ä¿å˜ã™ã‚‹ - hiroi10ã®ãƒ–ãƒã‚°
MySQL5.6ã‹ã‚‰rowãƒ™ãƒ¼ã‚¹ã®ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’ä½¿ç”¨ã—ã¦ã„ã‚‹å ´åˆã§ã‚‚ã‚¹ãƒ†ãƒ¼ãƒˆãƒ¡ãƒ³ãƒˆ(ã‚¯ã‚¨ãƒª)ã‚’ã‚³ãƒ¡ãƒ³ãƒˆã¨ã—ã¦ãƒã‚¤ãƒŠãƒªãƒã‚°ã«è¨˜éŒ²ã™ã‚‹ã‚ªãƒ—ã‚·ãƒ§ãƒ³(binlog_rows_query_log_events)ãŒè¿½åŠ ã•ã‚Œã¦ã„ã¾ã™ã€‚ ã“ã®ã‚ªãƒ—ã‚·ãƒ§ãƒ³ã‚’åˆ©ç”¨ã™ã‚‹ã“ã¨ã§rowãƒ™ãƒ¼ã‚¹ã§ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã•ã‚ŒãŸã‚¯ã‚¨ãƒªãŒç¢ºèªã—æ˜“ããªã‚Šã¾ã™ã€‚ ãƒžãƒ‹ãƒ¥ã‚¢ãƒ« binlog_rows_query_log_events å‹•ä½œç¢ºèªç’°å¢ƒ CentOS 6.3 x86_64(KVMã‚²ã‚¹ãƒˆ) MySQL 5.6.10 binlog_rows_query_log_eventsãŒç„¡åŠ¹ãªå ´åˆ mysqlbinlogã‚³ãƒžãƒ³ãƒ‰ã«-vã‚ªãƒ—ã‚·ãƒ§ãƒ³ã‚’ä½¿ã†äº‹ã§ã‚ã‚‹ç¨‹åº¦ã¯æŠŠæ¡ãŒå¯èƒ½ã§ã—ãŸã€‚ä»¥ä¸‹ä¾‹ã¯binlog_rows_query_log_eventsãŒç„¡åŠ¹ãªå ´åˆã®è¡¨ç¤ºä¾‹ã§ã™ã€‚ ãƒ†ãƒ¼ãƒ–ãƒ«å®šç¾©ã¨è¨å®š mysql> show create table
aki77 2013/05/28
mysql

replication
ãƒªãƒ³ã‚¯
MySQL-5.5/5.6ã§ã®ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³åˆ©ç”¨è€…ã«ä¼ãˆãŸã„ã€ŒRESET SLAVEã€ã«ã¾ã¤ã‚ã‚‹æ€–ã„è©± - Y-Ken Studio
MySQL-5.5ã‚ˆã‚ŠRESET SLAVE;ã®æŒ™å‹•ãŒå¤‰ã‚ã‚Šã€ç›´å¾Œã«CHANGE MASTERæ§‹æ–‡ã‚’ ç™ºè¡Œã—ãªã„ã¨å ´åˆã«ã‚ˆã£ã¦ã¯å•é¡ŒãŒç™ºç”Ÿã™ã‚‹ã¨MySQLã®ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã«è¨˜è¼‰ã•ã‚Œã¦ã„ã¾ã—ãŸã€‚ ã•ã‚‰ã«ã€RESET SLAVE ALL;ã¨ã„ã†ã‚¯ã‚¨ãƒªã‚‚ã‚µãƒãƒ¼ãƒˆã•ã‚ŒãŸã‚ˆã†ã§ã™ã€‚ ã©ã†ã„ã†äº‹ãªã®ã§ã—ã‚‡ã†ï¼Ÿ èª¿ã¹ã¦ã¿ã¾ã—ãŸã€‚ ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã«ã•ã‚‰ã£ã¨ä½•ã‹æ›¸ã„ã¦ã‚ã‚‹ In MySQL 5.6 (unlike the case in MySQL 5.1 and earlier), RESET SLAVE does not change any replication connection parameters such as master host, master port, master user, or master password, which are retained in memory. Thi
aki77 2013/05/20
mysql

replication
ãƒªãƒ³ã‚¯
Chef mysql master/slave recipes
aki77 2013/05/16
chef

mysql

replication
ãƒªãƒ³ã‚¯
MySQL5.6ã¨MySQL5.0ã®ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã§I/Oã‚¹ãƒ¬ãƒƒãƒ‰ãŒError: 2049
MySQL5.6ã‚’ã‚¹ãƒ¬ãƒ¼ãƒ–ã«ã€old_passwords = 1ãªMySQL5.0ã‚’ãƒžã‚¹ã‚¿ãƒ¼ã«ã—ã¦ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’çµ„ã‚‚ã†ã¨ã™ã‚‹ã¨ã€ mysql56> show slave status\G *************************** 1. row *************************** Slave_IO_State: Connecting to master Master_Host: localhost Master_User: replicator Master_Port: 64050 Connect_Retry: 60 Master_Log_File: bin.000019 Read_Master_Log_Pos: 820 Relay_Log_File: relay.000001 Relay_Log_Pos: 4 Relay_Master_Log_File
aki77 2013/05/10
mysql

replication
ãƒªãƒ³ã‚¯
conma.me
This domain may be for sale!
aki77 2013/04/24
5.6

mysql

replication
ãƒªãƒ³ã‚¯
MySQLã§statement-based replicationã‚’ä½¿ã£ã¦ã„ã‚‹å ´åˆã®trigger, function, procedureã®æ‰±ã„ - æ„›ã¨å‹‡æ°—ã¨ç¼¶ãƒ“ãƒ¼ãƒ«
row-basedãªreplicationã®å ´åˆã¯replicationã®å¯¾è±¡ãŒæ–‡å—é€šã‚Šrow=dataã§ã‚ã‚‹ãŸã‚ç‰¹ã«trigger, function, procedureã®å‹•ä½œã«ã¤ã„ã¦æ‡¸å¿µç‚¹ã¯ãªã„ã¨æ€ã‚ã‚Œã¾ã™ã€‚ã§ã‚‚ã€MySQLã§æ—¢ã«å¤šãã®äººãŒä½¿ã£ã¦ã„ã‚‹ã§ã‚ã‚ã†statement-basedãªreplicationã®å ´åˆã¯ã©ã†ãªã‚‹ã®ï¼Ÿmasterã ã‘ã§å®Ÿè¡Œã•ã‚Œã‚‹ã®ï¼Ÿãã‚Œã¨ã‚‚ä¸¡æ–¹ã§å®Ÿè¡Œã•ã‚Œã‚‹ã®ï¼Ÿä¸¡æ–¹ã§å®Ÿè¡Œã•ã‚Œã‚‹ã¨ã—ãŸã‚‰ãƒ‡ãƒ¼ã‚¿ã®æ•´åˆæ€§ã¨ã‹ã¯ã©ã†ãªã‚‹ã®ï¼Ÿ ã“ã‚Œã‚‰ã®ç–‘å•ã¸ã®ç”ãˆã¯ã ã„ãŸã„ä»¥ä¸‹ã®ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã«æ›¸ã„ã¦ã‚ã‚‹ã‚ˆã†ã§ã™ãŒã€æ—¥æœ¬èªžç‰ˆã¯ã€ŒãŠå‰ã¯ä½•ã‚’è¨€ã£ã¦ã„ã‚‹ã‚“ã ã€ã¨ã„ã†éƒ¨åˆ†ãŒå¤šã€…ã‚ã‚Šã€è‹±èªžç‰ˆã‚’èªã‚“ã§ã‚‚ã‚ã¾ã‚Šå®Ÿéš›ã®å‹•ä½œãŒã‚¤ãƒ¡ãƒ¼ã‚¸ã§ããªã‹ã£ãŸã®ã§ç¢ºèªã‚’å…¼ãã¦è‡ªåˆ†ã§è©¦ã™ã“ã¨ã«ã—ã¾ã—ãŸã€‚ http://dev.mysql.com/doc/refman/5.1/en/replication-featur
aki77 2013/01/12
mysql

replication
ãƒªãƒ³ã‚¯
ç¨¼åƒä¸ã®MySQLã«ç„¡åœæ¢ã§ã‚¹ãƒ¬ãƒ¼ãƒ–ã‚’è¿½åŠ ã™ã‚‹ - é›‘è¨˜å¸³(2011-10-17)
â– [MySQL] ç¨¼åƒä¸ã®MySQLã«ç„¡åœæ¢ã§ã‚¹ãƒ¬ãƒ¼ãƒ–ã‚’è¿½åŠ ã™ã‚‹ MySQLã¯ç°¡å˜ã«ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã™ã‚‹ã“ã¨ãŒã§ãã¦ä¾¿åˆ©ã€‚æœ€åˆã‹ã‚‰ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’å‰æã«æ§‹ç¯‰ã™ã‚‹ã®ã¯ç°¡å˜ã«ã§ãã‚‹ã€‚ã—ã‹ã—ã€å®Ÿã¯é‹ç”¨ãŒå§‹ã¾ã£ã¦ã—ã¾ã£ã¦ã€ãªã‹ãªã‹åœæ¢ã§ããªã„MySQLã«ã‚‚ã€ã»ã¼ç„¡åœæ¢ã§ã‚¹ãƒ¬ãƒ¼ãƒ–ã‚µãƒ¼ãƒã‚’è¿½åŠ ã§ãã‚‹ã€‚ç¾åœ¨ã®è¨å®šçŠ¶æ³ã«ã‚‚ã‚ˆã‚‹ãŒã€å†èµ·å‹•ã¯å¿…è¦ã«ãªã‚‹ã‹ã‚‚ã€‚ ãƒžã‚¹ã‚¿ãƒ¼ã§ãƒã‚¤ãƒŠãƒªãƒã‚°ã‚’å‡ºåŠ›ã™ã‚‹ã‚ˆã†ã«ã™ã‚‹ my.cnfã§ã€binlog_do_dbã®è¨å®šã‚’ã™ã‚‹ã€‚ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³å¯¾è±¡ã¨ãªã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’æŒ‡å®šã™ã‚‹ã€‚ [mysqld] binlog_do_db=your_db ãƒžã‚¹ã‚¿ã®server_idã‚’è¨å®šã™ã‚‹ my.cnf ã§ server_idã®è¨å®šã‚’ã™ã‚‹ã€‚ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã™ã‚‹éš›ã«ã€å€‹ã€…ã®ã‚µãƒ¼ãƒã‚’è˜åˆ¥ã™ã‚‹ã®ã«ä½¿ã‚ã‚Œã‚‹ã€‚ä»»æ„ã®ãƒ¦ãƒ‹ãƒ¼ã‚¯ãªæ•´æ•°ã‚’æŒ‡å®šã™ã‚Œã°è‰¯ã„ã€‚ [mysqld] server_id=10 ã“ã“ã¾ã§ã®
aki77 2012/10/12
mysql

replication
ãƒªãƒ³ã‚¯
1 2 æ¬¡ã®ãƒšãƒ¼ã‚¸