[B! mha] i43sã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

i43s id:i43s

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

MHAã‚’AWSã§ä½¿ã†ãŸã‚ã®æ”¯æ´ãƒ„ãƒ¼ãƒ«MHA::AWSã‚’ã‚¢ãƒƒãƒ—ãƒ‡ãƒ¼ãƒˆã—ã¦CPANã«ä¸Šã’ãŸ - é…’æ—¥è¨˜ ã¯ã¦ãªæ”¯åº—
ä»¥å‰ã«ä½œã£ã¦ã€ãƒ—ãƒãƒ€ã‚¯ã‚·ãƒ§ãƒ³ã§ã‚‚ã„ãã¤ã‹ã®ã‚µãƒ¼ãƒ“ã‚¹ã«å°Žå…¥ã—ã¦ã„ã‚‹ MHA::AWS ã§ã™ãŒã€failover æ–¹æ³•ã‚’ ENI ä»˜ã‘æ›¿ãˆã®ä»–ã« VPC Route Table ã®æ›¸ãæ›ãˆã‚‚ã‚µãƒãƒ¼ãƒˆã—ã¾ã—ãŸã€‚ ENIä»˜ã‘æ›¿ãˆã§ã¯åŒä¸€ Availability Zone å†…ã§ã® failover ã—ã‹ã§ãã¾ã›ã‚“ãŒã€VPC Route Table ã®æ›¸ãæ›ãˆã«ã‚ˆã‚‹æ–¹æ³•ã§ã¯ Multi-AZ ç’°å¢ƒã§ã® failover ã‚‚å¯èƒ½ã«ãªã‚Šã¾ã™ã€‚ CPANã«ã‚‚ä¸Šã’ã¾ã—ãŸã®ã§ã€ cpanm MHA::AWS ã§ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«å¯èƒ½ã§ã™ã€‚ MHA::AWS - A support script for "MySQL Master HA" running on AWS - metacpan.org fujiwara/MHA-AWS Â· GitHub ä»¥å‰ã®ç´¹ä»‹è¨˜äº‹ â†’ #11 MySQL Master HA ã‚’ AW
i43s 2014/08/18
mha

aws

mysql
ãƒªãƒ³ã‚¯
Consulã«ã‚ˆã‚‹MySQLãƒ•ã‚§ãƒ¼ãƒ«ã‚ªãƒ¼ãƒãƒ¼ - @ijin
å…ˆæ—¥(6/22/14)ã€6æœˆãªã®ã«ã©ã†ã„ã†åˆ†ã‘ã‹æ—©ã‚ã«é–‹å‚¬ã•ã‚ŒãŸJuly Tech Festa 2014ã§Consulã«ã¤ã„ã¦ç™ºè¡¨ã—ã¦ããŸã€‚ãã®ãƒ¦ãƒ¼ã‚¹ã‚±ãƒ¼ã‚¹ã®ä¸€ã¤ã¨ã—ã¦MySQL failoverã‚’ã¡ã‚‡ã£ã¨ã ã‘ç´¹ä»‹ã—ãŸã®ã§ã€ã“ã“ã«è©³ã—ãæ›¸ã„ã¦ãŠãã€‚ MHA MySQLãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®éšœå®³æ™‚ã«ãƒ•ã‚§ãƒ¼ãƒ«ã‚ªãƒ¼ãƒãƒ¼ã—ãŸã„å ´åˆã€MHAã‚’ä½¿ã†ã®çµæ§‹ãƒãƒ”ãƒ¥ãƒ©ãƒ¼ï¼ˆæ—¥æœ¬ã§ã¯ï¼‰ã ã¨æ€ã„ã¾ã™ã€‚MHAã¯æœ€æ–°binlogã®é©ç”¨ã€Slaveã®æ˜‡æ ¼ã¨ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®å¼µæ›¿ãˆã¾ã§ã¯ã‚„ã£ã¦ãã‚Œã¾ã™ãŒã€å®Ÿéš›ã®ãƒ•ã‚§ãƒ¼ãƒ«ã‚ªãƒ¼ãƒãƒ¼ã®éƒ¨åˆ†ã¯ãƒ¦ãƒ¼ã‚¶ã«å§”ãã‚‰ã‚Œã¦ã„ã¦ã€master_ip_failover_scriptã®ãƒ†ãƒ³ãƒ—ãƒ¬ãƒ¼ãƒˆã‚’ã‚«ã‚¹ã‚¿ãƒžã‚¤ã‚ºã™ã‚‹ã‹ç‹¬è‡ªå®Ÿè£…ã™ã‚‹å¿…è¦ãŒã‚ã‚Šã€ä¸€èˆ¬çš„ãªå®Ÿç¾æ–¹æ³•ã¨ã—ã¦ã¯ã‚«ã‚¿ãƒã‚°ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®æ›´æ–°ã‹Virtual IPã®åˆ‡æ›¿ç‰ãŒã‚ã‚Šã¾ã™ã€‚ Virtual IPã ã¨å±…æ®‹ã‚Šã‚»ãƒƒã‚·ãƒ§ãƒ³ã®å•é¡Œã‚„åˆ‡æ›¿ã®ä¿è¨¼é›£ã—ã‹ã£ãŸã‚Š
i43s 2014/07/11
mha

mysql

consul
ãƒªãƒ³ã‚¯
MHA + HAproxyã«ã‚ˆã‚‹MySQLã®å†—é•·æ§‹æˆã®æ¤œè¨¼ (ãƒ•ã‚§ã‚¤ãƒ«ã‚ªãƒ¼ãƒãƒ¼ç·¨) - s_tajima:TechBlog
å‰å›žã®è¨˜äº‹ã§ä½œæˆã—ãŸMHA + HAproxyã®MySQLã‚¯ãƒ©ã‚¹ã‚¿ã§ã€ãƒ•ã‚§ã‚¤ãƒ«ã‚ªãƒ¼ãƒãƒ¼ã®å®Ÿé¨“ã‚’ã—ã¦ã¿ãŸã€‚ MySQL Cluster of MHA + HAproxy (FAILOVER) from Satoshi Tajima æƒ³å®šã™ã‚‹çŠ¶æ³ ãƒ•ã‚§ã‚¤ãƒ«ã‚ªãƒ¼ãƒãƒ¼æ™‚ã®ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®çŠ¶æ…‹ã¯ã€ä¸Šã®ã‚¹ãƒ©ã‚¤ãƒ‰ã®å›³1ã®ã‚ˆã†ãªçŠ¶æ…‹ã‚’æƒ³å®šã€‚ master(mysqlserver-a), slave*2å°ã®æ§‹æˆã€‚ slv1(mysqlserver-b)ã¯t1ã¾ã§ã‚’DBã«åæ˜ æ¸ˆã¿ã€‚t3ã¾ã§ã®relay-logã‚’å—ä¿¡æ¸ˆã¿ã€‚ slv2(mysqlserver-c)ã¯t0ã¾ã§ã‚’DBã«åæ˜ æ¸ˆã¿ã€‚t2ã¾ã§ã®relay-logã‚’å—ä¿¡æ¸ˆã¿ã€‚ ã“ã®çŠ¶æ³ã§masterãŒ(ç‰©ç†éšœå®³ãªã©ã§)OSã”ã¨åœæ¢ã—ãŸçŠ¶æ³ã‚’æƒ³å®šã€‚ MHAãŒã©ã®ã‚ˆã†ã«ãƒªã‚«ãƒãƒªã‚’è¡Œã†ã‹ã‚’èª¿æŸ»ã™ã‚‹ã€‚ æ¤œè¨¼ç’°å¢ƒæ§‹ç¯‰ã®æº–å‚™ MySQLã®ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³æ§‹æˆã€MHAã®
i43s 2014/04/03
mysql

mha
ãƒªãƒ³ã‚¯
MHA + HAproxyã«ã‚ˆã‚‹MySQLã®å†—é•·æ§‹æˆã®æ¤œè¨¼ (ç’°å¢ƒæ§‹ç¯‰ç·¨) - s_tajima:TechBlog
ç¾åœ¨é‹ç”¨ä¸ã®ã€Heartbeat + DRBDã«ã‚ˆã‚‹MySQLã‚¯ãƒ©ã‚¹ã‚¿ç’°å¢ƒã®æ”¹å–„ã‚’è©¦ã¿ã‚‹ãŸã‚ã«ã€ MHA + HAproxyã«ã‚ˆã‚‹MySQLã‚¯ãƒ©ã‚¹ã‚¿ç’°å¢ƒã‚’ãƒ†ã‚¹ãƒˆä¸ã€‚ ä»Šå›žã¯ç’°å¢ƒã‚’æ•´ãˆã‚‹ã¨ã“ã‚ã¾ã§ã€‚ ç’°å¢ƒæ§‹ç¯‰ AWSä¸Šã«ä»¥ä¸‹ã®å›³ã¨æ–‡ç« ã§ç¤ºã™ã‚ˆã†ãªç’°å¢ƒã‚’æ§‹ç¯‰ã€‚ MySQL Cluster of MHA + HAproxy from Satoshi Tajima webserver, manageserver, mysqlserver * 3å°(master, slave, slave) (ä»Šå›žã¯webserverã¨manageserverã‚’åŒã˜ã‚¤ãƒ³ã‚¹ã‚¿ãƒ³ã‚¹ã«åŒå±…ã•ã›ãŸ) webserverã¯åŒãƒ›ã‚¹ãƒˆä¸Šã§ç¨¼åƒã—ã¦ã„ã‚‹HAproxyçµŒç”±ã§MySQLã‚µãƒ¼ãƒãƒ¼ã«ã‚¢ã‚¯ã‚»ã‚¹ åˆæœŸçŠ¶æ…‹ 127.0.0.1:3310ã§mysqlserver-aã®mysql(master)ã«æŽ¥ç¶šã€‚WRITEå‡¦ç†ã‚’è¡Œã†æƒ³å®šã€‚ 1
i43s 2014/04/03
mysql

mha
ãƒªãƒ³ã‚¯
1