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

nobu666 id:nobu666

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

${{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è¿½åŠ æ™‚ã«masterãŒå…¨åŠ›ã§binlogã‚’é€ã£ã¦å›°ã‚‹æ™‚ - As a Futurist...
ãŸã¾ã«ã¯ã—ã‚‡ã†ã‚‚ãªã„ TIPS ã§ã‚‚ã€‚MySQL ã®é…åŠ›ã¨ã„ãˆã°è¨€ã‚ãšã‚‚ãŒãª 10 å¹´ã®æ´å²ã‚’èª‡ã‚‹ã€Œãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã€ã®ä»•çµ„ã¿ã ã¨æ€ã„ã¾ã™ã€‚ã“ã‚Œã•ãˆã‚ã‚Œã° 1 ã¤ã®çä½“ã§å¿…æ»ã«ãƒ‡ãƒ¼ã‚¿ä¿å…¨ã—ãªãã¦ã‚‚ã‚³ãƒ”ãƒ¼ãŒã„ãã‚‰ã§ã‚‚å¢—ã‚„ã›ã‚‹ã—ã€@nippondanjiã•ã‚“ã®ã‚¹ãƒ©ã‚¤ãƒ‰ã«ã‚ã‚‹é€šã‚Šã€ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®å¦™æŠ€ã‚’é§†ä½¿ã™ã‚‹ã“ã¨ã§æ§˜ã€…ã«æŸ”è»Ÿãªé‹ç”¨ã‚’è¡Œã†ã“ã¨ãŒã§ãã¾ã™ã€‚ Art of MySQL Replication. slave è¿½åŠ ã¨ã¯ï¼Ÿ ã•ã¦ãã‚“ãªãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã§ã™ãŒã€å®Ÿé‹ç”¨ã§æœ€ã‚‚å¤šãè¡Œã‚ã‚Œã‚‹ã‚ªãƒšãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³ã¯ã€Œslave ã®è¿½åŠ ã€ã ã¨æ€ã„ã¾ã™ã€‚è¿½åŠ ã®æ–¹æ³•ã¯å¤§ããåˆ†ã‘ã‚‹ã¨ 2 é€šã‚Šã§ã™ã€‚(ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã¯ InnoDB ã‚’æƒ³å®šã€‚ã¨ã„ã†ã‹ InnoDB ä»¥å¤–èªã‚ã¾ã›ã‚“ï¼žï¼œ) è«–ç†ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã‚’åˆ©ç”¨ mysqldump ç‰ã‚’åˆ©ç”¨ã—ã¦è«–ç†çš„ã«ãƒ‡ãƒ¼ã‚¿ã®é™æ¢æ–é¢ã‚’ä½œã‚‹ï¼†ãã®æ™‚ã® binlog ã®ãƒã‚¸ã‚·ãƒ§ãƒ³ã‚’
nobu666 2011/02/03
mysql

replication
ãƒªãƒ³ã‚¯
ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹æƒ…å ±ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚·ã‚¹ãƒ†ãƒ (OSS iPedia) ã®ã‚³ãƒ³ãƒ†ãƒ³ãƒ„ã«ã¤ã„ã¦
nobu666 2010/05/31
tomcat

jboss

replication

session

cluster
ãƒªãƒ³ã‚¯
ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹æƒ…å ±ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚·ã‚¹ãƒ†ãƒ (OSS iPedia) ã®ã‚³ãƒ³ãƒ†ãƒ³ãƒ„ã«ã¤ã„ã¦
ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹æƒ…å ±ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚·ã‚¹ãƒ†ãƒ (OSS iPedia) ã¯ã€2013å¹´5æœˆ17æ—¥(é‡‘) ã‚’ã‚‚ã¡ã¾ã—ã¦é‹ç”¨ã‚’çµ‚äº†ã„ãŸã—ã¾ã—ãŸã€‚ é•·ã„é–“ã”åˆ©ç”¨ã‚’ã„ãŸã ãã¾ã—ã¦ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã—ãŸã€‚ OSS iPediaã§æä¾›ã—ã¦ãŠã‚Šã¾ã—ãŸã€IPA ãƒ•ã‚©ãƒ³ãƒˆã€æ–‡å—æƒ…å ±åŸºç›¤ã€ãã®ä»–å ±å‘Šæ›¸ç‰ã«ã¤ã„ã¦ã¯ã€ä¸‹è¨˜ãƒªãƒ³ã‚¯ã‚’ã”å‚ç…§ãã ã•ã„ã€‚ çš†æ§˜ã«ã¯å¤§å¤‰ã”ä¸ä¾¿ã‚’ãŠã‹ã‘ã„ãŸã—ã¾ã™ãŒã€ä½•å’ã”ç†è§£ã®ç¨‹ã‚’ã‚ˆã‚ã—ããŠé¡˜ã„ç”³ã—ä¸Šã’ã¾ã™ã€‚
nobu666 2010/05/31
tomcat

replication

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

mysql

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

mysql

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

database

memcached

replication

scalability

tools
ãƒªãƒ³ã‚¯
https://labs.cybozu.co.jp/blog/kazuho/archives/2008/01/dbix-replicate.php
nobu666 2008/01/29
ã‚ã¨ã§è©¦ã™

database

perl

replication

tools
ãƒªãƒ³ã‚¯
1