<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
</head>
<body bgcolor="#ffffff" text="#000000">
<font face="Arial">Hello All,<br>
<br>
I'm new to pacemaker so please forgive me if this is in a faq
somewhere, I haven't been able to find it!<br>
I am trying to set up a failover config for mysql using the following
setup:<br>
<br>
primitive mysqlvip ocf:heartbeat:IPaddr params ip="xx.xx.xx.xx"<br>
primitive mysqlfs ocf:heartbeat:Filesystem params device="-L mysql"
directory="/var/lib/mysql" fstype="ext3"<br>
primitive mysqlserver ocf:heartbeat:mysql params
binary="/usr/bin/mysqld_safe" op monitor interval="60s" timeout="30s"<br>
primitive st-null stonith:null params hostlist="mysql1 mysql2" <br>
group mysqlservice mysqlvip mysqlfs mysqlserver<br>
clone fencing st-null<br>
location mysql1loc mysqlservice 200: mysql1<br>
location mysql2loc mysqlservice 150: mysql2<br>
colocation mysql_ip_with_fs inf: mysqlvip mysqlfs<br>
colocation mysql_server_with_fs inf: mysqlserver mysqlfs<br>
order mysql_fsbeforeserver inf: mysqlfs mysqlserver<br>
<br>
And it looks to be working great. When I start the configuration three
resources are started on node mysql1. When I switch off node1 by
shutting down the heartbeat service I can see all my resources moving
over to node mysql2. However when I pull the plug on node mysql1 by
switching it off, my services are not moving over. Instead my services
are listed as having been started on node mysql1 (which is down!). This
is the output of crm_mon -r:<br>
<br>
<br>
============<br>
Last updated: Thu May 14 14:32:46 2009<br>
Current DC: nfs2 (e588fc86-92d8-4658-a394-3e031171bcd0) - partition
with quorum<br>
Version: 1.0.3-b133b3f19797c00f9189f4b66b513963f9d25db9<br>
6 Nodes configured, unknown expected votes<br>
2 Resources configured.<br>
============<br>
<br>
Node mysql1 (ea3da999-829d-4042-a5d5-9ee0ad27f989): UNCLEAN (offline)<br>
Online: [ apa1 apa2 mysql2 nfs1 nfs2 ]<br>
<br>
Full list of resources:<br>
<br>
Resource Group: mysqlservice<br>
mysqlvip (ocf::heartbeat:IPaddr): Started mysql1<br>
mysqlfs (ocf::heartbeat:Filesystem): Started mysql1<br>
mysqlserver (ocf::heartbeat:mysql): Started mysql1<br>
Clone Set: fencing<br>
Stopped: [ st-null:0 st-null:1 st-null:2 st-null:3 st-null:4
st-null:5 ]<br>
<br>
I must be missing something but I haven't yet found it.<br>
<br>
Any pointers would be appreciated.<br>
<br>
Thanks,<br>
Mark<br>
</font>
<pre class="moz-signature" cols="72">--
_____________________________________________________________________
Mark Schenk
Project Manager
Shared Service Centre ICT - 3xO
Technische Universiteit Delft
<a class="moz-txt-link-abbreviated" href="mailto:M.M.A.Schenk@tudelft.nl">M.M.A.Schenk@tudelft.nl</a>
Room 3B-41
Postbus 354
2600 AJ Delft
Landbergstraat 15
2628 CE DELFT ___________________________________________
+31 (0)15 27 85448 | Reality is that which, when you
<a class="moz-txt-link-abbreviated" href="http://www.tudelft.nl">www.tudelft.nl</a> | stop believing in it, doesn't go away.
_____________________________________________________________________
</pre>
</body>
</html>