Mailing List Archive: Slave$B%5!<%P$N$_$r(B$B5/F0$9$k$H!"(BDISCONNECT$B$N$^$^(B

Slave$B%5!<%P$N$_$r(B$B5/F0$9$k$H!"(BDISCONNECT$B$N$^$^(B

Nov 17, 2015, 12:07 AM

Post #1 of 3 (1123 views)

$B$*@$OC$K$J$C$F$*$j$^$9!#(B
$B?\F#$H?=$7$^$9!#(B

Master(A)$B!&(BSlave(B)$B$GF0:n$7$F$$$?%5!<%P$r!"(BSlave(B)$B$r%7%c%C%H%@%&%s$7!"(B
$B<!$K(BMaster(A)$B$r%7%c%C%H%@%&%s!#(B
$B$=$N8e!"(B(B)$B$N$_$r5/F0$7$?>l9g$K!"(B
pgsql-data-status:DISCONNECT$B$N$^$^$J$N$G$9$,!#(B
+ master-pgsql : -INFINITY
+ pgsql-data-status : DISCONNECT
+ pgsql-status : HS:alone
Pacemaker$B$N%m%0$K$O!"0J2<$,=PNO$5$lB3$1$^$9!#(B
WARNING: My data is out-of-date. status=DISCONNECT

crm_attribute$B%3%^%s%I$G!"6/@)E*$K(BLATEST$B$K$9$k$H!"F0:n$7$^$9!#(B
$BC"$7!"$=$N8e(B(A)$B$r5/F0$7$F$b!"(B(A)$B$O(BDISCONNECT$B$N$^$^$G!"(B(B)$B$+$i(B
pg_basebackup$B$G!"(B(A)$B$O(BSlave$B$H$7$FF0:n$7$^$9!#(B

(B)$B$,(BDISCONNECT$B$N$^$^$G!"8e$K(B(A)$B$r5/F0$7$?>l9g$O!"%7%c%C%H%@%&(B
$B%sA0$HF1MM$K(BSlave(B)$B$H$7$FF0:n$7$^$9!#(B

$B2?$+;W$$$D$/E@Ey$"$j$^$7$?$i!"%"%I%P%$%9D:$-$?$/!"$h$m$7$/$*4j$$$$$?$7$^(B
$B$9!#(B

$B9=@.(B/$B@_Dj35MW$O!"(B2015/10/3$B$N!V(BPF-REX$B$G3X$V(Bpacemaker$B1?MQ$N<BNc!W$r;29M$K!"(B
$B%5!<%S%9MQ2>A[(BIP(vip-master) /$B%l%W%j%1!<%7%g%sMQ2>A[(B
IP(vip-rep)/pgsql[stonith/ping/diskd$B$OL5$7(B]$B$G$9!#(B
$B!J(BPG-REX$B%$%s%9%HL5$7!K(B
CentOS6.7
PostgreSQL9.4.5
Pacemaker1.1.13-1.1
Corosync2.3.4-1

pgsql$BItJ,$N@_Dj$O0J2<$G$9!#(B
---------------------------
primitive pgsql ocf:heartbeat:pgsql \
params \
pgctl="/usr/pgsql-9.4/bin/pg_ctl" \
psql="/usr/pgsql-9.4/bin/psql" \
pgdata="/var/lib/pgsql/9.4/data/" \
rep_mode="sync" \
node_list="svpcmk21 svpcmk22" \
restore_command="cp /var/lib/pgsql/9.4/pg_archive/%f %p" \
primary_conninfo_opt="keepalives_idle=60 \
keepalives_interval=5 keepalives_count=5" \
master_ip="172.17.2.37" \
restart_on_promote='true' \
op start timeout="120s" interval="0s" on-fail="restart" \
op monitor timeout="60s" interval="10s" on-fail="restart" \
op monitor timeout="60s" interval="9s" on-fail="restart" role="Master" \
op promote timeout="120s" interval="0s" on-fail="restart" \
op demote timeout="120s" interval="0s" on-fail="stop" \
op stop timeout="120s" interval="0s" on-fail="block" \
op notify timeout="90s" interval="0s"
-------------------------------------------

$B0J>e!!59$7$/$*4j$$CW$7$^$9!#(B

_______________________________________________
Linux-ha-japan mailing list
Linux-ha-japan@lists.osdn.me
http://lists.osdn.me/mailman/listinfo/linux-ha-japan

Re: Slaveã‚µãƒ¼ãƒã®ã¿ã‚’èµ·å‹•ã™ã‚‹ã¨ã€DISCONNECTã®ã¾ã¾ [ In reply to ]

matsuo.tak at gmail

Nov 20, 2015, 3:18 AM

Post #2 of 3 (1100 views)

Permalink

$B?\F#$5$s(B
$B>>Hx$G$9!#(B

$B$3$l$O@5>o$JF0:n$G$9$M!#(B
B$B"*(BA $B$H;_$a$?>l9g!"(BA$B$K:G?7$N%G!<%?$,$"$k$N$G!"(BB$B$O(BMaster$B$K$J$l$J$$$h$&$K@)8f$5$l$^$9!#(B
A$B$,:G?7$N>uBV$G(BB$B$r6/@)$K(BMaster$B$K$9$k$H(BA$B$H(BB$B$N%G!<%?$O@09g@-$,<h$l$J$/$J$k$N$G!"(B
A$B>e$N%G!<%?$O(BB$B$G>e=q$-$7$F$+$i5/F0$9$kI,MW$,=P$F$-$^$9!#(B
$B$3$N;~!"(BA$B>e$K$N$_$KB8:_$7$F$$$?%G!<%?$O<:$o$l$^$9$N$G$4Cm0U$/$@$5$$!#(B

2015$BG/(B11$B7n(B17$BF|(B 17:07 Shigeko Sudo <shigeko@a.email.ne.jp>:
> $B$*@$OC$K$J$C$F$*$j$^$9!#(B
> $B?\F#$H?=$7$^$9!#(B
>
> Master(A)$B!&(BSlave(B)$B$GF0:n$7$F$$$?%5!<%P$r!"(BSlave(B)$B$r%7%c%C%H%@%&%s$7!"(B
> $B<!$K(BMaster(A)$B$r%7%c%C%H%@%&%s!#(B
> $B$=$N8e!"(B(B)$B$N$_$r5/F0$7$?>l9g$K!"(B
> pgsql-data-status:DISCONNECT$B$N$^$^$J$N$G$9$,!#(B
> + master-pgsql : -INFINITY
> + pgsql-data-status : DISCONNECT
> + pgsql-status : HS:alone
> Pacemaker$B$N%m%0$K$O!"0J2<$,=PNO$5$lB3$1$^$9!#(B
> WARNING: My data is out-of-date. status=DISCONNECT
>
>
> crm_attribute$B%3%^%s%I$G!"6/@)E*$K(BLATEST$B$K$9$k$H!"F0:n$7$^$9!#(B
> $BC"$7!"$=$N8e(B(A)$B$r5/F0$7$F$b!"(B(A)$B$O(BDISCONNECT$B$N$^$^$G!"(B(B)$B$+$i(B
> pg_basebackup$B$G!"(B(A)$B$O(BSlave$B$H$7$FF0:n$7$^$9!#(B
>
> (B)$B$,(BDISCONNECT$B$N$^$^$G!"8e$K(B(A)$B$r5/F0$7$?>l9g$O!"%7%c%C%H%@%&(B
> $B%sA0$HF1MM$K(BSlave(B)$B$H$7$FF0:n$7$^$9!#(B
>
>
> $B2?$+;W$$$D$/E@Ey$"$j$^$7$?$i!"%"%I%P%$%9D:$-$?$/!"$h$m$7$/$*4j$$$$$?$7$^(B
> $B$9!#(B
>
> $B9=@.(B/$B@_Dj35MW$O!"(B2015/10/3$B$N!V(BPF-REX$B$G3X$V(Bpacemaker$B1?MQ$N<BNc!W$r;29M$K!"(B
> $B%5!<%S%9MQ2>A[(BIP(vip-master) /$B%l%W%j%1!<%7%g%sMQ2>A[(B
> IP(vip-rep)/pgsql[stonith/ping/diskd$B$OL5$7(B]$B$G$9!#(B
> $B!J(BPG-REX$B%$%s%9%HL5$7!K(B
> CentOS6.7
> PostgreSQL9.4.5
> Pacemaker1.1.13-1.1
> Corosync2.3.4-1
>
> pgsql$BItJ,$N@_Dj$O0J2<$G$9!#(B
> ---------------------------
> primitive pgsql ocf:heartbeat:pgsql \
> params \
> pgctl="/usr/pgsql-9.4/bin/pg_ctl" \
> psql="/usr/pgsql-9.4/bin/psql" \
> pgdata="/var/lib/pgsql/9.4/data/" \
> rep_mode="sync" \
> node_list="svpcmk21 svpcmk22" \
> restore_command="cp /var/lib/pgsql/9.4/pg_archive/%f %p" \
> primary_conninfo_opt="keepalives_idle=60 \
> keepalives_interval=5 keepalives_count=5" \
> master_ip="172.17.2.37" \
> restart_on_promote='true' \
> op start timeout="120s" interval="0s" on-fail="restart" \
> op monitor timeout="60s" interval="10s" on-fail="restart" \
> op monitor timeout="60s" interval="9s" on-fail="restart" role="Master" \
> op promote timeout="120s" interval="0s" on-fail="restart" \
> op demote timeout="120s" interval="0s" on-fail="stop" \
> op stop timeout="120s" interval="0s" on-fail="block" \
> op notify timeout="90s" interval="0s"
> -------------------------------------------
>
> $B0J>e!!59$7$/$*4j$$CW$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

Re: Slave$B%5!<%P$N$_$r(B$B5/F0$9$k$H!"(BDISCONNECT$B$N$^$^(B [ In reply to ]

shigeko at a

Nov 25, 2015, 12:43 AM

Post #3 of 3 (1084 views)

Permalink

$B>>HxMM(B

$B$4JV?.!!$"$j$,$H$&$4$6$$$^$9!#(B
Lock$B%U%!%$%kEy$,B8:_$7$J$$>l9g$K$O!"@h$K5/F0$7$?$[.$&$,!"(B
$B$H$j$"$($:(BMaster$B$H$7$F!!F0:n$9$k$N$@$H!!8m2r$7$F$$$^$7$?!#!J$9$_$^$;$s!K(B

$B$b$75l(BSlave$B5!$N$_$GF0:n$5$;$J$1$l$P$J$i$J$$>l9g$K$O!"(B
$B<jF0$G6/@)E*$K(BMaster$B$H$7$FF0:n$5$;!"(B
$B<!$K5l(BMaster$B5!$r(BSlave$B$H$7$F5/F0(B($B?7%^%9%?!<$+$i$N%G!<%?%3%T!<(B)$B$7!"(B
Master-Slave$B>uBV$K$5$;$k(B
$B$H$$$&1?MQ$K$J$k$N$G$9$M!#(B
$B!J5l(BSlave$B$r?7(BMaster$B$H$7$?;~$K!"5l(BMaster$B$K$7$+B8:_$7$J$+$C$?%G!<%?$O<:$o(B
$B$l$^$9$,!#!K(B

$B$"$j$,$H$&$4$6$$$^$7$?!#(B

On Fri, 20 Nov 2015 20:18:51 +0900
Takatoshi MATSUO <matsuo.tak@gmail.com> wrote:

> $B?\F#$5$s(B
> $B>>Hx$G$9!#(B
>
> $B$3$l$O@5>o$JF0:n$G$9$M!#(B
> B$B"*(BA $B$H;_$a$?>l9g!"(BA$B$K:G?7$N%G!<%?$,$"$k$N$G!"(BB$B$O(BMaster$B$K$J$l$J$$$h$&$K@)8f$5$l$^$9!#(B
> A$B$,:G?7$N>uBV$G(BB$B$r6/@)$K(BMaster$B$K$9$k$H(BA$B$H(BB$B$N%G!<%?$O@09g@-$,<h$l$J$/$J$k$N$G!"(B
> A$B>e$N%G!<%?$O(BB$B$G>e=q$-$7$F$+$i5/F0$9$kI,MW$,=P$F$-$^$9!#(B
> $B$3$N;~!"(BA$B>e$K$N$_$KB8:_$7$F$$$?%G!<%?$O<:$o$l$^$9$N$G$4Cm0U$/$@$5$$!#(B
>
>
> 2015$BG/(B11$B7n(B17$BF|(B 17:07 Shigeko Sudo <shigeko@a.email.ne.jp>:
> > $B$*@$OC$K$J$C$F$*$j$^$9!#(B
> > $B?\F#$H?=$7$^$9!#(B
> >
> > Master(A)$B!&(BSlave(B)$B$GF0:n$7$F$$$?%5!<%P$r!"(BSlave(B)$B$r%7%c%C%H%@%&%s$7!"(B
> > $B<!$K(BMaster(A)$B$r%7%c%C%H%@%&%s!#(B
> > $B$=$N8e!"(B(B)$B$N$_$r5/F0$7$?>l9g$K!"(B
> > pgsql-data-status:DISCONNECT$B$N$^$^$J$N$G$9$,!#(B
> > + master-pgsql : -INFINITY
> > + pgsql-data-status : DISCONNECT
> > + pgsql-status : HS:alone
> > Pacemaker$B$N%m%0$K$O!"0J2<$,=PNO$5$lB3$1$^$9!#(B
> > WARNING: My data is out-of-date. status=DISCONNECT
> >
> >
> > crm_attribute$B%3%^%s%I$G!"6/@)E*$K(BLATEST$B$K$9$k$H!"F0:n$7$^$9!#(B
> > $BC"$7!"$=$N8e(B(A)$B$r5/F0$7$F$b!"(B(A)$B$O(BDISCONNECT$B$N$^$^$G!"(B(B)$B$+$i(B
> > pg_basebackup$B$G!"(B(A)$B$O(BSlave$B$H$7$FF0:n$7$^$9!#(B
> >
> > (B)$B$,(BDISCONNECT$B$N$^$^$G!"8e$K(B(A)$B$r5/F0$7$?>l9g$O!"%7%c%C%H%@%&(B
> > $B%sA0$HF1MM$K(BSlave(B)$B$H$7$FF0:n$7$^$9!#(B
> >
> >
> > $B2?$+;W$$$D$/E@Ey$"$j$^$7$?$i!"%"%I%P%$%9D:$-$?$/!"$h$m$7$/$*4j$$$$$?$7$^(B
> > $B$9!#(B
> >
> > $B9=@.(B/$B@_Dj35MW$O!"(B2015/10/3$B$N!V(BPF-REX$B$G3X$V(Bpacemaker$B1?MQ$N<BNc!W$r;29M$K!"(B
> > $B%5!<%S%9MQ2>A[(BIP(vip-master) /$B%l%W%j%1!<%7%g%sMQ2>A[(B
> > IP(vip-rep)/pgsql[stonith/ping/diskd$B$OL5$7(B]$B$G$9!#(B
> > $B!J(BPG-REX$B%$%s%9%HL5$7!K(B
> > CentOS6.7
> > PostgreSQL9.4.5
> > Pacemaker1.1.13-1.1
> > Corosync2.3.4-1
> >
> > pgsql$BItJ,$N@_Dj$O0J2<$G$9!#(B
> > ---------------------------
> > primitive pgsql ocf:heartbeat:pgsql \
> > params \
> > pgctl="/usr/pgsql-9.4/bin/pg_ctl" \
> > psql="/usr/pgsql-9.4/bin/psql" \
> > pgdata="/var/lib/pgsql/9.4/data/" \
> > rep_mode="sync" \
> > node_list="svpcmk21 svpcmk22" \
> > restore_command="cp /var/lib/pgsql/9.4/pg_archive/%f %p" \
> > primary_conninfo_opt="keepalives_idle=60 \
> > keepalives_interval=5 keepalives_count=5" \
> > master_ip="172.17.2.37" \
> > restart_on_promote='true' \
> > op start timeout="120s" interval="0s" on-fail="restart" \
> > op monitor timeout="60s" interval="10s" on-fail="restart" \
> > op monitor timeout="60s" interval="9s" on-fail="restart" role="Master" \
> > op promote timeout="120s" interval="0s" on-fail="restart" \
> > op demote timeout="120s" interval="0s" on-fail="stop" \
> > op stop timeout="120s" interval="0s" on-fail="block" \
> > op notify timeout="90s" interval="0s"
> > -------------------------------------------
> >
> > $B0J>e!!59$7$/$*4j$$CW$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

--
Shigeko Sudo <shigeko@a.email.ne.jp>

_______________________________________________
Linux-ha-japan mailing list
Linux-ha-japan@lists.osdn.me
http://lists.osdn.me/mailman/listinfo/linux-ha-japan