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

tom__bo id:tom__bo

HAã«é–¢ã™ã‚‹tom__boã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (10)

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

PostgreSQL9.3ã§ã®ã‚¹ãƒˆãƒªãƒ¼ãƒŸãƒ³ã‚°ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ç’°å¢ƒã®æ§‹ç¯‰ - Qiita
ã¯ã˜ã‚ã« PostgreSQLã®ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã¯ã€WEBã«æƒ…å ±ãŒã‚ã‚‹ãŒã€å®Ÿéš›ã«æ§‹ç¯‰ã—ãŸéš›ã«ã¯ã€ç´°ã‹ã„æ‰‹é †ãŒçœã‹ã‚Œã¦ã„ãŸã‚Šå°‘ã—ãƒãƒžã£ãŸã®ã§ã€ã“ã“ã«ç°¡å˜ã«ã¾ã¨ã‚ã¦ãŠãã€‚ ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã—ãŸDBã¸ã®ã€ã‚¯ã‚¨ãƒªåˆ†æ•£ã«ã¯pgpool-IIã‚’åˆ©ç”¨ã—ãŸãŸã‚ã€ãã‚Œã«ã¤ã„ã¦ã¯åˆ¥è¨˜äº‹ã§æ›¸ãäºˆå®šã€‚ å‰æçŸ¥è˜ ã‚¹ãƒˆãƒªãƒ¼ãƒŸãƒ³ã‚°ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ç’°å¢ƒã‚’æ§‹ç¯‰ã™ã‚‹ä¸Šã§ã€ä¸€å¿œçŸ¥ã£ã¦ãŠã„ãŸã»ã†ãŒã„ã„ã“ã¨ã€‚ ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®ä»•çµ„ã¿ ãƒžã‚¹ã‚¿DBã§ç™ºç”Ÿã—ãŸWALãƒ•ã‚¡ã‚¤ãƒ«ã‚’ã€ã‚¹ãƒ¬ãƒ¼ãƒ–ã¨ãªã‚‹DBã«åæ˜ ã•ã›ã‚‹ã“ã¨ã§ã€ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’å®Ÿç¾ã—ã¦ã„ã‚‹ã€‚ ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®åŒæœŸãƒ¢ãƒ¼ãƒ‰ ã“ã¡ã‚‰ã®è¨˜äº‹ãŒã‚ã‹ã‚Šã‚„ã™ã„ã€‚ http://codezine.jp/article/detail/7109 åŒæœŸãƒ»ãƒ¡ãƒ¢ãƒªåŒæœŸã¯ã€ã‚¹ãƒ¬ãƒ¼ãƒ–ãŒï¼‘å°ã®å ´åˆã¯ã‚¹ãƒ¬ãƒ¼ãƒ–ã«éšœå®³ãŒç™ºç”Ÿã™ã‚‹ã¨ã€ãƒžã‚¹ã‚¿ã¸ã®æ›´æ–°ã‚‚è¡Œã‚ã‚Œãšã€å…¨ä½“ã®éšœå®³ã«ã¤ãªãŒã£ã¦ã—ã¾ã†ã®ã§æ³¨æ„ã€‚ ä»Šå›žè©¦ã—ãŸç’°å¢ƒ
tom__bo 2015/11/07
postgresql

HA
ãƒªãƒ³ã‚¯
CentOS6.5ã§DRBD8.4ã‚’ä½¿ã£ã¦ã¿ã‚‹ - vol.1 ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ç·¨ - Qiita
Deleted articles cannot be recovered. Draft of this article would be also deleted. Are you sure you want to delete this article?
tom__bo 2015/10/29
DRBD

HA
ãƒªãƒ³ã‚¯
Design - Spilo PostgreSQL appliance
Spilo combines Patroni with the Stups infrastructure. Its major components are: Patroni Stups Patroni Patroni manages the PostgreSQL databases which are running in a Spilo. It ensures there is at most 1 master within Spilo. To allow distributed nodes to agree on anything, we need a Distributed Configuration Store (DCS). Patroni can utilize etcd and ZooKeeper. Etcd Most deployments of Patroni use e
tom__bo 2015/10/27
ã‚ã¨ã§èªã‚€

postgresql

HA
ãƒªãƒ³ã‚¯
ChapterÂ 26.Â High Availability, Load Balancing, and Replication
Database servers can work together to allow a second server to take over quickly if the primary server fails (high availability), or to allow several computers to serve the same data (load balancing). Ideally, database servers could work together seamlessly. Web servers serving static web pages can be combined quite easily by merely load-balancing web requests to multiple machines. In fact, read-o
tom__bo 2015/10/24
ã‚ã¨ã§èªã‚€

postgresql

HA
ãƒªãƒ³ã‚¯
PostgreSQL Â« Linux-HA Japan
å…ˆæ—¥ãƒªãƒªãƒ¼ã‚¹ã•ã‚ŒãŸFedora 19ã«ã¯ã€Linux-HA Japanã§é–‹ç™ºã—ãŸPostgreSQLã®ã‚¹ãƒˆãƒªãƒ¼ãƒŸãƒ³ã‚°ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®ã‚¯ãƒ©ã‚¹ã‚¿ãƒªãƒ³ã‚°æ©Ÿèƒ½ãŒã¤ã„ã«åŒæ¢±ã•ã‚Œã¾ã—ãŸã€‚ Pacemaker ã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã‚‚é–‹ç™ºç‰ˆã§æ¯”è¼ƒçš„æ–°ã—ã„ 1.1.9 ãŒåŒæ¢±ã•ã‚Œã¦ã„ã‚‹ã®ã§ã€ã“ã‚Œã‚’ä½¿ã£ã¦PostgreSQLã‚¹ãƒˆãƒªãƒ¼ãƒŸãƒ³ã‚°ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®ã‚¯ãƒ©ã‚¹ã‚¿ãƒªãƒ³ã‚°ã«æŒ‘æˆ¦ã—ã¦ã¿ãŸã„ã¨æ€ã„ã¾ã™ã€‚ ç’°å¢ƒ ä»Šå›žã€Fedoraã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«æ‰‹é †æ–¹æ³•ã¯å‰²æ„›ã—ã¾ã™ãŒã€ä»¥ä¸‹ã®ç’°å¢ƒã‚’ç”¨æ„ã—ã¦ãã ã•ã„ã€‚ â€» è¶…ã‚¹ãƒ¢ãƒ¼ãƒ«æ§‹æˆã®ãŸã‚ã€å•†ç”¨ã§ã®åˆ©ç”¨ã¯æŽ¨å¥¨ã—ã¾ã›ã‚“ã€‚ä¿¡é ¼æ€§ã‚’ç¢ºä¿ã™ã‚‹ã«ã¯ã€Pacemakerç”¨ã‚„ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ç”¨ã®å°‚ç”¨LANã‚’æº–å‚™ã—ã€STONITHã®å°Žå…¥ã‚’æ¤œè¨Žã—ã¦ãã ã•ã„ã€‚ ãƒ›ã‚¹ãƒˆåã¯ã€52-fe19 ã¨ 53-fe19 ã¨ã—ã¾ã™ã€‚ (å˜ã«ç§ã®æ‰‹å…ƒã®ç’°å¢ƒã§ä½¿ã£ã¦ã„ã‚‹ãƒ›ã‚¹ãƒˆåã§ã€æ·±ã„æ„å‘³ã¯ã‚ã‚Šã¾ã›ã‚“ã€‚ã€‚ã€‚) çš†å¤§å¥½ããªSEL
tom__bo 2015/10/24
ã‚ã¨ã§èªã‚€

postgresql

HA
ãƒªãƒ³ã‚¯
PowerPoint Presentation
Copyright Â© PostgreSQL Enterprise Consortium, All Rights Reserved. è¨è¨ˆé‹ç”¨WG 2013å¹´åº¦WG3æ´»å‹•å ±å‘Š PostgreSQL ã‚¨ãƒ³ã‚¿ãƒ¼ãƒ—ãƒ©ã‚¤ã‚ºãƒ»ã‚³ãƒ³ã‚½ãƒ¼ã‚·ã‚¢ãƒ WG3(è¨è¨ˆé‹ç”¨WG) ï¼èµ°ã‚Šç¶šã‘ã‚‹PostgreSQLã‚·ã‚¹ãƒ†ãƒ æ§‹ç¯‰ã®ãŸã‚ã«ï¼ Copyright Â© PostgreSQL Enterprise Consortium, All Rights Reserved. ã‚¢ã‚¸ã‚§ãƒ³ãƒ€ ï® WG3ã«ã¤ã„ã¦ ï‚¨ WG3è¨ç«‹ã®èƒŒæ™¯ ï‚¨ WG3ã®ä½ç½®ã¥ã‘ã€æ´»å‹•æ¦‚è¦ ï‚¨ 2013å¹´åº¦ã®æ´»å‹•ãƒ†ãƒ¼ãƒž ï‚¨ å®Ÿæ–½ä½“åˆ¶ï¼ˆ14ç¤¾ï¼‰ ï® 2013å¹´åº¦æ´»å‹•å ±å‘Š ï‚¨ ä¼æ¥ã‚·ã‚¹ãƒ†ãƒ ã«æ±‚ã‚ã‚‰ã‚Œã‚‹éžæ©Ÿèƒ½è¦æ±‚ ï‚¨ DBMSã«æ±‚ã‚ã‚‰ã‚Œã‚‹è¦æ±‚ï¼ˆè¦ä»¶ï¼‰ ï‚¨ DBè¦ä»¶ã‚’å®Ÿç¾ã™ã‚‹PostgreSQLã®ä»£è¡¨çš„ãªã‚·ã‚¹ãƒ†ãƒ æ§‹æˆ ï‚¨ PostgreSQLã‚·ã‚¹ãƒ†ãƒ æ§‹æˆã®åˆ†é¡ž
tom__bo 2015/10/23
postgresql

HA
ãƒªãƒ³ã‚¯
ã‚¯ãƒ©ã‚¹ã‚¿ãƒªãƒ³ã‚°ã§PostgreSQLã®å¯ç”¨æ€§ã¨ä¿¡é ¼æ€§ã‚’é«˜ã‚ã‚‹
HAã‚¯ãƒ©ã‚¹ã‚¿ã‚½ãƒ•ãƒˆã‚’ç”¨æ„ã™ã‚‹ ä»Šå›žã¯ã€PostgreSQLã‚’è¤‡æ•°ã®ã‚µãƒ¼ãƒãƒ¼æ©Ÿã«é…ç½®ã™ã‚‹ã‚¯ãƒ©ã‚¹ã‚¿ãƒªãƒ³ã‚°æ§‹æˆã«ã¤ã„ã¦ç´¹ä»‹ã—ã¾ã™ã€‚ã‚¯ãƒ©ã‚¹ã‚¿ãƒªãƒ³ã‚°æ§‹æˆã§é‹å–¶ã™ã‚‹ã¨ã€å¯ç”¨æ€§ï¼ˆä¿¡é ¼æ€§ï¼‰ã‚„æ€§èƒ½ã‚’å‘ä¸Šã•ã›ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ PostgreSQLã¯ä¼çµ±çš„ã«ã€ã‚¯ãƒ©ã‚¹ã‚¿ãƒªãƒ³ã‚°ã®ãŸã‚ã®ã‚½ãƒ•ãƒˆã‚’æœ¬ä½“ã«ã¯å«ã¾ãªã„ã¨ã„ã†æ–¹é‡ã§é–‹ç™ºã•ã‚Œã¦ãã¾ã—ãŸã€‚ãã®ä»£ã‚ã‚Šã«æœ¬ä½“ã¨ã¯ç‹¬ç«‹ã—ã¦ã€PostgreSQLã‚’ã‚¯ãƒ©ã‚¹ã‚¿ãƒªãƒ³ã‚°æ§‹æˆã§é‹å–¶ã™ã‚‹ãŸã‚ã®ãƒŸãƒ‰ãƒ«ã‚¦ã‚¨ã‚¢ãŒä½•ç¨®é¡žã‹é–‹ç™ºã•ã‚Œã¦ã„ã¾ã™ã€‚ ã“ã†ã—ãŸã‚½ãƒ•ãƒˆã«ã¯ã€ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã®ã‚‚ã®ã‚‚ã‚ã‚Šã¾ã™ã—ã€å•†ç”¨è£½å“ã¨ã—ã¦è²©å£²ã•ã‚Œã¦ã„ã‚‹ã‚‚ã®ã‚‚ã‚ã‚Šã¾ã™ã€‚ã¾ãŸã€æ±Žç”¨ã®HAï¼ˆHigh Availabilityï¼é«˜å¯ç”¨æ€§ï¼‰ã‚¯ãƒ©ã‚¹ã‚¿ãƒ»ã‚½ãƒ•ãƒˆã®å¤šããŒã€ä¿è·å¯¾è±¡ã®ãƒªã‚½ãƒ¼ã‚¹ã¨ã—ã¦PostgreSQLã‚’ã‚µãƒãƒ¼ãƒˆã—ã¦ã„ã¾ã™ã€‚ â– å¯ç”¨æ€§ã‚’ä¸Šã’ã‚‹ ã¾ãšã¯ã‚¯ãƒ©ã‚¹ã‚¿ãƒªãƒ³ã‚°ã®ãƒ¡ãƒªãƒƒãƒˆã‚’çŸ¥ã‚‹ãŸã‚ã«ã€åŸºæœ¬ã®ç¢ºèªã‚’ã—ã¾ã—ã‚‡ã†ã€‚ ã‚·ã‚¹ãƒ†ãƒ ã®
tom__bo 2015/10/22
postgresql

HA
ãƒªãƒ³ã‚¯
HAã‚¯ãƒ©ã‚¹ã‚¿ã§ PostgreSQLã‚’é«˜å¯ç”¨åŒ– (å¾Œç·¨) ï½ž ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ç·¨ ï½ž
HAã‚¯ãƒ©ã‚¹ã‚¿ã§ PostgreSQLã‚’é«˜å¯ç”¨åŒ– (å¾Œç·¨) ï½ž ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ç·¨ ï½ž ï¼’ï¼ï¼‘ï¼’å¹´ï¼™æœˆï¼’ï¼™æ—¥ ã—ãã¿+ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³å‹‰å¼·ä¼š æ¾å°¾ éš†åˆ© NTT OSSã‚»ãƒ³ã‚¿ 2 Copyright(c)2012 NTT, Inc. All Rights Reserved. ã¯ã˜ã‚ã« ï° ä»Šå›žã¯ã€ŽHAã‚¯ãƒ©ã‚¹ã‚¿ã§PostgreSQLã‚’é«˜å¯ç”¨åŒ–ã€ã®å¾Œç·¨ã§ã™ ï¿ ã‚¹ãƒˆãƒªãƒ¼ãƒŸãƒ³ã‚°ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³æ§‹æˆã®ã‚¯ãƒ©ã‚¹ã‚¿ãƒªãƒ³ã‚°ã®ãŠè©±ãŒãƒ¡ã‚¤ ãƒ³ã§ã™ ï¿ å‰ç·¨ã®å…¥é–€ç·¨ã‚’å¾©ç¿’ã•ã‚Œã¦ã„ã‚‹ã®ã‚’å‰æã«ãŠè©±ã—ã¾ã™ã€‚ â€¢ http://linux-ha.sourceforge.jp/wp/wp-content/uploads/pacemaker_20120526JPUG.pdf ï¿ ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³è‡ªä½“ã®ãŠè©±ã‚‚çœãã¾ã™ã€‚ 3 Copyright(c)2012 NTT, Inc. All Rights Reserved. ï°æ˜”ï½ž
tom__bo 2015/10/22
postgresql

HA
ãƒªãƒ³ã‚¯
HAã‚¯ãƒ©ã‚¹ã‚¿ã§PostgreSQLã‚’é«˜å¯ç”¨åŒ–ï¼ˆå‰ç·¨ï¼‰
Linux-HA Japan Project 1 HAã‚¯ãƒ©ã‚¹ã‚¿ã§ PostgreSQLã‚’é«˜å¯ç”¨åŒ– ï¼ˆå‰ç·¨ï¼‰ ï½žPacemakerå…¥é–€ç·¨ï½ž 2012å¹´5æœˆ26æ—¥ ç¬¬23å›žã—ãã¿+ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³å‹‰å¼·ä¼š Linux-HA Japan ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆ ç”°ä¸ å´‡å¹¸ Linux-HA Japan Project 2 ã¯ã˜ã‚ã«... DBå±‹ã•ã‚“ã§ã¯ãªã„ã®ã§ã€DBã«é–¢ã™ã‚‹è©³ã—ã„è©±ã¯ã§ ãã¾ã›ã‚“...ã€‚ PostgreSQLã‚’HAã‚¯ãƒ©ã‚¹ã‚¿åŒ–ã™ã‚‹ãŠè©±ã‚’ã—ã¾ã™ ãŒã€PostgreSQL9.1 ã® Streaming Replicationæ©Ÿèƒ½ã‚’ ç”¨ã„ãŸè©±ã¯ã—ã¾ã›ã‚“...ã€‚ï¼ˆå¾Œç·¨ã§ãŠè©±ã™ã‚‹äºˆå®šã§ã™ï¼‰ ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«æ–¹æ³•å«ã‚ã¦ã€HAã‚¯ãƒ©ã‚¹ã‚¿ã®è¶…åŸºæœ¬ã‹ã‚‰ ãŠè©±ã—ã¾ã™ã€‚ æ“¬äººåŒ–ã®è©±ã¯ã—ã¾ã›ã‚“ã€‚ Linux-HA Japan Project 3 è‡ªå·±ç´¹ä»‹ ï® åå‰ï¼š ç”°ä¸å´‡å¹¸ (Takayuki Tanaka) ï‚¨ Twi
tom__bo 2015/10/22
postgresql

HA
ãƒªãƒ³ã‚¯
MHA for MySQLã¨DeNAã®ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã®è©±
5. å˜ä¸€éšœå®³ç‚¹ã‚’ç„¡ãã—ãŸã„ Single Point of Failure: ãã®ç®‡æ‰€ãŒãƒ€ã‚¦ãƒ³ã™ã‚‹ã¨ã‚µãƒ¼ãƒ“ã‚¹ãŒ æ¢ã¾ã‚‹ ã„ã‹ãªã‚‹æ™‚ã«ã‚‚ç·Šæ€¥å¯¾å¿œãŒå¿…è¦ã«ãªã‚‹ æ—©æœã ã‚ã†ã¨æ·±å¤œã ã‚ã†ã¨å¯¾å¿œãŒå¿…è¦ ã‚¢ãƒ—ãƒªã®æ•°ãŒå¤šã‘ã‚Œã°ç¢ºçŽ‡ã‚‚ä¸ŠãŒã‚‹ ãƒ¡ãƒ³ãƒãƒ¼ã‚‚ç–²å¼Šã™ã‚‹ MySQLã®ä¸–ç•Œã§ã¯ ã‚¹ãƒ¬ãƒ¼ãƒ–ã¯å†—é•·åŒ–ã«ã‚ˆã£ã¦SPoFã§ãªãã™ã“ã¨ã¯ç°¡å˜ ãƒžã‚¹ã‚¿ãƒ¼ã¯1å€‹ã—ã‹ç„¡ã„ã‹ã‚‰é›£ã—ã„ 5 6. MySQLãƒžã‚¹ã‚¿ãƒ¼éšœå®³å¯¾å¿œã®èª²é¡Œ ãƒ»MySQLã®ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã¯éžåŒæœŸã¾ãŸã¯ Writer IP æº–åŒæœŸ master ãƒ»ãƒžã‚¹ã‚¿ãƒ¼éšœå®³æ™‚ã«ã€ä¸€éƒ¨ã®ã‚¹ãƒ¬ãƒ¼ãƒ– (ã‚ã‚‹ã„ã¯å…¨éƒ¨ã®ã‚¹ãƒ¬ãƒ¼ãƒ–)ãŒ id=99 æœ€æ–°ã®ãƒã‚¤ãƒŠãƒªãƒã‚°ã‚’å—ã‘å–ã£ã¦ã„ãªã„ id=100 id=101 å¯èƒ½æ€§ãŒã‚ã‚‹ id=102 ãƒ»ã‚¹ãƒ¬ãƒ¼ãƒ–é–“ã§ã€ãƒã‚¤ãƒŠãƒªãƒã‚°ã®è»¢é€çŠ¶æ³ã« 1. Save binlog events that ãšã‚ŒãŒç”Ÿã˜ã¦ã„ã‚‹å¯èƒ½æ€§ãŒã‚ã‚‹ exist o
tom__bo 2015/07/01
MySQL

MHA
ãƒªãƒ³ã‚¯
1