[pgpool-general-jp: 70] 縮退運転とパラメータ設定について

[Masami GOTO]

$B$O$8$a$^$7$F!"8eF#$H?=$7$^$9!#(B

pgpool$B-6$r%F%9%H$7$F$*$j$^$9$,!"%Q%i%a!<%?@_Dj$KLdBj$,$"$k$N$+!"(B
$B=LB`1?E>$K$D$$$F0U?^$9$kF0:n$r$7$^$;$s!#(B

$B!J9=@.!K(B
$B!Z(Btesthost1$B![(Bpgpool+masterDB
$B!&(Bdebian/GNU 3.1(kernel2.6)
$B!&(Bpgpool$B-6(B 1.0.1
$B!&(Bpostgres8.1.5
$B!Z(Btesthost2$B![(BslaveDB
$B!&(Bdebian/GNU 3.1(kernel2.6)
$B!&(Bpostgres8.1.5

$B!J(Bpgpool.conf$B$N<g$J ＠ _Dj!K(B
-------------------------------------
replication_mode = true
replication_strict = true
load_balance_mode = true
replication_stop_on_mismatch = true

system_db_hostname = 'localhost'
system_db_port = 5433

backend_hostname0 = 'localhost'
backend_port0 = 5431
backend_weight0 = 1
backend_hostname1 = 'testhost2'$B!!!!(B
backend_port1 = 5431
backend_weight1 = 0
-------------------------------------
$B!!(B
$B!J0U?^$9$kF0:n!K(B
$B#1!%(Btesthost1$B$N(Bpostgres$B!J(BsystemDB$B$H$OJL!K$rDd;_$5$;$?:]"*=LB`(B
$B#2!%#2(BHOST$B4V$H$G(BDB$BFb%G!<%?IT ＠ 09g$,5/$-$?>l9g"*=LB`$;$:IT ＠ 09g$N$^$^2TF0(B

$B!J8=:_$NF0:n!K(B
$B#1!%=LB`$;$:!#!J0J2<$N%W%m%s%W%H%a%C%;!<%8!K(B
test=# select * from test2;
server closed the connection unexpectedly
        This probably means the server terminated abnormally
        before or while processing the request.
The connection to the server was lost. Attempting reset: Succeeded.

$B#2!%=LB`$;$:IT ＠ 09g$N$^$^2TF0!J0U?^DL$j$K2TF0!K(B

load_balance_mode = false$B$H$9$l$P!"#1!%$N%1!<%9$OK~$?$5$l$^$9$,!"(B
$B#2!%$N%1!<%9$,(BNG$B$K$J$C$F$7$^$$$^$9!#(B
$B$^$?!"(Bload_balance_mode = true$B$H$9$l$P!"#2!%$N%1!<%9$,K~$?$5$l$^$9$,!"(B
$B#1!%$N%1!<%9$G$O(BNG$B$K$J$C$F$7$^$$$^$9!#(B

$BD9!9$H?=$7Lu$"$j$^$;$s$,!"#1!%#2!%6&$KK~$?$5$l$k$?$a$K$O$I$N$h$&$K ＠ _Dj$r9T$((B
$B$P(B
$BNI$$$N$G$7$g$&$+!)(B

-------------------------
Masami GOTO
m-goto ＠ networld.ne.jp