Mailing List Archive

$B0KF#$5$s(B
$B>>Hx$H?=$7$^$9!#(B

$BEl$5$s$,6D$C$F$k%+%9%1!<%I$OL5M}$+$b$7$l$^$;$s$,!"(B
$B0J2<$N$h$&$J%9%?!<7?$J$i!"(BRA$B$K<BAu$O$"$j$^$9!#(B

Master
+------Slave
+------Slave
+------Slave

$B$"$^$j<{MW$,$J$/%a%s%F$5$l$F$$$J$$5!G=$J$N$G!"(B
$B:G6a$N(BPostgreSQL$B$GF0:n$9$k$+$I$&$+$OA4$/$o$+$j$^$;$s!#(B
$B"((B $B>&MQ$G;H$&$J$i!"$+$J$jCm0U$,I,MW$+$H;W$$$^$9(B


$B$A$J$_$K!"<BAu%3!<%I$O$3$3$G$9$M!#(B
$B"((B2$BBfL\0J9_$N(BSlasve$B$O(BPOTENTIAL ($BF0$-$O(BASYNC)$B$H$J$j$^$9(B
---
"STREAMING|POTENTIAL")
change_data_status "$target" "$data_status"
change_master_score "$target" "$CAN_NOT_PROMOTE"
change_pgsql_status "$target" "HS:potential"
;;
----

2016$BG/(B3$B7n(B17$BF|(B 11:52 <kazuh@goo.jp>:
> $B0KF#MM(B
>
> $B$R$,$7$H?=$7$^$9!#(B
> $B$*@$OC$K$J$j$^$9!#(B
>
>>PostgreSQL$B>e$KJ#?t%$%s%9%?%s%9$r:n@.$7!"(B
>>$B$5$i$K!"(BMaster$B#1Bf!\(BSlave$B#2Bf9=@.$K$7$?>l9g$G$b(BPacemaker$B$G@)8f2DG=$G$7$g$&$+!)(B
>
> $B;DG0$J$,$i!"(BPacemaker($B$H$$$&$+(Bpgsql RA)$B$O!"(B3$BBf$N(BPostgreSQL$B$G%l%W%j%1!<%7%g%s$N(B
> $B@)8f$r$9$k$3$H$O$G$-$^$;$s!#(B
>
> 3$B=E2=$9$k>l9g!"$^$:(B2$BBf$G(BPacemaker$B$rMQ$$(BMaster-Slave$B9=@.$rAH$_!"(B
> $B$=$N(BSlave$B$K#3BfL\$r(BPacemaker$B$r;H$o$:$K@\B3$5$;$k!"$H$$$&J}K!$,(B
> $B9M$($i$l$^$9!#(B
>
> Master <--- Slave(1) <--- Slave(2)
> $B",(B $B",(B $B",(B
> Pacemaker$B$G4IM}(B $B<jF0$G(BSlave(1)$B$K@\B3(B
> ($B$$$o$f$k(BPG-REX)
>
> Master$B$*$h$S(BSlave(1)$B$O(BPacemaker$B$G4IM}$7$F$$$k$N$G!"(BMaster$B$^$?$O(BSlave(1)$B$,(B
> $B8N>c$7$?>l9g$O!"<+F0E*$K%U%'%$%k%*!<%P$7%5!<%S%9$,7QB3$7$^$9!#(B
>
> Slave(2)(3$BBfL\(B)$B$O(BPacemaker$B$,4IM}$7$F$$$J$$$N$G!"(BMaster$B$H(BSlave(1)$B$,8N>c$7$?>l9g$O!"(B
> $B<jF0$G(Bpg_ctl promote $B%3%^%s%I$r<B9T$7!"(BMaster$B2=$9$kI,MW$,$"$j$^$9!#(B
>
> Slave(2)$B$K$O<jF0$G(Brecovery.conf$B$r:n@.$7!"(BSlave(1)$B$G2TF/$7$F$$$k2>A[.(BIP$B%"%I%l%9(B
> (vip-slave)$B$K@\B3$5$;$^$9!#(B
> $B$3$&$9$k$3$H$G!"(BMaster$B$^$?$O(BSlave(1)$B$,8N>c$7$?>l9g$G$b!"(BPacemaker$B$,2>A[.(BIP$B$r(B
> $BF0$+$9$3$H$G(BSlave(2)$B$N%l%W%j%1!<%7%g%s@\B3$O<+F0E*$K7QB3$7$^$9!#(B
> $B$J$*!"$3$NF0:n$N$?$a!"K\9=@.$K$O!"(BPostgreSQL9.3$B0J>e$,I,?\$G$9!#(B
>
>
> Slave(2)$B$O!"D>@\(BMaster$B$K@\B3$9$k$3$H$b$G$-$^$9$,!"$=$N>l9g!"(BSlave(1)$B$h$j$b(B
> $B%G!<%?$,?J$s$G$7$^$&>l9g$,$"$j!"$=$N=V4V$K%U%'%$%k%*!<%P$,H/@8$9$k$H!"(B
> $B?7(BMaster($B5l(BSlave(1))$B$K@\B3$G$-$J$/$J$k!"$H$$$&LdBj$,H/@8$9$k2DG=@-$,$"$k$?$a(B
> $B$*4+$a$7$^$;$s!#(B
> $B>e5-$N$h$&$K?t<n$D$J$.(B($B%+%9%1!<%I(B)$B$K$9$k$3$H$r$*4+$a$7$^$9!#(B
>
>
> $B$J$*!"(BPG-REX$B$*$h$S(BPostgreSQL$B$K$D$$$F$O0J2<%5%$%H$J$I$b;29M$K$J$k$H;W$$$^$9!#(B
>
> $B"#(BJPUG $BBh(B24$B2s$7$/$_(B+$B%"%W%j%1!<%7%g%sJY6/2q(B $B%;%_%J!<;qNA(B
> $B!!(Bhttp://linux-ha.osdn.jp/wp/archives/3404
>
> $B"#(BOSC 2015 Fukuoka$B9V1i(B
> $B!!(Bhttp://linux-ha.osdn.jp/wp/archives/4137
> $B!!"*(BPG-REX$B$G3X$V(BPacemaker$B1?MQ$N<BNc(B
>
> $B"#(BPG-REX$B8x<0%5%$%H!':G?7%^%K%e%"%k(B
> $B!!(Bhttps://osdn.jp/projects/pg-rex/releases/63003
> $B!!"*(BPG-REX9.4$BMxMQ%^%K%e%"%k(B_$BBh(B1.0$BHG(B($B8x3+MQMxMQ<T%^%K%e%"%k(B).docx
>
> $B"#(BPostgreSQL$B8x<0%^%K%e%"%k!'%+%9%1!<%I%l%W%j%1!<%7%g%s(B
> $B!!(Bhttps://www.postgresql.jp/document/9.4/html/warm-standby.html#CASCADING-REPLICATION
>
>
> $B0J>e$G$9!#(B
> $B$h$m$7$/$*4j$$$$$?$7$^$9!#(B
>
> ----- $B85$N%a%C%;!<%8(B -----
> From: "itohysh" <itohysh@yahoo.co.jp>
> $B08@h(B: kazuh@goo.jp, linux-ha-japan@lists.osdn.me
> $BAw?.:Q$_(B: 2016$BG/(B3$B7n(B17$BF|(B, $BLZMKF|(B $B8aA0(B 5:38:41
> $B7oL>(B: Re: [Linux-ha-jp] $B$*Ld$$9g$o$;(B
>
>
>
> $B$R$,$7MM(B
>
>
> $B$42sEz$"$j$,$H$&$4$6$$$^$9!#(B
> $B$$$?$@$$$?>pJs$G;n$7$F$_$^$9!#(B
>
>
> $BDI2C$G<ALd$J$N$G$9$,!"(B
> PostgreSQL$B>e$KJ#?t%$%s%9%?%s%9$r:n@.$7!"(B
> $B$5$i$K!"(BMaster$B#1Bf!\(BSlave$B#2Bf9=@.$K$7$?>l9g$G$b(B
> Pacemaker$B$G@)8f2DG=$G$7$g$&$+!)(B
>
>
> $B2?$+CN8+$,$"$j$^$7$?$i!"$465<x$$$?$@$1$k$H9,$$$G$9!#(B
> $B$h$m$7$/$*4j$$$$$?$7$^$9!#(B
>
>
>
>
>
>
>
>
> ----- Original Message -----
> From: "kazuh@goo.jp" <kazuh@goo.jp>
> To: $B0KF#(B $B9/90(B <itohysh@yahoo.co.jp>; linux-ha-japan@lists.osdn.me
> Date: 2016/3/14, Mon 15:03
> Subject: Re: [Linux-ha-jp] $B$*Ld$$9g$o$;(B
>
> $B0KF#MM(B
>
> $B$R$,$7$H?=$7$^$9!#(B
> $B$*@$OC$K$J$j$^$9!#(B
>
>>PostgreSQL $B$H(B Pacemaker $B$rMQ$$$F(B HA $B%/%i%9%?4D6-$r9=C[$7!"(B
>>PostgreSQL $B$N%9%H%j!<%_%s%0%l%W%j%1!<%7%g%s$G%G!<%?F14|$7$h$&$H$7$F$$$^$9$,!"(B
>>PostgreSQL $B>e$KJ#?t%$%s%9%?%s%9$r:n@.$7$?>l9g$G$b(B
>>Pacemaker $B$G(B HA $B%/%i%9%?4D6-$r9=C[2DG=$J$N$G$7$g$&$+!)(B
>
> $B<B:]$K9=C[$7$?$3$H$OL5$$$N$G$9$,!"M}O@E*$K$O(B
> $B2DG=$J$O$:$G$9!#(B
>
> $B6qBNE*$K$O!"(BPGDATA$BNN0h$d%]!<%HEy$r$-$A$s$H(B
> $B8DJL$N$b$N$KJ,$1$F$$$?$@$1$l$PBg>fIW$H;W$$$^$9!#(B
>
> pgsql RA$B$N%Q%i%a!<%?$G$$$&$H!"0J2<$O:GDc8B!"(B
> $B$7$C$+$jJ,$1$kI,MW$,$"$k$H;W$$$^$9!#(B
>
> start_opt$B!'%]!<%H$r5-:\$7$F$$$k>l9g%]!<%H(B
> pgdata$B!'(BPGDATA$BNN0h(B
> pgport$B!'%]!<%H(B
> restore_command$B!'%"!<%+%$%VG[.CV%G%#%l%/%H%j(B
>
> $B!tB>$b4D6-$K1~$8E,59E,@Z$K@_Dj$7$F$/$@$5$$!#(B
>
>
> $B0J>e$G$9!#(B
> $B$h$m$7$/$*4j$$$$$?$7$^$9!#(B
>
> ----- $B85$N%a%C%;!<%8(B -----
> From: "$B0KF#(B $B9/90(B" < itohysh@yahoo.co.jp >
> $B08@h(B: linux-ha-japan@lists.osdn.me
> $BAw?.:Q$_(B: 2016$BG/(B3$B7n(B11$BF|(B, $B6bMKF|(B $B8a8e(B 3:12:38
> $B7oL>(B: [Linux-ha-jp] $B$*Ld$$9g$o$;(B
>
>
>
>
> $B0KF#$H?=$7$^$9!#(B
>
>
> $B<ALd$5$;$F$$$?$@$-$^$9!#(B
>
>
> PostgreSQL $B$H(B Pacemaker $B$rMQ$$$F(B HA $B%/%i%9%?4D6-$r9=C[$7!"(B
> PostgreSQL $B$N%9%H%j!<%_%s%0%l%W%j%1!<%7%g%s$G%G!<%?F14|$7$h$&$H$7$F$$$^$9$,!"(B
> PostgreSQL $B>e$KJ#?t%$%s%9%?%s%9$r:n@.$7$?>l9g$G$b(B
> Pacemaker $B$G(B HA $B%/%i%9%?4D6-$r9=C[2DG=$J$N$G$7$g$&$+!)(B
>
>
> $B$h$m$7$/$*4j$$$$$?$7$^$9!#(B
>
>
> _______________________________________________
> Linux-ha-japan mailing list
> Linux-ha-japan@lists.osdn.me
> http://lists.osdn.me/mailman/listinfo/linux-ha-japan
>
> _______________________________________________
> Linux-ha-japan mailing list
> Linux-ha-japan@lists.osdn.me
> http://lists.osdn.me/mailman/listinfo/linux-ha-japan
_______________________________________________
Linux-ha-japan mailing list
Linux-ha-japan@lists.osdn.me
http://lists.osdn.me/mailman/listinfo/linux-ha-japan