<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 6.5.7652.24">
<TITLE>Problems with colocation/order with drbd tree-node-setup</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/rtf format -->
<P><FONT SIZE=2 FACE="Arial">my first post on this list; will be quite a long one :)</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">environment:</FONT>
<BR><FONT SIZE=2 FACE="Arial">OS: RHEL 5.4 x86_64</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">drbd83.x86_64 8.3.2-6.el5_3</FONT>
<BR><FONT SIZE=2 FACE="Arial">kmod-drbd83.x86_64 8.3.2-6.el5_3</FONT>
<BR><FONT SIZE=2 FACE="Arial">openais.x86_64 0.80.6-8.el5_4.1</FONT>
<BR><FONT SIZE=2 FACE="Arial">heartbeat.x86_64 3.0.0-33.2</FONT>
<BR><FONT SIZE=2 FACE="Arial">resource-agents.x86_64 1.0-31.4</FONT>
<BR><FONT SIZE=2 FACE="Arial">pacemaker.x86_64 1.0.5-4.1</FONT>
<BR><FONT SIZE=2 FACE="Arial">pacemaker-libs.x86_64 1.0.5-4.1</FONT>
</P>
<BR>
<P><FONT SIZE=2 FACE="Arial">i would like to mention that i first successfully implemented a 2 node active-passive setup with pacemaker with help from the drbd-users-guide.</FONT></P>
<P><FONT SIZE=2 FACE="Arial">my next try was the three node setup (one backup-server outside of the HA cluster)</FONT>
<BR><FONT SIZE=2 FACE="Arial">it is up-and-running when i doing it 'by hand' !</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">my problems start with the configuration of pacemaker, here i' m lost.</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">i defined the primitive resources, master-slave (without complains of crm/configure/ptest)</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">after colocation + ordering, ptest complains:</FONT>
<BR><FONT SIZE=2 FACE="Arial">-------------------------------------------------------------------------------------------------------------------------</FONT></P>
<P><FONT SIZE=2 FACE="Arial">crm(live)configure# ptest</FONT>
<BR><FONT SIZE=2 FACE="Arial">ptest[15059]: 2009/10/16_11:27:17 WARN: native_color: Resource res.ip.mysql cannot run anywhere</FONT>
<BR><FONT SIZE=2 FACE="Arial">ptest[15059]: 2009/10/16_11:27:17 WARN: native_color: Resource res.drbd.mysqlstack:0 cannot run anywhere</FONT>
<BR><FONT SIZE=2 FACE="Arial">-------------------------------------------------------------------------------------------------------------------------</FONT></P>
<P><FONT SIZE=2 FACE="Arial">-------------------------------------------------------------------------------------------------------------------------</FONT></P>
<P><FONT SIZE=2 FACE="Arial">crm(live)configure# show</FONT>
<BR><FONT SIZE=2 FACE="Arial">node mysqlHA1.cologne.tecdoc.local</FONT>
<BR><FONT SIZE=2 FACE="Arial">node mysqlHA2.cologne.tecdoc.local</FONT>
<BR><FONT SIZE=2 FACE="Arial">primitive res.drbd.mysqldb ocf:linbit:drbd \</FONT>
<BR><FONT SIZE=2 FACE="Arial"> params drbd_resource="mysqldb"</FONT>
<BR><FONT SIZE=2 FACE="Arial">primitive res.drbd.mysqlstack ocf:linbit:drbd \</FONT>
<BR><FONT SIZE=2 FACE="Arial"> params drbd_resource="mysqlstack"</FONT>
<BR><FONT SIZE=2 FACE="Arial">primitive res.ip.mysql ocf:heartbeat:IPaddr2 \</FONT>
<BR><FONT SIZE=2 FACE="Arial"> params ip="172.30.2.10" nic="eth0" \</FONT>
<BR><FONT SIZE=2 FACE="Arial"> op monitor interval="2s" timeout="0.5s"</FONT>
<BR><FONT SIZE=2 FACE="Arial">ms ms.drbd.mysqldb res.drbd.mysqldb \</FONT>
<BR><FONT SIZE=2 FACE="Arial"> meta master-max="1" master-node-max="1" clone-max="2" clone-node-max="1" notify="true" globally_unique="false"</FONT>
<BR><FONT SIZE=2 FACE="Arial">ms ms.drbd.mysqlstack res.drbd.mysqlstack \</FONT>
<BR><FONT SIZE=2 FACE="Arial"> meta master-max="1" master-node-max="1" clone-max="1" clone-node-max="1" notify="true" globally_unique="false"</FONT>
<BR><FONT SIZE=2 FACE="Arial">colocation co.ms.drbd.mysqlstack_on_ms.drbd.mysqldb inf: ms.drbd.mysqlstack ms.drbd.mysqldb:Master</FONT>
<BR><FONT SIZE=2 FACE="Arial">colocation co.ms.drbd.mysqlstack_on_res.ip.mysql inf: ms.drbd.mysqlstack res.ip.mysql</FONT>
<BR><FONT SIZE=2 FACE="Arial">colocation co.res.ip.mysql_on_ms.drbd.mysqldb_master inf: res.ip.mysql ms.drbd.mysqldb:Master</FONT>
<BR><FONT SIZE=2 FACE="Arial">order o.ip.mysql_before_ms.drbd.mysqlstack inf: res.ip.mysql ms.drbd.mysqlstack:start</FONT>
<BR><FONT SIZE=2 FACE="Arial">order o.ms.drbd.mysqldb_before_ms.drbd.mysqlstack inf: ms.drbd.mysqldb:promote ms.drbd.mysqlstack:start</FONT>
<BR><FONT SIZE=2 FACE="Arial">property $id="cib-bootstrap-options" \</FONT>
<BR><FONT SIZE=2 FACE="Arial"> stonith-enabled="false"</FONT>
<BR><FONT SIZE=2 FACE="Arial">-------------------------------------------------------------------------------------------------------------------------</FONT></P>
<P><FONT SIZE=2 FACE="Arial">i have no idea why the cluster-ip cannot be run anywhere (and of course prevent res.drbd.mysqlstack from starting)</FONT>
</P>
<BR>
<P><FONT SIZE=2 FACE="Arial">if you're interested, my /etc/drbd.conf:</FONT>
<BR><FONT SIZE=2 FACE="Arial">-------------------------------------------------------------------------------------------------------------------------</FONT></P>
<P><FONT SIZE=2 FACE="Arial">global {</FONT>
<BR><FONT SIZE=2 FACE="Arial"> usage-count no;</FONT>
<BR><FONT SIZE=2 FACE="Arial">}</FONT>
<BR><FONT SIZE=2 FACE="Arial">common {</FONT>
<BR><FONT SIZE=2 FACE="Arial"> syncer {</FONT>
<BR><FONT SIZE=2 FACE="Arial"> rate 10M;</FONT>
<BR><FONT SIZE=2 FACE="Arial"> verify-alg sha1;</FONT>
<BR><FONT SIZE=2 FACE="Arial"> }</FONT>
<BR><FONT SIZE=2 FACE="Arial"> protocol C;</FONT>
<BR><FONT SIZE=2 FACE="Arial">}</FONT>
<BR><FONT SIZE=2 FACE="Arial">resource mysqldb {</FONT>
<BR><FONT SIZE=2 FACE="Arial"> handlers {</FONT>
<BR><FONT SIZE=2 FACE="Arial"> fence-peer "/usr/lib/drbd/crm-fence-peer.sh";</FONT>
<BR><FONT SIZE=2 FACE="Arial"> after-resync-target "/usr/lib/drbd/crm-unfence-peer.sh";</FONT>
<BR><FONT SIZE=2 FACE="Arial"> split-brain "/usr/lib/drbd/notify-split-brain.sh root";</FONT>
<BR><FONT SIZE=2 FACE="Arial"> }</FONT>
<BR><FONT SIZE=2 FACE="Arial"> startup {</FONT>
<BR><FONT SIZE=2 FACE="Arial"> degr-wfc-timeout 60; # 1 minute</FONT>
<BR><FONT SIZE=2 FACE="Arial"> outdated-wfc-timeout 2; # 2 seconds.</FONT>
<BR><FONT SIZE=2 FACE="Arial"> }</FONT>
<BR><FONT SIZE=2 FACE="Arial"> disk {</FONT>
<BR><FONT SIZE=2 FACE="Arial"> on-io-error detach;</FONT>
<BR><FONT SIZE=2 FACE="Arial"> }</FONT>
<BR><FONT SIZE=2 FACE="Arial"> net {</FONT>
<BR><FONT SIZE=2 FACE="Arial"> cram-hmac-alg "sha1";</FONT>
<BR><FONT SIZE=2 FACE="Arial"> shared-secret "secret";</FONT>
<BR><FONT SIZE=2 FACE="Arial"> after-sb-0pri disconnect;</FONT>
<BR><FONT SIZE=2 FACE="Arial"> after-sb-1pri disconnect;</FONT>
<BR><FONT SIZE=2 FACE="Arial"> after-sb-2pri disconnect;</FONT>
<BR><FONT SIZE=2 FACE="Arial"> rr-conflict disconnect;</FONT>
<BR><FONT SIZE=2 FACE="Arial"> }</FONT>
<BR><FONT SIZE=2 FACE="Arial"> syncer {</FONT>
<BR><FONT SIZE=2 FACE="Arial"> rate 20M;</FONT>
<BR><FONT SIZE=2 FACE="Arial"> al-extents 257;</FONT>
<BR><FONT SIZE=2 FACE="Arial"> }</FONT>
<BR><FONT SIZE=2 FACE="Arial"> device /dev/drbd0;</FONT>
<BR><FONT SIZE=2 FACE="Arial"> disk /dev/sdb;</FONT>
<BR><FONT SIZE=2 FACE="Arial"> meta-disk internal;</FONT>
<BR><FONT SIZE=2 FACE="Arial"> on mysqlHA1.cologne.tecdoc.local {</FONT>
<BR><FONT SIZE=2 FACE="Arial"> address 10.6.0.127:7788;</FONT>
<BR><FONT SIZE=2 FACE="Arial"> }</FONT>
<BR><FONT SIZE=2 FACE="Arial"> on mysqlHA2.cologne.tecdoc.local {</FONT>
<BR><FONT SIZE=2 FACE="Arial"> address 10.6.0.128:7788;</FONT>
<BR><FONT SIZE=2 FACE="Arial"> }</FONT>
<BR><FONT SIZE=2 FACE="Arial">}</FONT>
<BR><FONT SIZE=2 FACE="Arial">resource mysqlstack {</FONT>
<BR><FONT SIZE=2 FACE="Arial"> protocol A;</FONT>
<BR><FONT SIZE=2 FACE="Arial"> device /dev/drbd10;</FONT>
<BR><FONT SIZE=2 FACE="Arial"> stacked-on-top-of mysqldb {</FONT>
<BR><FONT SIZE=2 FACE="Arial"> address 172.30.2.10:7789; # Cluster IP</FONT>
<BR><FONT SIZE=2 FACE="Arial"> }</FONT>
<BR><FONT SIZE=2 FACE="Arial"> on mysqlHAoffsite.cologne.tecdoc.local {</FONT>
<BR><FONT SIZE=2 FACE="Arial"> disk /dev/sdb;</FONT>
<BR><FONT SIZE=2 FACE="Arial"> address 172.30.2.78:7789; # public IP of backup-node</FONT>
<BR><FONT SIZE=2 FACE="Arial"> meta-disk internal;</FONT>
<BR><FONT SIZE=2 FACE="Arial"> }</FONT>
<BR><FONT SIZE=2 FACE="Arial">}</FONT>
<BR><FONT SIZE=2 FACE="Arial">-------------------------------------------------------------------------------------------------------------------------</FONT></P>
<P><FONT COLOR="#000000" SIZE=2 FACE="Arial">Mit freundlichen Grüßen / with kind regards</FONT>
<BR><B><FONT COLOR="#000000" FACE="Arial">Torsten Schmidt</FONT></B>
<BR><FONT COLOR="#000000" SIZE=2 FACE="Arial">System Manager</FONT>
</P>
<BR>
</BODY>
</HTML>