[B! HA] bigwestã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

bigwest id:bigwest

HAã«é–¢ã™ã‚‹bigwestã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (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 ã‚’ MHA + HAProxy ã§å†—é•·åŒ–ã—ã¦ã¿ã‚ˆã†
æ–Žè—¤ã§ã™ã€‚ã“ã‚“ã«ã¡ã¯ã€‚ ä»Šæ—¥ã¯ã€MySQLã«ã¦ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³æ§‹æˆã«ãŠã„ã¦ã€ãƒžã‚¹ã‚¿ã‚µãƒ¼ãƒã®ãƒ•ã‚§ã‚¤ãƒ«ã‚ªãƒ¼ãƒãƒ¼ã‚’å¸ã‚‹mysql-master-ha(ä»¥ä¸‹ã€MHA)ã‚’ç”¨ã„ã‚‹éš›ã€ãƒžã‚¹ã‚¿ã‚µãƒ¼ãƒæŽ¥ç¶šå…ˆã®åˆ‡ã‚Šæ›¿ãˆã«HAProxyã‚’ä½¿ã£ã¦ã¿ã‚ˆã†ã¨ã„ã†ãŠè©±ã§ã™ã€‚ â€»MHAã¯0.53.0(å…¬å¼ãƒ‘ãƒƒã‚±ãƒ¼ã‚¸)ã€MySQLã¯5.5.25a(Oracleå…¬å¼ãƒ‘ãƒƒã‚±ãƒ¼ã‚¸)ã€HAProxyã¯1.4.22(CentOS6æ¨™æº–ãƒ‘ãƒƒã‚±ãƒ¼ã‚¸)ã€OSã¯CentOS 6.3 x86_64ã‚’ç”¨ã„ã¾ã—ãŸã€‚ â€»MHAã«ã‚ˆã‚‹å†—é•·åŒ–ãŠã‚ˆã³HAProxyã«ã‚ˆã‚‹MySQLã®è² è·åˆ†æ•£ã®è¨å®šã‚’çµŒé¨“ã•ã‚ŒãŸäº‹ãŒã‚ã‚‹å‰æã§è¨˜è¿°ã—ã¾ã™ã€‚ æœ¬è¨˜äº‹ã§ã¯ã€æ¬¡ã®æµã‚Œã§è©±é¡Œã‚’å±•é–‹ã—ã¾ã™ã€‚ ãƒ•ã‚§ã‚¤ãƒ«ã‚ªãƒ¼ãƒãƒ¼æ™‚ã®æŽ¥ç¶šå…ˆåˆ‡ã‚Šæ›¿ãˆæ–¹æ³• æ§‹æˆ(å‚è€ƒ) ãªãœHAProxyãªã®ã‹ åˆ‡ã‚Šæ›¿ãˆæ–¹ 2å°æ§‹æˆã®å•é¡Œç‚¹ ãã®ä»– ã‚³ãƒ„ è¨å®š(å‚è€ƒ) ä¸»ã«MHA+HAProxyã«ã‚ˆã‚‹ãƒ•ã‚§ã‚¤ãƒ«ã‚ªãƒ¼
bigwest 2013/06/03
mysql

HA
ãƒªãƒ³ã‚¯
MHA for MySQL ã®æ¦‚è¦ - Gosuke Miyashita
MHA for MySQL ã®å°Žå…¥ã‚’æ¤œè¨Žã—ã¦ã„ã¦ã€ã¾ãšã¯ç¤¾å†…ã®æŠ€è¡“è€…å‘ã‘ã«ã€MHA for MySQL ã®æ¦‚è¦ã‚’ä¼ãˆã‚ˆã†ã¨ã€ä¸»ã« ã‚ªãƒ•ã‚£ã‚·ãƒ£ãƒ«ãªãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆ ã‹ã‚‰ãƒã‚¤ãƒ³ãƒˆã‚’æŠœç²‹ã—ã¦ç¤¾å†…å‘ã‘ã® Wiki ã«æ›¸ã„ã¦ã¿ãŸã€‚æœ¬å½“ãªã‚‰ã€ã‚ªãƒ•ã‚£ã‚·ãƒ£ãƒ«ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆå…¨ä½“ã«ç›®ã‚’é€šã—ã¦ã‚‚ã‚‰ã†ã®ãŒã„ã„ã‚“ã ã‘ã©ã€è‹±èªžãªã®ã§ã€ã¯ã˜ã‚ã®ä¸€æ©ã¨ã—ã¦ã¯æ•·å±…ãŒé«˜ãæ„Ÿã˜ã‚‹äººã‚‚ã„ã‚‹ã ã‚ã†ã€ã¨ã„ã†ã“ã¨ã§ã€‚ ç‰¹ã«å¤–ã«å‡ºã—ã¦ã¾ãšã„æƒ…å ±ãŒã‚ã‚‹ã‚ã‘ã§ã‚‚ãªã„ã®ã§ã€ã“ã®ãƒ–ãƒã‚°ã§ã‚‚æ›ã—ã¦ãŠãã¾ã™ã€‚ MHA ã®æ¦‚è¦ MySQL ã‚¨ã‚ã‚¹ãƒ‘ãƒ¼ãƒˆã¨ã—ã¦ä¸–ç•Œçš„ã«ã‚‚è‘—åãªæ¾ä¿¡å˜‰ç¯„æ°ã«ã‚ˆã‚‹ã€MySQL ãƒžã‚¹ã‚¿ãƒ¼ã® HA åŒ–ã‚’è¡Œã†ãŸã‚ã®ãƒ„ãƒ¼ãƒ«ã€‚Perl è£½ã€‚ æœ€å°é™ã®ãƒ€ã‚¦ãƒ³ã‚¿ã‚¤ãƒ ã§ã€ãƒ‡ãƒ¼ã‚¿ã®ä¸æ•´åˆã‚’é˜²ãŽã¤ã¤ã€ãƒžã‚¹ã‚¿ãƒ¼ã®ãƒ•ã‚§ã‚¤ãƒ«ã‚ªãƒ¼ãƒãƒ¼ã‚’è¡Œã†ã€ã¨ã„ã†ã®ãŒä¸»ãªæ©Ÿèƒ½ã€‚ ã¾ãŸã€æ—¢ã«å‹•ä½œã—ã¦ã„ã‚‹ MySQL ã«å½±éŸ¿ã‚’ä¸Žãˆã‚‹ã“ã¨ãªãå°Žå…¥ã§ãã‚‹ã€‚ æ©Ÿèƒ½ã¯å¤§ããã‚ã‘ã‚‹ã¨ä»¥ä¸‹
bigwest 2013/02/06
mysql

HA
ãƒªãƒ³ã‚¯
Announcing MySQL-MHA: "MySQL Master High Availability manager and tools"
I have published "MySQL MHA" that fully automates MySQL master failover. You can also get commercial support from SkySQL. Let's try MHA today! Today I'm happy to announce that I have released MySQL-MHA: MySQL Master High Availability manager and tools as an open source software (GPL v2 license). The below is a part of documentation of MHA. I'm glad if you are interested in MHA. A primary objective
bigwest 2011/08/10
mysql

HA
ãƒªãƒ³ã‚¯
HAåŒ–æ©Ÿèƒ½ã‚’æ‰‹ã«å…¥ã‚ŒãŸSPIDERã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã«ã¯ã‚‚ã¯ã‚„æ»è§’ã¯ãªã‹ã£ãŸã€‚
æœ¬ãƒ–ãƒã‚°ã§ã‚‚ä½•åº¦ã‹å–ã‚Šä¸Šã’ãŸã“ã¨ã®ã‚ã‚‹ã‚ã®SPIDERã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ãŒã•ã‚‰ã«ãƒ‘ãƒ¯ãƒ¼ã‚¢ãƒƒãƒ—ã—ã¦ä¾¿åˆ©ã«ãªã£ãŸï¼ï¼˜æœˆã«ãƒªãƒªãƒ¼ã‚¹ã•ã‚ŒãŸãƒãƒ¼ã‚¸ãƒ§ãƒ³2.22ã§ã¯æ¬¡ã®ï¼’ã¤ã®å¼·åŒ–ãŒè¡Œã‚ã‚Œã¦ã„ã‚‹ã€‚ HAæ©Ÿèƒ½ã®è¿½åŠ ï¼ˆãƒ‡ãƒ¼ã‚¿ãƒŽãƒ¼ãƒ‰ã®å†—é•·åŒ–ï¼‰ LinuxãŠã‚ˆã³Windowsç”¨ãƒ“ãƒ«ãƒ‰æ¸ˆã¿MySQLãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ã®é…å¸ƒ ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ãŒç°¡å˜ã«ãªã£ãŸï¼å‰å›žSPIDERã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã‚’ç´¹ä»‹ã—ãŸã¨ãã«ã¯ã€ã‚½ãƒ¼ã‚¹ã‚³ãƒ¼ãƒ‰ã‹ã‚‰ã‚³ãƒ³ãƒ‘ã‚¤ãƒ«ã™ã‚‹å¿…è¦ãŒã‚ã‚Šã€ãªãŠã‹ã¤MySQL æœ¬ä½“ã«ãƒ‘ãƒƒãƒã‚’é©ç”¨ã—ãªã‘ã‚Œã°ãªã‚‰ãšã€åˆ©ç”¨ã™ã‚‹ã¾ã§ã®æ•·å±…ãŒé«˜ã‹ã£ãŸã‚ˆã†ã«æ€ã†ã€‚ã—ã‹ã—ã€ãƒãƒ¼ã‚¸ãƒ§ãƒ³2.22ã‚ˆã‚ŠSPIDERã‚’å«ã‚“ã ãƒ“ãƒ«ãƒ‰æ¸ˆã¿ãƒã‚¤ãƒŠãƒªãŒæä¾›ã•ã‚ŒãŸã“ã¨ã«ã‚ˆã‚Šã€SPIDERã‚’åˆ©ç”¨ã™ã‚‹æ‰‹é–“ã¯ãã£ã¨å°‘ãªããªã£ãŸã€‚ã—ã‹ã‚‚ã“ã®ãƒ“ãƒ«ãƒ‰æ¸ˆã¿ã®ãƒã‚¤ãƒŠãƒªã«ã¯SPIDERã ã‘ã§ãªãå„ç¨®ãƒ‘ãƒƒãƒã¨ã€ã•ã‚‰ã«ã¯VPã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã¾ã§å«ã¾ã‚Œã¦ã„ã‚‹ã¨ã„ã†æ°—ã®åˆ©ãã‚ˆã†ã ã€‚ã‚³ãƒ³ãƒ‘ã‚¤ãƒ«
bigwest 2010/10/20
mysql

HA
ãƒªãƒ³ã‚¯
PostgreSQL 9.0 Update ï½žãƒ›ãƒƒãƒˆãƒ»ã‚¹ã‚¿ãƒ³ãƒã‚¤ãŒã‚„ã£ã¦ããŸï¼ï½ž
PostgreSQL 9.0 was released in August 2010 with several new features including improved performance, replication capabilities, and data types. Version 9.0 focuses on areas like replication, vacuuming, and indexing. It features increased replication support through streaming replication and improved standby servers. The new version also enhances vacuuming performance and introduces exclusion constr
bigwest 2010/06/29
ã“ã‚Œã¯ã€è¦‹ãªã„ã¨ã€‚

PostgreSQL

HA
ãƒªãƒ³ã‚¯
å®ŸéŒ²ã€ã»ã¼ç„¡åœæ¢ãªMySQLã®ãƒ•ã‚§ã‚¤ãƒ«ã‚ªãƒ¼ãƒ (å‹•ç”»ã‚‚ã‚ã‚‹ã‚ˆ) - ï¼ˆã²ï¼‰ãƒ¡ãƒ¢
ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã—ã¦ã‚‹MySQLã§ã€ãƒžã‚¹ã‚¿ã‚„ã‚¹ãƒ¬ãƒ¼ãƒ–ãŒéšœå®³åœæ¢ã—ãŸå ´åˆã®ãƒªã‚«ãƒãƒªãƒ—ãƒ©ãƒ³ ã§ã‚‚æŽ²ã’ãŸã‚´ãƒ¼ãƒ«ã§ã‚ã‚‹ã€ã€Œãƒžã‚¹ã‚¿ãŒè½ã¡ã¦ã‚‚ããƒ¼ã™ã‹å¯ã¦ã„ã‚‰ã‚Œã‚‹ã‚ˆã†ã«ã—ãŸã„ã€ãŒã»ã¼ã§ããŸã®ã§ã€ã»ã¨ã‚“ã©ã‚µãƒ¼ãƒ“ã‚¹ãŒåœæ¢ã™ã‚‹ã“ã¨ãªãã€ãƒ•ã‚§ã‚¤ãƒ«ã‚ªãƒ¼ãƒã™ã‚‹æ§˜ã‚’ã‚¹ã‚¯ãƒªãƒ¼ãƒ³ã‚ãƒ£ã‚¹ãƒˆã«åŽã‚ã¾ã—ãŸã€‚ åŸ‹ã‚è¾¼ã¿ãƒ—ãƒ¬ã‚¤ãƒ¤ãƒ¼ã ã¨ã€å°ã•ãã¦ã‚ã‹ã‚‰ãªã„ã¨æ€ã†ã®ã§ã€ãƒªãƒ³ã‚¯ç›´æŽ¥ã§ã¿ã¦ãã ã•ã„ã€‚ http://www.irori.org/pub/mysql-mm.mov ç™»å ´ã™ã‚‹ãƒ›ã‚¹ãƒˆ ç™»å ´ã™ã‚‹ãƒ›ã‚¹ãƒˆã¯2å°ã€db 901ã¨db902ã§ã™ã€‚ æœ€åˆã¯ã€db 901ãŒæ›´æ–°ç³»ã‚¯ã‚¨ãƒªã‚’å—ã‘ã‚‹ãƒ—ãƒ©ã‚¤ãƒžãƒªã§db900ã®æµ®å‹•IPã‚¢ãƒ‰ãƒ¬ã‚¹ã‚’æŒã£ã¦ã„ã¾ã™ã€‚ ç”»é¢åˆ†å‰² ç”»é¢ã¯5åˆ†å‰²ã—ã¦ã„ã¾ã™ã€‚ å·¦ä¸Š = ã€Œselect sysdate(),@@server_idã€ã‚’db900ã«å¯¾ã—ã¦(sleep 1ã—ãªãŒã‚‰)å»¶ã€…ã¨å®Ÿè¡Œã—ã¾ãã‚Šã‚“ã å³ä¸Š = ping -n
bigwest 2009/12/08
mysql

HA

cluster

Linux

Server
ãƒªãƒ³ã‚¯
[ThinkIT] ç¬¬8å›žï¼šMySQLï¼Oracleã¨LifeKeeperã«ã‚ˆã‚‹HAã‚¯ãƒ©ã‚¹ã‚¿åŒ– (1/4)
ä»Šå›žã¯Oracle Database 10gã¨MySQLã‚’ä¾‹ã«ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ï¼ˆDBï¼‰ã®HAã‚¯ãƒ©ã‚¹ã‚¿åŒ–æ§‹æˆã®æ¦‚è¦ã«ã¤ã„ã¦ç´¹ä»‹ã—ã¦ã„ãã€‚ ã¾ãšå„ARKã«ã‚ˆã‚‹æ§‹ç¯‰ã®æ¦‚è¦ã‚’è¿°ã¹ã‚‹å‰ã«ã€LifeKeeperã«ã‚ˆã‚‹DBã‚·ã‚¹ãƒ†ãƒ ã®HAã‚¯ãƒ©ã‚¹ã‚¿åŒ–ã«ã‚ãŸã£ã¦ã€äº‹å‰ã®ç•™æ„äº‹é …ã‚’è¡¨1ã«ã‚ã’ã‚‹ã€‚ ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ãŒã™ã§ã«ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã•ã‚Œã¦ã„ã‚‹ã“ã¨ ç›£è¦–ãƒ»åˆ‡ã‚Šæ›¿ãˆå¯¾è±¡ã®ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã¯ã€LifeKeeperã®è¨å®šã‚’è¡Œã†å‰ã«ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã•ã‚Œã¦ã„ã‚‹å¿…è¦ãŒã‚ã‚‹ã€‚ã¾ãŸLifeKeeperã§ã¯ã€DBã®æ»æ´»ç›£è¦–ã‚’ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆãƒ¦ãƒ¼ãƒ†ã‚£ãƒªãƒ†ã‚£ã‹ã‚‰è¡Œã†ãŸã‚ã€ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã‚³ãƒ³ãƒãƒ¼ãƒãƒ³ãƒˆã‚‚ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã•ã‚Œã¦ã„ãªã‘ã‚Œã°ãªã‚‰ãªã„ã€‚ å„ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã«ãŠã‘ã‚‹ã‚µãƒãƒ¼ãƒˆã™ã‚‹ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã®æœ€æ–°æƒ…å ±ã¯ã€Release Notesï¼ˆhttp://licensing.steeleye.com/support/docm.phpï¼‰ã‚’å‚ç…§ã—ã¦ç¢ºèªã—ã¦ã„ãŸã ã
bigwest 2008/03/10
mysql

lifekeeper

cluster

HA
ãƒªãƒ³ã‚¯
1