[B! pgpool] sbuskã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

sbusk id:sbusk

pgpoolã«é–¢ã™ã‚‹sbuskã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (3)

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

Pgpoolã®å„å‹•ä½œãƒ¢ãƒ¼ãƒ‰ã®ä½¿ã„ã©ã“ã‚ - takami_hirokiâ€™s blog
Pgpoolã«ã¯ã€ä»¥ä¸‹ã®ã‚ˆã†ãªå‹•ä½œãƒ¢ãƒ¼ãƒ‰ãŒã‚ã‚Šã€ç”¨é€”ã«ã‚ˆã£ã¦ä½¿ã„åˆ†ã‘ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ãã‚Œãžã‚Œã®ç‰¹å¾´ã‚„ãƒ¡ãƒªãƒƒãƒˆã‚’ã¾ã¨ã‚ãŸä¸Šã§ã€å„å‹•ä½œãƒ¢ãƒ¼ãƒ‰ã®ä½¿ã„ã©ã“ã‚ã‚’æ•´ç†ã—ã¦ã¿ãŸã„ã¨æ€ã„ã¾ã™ã€‚ç‰¹ã«ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³æ©Ÿèƒ½ã«é–¢ã™ã‚‹é•ã„ãŒãƒã‚¤ãƒ³ãƒˆã¨ãªã‚Šã¾ã™ã€‚ ã“ã“ã§ã¯ã€Pgpool2.3.3ã‚’ãƒ™ãƒ¼ã‚¹ã«è¨˜è¿°ã—ã¦ã„ã¾ã™ã€‚ ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ãƒ¢ãƒ¼ãƒ‰ã§ã®åˆ©ç”¨ ã“ã®å‹•ä½œãƒ¢ãƒ¼ãƒ‰ã¯ã€Pgpoolå˜ä½“ã§ã€ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³æ©Ÿèƒ½ã‚’æä¾›ã§ãã‚‹ã¨ã„ã†ç‰¹å¾´ãŒã‚ã‚Šã¾ã™ã€‚ å‹•ä½œæ¦‚è¦ INSERT,UPDATE,DELETEã¯ãƒžã‚¹ã‚¿ã€ã‚¹ãƒ¬ãƒ¼ãƒ–ä¸¡æ–¹ã«ç™ºè¡Œ SELECTã¯ã€ãƒžã‚¹ã‚¿ã€ã‚¹ãƒ¬ãƒ¼ãƒ–ã®ã©ã¡ã‚‰ã‹ã«ç™ºè¡Œ SELECTã¯ã€è¤‡æ•°ã®ã‚µãƒ¼ãƒã«å¯¾ã—ã¦ã€è² è·åˆ†æ•£å¯èƒ½ æ©Ÿèƒ½çš„ãªãƒ¡ãƒªãƒƒãƒˆã‚„ãƒ‡ãƒ¡ãƒªãƒƒãƒˆ Pgpoolã®ã¿ã§ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³å¯èƒ½ã§ã‚ã‚Šã€ä»–ã®ãƒŸãƒ‰ãƒ«ã‚¦ã‚§ã‚¢ã¯ä¸è¦ï¼ˆâ—‹ï¼‰ åŒæœŸãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã§ã‚ã‚‹ãŸã‚ã€SELECTã‚’è² è·åˆ†æ•£ã—ãŸå ´åˆã‚‚ã€ãƒŽãƒ¼ãƒ‰ã«ã‚ˆã£ã¦çµæžœãŒç•°
sbusk 2010/11/08
pgpool

postgresql
ãƒªãƒ³ã‚¯
ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ãƒ—ãƒ¼ãƒ«ã§æŽ¥ç¶šè² è·ã‚’è»½æ¸›ï¼
ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ãƒ—ãƒ¼ãƒ«ã¨ã¯ ã€Œç¬¬1å›žï¼špgpool-IIã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«æ–¹æ³•ï¼ˆhttp://www.thinkit.co.jp/article/98/1/ï¼‰ã€ã§ã¯ã€pgpool-IIã¨Webãƒ™ãƒ¼ã‚¹ã®ç®¡ç†ãƒ„ãƒ¼ãƒ«ã§ã‚ã‚‹pgpoolAdminã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«æ–¹æ³•ã«ã¤ã„ã¦è§£èª¬ã—ã¾ã—ãŸã€‚ä»Šå›žã¯ã€pgpool-IIã®ã€Œã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ãƒ—ãƒ¼ãƒ«ã€æ©Ÿèƒ½ã«ã¤ã„ã¦è§£èª¬ã—ã¾ã™ã€‚ ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ãƒ—ãƒ¼ãƒ«ã¨ã¯ã€ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã‹ã‚‰pgpool-IIã¸ã®æŽ¥ç¶šãŒåˆ‡æ–ã—ãŸæ™‚ã€pgpool-IIã‹ã‚‰PostgreSQLé–“ã®æŽ¥ç¶šã‚’ä¿æŒã—ã€å¾Œã§æ–°ãŸã«ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã‹ã‚‰ã®æŽ¥ç¶šè¦æ±‚ã‚’å—ã‘ãŸæ™‚ã«å†åˆ©ç”¨ã™ã‚‹ã“ã¨ã§ã€æŽ¥ç¶šã«ã‚ˆã‚‹ã‚ªãƒ¼ãƒãƒ¼ãƒ˜ãƒƒãƒ‰ã‚’è»½æ¸›ã™ã‚‹æ©Ÿèƒ½ã§ã™ã€‚ ç‰¹ã«Webã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®ã‚ˆã†ã«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«å¯¾ã™ã‚‹æŽ¥ç¶šã€åˆ‡æ–ã‚’é »ç¹ã«ç¹°ã‚Šè¿”ã™ã‚·ã‚¹ãƒ†ãƒ ã«ãŠã„ã¦ã€å…¨ä½“çš„ã«ã‚¹ãƒ«ãƒ¼ãƒ—ãƒƒãƒˆã‚’å‘ä¸Šã•ã›ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ pgpool-IIã®ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ãƒ—ãƒ¼ãƒ«ã®ç‰¹å¾´ ã‚³ãƒã‚¯ã‚·
sbusk 2008/07/10
postgresql

pgpool
ãƒªãƒ³ã‚¯
pgpool-IIã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«æ–¹æ³•
pgpoolã¨ã¯ pgpoolã¨ã¯PostgreSQLå°‚ç”¨ã®ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ãƒ—ãƒ¼ãƒªãƒ³ã‚°ã‚µãƒ¼ãƒãƒ¼ã§ã™ã€‚2004å¹´ã«ãƒ•ã‚¡ãƒ¼ã‚¹ãƒˆãƒãƒ¼ã‚¸ãƒ§ãƒ³ãŒãƒªãƒªãƒ¼ã‚¹ã•ã‚Œã€2006å¹´ã«ã¯ãƒ‘ãƒ©ãƒ¬ãƒ«ã‚¯ã‚¨ãƒªãªã©ã®æ–°æ©Ÿèƒ½ã‚’å®Ÿè£…ã—ãŸpgpool-IIãŒç™»å ´ã—ã€ãã®å¾Œã‚‚ã‚ªãƒ³ãƒ©ã‚¤ãƒ³ãƒªã‚«ãƒãƒªãƒ¼ãªã©ã®æ–°ã—ã„æ©Ÿèƒ½ã‚’æ¬¡ã€…ã¨å®Ÿè£…ã—ãªãŒã‚‰é€²åŒ–ã‚’ç¶šã‘ã¦ã„ã¾ã™ã€‚ æœ€è¿‘ã§ã¯ã€éžåŒæœŸãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚·ã‚¹ãƒ†ãƒ ã¨ã—ã¦äººæ°—ã®é«˜ã„Slony-Iã¨ã®çµ„ã¿åˆã‚ã›ã‚„ã€PostgreSQL 8.2ã‹ã‚‰ã®æ–°æ©Ÿèƒ½ã§ã‚ã‚‹warm standbyã¨ã®çµ„ã¿åˆã‚ã›ã¨ã„ã£ãŸæ–°ã—ã„æ´»ç”¨æ–¹æ³•ã‚‚æ³¨ç›®ã•ã‚Œã¦ã„ã¾ã™ã€‚ æœ¬é€£è¼‰ã§ã¯ã€å¤šæ§˜ãªpgpool-IIã®æ´»ç”¨æ–¹æ³•ã®ä¸ã‹ã‚‰æœ€ã‚‚ã‚ˆãä½¿ã‚ã‚Œã¦ã„ã‚‹ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ãƒ—ãƒ¼ãƒªãƒ³ã‚°ã¨ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’ä¸å¿ƒã«æ´»ç”¨æ–¹æ³•ã‚’è§£èª¬ã—ã¾ã™ã€‚ ç¬¬1å›žã¯pgpool-IIã®æ©Ÿèƒ½ã®ç°¡å˜ãªç´¹ä»‹ã¨ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«æ–¹æ³•ã«ã¤ã„ã¦è§£èª¬ã—ã¾ã™ã€‚ å¤šæ©Ÿèƒ½ãƒŸãƒ‰ãƒ«ã‚¦ã‚¨ã‚¢pgpool-II pgpo
sbusk 2008/07/03
postgresql

pgpool

è² è·åˆ†æ•£

å†—é•·
ãƒªãƒ³ã‚¯
1

ãŠçŸ¥ã‚‰ã›

ã‚‚ã£ã¨èªã‚€

å…¬å¼Twitter

@hatebu
æœ€æ–°ã®äººæ°—ã‚¨ãƒ³ãƒˆãƒªãƒ¼ã®é…ä¿¡

ã‚ãƒ¼ãƒœãƒ¼ãƒ‰ã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆä¸€è¦§

jæ¬¡ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

kå‰ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

lã‚ã¨ã§èªã‚€

eã‚³ãƒ¡ãƒ³ãƒˆä¸€è¦§ã‚’é–‹ã

oãƒšãƒ¼ã‚¸ã‚’é–‹ã

è¨å®šã‚’å¤‰æ›´ã—ã¾ã—ãŸx

ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

ã‚¿ã‚°

é–¢é€£ã‚¿ã‚°ã§çµžã‚Šè¾¼ã‚€ (3)

pgpoolã«é–¢ã™ã‚‹sbuskã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (3)

ãŠçŸ¥ã‚‰ã›

ã€Œã‚ã¨ã§èªã‚€ã€ã‚¿ã‚°ã§æŒ¯ã‚Šè¿”ã‚‹2024å¹´ ã€œä»Šå¹´ã®ã€Œã‚ã¨ã§èªã‚€ã€ã€ä»Šå¹´ã®ã†ã¡ã«ã€œ

ä»Šé€±ã®ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚ãƒ³ã‚°ï¼ˆ2024å¹´12æœˆç¬¬3é€±ï¼‰

ä»Šé€±ã®ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚ãƒ³ã‚°ï¼ˆ2024å¹´12æœˆç¬¬2é€±ï¼‰

å…¬å¼Twitter

ã‚ãƒ¼ãƒœãƒ¼ãƒ‰ã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆä¸€è¦§

ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

å…¬å¼Twitter

ã¯ã¦ãªã®ã‚µãƒ¼ãƒ“ã‚¹

ã‚¿ã‚°

é–¢é€£ã‚¿ã‚°ã§çµžã‚Šè¾¼ã‚€ (3)

pgpoolã«é–¢ã™ã‚‹sbuskã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (3)

Pgpoolã®å„å‹•ä½œãƒ¢ãƒ¼ãƒ‰ã®ä½¿ã„ã©ã“ã‚ - takami_hirokiâ€™s blog

ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ãƒ—ãƒ¼ãƒ«ã§æŽ¥ç¶šè² è·ã‚’è»½æ¸›ï¼

pgpool-IIã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«æ–¹æ³•

ãŠçŸ¥ã‚‰ã›

ã€Œã‚ã¨ã§èª­ã‚€ã€ã‚¿ã‚°ã§æŒ¯ã‚Šè¿”ã‚‹2024å¹´ ã€œä»Šå¹´ã®ã€Œã‚ã¨ã§èª­ã‚€ã€ã€ä»Šå¹´ã®ã†ã¡ã«ã€œ

ä»Šé€±ã®ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚­ãƒ³ã‚°ï¼ˆ2024å¹´12æœˆç¬¬3é€±ï¼‰

ä»Šé€±ã®ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚­ãƒ³ã‚°ï¼ˆ2024å¹´12æœˆç¬¬2é€±ï¼‰

å…¬å¼Twitter

ã‚­ãƒ¼ãƒœãƒ¼ãƒ‰ã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆä¸€è¦§

ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

å…¬å¼Twitter

ã¯ã¦ãªã®ã‚µãƒ¼ãƒ“ã‚¹

é–¢é€£ã‚¿ã‚°ã§çµžã‚Šè¾¼ã‚€ (3)

pgpoolã«é–¢ã™ã‚‹sbuskã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (3)

Pgpoolã®å„å‹•ä½œãƒ¢ãƒ¼ãƒ‰ã®ä½¿ã„ã©ã“ã‚ - takami_hirokiâ€™s blog

ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ãƒ—ãƒ¼ãƒ«ã§æŽ¥ç¶šè² è·ã‚’è»½æ¸›ï¼

pgpool-IIã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«æ–¹æ³•

ãŠçŸ¥ã‚‰ã›

ã€Œã‚ã¨ã§èªã‚€ã€ã‚¿ã‚°ã§æŒ¯ã‚Šè¿”ã‚‹2024å¹´ ã€œä»Šå¹´ã®ã€Œã‚ã¨ã§èªã‚€ã€ã€ä»Šå¹´ã®ã†ã¡ã«ã€œ

ä»Šé€±ã®ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚ãƒ³ã‚°ï¼ˆ2024å¹´12æœˆç¬¬3é€±ï¼‰

ä»Šé€±ã®ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚ãƒ³ã‚°ï¼ˆ2024å¹´12æœˆç¬¬2é€±ï¼‰

å…¬å¼Twitter

ã‚ãƒ¼ãƒœãƒ¼ãƒ‰ã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆä¸€è¦§

ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

å…¬å¼Twitter

ã¯ã¦ãªã®ã‚µãƒ¼ãƒ“ã‚¹