[Pacemaker] can pacemaker do mysql Master/Slave.

[Joe]

Thank you very much Mike. I tried but it does not seem to work. Would 
you happen to have a doc somewhere that has example crm configure show. 
Thank you - Joe.

On 10/31/2011 12:48 PM, Michael Marrotte wrote:
> 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>:
>     wgethttps://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 
> <mailto: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
>     <mailto: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
>
>
>
>
> _______________________________________________
> 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/4f092e36/attachment.htm>