mkubo at 3ware
Jul 11, 2012, 4:25 PM
Post #2 of 2
(216 views)
Permalink
|
|
Re: PostgreSQL$B$N%U%'!<(B$B%k%*!<%P$,$G$-$^$;$s(B
[In reply to]
|
|
$B$3$s$K$A$O!"5WJ]$H?=$7$^$9!#(B
migrate$B$G<jF0$N%9%$%C%A%*!<%P!<$r;n83$7$?8e!"(Bunmigrate$B$r<B9T$7$F$*$i$l$J(B
$B$$$N$G$O$J$$$G$7$g$&$+!#(B
location cli-standby-gr_postgres gr_postgres \
rule $id="cli-standby-rule-gr_postgres" -inf: #uname eq vm85.lab
$B$H$$$&@)Ls$O!"(Bmigrate$B$r<B9T$7$?$H$-$K<+F0E*$KDI2C$5$l$^$9!#(B
$B$3$N@)Ls$,;D$C$?$^$^$@$H!"(B"#uname eq"$B$K=q$$$F$"$k%[.%9%H$G%j%=!<%9$r<B9T(B
$B$9$k$3$H$,6X;_$5$l$^$9(B(-inf$B$N%9%3%"$,IU$1$i$l$?$?$a(B)$B!#(B
unmigrate$B$O!"<+F0E*$KIU2C$5$l$k$3$N@)Ls$r=|5n$7$F$/$l$k%3%^%s%I$G!"$3$l(B
$B$r<B9T$7$J$$8B$j(Bvm85.lab$B$G(Bgr_postgres$B%j%=!<%9$O<B9T$5$l$^$;$s!#(B
migrate$B$r<B9T$7$?;~E@$G!"(BPacemaker$B$O8=:_$N%j%=!<%9G[.CV$,:GE,$G$"$k$HH=CG(B
$B$7$F$$$^$9!#$3$N$^$^$G$O%9%$%C%A%*!<%P!<$O5/$3$C$F$/$l$^$;$s!#(Bmigrate$B%3(B
$B%^%s%I$O>e=R$N$h$&$JG[.CV$K4X$9$k@)Ls$rIU2C$9$k$3$H$K$h$C$F!"(BPacemaker$B$K(B
$B!V:#$N%j%=!<%9G[.CV$8$c%@%a$@!W$H$$$&H=CG$rB%$9$o$1$G$9!#(B
$B$?$@$7(Bmigrate$B$,IU2C$7$?@)Ls$O<+F0E*$K:o=|$5$l$J$$;EMM$K$J$C$F$$$^$9!#<+(B
$BF0:o=|$5$l$?$i!"(Bdefault-resource-stickiness$BCM$J$I$N [at] _D$K$h$C$F$O!"<+F0(B
$BE*$K85$NG[CV$KLa$C$F$7$^$&$?$a$@$m$&$H;W$$$^$9!#$=$NBe$o$j$K!"(Bunmigrate
$B%3%^%s%I$,MQ0U$5$l$F$$$^$9!#(B
(2012$BG/(B07$B7n(B12$BF|(B 04:56), taka yamada wrote:
> $B$O$8$a$^$7$F!";3ED$H$b$&$7$^$9!#(B
>
> $B:G6a!"(BPacemaker$B$NJY6/$r;O$a$^$7$?!#(B
> RA$B$G(BPostgreSQQL$BMQ$N$,$"$k$_$?$$$@$C$?$N(BPostgreSQL$B$N(BHA$B2=$r;n$7$F$_$F$*$j(B
> $B$^$9!#(B
>
> $B$$$m$$$m$J%5%$%H$NFbMF$r;29M$K0J2<$N$h$&$K [at] _D$r$7$^$7$?!#(B
>
> primitive fs_db ocf:heartbeat:Filesystem \
> params device="/dev/drbd1" directory="/pgdata" fstype="ext3"
> options="noatime" \
> op monitor interval="10s"
> primitive postgresql ocf:heartbeat:pgsql \
> params pgctl="/usr/bin/pg_ctl" start_opt="-p 5432 -h 127.0.0.1"
> psql="/usr/bin/psql" pgdata="/pgdata" pgdba="postgres" pgport="5432"
> pgdb="template1" \
> op start interval="0s" timeout="120s" on-fail="restart" \
> op monitor interval="10s" timeout="60s" on-fail="restart" \
> op stop interval="0s" timeout="120s" on-fail="block"
> primitive res_drbd ocf:linbit:drbd \
> params drbd_resource="db" \
> op monitor interval="10s" timeout="30s"
> group gr_postgres fs_db postgresql
> ms ms_drbd res_drbd \
> meta master-max="1" master-node-max="1" clone-max="2"
> clone-node-max="1" notify="true" is-managed="true" target-role="Started"
> location cli-standby-gr_postgres gr_postgres \
> rule $id="cli-standby-rule-gr_postgres" -inf: #uname eq vm85.lab
> colocation postgres_on_drbd inf: gr_postgres ms_drbd:Master
> order postgres_after_drbd inf: ms_drbd:promote gr_postgres:start
> property $id="cib-bootstrap-options" \
> dc-version="1.0.12-066152e" \
> cluster-infrastructure="Heartbeat" \
> expected-quorum-votes="2" \
> no-quorum-policy="ignore" \
> stonith-enabled="false"
> rsc_defaults $id="rsc-options" \
> resource-stickiness="INFINITY" \
> migration-threshold="1"
>
> migrate$B$G(BDRBD$B$N%9%l!<%VB&$K@Z$jBX$o$C$?:]$K(BPostgreSQL$B$b@Z$jBX$o$j!"@5>o(B
> $B$K(BPostgreSQL$B$b;HMQ$G$-$^$9!#(B
> migrate$B$G$&$^$/@Z$jBX$o$k$N$G!"8N>c;~$N@Z$jBX$($r;n$9$N$K(BPostgreSQL$B$rDd(B
> $B;_$5$;$^$7$?!#(B
> $B$7$+$7!"(Bcrm_mon$B$G$O0J2<$N$h$&$K(BStopped$B$HDd;_$r8!=P$O$7$F$/$l$F$$$k$h$&$G(B
> $B$9$,%U%'!<%k%*!<%P$7$F$/$l$^$;$s!#(B
>
> Online: [ vm84.lab vm85.lab ]
>
> Master/Slave Set: ms_drbd
> Masters: [ vm84.lab ]
> Slaves: [ vm85.lab ]
> Resource Group: gr_postgres
> fs_db (ocf::heartbeat:Filesystem): Started vm84.lab
> postgresql (ocf::heartbeat:pgsql): Stopped
>
> $B$J$K$+@_Dj$,0-$$$N$+$H;29M$K$7$?%5%$%H$r8+D>$7$^$7$?$,!"F1$8$h$&$J [at] _D$r(B
> $B$7$F$$$k$h$&$J$N$G860x$,J,$+$j$^$;$s!#(B
> $B8f65<($7$F$$$?$@$1$J$$$G$7$g$&$+!#(B
>
>
> _______________________________________________
> Linux-ha-japan mailing list
> Linux-ha-japan [at] lists
> http://lists.sourceforge.jp/mailman/listinfo/linux-ha-japan
>
_______________________________________________
Linux-ha-japan mailing list
Linux-ha-japan [at] lists
http://lists.sourceforge.jp/mailman/listinfo/linux-ha-japan
|
