[B! pgpool] nao-tã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

nao-t id:nao-t

pgpoolã«é–¢ã™ã‚‹nao-tã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (6)

${{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ãŒèµ·å‹•ã§ããªã„ - kunikuâ€™s diary
ãšã„ã¶ã‚“å‰ã«æ›¸ã„ã¦ãŸã‘ã©ã€ãšãƒ¼ã£ã¨ä¸‹æ›¸ãã«ãªã£ã¦ãŸã€‚ #pgpool ã§pgpoolã‚’é–‹å§‹ã™ã‚‹ã‘ã©ã€ã‚³ãƒ³ã‚½ãƒ¼ãƒ«ã«ä½•ã‚‚å‡ºã¦ã“ãªã„ï¼ ãƒ—ãƒã‚»ã‚¹ã‚’ç¢ºèªã—ã¦ã‚‚å˜åœ¨ã—ãªã„ã€‚ ã‘ã©ã€ pgpoolã‚’åœæ¢ã™ã‚‹ pgpool stop ã‚’å®Ÿè¡Œã™ã‚‹ã¨ã€ãã‚“ãªãƒ—ãƒã‚»ã‚¹IDå˜åœ¨ã—ããƒ¼ã‚ˆ ã£ã¦ãŠã“ã‚‰ã‚Œã‚‹ã€‚ ãªã‚“ã§ã ã‚ãƒ»ãƒ»ãƒ» pgpool.conf ã®è¨å®šã—ãŸã®ã«ãƒ»ãƒ»ãƒ»ã¨æ€ã£ã¦ãƒãƒƒãƒˆã§æ¤œç´¢ã—ã¦ã‚‚ã‚ˆã†ã‚ã‹ã‚‰ã‚“ã€‚ ã¨æ€ã£ã¦ãŸã‚‰ã€pgpoolã®ãƒã‚°ãŒå‡ºåŠ›ã§ãã‚‹ã‚ˆã†ãªã®ã§ã€ãƒã‚°ã‚’å‡ºåŠ›ã‹ã‚‰èª¿æŸ»ã—ã¦ã¿ãŸã€‚ pgpoolã®ãƒã‚°ã‚’è¿½ã£ã¦ã¿ã‚‹ã€‚ http://74.125.153.132/search?q=cache:uDj8Eyj2d84J:www2b.biglobe.ne.jp/~caco/pgpool/+pgpool+%E3%80%80log&cd=1&hl=ja&ct=clnk&gl=jp&lr=lang_ja ã‚’è¦‹ã‚‹ã¨ã€
nao-t 2012/11/05
pgpool

è¨å®š
ãƒªãƒ³ã‚¯
ã€ã‚³ãƒ©ãƒ ã€‘Yet Another ä»•äº‹ã®ãƒ„ãƒ¼ãƒ« (29) pgpoolã®éšœå®³å¾©æ—§æ‰‹é †(2) | ã‚¨ãƒ³ã‚¿ãƒ¼ãƒ—ãƒ©ã‚¤ã‚º | ãƒžã‚¤ãƒŠãƒ“ãƒ‹ãƒ¥ãƒ¼ã‚¹
nao-t 2012/10/18
pgpool

postgresql

ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—
ãƒªãƒ³ã‚¯
ã€PostgreSQLã€‘pgpool-â…¡ã§ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã€ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã¨è¨å®š
PostgreSQLã§ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã™ã‚‹ã«ã¯pgpool-â…¡ã¨ã„ã†ãƒŸãƒ‰ãƒ«ã‚¦ã‚§ã‚¢ã§ç°¡å˜ã«ã§ãã‚‹ã¨ã„ã†ã“ã¨ãªã®ã§ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã¨è¨å®šã‚’ãƒ¡ãƒ¢ã€‚ å‚è€ƒã«ãªã‚‹ã‚µã‚¤ãƒˆã¯ä¸‹è¨˜ ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å¤ã®é™£ã€‘PostgreSQLã«ã¯çµ¶å¯¾ï¼pgpool-II pukiwiki:pgpoolAdmin/install (ä»®ã‚¿ã‚¤ãƒˆãƒ«)pgpool-IIã«ã‚ˆã‚‹ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã¨ã‚ªãƒ³ãƒ©ã‚¤ãƒ³ãƒªã‚«ãƒãƒª ã¾ãšã¯PostgreSQLã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã€‚ã‚„ã‚Šæ–¹ã¯å‰ã®è¨˜äº‹ã‚’å‚è€ƒã«ã€‚ pgpoolã¯ã“ã“ã‹ã‚‰ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã€‚ è§£å‡ã¨ã‚³ãƒ³ãƒ‘ã‚¤ãƒ« # tar xzvf pgpool-II-2.2.tar.gz # cdÂ pgpool-II-2.2 # ./configure # make # make install ã‚ªãƒ³ãƒ©ã‚¤ãƒ³ãƒªã‚«ãƒãƒªã®ãŸã‚ã®ãƒ©ã‚¤ãƒ–ãƒ©ãƒªã‚‚ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« # su postgres $ cd /opt/software/pgpool
nao-t 2011/07/07
postgreSQL

pgpool
ãƒªãƒ³ã‚¯
pgpool-II ãƒ¦ãƒ¼ã‚¶ãƒžãƒ‹ãƒ¥ã‚¢ãƒ«
(*)ãƒ‘ãƒ©ãƒ¬ãƒ«ã‚¯ã‚¨ãƒªãƒ¢ãƒ¼ãƒ‰ã§ã¯ãƒ‡ãƒ¼ã‚¿ã‚’åˆ†å‰²ã—ã¦ä¿å˜ã—ã¦ã„ã‚‹ãƒ†ãƒ¼ãƒ–ãƒ«ã«å¯¾ã—ã¦ã¯ã€ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ãªã‚‰ã³ã«è² è·åˆ†æ•£ã®æ©Ÿèƒ½ã¯ä½¿ãˆã¾ã›ã‚“ã€‚ pcp.confã®è¨å®š ã©ã®å‹•ä½œãƒ¢ãƒ¼ãƒ‰ã§ã‚‚ã€pcp.confã®è¨å®šã¯å¿…è¦ã§ã™ã€‚pgpool-IIã«ã¯ç®¡ç†è€…ãŒpgpool-IIã® åœæ¢ã‚„æƒ…å ±å–å¾—ãªã©ã®ç®¡ç†æ“ä½œã‚’è¡Œã†ãŸã‚ã®ã‚¤ãƒ³ã‚¿ãƒ¼ãƒ•ã‚§ã‚¤ã‚¹ãŒç”¨æ„ã•ã‚Œã¦ã„ã¾ ã™ã€‚ãã®ã‚¤ãƒ³ã‚¿ãƒ¼ãƒ•ã‚§ã‚¤ã‚¹ã‚’åˆ©ç”¨ã™ã‚‹ãŸã‚ã«ã¯ãƒ¦ãƒ¼ã‚¶èªè¨¼ãŒå¿…è¦ã«ãªã‚‹ã®ã§ã€ã ã®ãƒ¦ãƒ¼ã‚¶åã¨ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ã‚’pcp.confã«ç™»éŒ²ã—ã¾ã™ã€‚ pgpool-IIã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã™ã‚‹ã¨ã€$prefix/etc/pcp.conf.sampleãŒã§ãã‚‹ã®ã§ã€ãã‚Œã‚’ $prefix/etc/pcp.confã¨ã„ã†åå‰ã§ã‚³ãƒ”ãƒ¼ã—ã¾ã™ã€‚ cp $prefix/etc/pcp.conf.sample $prefix/etc/pcp.conf pcp.confã§ã¯ç©ºç™½è¡Œã‚„#ã§å§‹ã¾ã‚‹è¡Œã¯ã‚³ãƒ¡
nao-t 2011/07/07
pgpool

PostgreSQL
ãƒªãƒ³ã‚¯
pgpoolã‚’ä½¿ã£ãŸPostgreSQLã®ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³
ã“ã‚“ã°ã‚“ã¯ã€ç‰§é‡Žã§ã™ã€‚ å‰å›žã€ãã®å‰ã®å‰ã¨PostgreSQLã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã«ã¤ã„ã¦ã§ã—ãŸãŒä»Šæ—¥ã‚‚PostgreSQLé–¢é€£ã§ã€PostgreSQLã§ã®ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã«ã¤ã„ã¦ã§ã™ã€‚ MySQLã®å ´åˆã€åˆ¥ã®ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã‚’ä½¿ã‚ãªãã¦ã‚‚MySQLã ã‘ã§ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’å®Ÿç¾ã§ãã¾ã™ãŒã€PostgreSQLã®å ´åˆã¯åˆ¥é€”å°‚ç”¨ã®ã‚½ãƒ•ãƒˆãŒå¿…è¦ã«ãªã‚Šã¾ã™ã€‚ ä»Šå›žã¯ãã‚“ãªã‚½ãƒ•ãƒˆã®1ã¤ã€pgpool-II(ä»¥ä¸‹pgpoolã¨æ›¸ã„ã¦ã„ã¾ã™ï¼‰ã‚’ä½¿ã£ãŸãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’ç´¹ä»‹ã—ã¾ã™ã€‚ pgpoolã‚’ä½¿ã†ã¨ã€PostgreSQLã§æ‰‹è»½ã«ãƒžãƒ«ãƒãƒžã‚¹ã‚¿æ–¹å¼ã®ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’å®Ÿç¾ã§ãã¾ã™ã€‚ ä»–ã«ã‚‚ã€ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ãƒ—ãƒ¼ãƒªãƒ³ã‚°ã€ã‚¢ã‚¯ãƒ†ã‚£ãƒ–ã‚¹ã‚¿ãƒ³ãƒã‚¤ã€slony-Iç‰ã®ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚½ãƒ•ãƒˆã¨çµ„ã¿åˆã‚ã›ãŸãƒžã‚¹ã‚¿ãƒ»ã‚¹ãƒ¬ãƒ¼ãƒ–æ–¹å¼ã®ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã€æ™‚é–“ãŒã‹ã‹ã‚‹æ¤œç´¢å‡¦ç†ã‚’è¤‡æ•°ã‚µãƒ¼ãƒã§ä¸¦åˆ—å‡¦ç†ã•ã›ã‚‹ï¼ˆãƒ‘ãƒ©ãƒ¬ãƒ«ãƒ¢ãƒ¼ãƒ‰ï¼‰ã¨ã„ã†ã‚ˆã†ãªã“ã¨ãŒã§ã
nao-t 2011/07/07
postgresql

pgpool
ãƒªãƒ³ã‚¯
pgpool-II + HS/SRã‚¯ãƒ©ã‚¹ã‚¿æ§‹æˆ â€” Let's Postgres
SRA OSS, inc. åŒ—å· ä¿Šåºƒ ã¯ã˜ã‚ã« æœ¬ç¨¿ã§ã¯ã€pgpool-II 3.0 ã¨ PostgreSQL 9.0 ã® Streaming Replication/Hot Standbyï¼ˆä»¥é™SR/HSã¨è¡¨è¨˜ã—ã¾ã™ï¼‰æ©Ÿèƒ½ã‚’çµ„ã¿åˆã‚ã›ãŸã‚¯ãƒ©ã‚¹ã‚¿æ§‹æˆã«ã¤ã„ã¦è§£èª¬ã—ã¾ã™ã€‚ pgpool-II 3.0 pgpool-II ã¯ã€2010å¹´9æœˆã«ãƒãƒ¼ã‚¸ãƒ§ãƒ³ 2.3 ã‹ã‚‰ãƒãƒ¼ã‚¸ãƒ§ãƒ³ 3.0 ã¸å¤§å¹…ãªãƒ¡ã‚¸ãƒ£ãƒ¼ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã‚¢ãƒƒãƒ—ãŒè¡Œã‚ã‚Œã¾ã—ãŸã€‚3.0 ã«ãŠã‘ã‚‹å¤§ããªå¤‰æ›´ç‚¹ã¯ SR/HS ã¸ã®å¯¾å¿œã§ã€ä¸»ã«ã‚¯ã‚¨ãƒªæŒ¯ã‚Šåˆ†ã‘ã®å‡¦ç†ã«å¤‰æ›´ãŒåŠ ãˆã‚‰ã‚Œã¦ã„ã¾ã™ã€‚ pgpool-II ã§æ¬¡ã®ã¨ãŠã‚Šãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿è¨å®šã‚’ã™ã‚‹ã¨ã€SR/HSã‚¯ãƒ©ã‚¹ã‚¿æ§‹æˆã«é©ã—ãŸå‹•ä½œã‚’ã—ã¾ã™ã€‚master_slave_sub_mode ã¯ã€pgpool-II 3.0ã§æ–°è¨ã•ã‚ŒãŸãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ã§ã™ã€‚ master_slave_mode = true ma
nao-t 2011/07/07
postgresql

pgpool
ãƒªãƒ³ã‚¯
1