On May 27, 2010, at 7:17 AM, Robinson, Eric wrote: > Here is my current crm configuration. Using this config, all of the > MySQL resources would failover sequentially. How would I rewrite this to > make the MySQL resources failover in parallel (i.e., not dependent on > each other) while all still being dependent on the ClusetIP, DRBD, and > FileSystem resources? > > -- > > node ha05.mydomain.com > node ha06.mydomain.com > primitive p_ClusterIP ocf:heartbeat:IPaddr2 \ > params ip="192.168.10.205" cidr_netmask="32" \ > op monitor interval="15s" > primitive p_DRBD ocf:linbit:drbd \ > params drbd_resource="ha_mysql" \ > op monitor interval="15s" > primitive p_FileSystem ocf:heartbeat:Filesystem \ > params device="/dev/drbd0" directory="/ha_mysql" fstype="ext3" > primitive p_MySQL_001 lsb:mysql_001 > primitive p_MySQL_053 lsb:mysql_053 > primitive p_MySQL_054 lsb:mysql_054 > primitive p_MySQL_057 lsb:mysql_057 > primitive p_MySQL_103 lsb:mysql_103 > primitive p_MySQL_106 lsb:mysql_106 \ > meta target-role="Started" > primitive p_MySQL_115 lsb:mysql_115 > primitive p_MySQL_139 lsb:mysql_139 > primitive p_MySQL_140 lsb:mysql_140 > primitive p_MySQL_141 lsb:mysql_141 > primitive p_MySQL_142 lsb:mysql_142 > primitive p_MySQL_143 lsb:mysql_143 > primitive p_MySQL_144 lsb:mysql_144 > primitive p_MySQL_145 lsb:mysql_145 > primitive p_MySQL_146 lsb:mysql_146 > primitive p_MySQL_147 lsb:mysql_147 > primitive p_MySQL_148 lsb:mysql_148 > primitive p_MySQL_149 lsb:mysql_149 > primitive p_MySQL_150 lsb:mysql_150 > primitive p_MySQL_151 lsb:mysql_151 > primitive p_MySQL_152 lsb:mysql_152 > primitive p_MySQL_153 lsb:mysql_153 > primitive p_MySQL_154 lsb:mysql_154 > primitive p_MySQL_155 lsb:mysql_155 > group g_MySQL p_FileSystem p_ClusterIP p_MySQL_001 p_MySQL_139 > p_MySQL_140 p_MySQL_141 p_MySQL_142 p_MySQL_143 p_MySQL_144 p_MySQL_145 > p_MySQL_146 p_MySQL_147 p_ > MySQL_148 p_MySQL_149 p_MySQL_053 p_MySQL_106 p_MySQL_115 p_MySQL_103 > p_MySQL_150 p_MySQL_057 p_MySQL_151 p_MySQL_152 p_MySQL_153 p_MySQL_154 > p_MySQL_155 p_MySQL > _054 > ms ms_DRBD p_DRBD \ > meta master-max="1" master-node-max="1" clone-max="2" > clone-node-max="1" notify="true" > location cli-prefer-p_MySQL_054 p_MySQL_054 \ > rule $id="cli-prefer-rule-p_MySQL_054" inf: #uname eq > ha06.mydomain.com > location cli-prefer-p_MySQL_057 p_MySQL_057 \ > rule $id="cli-prefer-rule-p_MySQL_057" inf: #uname eq > ha06.mydomain.com > location cli-prefer-p_MySQL_151 p_MySQL_151 \ > rule $id="cli-prefer-rule-p_MySQL_151" inf: #uname eq > ha06.mydomain.com > location cli-prefer-p_MySQL_152 p_MySQL_152 \ > rule $id="cli-prefer-rule-p_MySQL_152" inf: #uname eq > ha06.mydomain.com > location cli-prefer-p_MySQL_153 p_MySQL_153 \ > rule $id="cli-prefer-rule-p_MySQL_153" inf: #uname eq > ha06.mydomain.com > location cli-prefer-p_MySQL_154 p_MySQL_154 \ > rule $id="cli-prefer-rule-p_MySQL_154" inf: #uname eq > ha06.mydomain.com > location cli-prefer-p_MySQL_155 p_MySQL_155 \ > rule $id="cli-prefer-rule-p_MySQL_155" inf: #uname eq > ha06.mydomain.com > colocation c_MySQL_DRBD inf: g_MySQL ms_DRBD:Master > order o_MySQL_then_DRBD inf: ms_DRBD:promote g_MySQL:start > property $id="cib-bootstrap-options" \ > dc-version="1.0.7-d3fa20fc76c7947d6de66db7e52526dc6bd7d782" \ > cluster-infrastructure="openais" \ > expected-quorum-votes="2" \ > stonith-enabled="false" \ > no-quorum-policy="ignore" \ > last-lrm-refresh="1273411570" > rsc_defaults $id="rsc-options" \ > resource-stickiness="100" >
Remove mysql primitives from the group, and as long as we changing config use ocf script for managing mysql ( crm ra list ocf ) (crm ra meta mysql) Then put collocation and order constraints: collocation c_mysql inf: (p_mysql1 p_mysql2 pmysql3) g_MySQL order o_mysql inf: g_MySQL (p_mysql1 p_mysql2 pmysql3) Vadym _______________________________________________ Linux-HA mailing list [email protected] http://lists.linux-ha.org/mailman/listinfo/linux-ha See also: http://linux-ha.org/ReportingProblems
