Mailing List Archive

DBのMaster/Slaveセットと仮想IPの同居について
$B$*@$OC$K$J$j$^$9!#6b>k$H?=$7$^$9!#(B

$B2<5-$N4D6-$K$*$$$F!"(BDB$B%5!<%P$N(BMaster/Slave$B%;%C%H$NFb!"(B
Master$BB&$N%M%C%H%o!<%/$K2?$+$7$i$NITNI(B($BCG@~$d(BIF$B8N>c(B)$B$,$"$C$?>l9g$K!"(B
Slave$B$r(BMaster$B$K>:3J$5$;$?$$$N$G$9$,!"(Beth0$B$KITNI$,$"$C$?>l9g$K(B
$B2>A[(BIP(vip1)$B$,Dd;_$;$:!"(BMySQL$B$N(BSlave$B$O(BMaster$B$K>:3J$5$l$J$$(B
$B>uBV$G$9!#(B

$B860x$d2r7h:v$r$4B8CN$G$"$l$P!"$465<xD:$1$^$9$G$7$g$&$+!#(B
($B>l9g$K$h$C$F$O(BVIPcheck$B$J$IB>$N%j%=!<%9$,I,MW$H9M$($F$$$^$9$,!"(B
$B2?$rA*Br$9$Y$-$+!"D4$Y$?$b$N$N!":#$R$H$DJ,$+$C$F$$$^$;$s!#(B)

$B$*<j?t$r$*3]$1$7$F?=$7Lu$"$j$^$;$s$,!"59$7$/$*4j$$CW$7$^$9!#(B
$B0J2<!">\:Y$G$9!#(B


[$BMW7o(B]
CentOS$B%5!<%P(B2$BBf$G(BMySQL$B$N(BMaster/Slave$B%;%C%H$r9=C[$9$k!#(B
$B3F%N!<%I$K$O%M%C%H%o!<%/(BIF$B$,(B2$BKg(B(eth0/eth1)$BAuHw$5$l$F$*$j!"(B
$B$=$l$>$l$K2>A[(BIP$B$r@_Dj$9$k!#(B
$BB>$N%[%9%H$+$i$N%"%/%;%9$N:]$O2>A[(BIP$B7PM3$G(BMaster$BB&$X%"%/%;%9$9$k!#(B

$B3F%M%C%H%o!<%/(BIF$B$NLr3d$O2<5-$NDL$j!#(B
eth0:$B30It%5!<%S%9$H$NO"7H(B
eth1:$BFbIt%M%C%H%o!<%/Fb$N@\B3(B(Web$B%"%W%j$+$i$N@\B3Ey(B)


[$B4D6-(B] $B"(%F%9%HMQ$K2>A[.4D6-$r9=C[.(B
CentOS 6.6(64bit)
pacemaker 1.1.12-1.el6
corosync 2.3.4-1.el6
MySQL 5.6.24-1.el6

(host1)
eth0: 10.0.2.11/24
eth1: 192.168.56.11/24

(host2)
eth0: 10.0.2.12/24
eth1: 192.168.56.12/24

eth0$B$K$O2>A[(BIP$B%"%I%l%9(B"10.0.2.10"$B$r!"(B
eth1$B$K$O2>A[(BIP$B%"%I%l%9(B"192.168.56.10"$B$rIUM?$9$k!#(B


[host1$B$K$F(Bifconfig eth0 down$B$r<B9T$7$?7k2L(B($B0lIt>JN,(B)]
# crm_mon -fA1
Online: [ host1 host2 ]

Resource Group: grpNetwork
vip1 (ocf::heartbeat:IPaddr2): Started host1 $B"+Dd;_$9$k$N$r4|BT(B
vip2 (ocf::heartbeat:IPaddr2): Started host1
mailto (ocf::private:MailTo): Started host1
Master/Slave Set: msMysql [mysql]
Masters: [ host1 ]
Slaves: [ host2 ]


[$B@_Dj(B(etc/corosync/corosync.conf)]
totem {
version: 2

crypto_cipher: none
crypto_hash: none
rrp_mode:active

interface {
ringnumber: 0
bindnetaddr: 192.168.56.0
mcastport: 5405
ttl: 1
}
interface {
ringnumber: 1
bindnetaddr: 10.0.2.0
mcastport: 5405
ttl: 1
}
transport: udpu
}

logging {
fileline: off
to_logfile: yes
to_syslog: no
logfile: /var/log/cluster/corosync.log
debug: off
timestamp: on
logger_subsys {
subsys: QUORUM
debug: off
}
}

nodelist {
node {
ring0_addr: 192.168.56.11
nodeid: 1
}

node {
ring0_addr: 192.168.56.12
nodeid: 2
}
}

quorum {
# Enable and configure quorum subsystem (default: off)
# see also corosync.conf.5 and votequorum.5
provider: corosync_votequorum
expected_votes: 2
}


[$B@_Dj(B(crm configure$B%3%^%s%I$rMQ$$$F%$%s%]!<%H$7$?%F%-%9%H(B)]
### Cluster Option ###
property no-quorum-policy="ignore" \
stonith-enabled="false" \
startup-fencing="false"

### Resource Defaults ###
rsc_defaults resource-stickiness="INFINITY" \
migration-threshold="1"

### Group Configuration ###
group grpNetwork \
vip1 \
vip2

### Clone Configuration ###

### Master/Slave Configuration ###
ms msMysql mysql \
meta \
master-max="1" \
master-node-max="1" \
clone-max="2" \
clone-node-max="1" \
notify="true"

### Fencing Topology ###

### Primitive Configuration ###
primitive vip1 ocf:heartbeat:IPaddr2 \
params \
ip="10.0.2.10" \
nic="eth0" \
cidr_netmask="24" \
op start interval="0s" timeout="60s" on-fail="restart" \
op monitor interval="10s" timeout="60s" on-fail="restart" \
op stop interval="0s" timeout="60s" on-fail="block"

primitive vip2 ocf:heartbeat:IPaddr2 \
params \
ip="192.168.56.10" \
nic="eth1" \
cidr_netmask="24" \
op start interval="0s" timeout="60s" on-fail="restart" \
op monitor interval="10s" timeout="60s" on-fail="restart" \
op stop interval="0s" timeout="60s" on-fail="block"

primitive mysql ocf:private:mysql56 \
params \
binary="/usr/bin/mysqld_safe" \
pid="/var/run/mysqld/mysqld.pid" \
replication_user="****" \
replication_passwd="****" \
op start interval="0s" timeout="120s" on-fail="restart" \
op stop interval="0s" timeout="120s" on-fail="block" \
op monitor interval="20s" timeout="30s" on-fail="restart" \
op monitor interval="10s" timeout="30s" on-fail="restart" role="Master" \
op monitor interval="30s" timeout="30s" on-fail="restart" role="Slave" \
op promote interval="0s" timeout="120s" on-fail="restart" \
op demote interval="0s" timeout="120s" on-fail="stop" \
op notify interval="0s" timeout="90s"

### Resource Location ###

### Resource Colocation ###
colocation colocation-1 inf: grpNetwork msMysql:Master

### Resource Order ###
order order-1 inf: msMysql:promote grpNetwork:start symmetrical=false
order order-2 0: msMysql:demote grpNetwork:stop symmetrical=false


[$BFC5-;v9`(B]
$B!&@_DjFbMF$N5-=RCf$N(BMySQL$B$N%m%0%$%s>pJs$O%^%9%/$7$F$*$j$^$9!#(B
$B!&(BMySQL$B$N%j%=!<%9%(!<%8%'%s%H$O!"I8=`$N$b$N(B(ocf:heartbeat:mysql)$B$,(B
v5.6$B$KBP1~$7$F$$$J$$MM$G!"%+%9%?%^%$%:$7$?$b$N$r;HMQ$7$F$*$j$^$9$,!"(B
$B:#2s$N!V2>A[(BIP(vip1)$B$,Dd;_$7$J$$!W$H$$$&8=>]$H$OD>@\E*$J4X78$,(B
$B9M$($K$/$$$?$a!"%+%9%?%^%$%:$N>\:Y$O0lC63d0&$7$^$9!#(B
_______________________________________________
Linux-ha-japan mailing list
Linux-ha-japan@lists.osdn.me
http://lists.osdn.me/mailman/listinfo/linux-ha-japan
Re: DBのMaster/Slaveセットと仮想IPの同居について [ In reply to ]
金城さん

こんにちは、山内です。

eth0の停止不良ということは、以下のvip1リソースに故障を起こして、
stopに失敗している状態と思います。

> primitive vip1 ocf:heartbeat:IPaddr2 \
>   params \
>   ip="10.0.2.10" \
>   nic="eth0" \
>   cidr_netmask="24" \
>   op start interval="0s" timeout="60s" 
> on-fail="restart" \
>   op monitor interval="10s" timeout="60s" 
> on-fail="restart" \
>   op stop interval="0s" timeout="60s" 
> on-fail="block"


この場合、stopのon-fail="block"ですので、stopに失敗するとFO(MySQLのSlaveはMasterに昇格されない)しません。
#on-fail="block"は、そのままで何もしない。
#on-fail="ignore"は、失敗を無視して処理を継続。
#on-fail="restart"は、stop->startを実行。
#on-fail="fence"は、stonithを実行。

on-fail="fence"に設定して、stonithリソースの導入を検討して頂くか、
on-fail="ignore"に設定して、VIPcheckリソースを先頭リソースとして採用して頂くなどの対応が必要です。
#on-fail="ignore"でVIPcheckを採用した場合、eth0の故障で、実際にvip1が外れていなかった場合には、Slaveノードからvip1に疎通が取れる為、やはりFOに失敗しますが、
#Master側のeth0がハード故障などで、Slaveノードからvip1に疎通が取れない場合にはFO可能です。

設定に関しては、MLやLinuxha-japanの資料に記載があったと思います。

以上です。




----- Original Message -----
> From: Yoshiki Kinjo <yossroid@gmail.com>
> To: Linux-ha-japan@lists.osdn.me
> Cc:
> Date: 2015/6/3, Wed 17:22
> Subject: [Linux-ha-jp] DBのMaster/Slaveセットと仮想IPの同居について
>
> お世話になります。金城と申します。
>
> 下記の環境において、DBサーバのMaster/Slaveセットの内、
> Master側のネットワークに何かしらの不良(断線やIF故障)があった場合に、
> SlaveをMasterに昇格させたいのですが、eth0に不良があった場合に
> 仮想IP(vip1)が停止せず、MySQLのSlaveはMasterに昇格されない
> 状態です。
>
> 原因や解決策をご存知であれば、ご教授頂けますでしょうか。
> (場合によってはVIPcheckなど他のリソースが必要と考えていますが、
> 何を選択すべきか、調べたものの、今ひとつ分かっていません。)
>
> お手数をお掛けして申し訳ありませんが、宜しくお願い致します。
> 以下、詳細です。
>
>
> [要件]
> CentOSサーバ2台でMySQLのMaster/Slaveセットを構築する。
> 各ノードにはネットワークIFが2枚(eth0/eth1)装備されており、
> それぞれに仮想IPを設定する。
> 他のホストからのアクセスの際は仮想IP経由でMaster側へアクセスする。
>
> 各ネットワークIFの役割は下記の通り。
> eth0:外部サービスとの連携
> eth1:内部ネットワーク内の接続(Webアプリからの接続等)
>
>
> [環境] ※テスト用に仮想環境を構築
> CentOS 6.6(64bit)
> pacemaker 1.1.12-1.el6
> corosync 2.3.4-1.el6
> MySQL 5.6.24-1.el6
>
> (host1)
> eth0: 10.0.2.11/24
> eth1: 192.168.56.11/24
>
> (host2)
> eth0: 10.0.2.12/24
> eth1: 192.168.56.12/24
>
> eth0には仮想IPアドレス"10.0.2.10"を、
> eth1には仮想IPアドレス"192.168.56.10"を付与する。
>
>
> [host1にてifconfig eth0 downを実行した結果(一部省略)]
> # crm_mon -fA1
> Online: [ host1 host2 ]
>
> Resource Group: grpNetwork
>     vip1  (ocf::heartbeat:IPaddr2):  Started host1 ←停止するのを期待
>     vip2  (ocf::heartbeat:IPaddr2):  Started host1
>     mailto (ocf::private:MailTo):  Started host1
> Master/Slave Set: msMysql [mysql]
>     Masters: [ host1 ]
>     Slaves: [ host2 ]
>
>
> [設定(etc/corosync/corosync.conf)]
> totem {
>   version: 2
>
>   crypto_cipher: none
>   crypto_hash: none
>   rrp_mode:active
>
>   interface {
>     ringnumber: 0
>     bindnetaddr: 192.168.56.0
>     mcastport: 5405
>     ttl: 1
>   }
>   interface {
>     ringnumber: 1
>     bindnetaddr: 10.0.2.0
>     mcastport: 5405
>     ttl: 1
>   }
>   transport: udpu
> }
>
> logging {
>   fileline: off
>   to_logfile: yes
>   to_syslog: no
>   logfile: /var/log/cluster/corosync.log
>   debug: off
>   timestamp: on
>   logger_subsys {
>     subsys: QUORUM
>     debug: off
>   }
> }
>
> nodelist {
>   node {
>     ring0_addr: 192.168.56.11
>     nodeid: 1
>   }
>
>   node {
>     ring0_addr: 192.168.56.12
>     nodeid: 2
>   }
> }
>
> quorum {
>   # Enable and configure quorum subsystem (default: off)
>   # see also corosync.conf.5 and votequorum.5
>   provider: corosync_votequorum
>   expected_votes: 2
> }
>
>
> [設定(crm configureコマンドを用いてインポートしたテキスト)]
> ### Cluster Option ###
> property no-quorum-policy="ignore" \
>   stonith-enabled="false" \
>   startup-fencing="false"
>
> ### Resource Defaults ###
> rsc_defaults resource-stickiness="INFINITY" \
>   migration-threshold="1"
>
> ### Group Configuration ###
> group grpNetwork \
>   vip1 \
>   vip2
>
> ### Clone Configuration ###
>
> ### Master/Slave Configuration ###
> ms msMysql mysql \
>   meta \
>     master-max="1" \
>     master-node-max="1" \
>     clone-max="2" \
>     clone-node-max="1" \
>     notify="true"
>
> ### Fencing Topology ###
>
> ### Primitive Configuration ###
> primitive vip1 ocf:heartbeat:IPaddr2 \
>   params \
>   ip="10.0.2.10" \
>   nic="eth0" \
>   cidr_netmask="24" \
>   op start interval="0s" timeout="60s"
> on-fail="restart" \
>   op monitor interval="10s" timeout="60s"
> on-fail="restart" \
>   op stop interval="0s" timeout="60s"
> on-fail="block"
>
> primitive vip2 ocf:heartbeat:IPaddr2 \
>   params \
>   ip="192.168.56.10" \
>   nic="eth1" \
>   cidr_netmask="24" \
>   op start interval="0s" timeout="60s"
> on-fail="restart" \
>   op monitor interval="10s" timeout="60s"
> on-fail="restart" \
>   op stop interval="0s" timeout="60s"
> on-fail="block"
>
> primitive mysql ocf:private:mysql56 \
>   params \
>   binary="/usr/bin/mysqld_safe" \
>   pid="/var/run/mysqld/mysqld.pid" \
>   replication_user="****" \
>   replication_passwd="****" \
>   op start  interval="0s"  timeout="120s"
> on-fail="restart" \
>   op stop    interval="0s"  timeout="120s"
> on-fail="block" \
>   op monitor interval="20s" timeout="30s" 
> on-fail="restart" \
>   op monitor interval="10s" timeout="30s" 
> on-fail="restart" role="Master" \
>   op monitor interval="30s" timeout="30s" 
> on-fail="restart" role="Slave" \
>   op promote interval="0s"  timeout="120s"
> on-fail="restart" \
>   op demote  interval="0s"  timeout="120s"
> on-fail="stop" \
>   op notify  interval="0s"  timeout="90s"
>
> ### Resource Location ###
>
> ### Resource Colocation ###
> colocation colocation-1 inf: grpNetwork msMysql:Master
>
> ### Resource Order ###
> order order-1 inf: msMysql:promote grpNetwork:start symmetrical=false
> order order-2 0:  msMysql:demote  grpNetwork:stop  symmetrical=false
>
>
> [特記事項]
> ・設定内容の記述中のMySQLのログイン情報はマスクしております。
> ・MySQLのリソースエージェントは、標準のもの(ocf:heartbeat:mysql)が
>   v5.6に対応していない様で、カスタマイズしたものを使用しておりますが、
>   今回の「仮想IP(vip1)が停止しない」という現象とは直接的な関係が
>   考えにくいため、カスタマイズの詳細は一旦割愛します。
> _______________________________________________
> 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: DBのMaster/Slaveセットと仮想IPの同居について [ In reply to ]
$B;3FbMM(B

$B$*@$OC$K$J$C$F$*$j$^$9!#6b>k$G$9!#(B

$B$4JV?.$"$j$,$H$&$4$6$$$^$9!#(B
$B$4Ds0FD:$$$?J}K!$GD4::8!>Z$r$7$F$_$^$9!#(B

$B<h$j5^$.8fNi$^$G!#(B

2015$BG/(B6$B7n(B4$BF|(B 8:19 <renayama19661014@ybb.ne.jp>:
> $B6b>k$5$s(B
>
> $B$3$s$K$A$O!";3Fb$G$9!#(B
>
> eth0$B$NDd;_ITNI$H$$$&$3$H$O!"0J2<$N(Bvip1$B%j%=!<%9$K8N>c$r5/$3$7$F!"(B
> stop$B$K<:GT$7$F$$$k>uBV$H;W$$$^$9!#(B
>
>> primitive vip1 ocf:heartbeat:IPaddr2 \
>> params \
>> ip="10.0.2.10" \
>> nic="eth0" \
>> cidr_netmask="24" \
>> op start interval="0s" timeout="60s"
>> on-fail="restart" \
>> op monitor interval="10s" timeout="60s"
>> on-fail="restart" \
>> op stop interval="0s" timeout="60s"
>> on-fail="block"
>
>
> $B$3$N>l9g!"(Bstop$B$N(Bon-fail="block"$B$G$9$N$G!"(Bstop$B$K<:GT$9$k$H(BFO(MySQL$B$N(BSlave$B$O(BMaster$B$K>:3J$5$l$J$$(B)$B$7$^$;$s!#(B
> $B!t(Bon-fail="block"$B$O!"$=$N$^$^$G2?$b$7$J$$!#(B
> $B!t(Bon-fail="ignore"$B$O!"<:GT$rL5;k$7$F=hM}$r7QB3!#(B
> $B!t(Bon-fail="restart"$B$O!"(Bstop->start$B$r<B9T!#(B
> $B!t(Bon-fail="fence"$B$O!"(Bstonith$B$r<B9T!#(B
>
> on-fail="fence"$B$K@_Dj$7$F!"(Bstonith$B%j%=!<%9$NF3F~$r8!F$$7$FD:$/$+!"(B
> on-fail="ignore"$B$K@_Dj$7$F!"(BVIPcheck$B%j%=!<%9$r@hF,%j%=!<%9$H$7$F:NMQ$7$FD:$/$J$I$NBP1~$,I,MW$G$9!#(B
> $B!t(Bon-fail="ignore"$B$G(BVIPcheck$B$r:NMQ$7$?>l9g!"(Beth0$B$N8N>c$G!"<B:]$K(Bvip1$B$,30$l$F$$$J$+$C$?>l9g$K$O!"(BSlave$B%N!<%I$+$i(Bvip1$B$KABDL$,<h$l$k0Y!"$d$O$j(BFO$B$K<:GT$7$^$9$,!"(B
> $B!t(BMaster$BB&$N(Beth0$B$,%O!<%I8N>c$J$I$G!"(BSlave$B%N!<%I$+$i(Bvip1$B$KABDL$,<h$l$J$$>l9g$K$O(BFO$B2DG=$G$9!#(B
>
> $B@_Dj$K4X$7$F$O!"(BML$B$d(BLinuxha-japan$B$N;qNA$K5-:\$,$"$C$?$H;W$$$^$9!#(B
>
> $B0J>e$G$9!#(B
>
>
>
>
> ----- Original Message -----
>> From: Yoshiki Kinjo <yossroid@gmail.com>
>> To: Linux-ha-japan@lists.osdn.me
>> Cc:
>> Date: 2015/6/3, Wed 17:22
>> Subject: [Linux-ha-jp] DB$B$N(BMaster/Slave$B%;%C%H$H2>A[.(BIP$B$NF15o$K$D$$$F(B
>>
>> $B$*@$OC$K$J$j$^$9!#6b>k$H?=$7$^$9!#(B
>>
>> $B2<5-$N4D6-$K$*$$$F!"(BDB$B%5!<%P$N(BMaster/Slave$B%;%C%H$NFb!"(B
>> Master$BB&$N%M%C%H%o!<%/$K2?$+$7$i$NITNI(B($BCG@~$d(BIF$B8N>c(B)$B$,$"$C$?>l9g$K!"(B
>> Slave$B$r(BMaster$B$K>:3J$5$;$?$$$N$G$9$,!"(Beth0$B$KITNI$,$"$C$?>l9g$K(B
>> $B2>A[.(BIP(vip1)$B$,Dd;_$;$:!"(BMySQL$B$N(BSlave$B$O(BMaster$B$K>:3J$5$l$J$$(B
>> $B>uBV$G$9!#(B
>>
>> $B860x$d2r7h:v$r$4B8CN$G$"$l$P!"$465<xD:$1$^$9$G$7$g$&$+!#(B
>> ($B>l9g$K$h$C$F$O(BVIPcheck$B$J$IB>$N%j%=!<%9$,I,MW$H9M$($F$$$^$9$,!"(B
>> $B2?$rA*Br$9$Y$-$+!"D4$Y$?$b$N$N!":#$R$H$DJ,$+$C$F$$$^$;$s!#(B)
>>
>> $B$*<j?t$r$*3]$1$7$F?=$7Lu$"$j$^$;$s$,!"59$7$/$*4j$$CW$7$^$9!#(B
>> $B0J2<!">\:Y$G$9!#(B
>>
>>
>> [$BMW7o(B]
>> CentOS$B%5!<%P(B2$BBf$G(BMySQL$B$N(BMaster/Slave$B%;%C%H$r9=C[$9$k!#(B
>> $B3F%N!<%I$K$O%M%C%H%o!<%/(BIF$B$,(B2$BKg(B(eth0/eth1)$BAuHw$5$l$F$*$j!"(B
>> $B$=$l$>$l$K2>A[(BIP$B$r@_Dj$9$k!#(B
>> $BB>$N%[%9%H$+$i$N%"%/%;%9$N:]$O2>A[.(BIP$B7PM3$G(BMaster$BB&$X%"%/%;%9$9$k!#(B
>>
>> $B3F%M%C%H%o!<%/(BIF$B$NLr3d$O2<5-$NDL$j!#(B
>> eth0:$B30It%5!<%S%9$H$NO"7H(B
>> eth1:$BFbIt%M%C%H%o!<%/Fb$N@\B3(B(Web$B%"%W%j$+$i$N@\B3Ey(B)
>>
>>
>> [$B4D6-(B] $B"(%F%9%HMQ$K2>A[.4D6-$r9=C[.(B
>> CentOS 6.6(64bit)
>> pacemaker 1.1.12-1.el6
>> corosync 2.3.4-1.el6
>> MySQL 5.6.24-1.el6
>>
>> (host1)
>> eth0: 10.0.2.11/24
>> eth1: 192.168.56.11/24
>>
>> (host2)
>> eth0: 10.0.2.12/24
>> eth1: 192.168.56.12/24
>>
>> eth0$B$K$O2>A[(BIP$B%"%I%l%9(B"10.0.2.10"$B$r!"(B
>> eth1$B$K$O2>A[(BIP$B%"%I%l%9(B"192.168.56.10"$B$rIUM?$9$k!#(B
>>
>>
>> [host1$B$K$F(Bifconfig eth0 down$B$r<B9T$7$?7k2L(B($B0lIt>JN,(B)]
>> # crm_mon -fA1
>> Online: [ host1 host2 ]
>>
>> Resource Group: grpNetwork
>> vip1 (ocf::heartbeat:IPaddr2): Started host1 $B"+Dd;_$9$k$N$r4|BT(B
>> vip2 (ocf::heartbeat:IPaddr2): Started host1
>> mailto (ocf::private:MailTo): Started host1
>> Master/Slave Set: msMysql [mysql]
>> Masters: [ host1 ]
>> Slaves: [ host2 ]
>>
>>
>> [$B@_Dj(B(etc/corosync/corosync.conf)]
>> totem {
>> version: 2
>>
>> crypto_cipher: none
>> crypto_hash: none
>> rrp_mode:active
>>
>> interface {
>> ringnumber: 0
>> bindnetaddr: 192.168.56.0
>> mcastport: 5405
>> ttl: 1
>> }
>> interface {
>> ringnumber: 1
>> bindnetaddr: 10.0.2.0
>> mcastport: 5405
>> ttl: 1
>> }
>> transport: udpu
>> }
>>
>> logging {
>> fileline: off
>> to_logfile: yes
>> to_syslog: no
>> logfile: /var/log/cluster/corosync.log
>> debug: off
>> timestamp: on
>> logger_subsys {
>> subsys: QUORUM
>> debug: off
>> }
>> }
>>
>> nodelist {
>> node {
>> ring0_addr: 192.168.56.11
>> nodeid: 1
>> }
>>
>> node {
>> ring0_addr: 192.168.56.12
>> nodeid: 2
>> }
>> }
>>
>> quorum {
>> # Enable and configure quorum subsystem (default: off)
>> # see also corosync.conf.5 and votequorum.5
>> provider: corosync_votequorum
>> expected_votes: 2
>> }
>>
>>
>> [$B@_Dj(B(crm configure$B%3%^%s%I$rMQ$$$F%$%s%]!<%H$7$?%F%-%9%H(B)]
>> ### Cluster Option ###
>> property no-quorum-policy="ignore" \
>> stonith-enabled="false" \
>> startup-fencing="false"
>>
>> ### Resource Defaults ###
>> rsc_defaults resource-stickiness="INFINITY" \
>> migration-threshold="1"
>>
>> ### Group Configuration ###
>> group grpNetwork \
>> vip1 \
>> vip2
>>
>> ### Clone Configuration ###
>>
>> ### Master/Slave Configuration ###
>> ms msMysql mysql \
>> meta \
>> master-max="1" \
>> master-node-max="1" \
>> clone-max="2" \
>> clone-node-max="1" \
>> notify="true"
>>
>> ### Fencing Topology ###
>>
>> ### Primitive Configuration ###
>> primitive vip1 ocf:heartbeat:IPaddr2 \
>> params \
>> ip="10.0.2.10" \
>> nic="eth0" \
>> cidr_netmask="24" \
>> op start interval="0s" timeout="60s"
>> on-fail="restart" \
>> op monitor interval="10s" timeout="60s"
>> on-fail="restart" \
>> op stop interval="0s" timeout="60s"
>> on-fail="block"
>>
>> primitive vip2 ocf:heartbeat:IPaddr2 \
>> params \
>> ip="192.168.56.10" \
>> nic="eth1" \
>> cidr_netmask="24" \
>> op start interval="0s" timeout="60s"
>> on-fail="restart" \
>> op monitor interval="10s" timeout="60s"
>> on-fail="restart" \
>> op stop interval="0s" timeout="60s"
>> on-fail="block"
>>
>> primitive mysql ocf:private:mysql56 \
>> params \
>> binary="/usr/bin/mysqld_safe" \
>> pid="/var/run/mysqld/mysqld.pid" \
>> replication_user="****" \
>> replication_passwd="****" \
>> op start interval="0s" timeout="120s"
>> on-fail="restart" \
>> op stop interval="0s" timeout="120s"
>> on-fail="block" \
>> op monitor interval="20s" timeout="30s"
>> on-fail="restart" \
>> op monitor interval="10s" timeout="30s"
>> on-fail="restart" role="Master" \
>> op monitor interval="30s" timeout="30s"
>> on-fail="restart" role="Slave" \
>> op promote interval="0s" timeout="120s"
>> on-fail="restart" \
>> op demote interval="0s" timeout="120s"
>> on-fail="stop" \
>> op notify interval="0s" timeout="90s"
>>
>> ### Resource Location ###
>>
>> ### Resource Colocation ###
>> colocation colocation-1 inf: grpNetwork msMysql:Master
>>
>> ### Resource Order ###
>> order order-1 inf: msMysql:promote grpNetwork:start symmetrical=false
>> order order-2 0: msMysql:demote grpNetwork:stop symmetrical=false
>>
>>
>> [$BFC5-;v9`(B]
>> $B!&@_DjFbMF$N5-=RCf$N(BMySQL$B$N%m%0%$%s>pJs$O%^%9%/$7$F$*$j$^$9!#(B
>> $B!&(BMySQL$B$N%j%=!<%9%(!<%8%'%s%H$O!"I8=`$N$b$N(B(ocf:heartbeat:mysql)$B$,(B
>> v5.6$B$KBP1~$7$F$$$J$$MM$G!"%+%9%?%^%$%:$7$?$b$N$r;HMQ$7$F$*$j$^$9$,!"(B
>> $B:#2s$N!V2>A[(BIP(vip1)$B$,Dd;_$7$J$$!W$H$$$&8=>]$H$OD>@\E*$J4X78$,(B
>> $B9M$($K$/$$$?$a!"%+%9%?%^%$%:$N>\:Y$O0lC63d0&$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