[Pacemaker] can pacemaker do mysql Master/Slave.

[Michael Marrotte]

Joe:

Yes.  There is now support for replication (master/slave):

   - See if the installed MySQL RA (Resource Agent) includes support for
   replication (your paths might be different)

   grep -i 'replication capability' /usr/lib/ocf/resource.d/heartbeat/mysql
   #		Marian Marinov, Florian Haas: add replication capability

   - If not (grep's empty), then grab the latest from
GitHub?<https://trac.dechocorp.com/wiki/GitHub>:


   wget https://raw.github.com/ClusterLabs/resource-agents/master/heartbeat/mysql



   - Backup the current MySQL RA, move the new one in place (paths might be
   different):

   mv /usr/lib/ocf/resource.d/heartbeat/mysql
/usr/lib/ocf/resource.d/heartbeat/mysql.backup
   mv mysql /usr/lib/ocf/resource.d/heartbeat/mysql
   chmod +x /usr/lib/ocf/resource.d/heartbeat/mysql

   - You might have to do something like this if your paths are off --
   Patch the new MySQL RA::

  Open /usr/lib/ocf/resource.d/heartbeat/mysql and replace:

: ${OCF_FUNCTIONS_DIR=${OCF_ROOT}/lib/heartbeat}
. ${OCF_FUNCTIONS_DIR}/ocf-shellfuncs

with

: ${OCF_FUNCTIONS_DIR=${OCF_ROOT}/resource.d/heartbeat}
. ${OCF_FUNCTIONS_DIR}/.ocf-shellfuncs


~Mike


On Mon, Oct 31, 2011 at 1:39 PM, Joe <weester at hotmail.com> wrote:

>  I have a quick question is the Master Slave setting in pacemaker only
> allowed in regards to a DRBD device? Can you use it to create other Master
> Slave relationships such as mysql . What I am trying to do is to failover
> mysql service on a primary to a secondary if the mysql service fails on the
> primary . Here is my RA Mysql Service.
>
> *crm configure show*
> node mysqldrbd01 \
>         attributes standby="off"
> node mysqldrbd02 \
>         attributes standby="off"
> primitive DRBD ocf:linbit:drbd \
>         params drbd_resource="QD-RES" \
>         operations $id="DRBD-operations" \
>         op start interval="0" timeout="240" \
>         op stop interval="0" timeout="100" \
>         op monitor interval="120" \
>         meta target-role="started"
> primitive FAILOVER-ADDR ocf:heartbeat:IPaddr2 \
>         params ip="192.168.1.160" nic="eth1" \
>         operations $id="FAILOVER-ADDR-operations" \
>         op monitor start-delay="0" interval="10" \
>         meta target-role="started"
> primitive PING-NET ocf:pacemaker:ping \
>         params multiplier="100" host_list="192.168.1.5" \
>         operations $id="PING-NET-operations" \
>         op start interval="0" timeout="60" \
>         op stop interval="0" timeout="60" \
>         op monitor interval="60" timeout="60" start-delay="0" \
>         meta target-role="started"
> primitive SRV-MOUNT ocf:heartbeat:Filesystem \
>         params device="/dev/drbd0" directory="/data/" fstype="ext3" \
>         operations $id="SRV-MOUNT-operations" \
>         op start interval="0" timeout="60" \
>         op stop interval="0" timeout="60" \
>         meta target-role="started"
> primitive res_mysqld_MYSQL_SRV lsb:mysqld \
>         operations $id="res_mysqld_MYSQL_SRV-operations" \
>         op start interval="0" timeout="15" \
>         op stop interval="0" timeout="15" \
>         op monitor interval="15" timeout="15" start-delay="15"
> group AP-CLUST SRV-MOUNT FAILOVER-ADDR
> ms DRBD-DATA DRBD \
>         meta clone-max="2" notify="true" target-role="started"
> ms MYSQ_MASTER_SLAVE res_mysqld_MYSQL_SRV \
>         meta clone-max="2" notify="true" target-role="started"
> clone PING-NET-CLONE PING-NET \
>         meta clone-max="2"
> location connected_node DRBD-DATA \
>         rule $id="connected_node-rule" -inf: not_defined pingd or pingd
> lte 0
> colocation AP-CLUST_on_DRBD inf: AP-CLUST DRBD-DATA:Master
> order AP-CLUST_after_DRBD-DATA inf: DRBD-DATA:promote AP-CLUST:start
> property $id="cib-bootstrap-options" \
>         expected-quorum-votes="2" \
>         stonith-enabled="false" \
>         dc-version="1.0.11-1554a83db0d3c3e546cfd3aaff6af1184f79ee87" \
>         no-quorum-policy="ignore" \
>         cluster-infrastructure="openais" \
>         last-lrm-refresh="1320082592"
> rsc_defaults $id="rsc-options" \
>         resource-stickiness="100"
>
>
>
>
> thank you very much,
> Joe
>
>
> _______________________________________________
> Pacemaker mailing list: Pacemaker at oss.clusterlabs.org
> http://oss.clusterlabs.org/mailman/listinfo/pacemaker
>
> Project Home: http://www.clusterlabs.org
> Getting started: http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf
> Bugs:
> http://developerbugs.linux-foundation.org/enter_bug.cgi?product=Pacemaker
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.clusterlabs.org/pipermail/pacemaker/attachments/20111031/d9835c50/attachment.htm>