niwano at showtime
Dec 8, 2011, 6:00 PM
Post #3 of 5
(368 views)
Permalink
|
|
Re: Heartbeat + Pacemaker + MHA $B$rMQ$$$?(BMySQL$B%^%9%?!<>iD9(B$B2=$K$D$$$F(B
[In reply to]
|
|
$B>>EgMM(B
$BDmLn$G$9!#(B
$B$4JV?.M-$jFq$&8f:B$$$^$9!#(B
$B$3$A$i$3$=$I$&$>59$7$/$*4j$$CW$7$^$9!#(B
> MHA$B$K$D$$$FL5CN$J$N$GE*30$l$+$b$7$l$^$;$s$,!"$3$N [at] _D$G$9$H(BActive/Standby$B$J$N$G(B
> MHA$B$N6/$_$r@8$+$;$J$$$+$H;W$$$^$9!#(B
$B>>EgMM$N6D$k$H$*$j [at] h|E=$i$;$F$$$?$@$$$?@_Dj$@$H(B
Active/Standby$B9=@.$K$J$C$F$7$^$$$^$9!#(B
MySQL$B$,Mn$A$?$+$I$&$+$@$1$r4F;k$7$?$+$C$?$N$G(B
>> $B!!(Bop start interval="0s" timeout="120s" on-fail="ignore" \
>> $B!!(Bop monitor interval="10s" timeout="60s" on-fail="ignore" \
>> $B!!(Bop stop interval="0s" timeout="120s" on-fail="ignore"
$B$H [at] _D$rF~$l$F$$$^$7$?$,!"$"$^$j<BMQE*$G$O$J$$$h$&$G$7$?!#(B
> Clone$B$GN)$A>e$2$F$7$^$&$H!"$9$Y$F$N%N!<%I$GF1$8>r7o$K$J$C$F$7$^$$$^$9!#(B
> MHA$B$,$=$N$"$?$j$OD4@0$7$F$/$l$k$N$G$7$g$&$+(B??
$B;d<+?H(BMHA$B$rJY6/$7;O$a$?$P$+$j$G$9$N$G$=$l$[.$I>\$7$/$O$J$$$N$G$9$,!"(B
MHA$B$O%^%9%?!<%N!<%I$H$=$l$KIU?o$9$k%9%l!<%V%N!<%I!J%^%9%?!<$H(B
$B%l%W%j%1!<%7%g%s<B;\!K$,$"$C$?$H2>Dj$7!"%^%9%?!<%N!<%I$,Mn$A$k$H(B
$B<+F0E*$K%9%l!<%V%N!<%I$,%^%9%?!<%N!<%I$K>:3J$7$F$/$l$^$9!#(B
$B!!"((BLinux-ha$B$NOCBj$+$i0o$l$F$7$^$$$=$&$J$N$G(B
$B!!!!:Y$+$$$H$3$m$K$D$$$F$O>JN,$5$;$F$$$?$@$-$^$9!#(B
$B!!!!?=$7Lu$"$j$^$;$s!#(B
$B$G$9$N$G!"(BHeartbeat + Pacemaker$BB&$+$i8+$?(BAct/Stb$B%N!<%IN>J}$G(B
MySQL$B$,5/F0$7$F$$$kI,MW$,$"$j$^$9!#(B
$B$=$3;kE@$+$i(BClone$B$GN)$A>e$2$kI,MW$,$"$k$N$G$O$H$$$&9M$($K;j$j$^$7$?!#(B
$B$*=P$7$9$k>pJs$,A08e$7?=$7Lu$"$j$^$;$s$,!":#2s<B8=$7$?$$$3$H$O(B
$B!!(B1. Active(Master)$B%N!<%I$G(BMySQL$B>c32$,5/$-$?>l9g$K(BStanby(Slave)$B%N!<%I(B
$B!!!!(B $B$,(BMHA$B$K$h$j<+F0E*$K(BActive(Master)$B%N!<%I$K>:3J$9$k!#(B
$B!!(B2. Heartbeat + Pacemaker$B$,>e5-(B[1]$B$N@Z$jBX$o$j4F;k$7!"(BIP$B%U%'%$%k(B
$B!!!!(B $B%*!<%P!<$r9T$&!#(B
$B!!!!(B $B$?$@$7!"(BHeartbeat + Pacemaker$B$G$N(BMySQL$B$N%U%'%$%k%*!<%P!<$O(B
$B!!!!(B $B9T$o$J$$!#"((BMHA$B$,9T$&$?$a!#(B
$B$H$$$&0lO"$NF0:n$H$J$j$^$9!#(B
$B$J$*!"$4;XE&$$$?$@$$$?(B
> $B!&(Border$B$G(Bsymmetrical=false$B$K$7$F$$$k$N$O$J$<$G$7$g$&$+(B
> $B!&(Border$B$H(Bcolocation$B$r(B2$B9T$KJ,$1$F$$$k$N$O$J$<$G$7$g$&$+(B
$B$K$D$$$F$G$9$,!"(B
> $B!&(Border$B$G(Bsymmetrical=false$B$K$7$F$$$k$N$O$J$<$G$7$g$&$+(B
$B$I$3$+$N%5%$%H$+$i=&$C$F$-$?$^$^$N [at] _D$K$7$F$$$^$7$?!#(B
$BFCJL$JM}M3$,$J$$8B$jIaDL$O!V(Btrue$B!W$G$9$M!&!&!&!#(B
$B$4;XE&46<U$7$^$9!#(B
> $B!&(Border$B$H(Bcolocation$B$r(B2$B9T$KJ,$1$F$$$k$N$O$J$<$G$7$g$&$+(B
$B$4;XE&$5$l$k$^$G5$$,$D$-$^$;$s$G$7$?!#(B
$B$h$/$h$/9M$($?$i(BclnPingd$B$b(BgrpMhaDb$B$b(BclnDiskd$B$b$9$Y$FF15o$G(B
$B5/F0=gHV$b(B1$B9T$G=q$1$^$7$?$M!#(B
colocation colocation-grpMha-1 INFINITY: grpMhaDb clnPingd clnDiskd
order order-grpMhaDb 0: clnPingd clnDiskd grpMhaDb symmetrical=true
$B$$$m$$$m$H$I$&$bM-$jFq$&8f:B$$$^$9!#(B
$B$H$F$bJY6/$K$J$j$^$9!#(B
$B0J>e!"59$7$/$*4j$$CW$7$^$9!#(B
(2011/12/09 10:08), Takehiro Matsushima wrote:
> $BDmLn(B $BMM(B
>
> $B$O$8$a$^$7$F!">>Eg$H?=$7$^$9!#(B
> $B$h$m$7$/$*4j$$$$$?$7$^$9!#(B
>
> $B;d$N6P$a@h$G$O(BHeartbeat + Pacemaker + MySQL(Async. Repl)$B$N9=@.$G1?MQ$7$F$$$^$9!#(B
> MHA$B$K$D$$$FL5CN$J$N$GE*30$l$+$b$7$l$^$;$s$,!"$3$N [at] _D$G$9$H(BActive/Standby$B$J$N$G(B
> MHA$B$N6/$_$r@8$+$;$J$$$+$H;W$$$^$9!#(B
>
> Clone$B$GN)$A>e$2$F$7$^$&$H!"$9$Y$F$N%N!<%I$GF1$8>r7o$K$J$C$F$7$^$$$^$9!#(B
> MHA$B$,$=$N$"$?$j$OD4@0$7$F$/$l$k$N$G$7$g$&$+(B??
>
> $B$b$7!"(BMHA$B$K$=$N$h$&$J5!G=$,L5$$$N$G$7$?$i(BMySQL$B$r(BClone$B$G$O$J$/(B
> Master/Slave$B$K$5$l$F$O$$$+$,$G$7$g$&$+!#(B
>
> $B;d<+?H!"$7$C$+$j$HJY6/$7$F$$$J$$$N$G [at] _D$K$D$$$F$465<x$$$?$@$1$l$P$H;W$$$^$9(B
> $B!&(Border$B$G(Bsymmetrical=false$B$K$7$F$$$k$N$O$J$<$G$7$g$&$+(B
> $B!&(Border$B$H(Bcolocation$B$r(B2$B9T$KJ,$1$F$$$k$N$O$J$<$G$7$g$&$+(B
>
> $B$h$m$7$/$*4j$$$$$?$7$^$9!#(B
>
> ----
> Takehiro Matsushima
>
>
>
> 2011$BG/(B12$B7n(B8$BF|(B14:12 $BDmLn(B $B8g(B<niwano [at] showtime>:
>> $B$O$8$a$^$7$F!#DmLn$H?=$7$^$9!#(B
>>
>> $B=iEj9F$H$J$j$^$9!#(B
>> $B$I$&$>59$7$/$*4j$$$7$^$9!#(B
>>
>> MySQL$B$N%^%9%?!<%N!<%I$r>iD92=$9$Y$/9=@.8!F$$r9T$C$F$$$^$9!#(B
>> $B8uJd$H$7$F$O0J2<$G$9!#(B
>>
>> $B!!(B1. Heartbeat + Pacemaker + DRBD + MySQL
>> $B!!(B2. Heartbeat + Pacemaker + MySQL + MHA
>>
>> $B%^%9%?!<%N!<%I$O(B Act/Stb $B>uBV$G(B2$BBf=`Hw$7!"(BAct$BB&$K$O2>A[(BIP$B$,(B
>> $B3d$jEv$F$i$l$F$$$F!"99?7%/%(%j$N$_<u$1IU$1$k$h$&$J9=@.$K(B
>> $B$J$C$F$$$^$9!#(B
>>
>> $B>e5-(B[1]$B$N9=@.$O2a5n$K9=C[$7$?7P83$b$"$k$N$G$9$,!"9+$GOCBj$N(B
>> MHA$B$b8!>Z$7$F$_$h$&$H;W$$(B[2]$B$N$h$&$J9=@.$r9M$($^$7$?!#(B
>> $B"((BMHA$B$NIUB0%9%/%j%W%H$G(BIP$B%U%'%$%k%*!<%P!<$r9T$C$F$/$l$k(B
>> $B!!%5%s%W%k$,$"$k$N$G$9$,!"(BPerl$B$G=q$+$l$F$$$F;d$K$OM}2r$G$-$:$G!#!#(B
>> $B>e5-$N(B[2]$B$N$h$&$J9=@.$G>iD92=$r9T$C$F$$$k7P83<T$O(B
>> $B$$$i$C$7$c$$$^$;$s$G$7$g$&$+!)(B
>>
>> $B;d$O$^$@8!>ZCJ3,$G$O$"$j$^$9$,!":#$N$H$3$m0J2<$N$h$&$J [at] _D$G(B
>> $B0l1~$O@5>o$KF0$$$F$$$k$3$H$r3NG'$G$-$F$$$^$9!#(B
>>
>> ha.cf$B!!"(H4?h(B
>> $B!!(Bkeepalive 2
>> $B!!(Bdeadtime 20
>> $B!!(Bwarntime 15
>> $B!!(Binitdead 60
>> $B!!(Budpport 694
>> $B!!(Bbcast eth1 # Linux
>> $B!!(Bwatchdog /dev/watchdog
>> $B!!(Bnode mha-db01
>> $B!!(Bnode mha-db02
>> $B!!(Brespawn root /usr/lib64/heartbeat/ifcheckd
>> $B!!(Bpacemaker on
>>
>> crm configure
>> $B!!(Bproperty no-quorum-policy="ignore"
>> $B!!(Bproperty stonith-enabled="false"
>> $B!!(Bproperty startup-fencing="false"
>> $B!!(Bproperty stonith-timeout="740s"
>>
>> $B!!(Brsc_defaults resource-stickiness="INFINITY" \
>> $B!!(Bmigration-threshold="1"
>>
>> $B!!(Bprimitive res_ip ocf:heartbeat:IPaddr2 \
>> $B!!(Bparams ip="192.168.1.1" nic="eth0" cidr_netmask="24" \
>> $B!!(Bop start interval="0s" timeout="60s" on-fail="restart" \
>> $B!!(Bop monitor interval="10s" timeout="60s" on-fail="restart" \
>> $B!!(Bop stop interval="0s" timeout="60s" on-fail="restart"
>>
>> $B!!(Bprimitive res_mysql ocf:heartbeat:mysql \
>> $B!!(Bparams binary="/usr/bin/mysqld_safe" config="/etc/my.cnf"
>> datadir="/var/lib/mysql" \
>> $B!!(Buser="mysql" group="mysql" pid="/var/lib/mysql/mha-db.pid"
>> socket="/var/lib/mysql/mysql.sock" \
>> $B!!(Bop start interval="0s" timeout="120s" on-fail="ignore" \
>> $B!!(Bop monitor interval="10s" timeout="60s" on-fail="ignore" \
>> $B!!(Bop stop interval="0s" timeout="120s" on-fail="ignore"
>>
>> $B!!(Bprimitive prmPingd ocf:pacemaker:pingd \
>> $B!!(Bparams name="default_ping_set" host_list="192.168.1.254"
>> multiplier="100" dampen="0" \
>> $B!!(Bmeta migration-threshold="3" \
>> $B!!(Bop start interval="0s" timeout="60s" on-fail="restart" \
>> $B!!(Bop monitor interval="10s" timeout="60s" on-fail="restart" \
>> $B!!(Bop stop interval="0s" timeout="60s" on-fail="block"
>>
>> $B!!(Bprimitive prmDiskd ocf:pacemaker:diskd \
>> $B!!(Bparams name="diskcheck_status" device="/dev/sda" interval="10" \
>> $B!!(Bmeta migration-threshold="3" \
>> $B!!(Bop start interval="0s" timeout="60s" on-fail="restart" \
>> $B!!(Bop monitor interval="10s" timeout="60s" on-fail="restart" \
>> $B!!(Bop stop interval="0s" timeout="60s" on-fail="block"
>>
>> $B!!(Bgroup grpMhaDb res_ip res_mysql
>>
>> $B!!(Bclone clnPingd prmPingd \
>> $B!!(Bmeta clone-max="2" clone-node-max="1"
>> $B!!(Bclone clnDiskd prmDiskd \
>> $B!!(Bmeta clone-max="2" clone-node-max="1"
>>
>> $B!!(Blocation location-grpMhaDb-1 grpMhaDb \
>> $B!!(Brule 200: #uname eq mha-db01 \
>> $B!!(Brule 100: #uname eq mha-db02 \
>> $B!!(Brule -INFINITY: defined default_ping_set and default_ping_set lt 100 \
>> $B!!(Brule -INFINITY: defined diskcheck_status and diskcheck_status eq ERROR \
>> $B!!(Brule -INFINITY: defined diskcheck_status_internal and
>> diskcheck_status_internal eq ERROR
>>
>> $B!!(Bcolocation colocation-grpMhaDb-clnPingd-1 INFINITY: grpMhaDb clnPingd
>> $B!!(Bcolocation colocation-grpMhaDb-clnDiskd-2 INFINITY: grpMhaDb clnDiskd
>>
>> $B!!(Border order-clnPingd-grpMhaDb-1 0: clnPingd grpMhaDb symmetrical=false
>> $B!!(Border order-clnDiskd-grpMhaDb-2 0: clnDiskd grpMhaDb symmetrical=false
>>
>> $B$^$:F0:n$NA0Ds>r7o$H$7$F(B
>> $B!!!V(BAct/Stb$BN>J}$K$F(BMySQL$B$,5/F0!W(B
>> $B!!!!$+$D(B
>> $B!!!V(BStb$B$O(BAct$B$H%l%W%j%1!<%7%g%sCf!W(B
>> $B$,$"$j$^$9!#(B
>> $B=hM}$NN.$l$O!"(B
>> $B!!(BAct$BB&$G(BMySQL$B%@%&%s$r8!CN$7$?$i!"(Bcrm$BFb$N(Bres_mysql$B$,(Bfail$B$H$J$j!"(B
>> $B!!=hM}$rDd;_(B(ignore)$B$7!"(BIP$B%U%'%$%k%*!<%P!<$r9T$&!#(B
>> $B$H$J$j$^$9!#(B
>>
>> $B$3$N [at] _Dj0J3$G$b$C$H%9%^!<%H$JJ}K!$r$4B8$8$JJ}$O(B
>> $B$$$i$C$7$c$$$^$;$s$G$7$g$&$+!#(B
>>
>> $B"(:#2s$N>l9g!"(BMySQL$B$ON>%5!<%P!<$G>e$,$C$F$$$kI,MW$,$"$k$N$G(BClone$B$G(B
>> $B!!:n$kI,MW$,$"$k$h$&$J5$$b$7$^$9$,!"$d$O$j$=$&$J$j$^$9$G$7$g$&$+!"!"!)(B
>>
>> $B59$7$/$*4j$$CW$7$^$9!#(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
>
_______________________________________________
Linux-ha-japan mailing list
Linux-ha-japan [at] lists
http://lists.sourceforge.jp/mailman/listinfo/linux-ha-japan
|
