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

wozozo id:wozozo

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

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

ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ä½œæˆã‚’ç°¡å˜ã«ã™ã‚‹ mysql40dump ã¨ã„ã† mysqldump ã® wrapper ã‚’ä½œã£ãŸè©± - blog.nomadscafe.jp
ã¿ãªã•ã‚“ mysqldump ã¯å¥½ãã§ã™ã‹ï¼Ÿ è‡ªåˆ†ã¯ã©ã£ã¡ã§ã‚‚ã‚ã‚Šã¾ã›ã‚“ã€‚ MySQLã§ã‚ˆãã‚ã‚‹Master-Slaveæ§‹æˆã‚’ä½œã‚‹æ‰‹é †ã¯ä»¥ä¸‹ã®ã‚ˆã†ã«ãªã‚‹ã¨æ€ã„ã¾ã™ Masterã‹ã‚‰Slaveã¨ãªã‚‹ã‚µãƒ¼ãƒã«ä¸€è²«æ€§ã‚’ä¿ã£ãŸçŠ¶æ…‹ã®ã‚³ãƒ”ãƒ¼ã‚’ã—ã€ãã®ãƒ‡ãƒ¼ã‚¿ã®ãƒã‚¤ãƒŠãƒªãƒã‚°ã®ãƒ•ã‚¡ã‚¤ãƒ«ãƒ»ãƒã‚¸ã‚·ãƒ§ãƒ³ã‚’ãƒ¡ãƒ¢ã€‚ SLAVEã§ãƒ‡ãƒ¼ã‚¿ã‚’ãƒªã‚¹ãƒˆã‚¢ã—ã€Masterã®ãƒ›ã‚¹ãƒˆåã€ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã«ä½¿ã†ãƒ¦ãƒ¼ã‚¶åãƒ»ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ã¨ãƒ¡ãƒ¢ã—ãŸãƒã‚¤ãƒŠãƒªãƒã‚°ã®ãƒã‚¸ã‚·ãƒ§ãƒ³ã‚’CHANGE MASTERæ–‡ã«æ¸¡ã—ã€START SLAVE ä¸€è²«æ€§ã®å–ã‚ŒãŸã‚³ãƒ”ãƒ¼ã‚’ä½œæˆã™ã‚‹ãŸã‚ã«mysqldumpã‚„xtrabackupã€LVMãªã©ã§ã®ã‚¹ãƒŠãƒƒãƒ—ã‚·ãƒ§ãƒƒãƒˆãŒåˆ©ç”¨ã§ãã¾ã™ãŒã€ã‚‚ã£ã¨ã‚‚ç°¡å˜ãªæ–¹æ³•ãŒmysqldumpã ã¨æ€ã„ã¾ã™ã€‚ mysqldumpã§ä¸€è²«æ€§ã®ã‚ã‚‹ãƒ‡ãƒ¼ã‚¿ã‚’ã¨ã‚Šã€ãã®éš›ã®ãƒã‚¤ãƒŠãƒªãƒã‚°ãƒã‚¸ã‚·ãƒ§ãƒ³ã‚’è¨˜éŒ²ã™ã‚‹ã«ã¯ $ mysqldump --single-
wozozo 2012/01/09
mysql

replication
ãƒªãƒ³ã‚¯
Reasons for MySQL Replication Lag
One common theme in the questions our MySQL Support customers ask is MySQL Replication Lag. The story is typically along the lines everything is same as before and for some unknown reason the slave is started to lag and not catching up any more. I always smile at â€œnothing has changedâ€ claim as it usually wrong, and one should claim Iâ€™m not aware of any change. Digging deeper we would find some cha
wozozo 2011/07/30
mysql

replication
ãƒªãƒ³ã‚¯
PostgreSQLãƒ¦ãƒ¼ã‚¶ã®ãŸã‚ã®MySQLãƒã‚¤ãƒŠãƒªãƒã‚°ãƒ»ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³è¬›åº§ - interdbâ€™s blog
Original Streaming Replicationæè¼‰ã®PostgreSQL9.0ãƒªãƒªãƒ¼ã‚¹ãŒè¿‘ã¥ãã€MySQLã¨ã®ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³æ¯”è¼ƒãŒä»Šå¾Œã¾ã™ã¾ã™ç››ã‚“ã«ãªã‚‹ã¨æ€ã‚ã‚Œã‚‹ã®ã§ã€PostgreSQLãƒ¦ãƒ¼ã‚¶å‘ã‘ã«MySQLã®èª¬æ˜Žã‚’è¡Œã†ã€‚ å‚è€ƒ->MySQLãƒ¦ãƒ¼ã‚¶ã®ãŸã‚ã®PostgreSQL:WALãƒã‚°ã¨ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³è¬›åº§ ãªãŠã€ãªãœæœ€åˆã«å»¶ã€…ã¨ãƒã‚¤ãƒŠãƒªãƒã‚°ã‚’èª¬æ˜Žã™ã‚‹ã‹ã¨ã„ãˆã°ã€MySQLã®ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã§ãƒžã‚¹ã‚¿ã‹ã‚‰ã‚¹ãƒ¬ãƒ¼ãƒ–ã«é€ã‚‹ã®ã¯ã€ãƒã‚¤ãƒŠãƒªãƒã‚°ã®ãƒ‡ãƒ¼ã‚¿ã ã‹ã‚‰ã§ã‚ã‚‹ã€‚ [ãƒ¬ãƒ™ãƒ«:1] MySQLã®ãƒã‚¤ãƒŠãƒªãƒã‚° MySQLã«ã¯WALãƒã‚°ã«ç›´æŽ¥å¯¾å¿œã™ã‚‹ã‚‚ã®ã¯ãªã„ã€‚ç†ç”±ã¯MySQLãŒãƒžãƒ«ãƒã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã ã‹ã‚‰ã§ã‚ã‚‹ã€‚ ãƒžãƒ«ãƒã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã«ã¤ã„ã¦ã¯å¾Œè¿°ã™ã‚‹ã®ã§ã“ã“ã§ã¯ç°¡å˜ã«èª¬æ˜Žã™ã‚‹ã¨ã€ MySQLã¯ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³æ©Ÿèƒ½ã‚ã‚Šã®InnoDBåž‹ã¨ã„ã†ãƒ†ãƒ¼ãƒ–ãƒ«ã‚„ã€ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³æ©Ÿèƒ½ãªã—
wozozo 2010/08/26
mysql

replication
ãƒªãƒ³ã‚¯
MySQLã§ã®ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®è¨å®š - KAWANO's PukiWiki
ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã¨ã¯ é€šå¸¸ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’åˆ¥ã®ã‚µãƒ¼ãƒã«è¤‡è£½ã™ã‚‹ã“ã¨ã‚’ã€ã€Œãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã€ã¨ã„ã†ã€‚ ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®ãƒ¡ãƒªãƒƒãƒˆã¯ã€æ¬¡ã®ã¨ãŠã‚Šã€‚ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ— ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®å†—é•·åŒ– ã‚µãƒ¼ãƒã®è² è·åˆ†æ•£ MySQLã¯æ¨™æº–ã§ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³æ©Ÿèƒ½ã‚’å‚™ãˆã¦ã„ã‚‹ãŒã€ ãã®æ–¹å¼ã¯ã€Œãƒžã‚¹ã‚¿-ã‚¹ãƒ¬ãƒ¼ãƒ–æ–¹å¼ã€ã§ã€ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®æ›´æ–°ã‚’å—ã‘ä»˜ã‘ã‚‹ã€Œãƒžã‚¹ã‚¿ã€ã¨ã€ ãƒžã‚¹ã‚¿ã‹ã‚‰ä¼æ¬ã•ã‚ŒãŸãƒ‡ãƒ¼ã‚¿ã‚’å—ã‘ä»˜ã‘ã‚‹ã€Œã‚¹ãƒ¬ãƒ¼ãƒ–ã€ã‹ã‚‰ãªã‚‹ã€ ä¸€æ–¹é€šè¡Œã®è¤‡è£½ã«ãªã‚‹ã€‚ ç´°ã‹ã„ã“ã¨ã¯ã€å‚ç…§å…ˆã®ãƒšãƒ¼ã‚¸ã‚’è¦‹ã‚‹ã“ã¨ã€‚ â–²Â â–¼ ä»Šå›žã®ç›®çš„ ã¾ã£ãŸãåŒä¸€æ§‹æˆã®2å°ã®ãƒžã‚·ãƒ³ãŒã‚ã‚‹ã®ã§ã€ 1å°ã‚’ãƒžã‚¹ã‚¿ã€ã‚‚ã†1å°ã‚’ã‚¹ãƒ¬ãƒ¼ãƒ–ã«ã—ã¦ã€ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã¨å†—é•·åŒ–ã‚’ã¯ã‹ã‚‹ã€‚ â–²Â â–¼ ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ç”¨ã®ãƒ¦ãƒ¼ã‚¶ã®ä½œæˆ ã‚¹ãƒ¬ãƒ¼ãƒ–ãŒãƒžã‚¹ã‚¿ã«æŽ¥ç¶šã™ã‚‹ãŸã‚ã®å°‚ç”¨ãƒ¦ãƒ¼ã‚¶ã‚’ã€ãƒžã‚¹ã‚¿ã§ä½œæˆã™ã‚‹ã€‚ ä¸Žãˆã‚‹æ¨©é™ã¯ã€ŒREPLICATIONã€ã€ŒSLAVEã€
wozozo 2009/12/21
mysql

replication
ãƒªãƒ³ã‚¯
How To Set Up Database Replication In MySQL
This is a "copy & paste" HowTo! The easiest way to follow this tutorial is to use a command line client/SSH client (like PuTTY for Windows) and simply copy and paste the commands (except where you have to provide own information like IP addresses, hostnames, passwords,...). This helps to avoid typos. How To Set Up Database Replication In MySQL Version 1.1 Author: Falko Timme Last edited: 01/14/200
wozozo 2009/10/17
mysql

replication
ãƒªãƒ³ã‚¯
http://blog.suz-lab.com/2009/07/mysql.html
wozozo 2009/07/29
mysql

replication
ãƒªãƒ³ã‚¯
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ã®è¨å®šãŒå…¥ã£ã¦ã„ã‚‹ã“ã¨ã‚’ç¢º
wozozo 2009/07/29
mysql

replication
ãƒªãƒ³ã‚¯
MySQLã®ãƒ¬ãƒ—ãƒªé…å»¶ã®åŽŸå› ã‚’èª¿ã¹ã‚‹æ–¹æ³• | dTblog | ãƒ‡ã‚¶ã‚¤ãƒ³ã¨ãƒ—ãƒã‚°ãƒ©ãƒ ã®å¢ƒç•Œã‚’ã•ã¾ã‚ˆã†ãƒ–ãƒã‚°
MySQLã®ãƒ¬ãƒ—ãƒªé…å»¶ã®åŽŸå› ã«ã¯ã€å¤§ããåˆ†ã‘ã¦ã€è»¢é€é…å»¶ã¨SQLå®Ÿè¡Œé…å»¶ã®2ã¤ãŒã‚ã‚Šã¾ã™ã€‚ è»¢é€é…å»¶ã¯ã€ãƒžã‚¹ã‚¿ã§ãƒã‚¤ãƒŠãƒªãƒã‚°ã«å‡ºåŠ›ã•ã‚ŒãŸSQLã‚¯ã‚¨ãƒªãŒã€ã‚¹ãƒ¬ãƒ¼ãƒ–ã®ãƒªãƒ¬ãƒ¼ãƒã‚°ã«å‡ºåŠ›ã•ã‚Œã¦ã„ãªã„ã‚±ãƒ¼ã‚¹ã€‚SQLå®Ÿè¡Œé…å»¶ã¯ã€SQLã‚¯ã‚¨ãƒªãŒãƒªãƒ¬ãƒ¼ãƒã‚°ã«å‡ºåŠ›ã•ã‚ŒãŸãŒã€å®Ÿè¡ŒãŒé…ã‚Œã¦ã„ã‚‹ã‚±ãƒ¼ã‚¹ã€‚ãƒ¬ãƒ—ãƒªé…å»¶æ™‚ã®å•é¡Œã®åˆ‡ã‚Šåˆ†ã‘ã¨ã—ã¦ã€ã¾ãšã©ã¡ã‚‰ã®ã‚±ãƒ¼ã‚¹ã«è©²å½“ã—ã¦ã„ã‚‹ã‹ã‚’åˆ¤æ–ã™ã‚‹å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚ è»¢é€é…å»¶ã®åˆ¤å®šæ–¹æ³• ãƒžã‚¹ã‚¿ã§ã® SHOW MASTER STATUS ã®çµæžœã¨ã€å¯¾è±¡ã‚¹ãƒ¬ãƒ¼ãƒ–ã§ã® SHOW SLAVE STATUS ã®çµæžœã‚’æ¯”è¼ƒã—ã¾ã™ã€‚æ¯”è¼ƒã™ã‚‹é …ç›®ã¯ã€ä»¥ä¸‹ã®ã¨ãŠã‚Šã€‚ æ¯”è¼ƒå…ƒ(MASTER)æ¯”è¼ƒå…ˆ(SLAVE)èª¬æ˜Ž
wozozo 2009/06/10
mysql

replication
ãƒªãƒ³ã‚¯
ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®é…å»¶ã‚’è¨ˆã‚‹ã‚·ãƒ³ãƒ—ãƒ«ãªæ–¹æ³• - ãã‚‹ãã‚‹ã‚µãƒ¼ã‚«ã‚¹
MySQLã§ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’ã™ã‚‹ã¨ãã«ã€å¿…ãšæ°—ã«ãªã‚‹ã®ãŒ master-slaveé–“ã®é…å»¶ã ã¨æ€ã„ã¾ã™ã€‚ ãã“ã§ã€å…ˆæ—¥ã®DeNAã•ã‚“ã®ãƒ†ã‚¯ãƒŽãƒã‚¸ãƒ¼ã‚»ãƒŸãƒŠãƒ¼ã§é–‹ç¤ºã—ã¦ã„ãŸã ã„ãŸãƒã‚¿ã‚’ã‚‚ã¨ã«ç°¡å˜ãªé…å»¶ç›£è¦–æ–¹æ³•ã‚’å®Ÿè£…ã—ã¦ã¿ã¾ã—ãŸã€‚ MySQLãƒãƒ¼ã‚¸ãƒ§ãƒ³ 5.1.23 binlog_format=MIXED ã¾ãšmasterã«ä»¥ä¸‹ã®ã‚ˆã†ãªãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ä½œã‚Šã¾ã™ã€‚databaseã¯é©å½“ã«ä½œã£ã¦ãã ã•ã„ã€‚ CREATE TABLE `replitimes` ( `No` int(10) unsigned NOT NULL AUTO_INCREMENT, `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `ldate` timestamp NOT NULL DEFAULT '0000-00-00
wozozo 2009/01/07
mysql

replication
ãƒªãƒ³ã‚¯
1