Raoul:<br><br>I made some progress... The default location of the relay-log and log-bin weren't matching up. So, when I specify them things worked out -- now Pacemaker is starting my mysql instances and replication is working -- that is, master/slave... Next hurdle is master/slave <-> master/slave.<br>
<br>Thanks for your help.<br><br>~Mike.<br><br><div class="gmail_quote">On Sat, Oct 22, 2011 at 3:34 PM, Raoul Bhatia [IPAX] <span dir="ltr"><<a href="mailto:r.bhatia@ipax.at">r.bhatia@ipax.at</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">hi!<div class="im"><br>
<br>
On 22.10.2011 20:33, Michael Marrotte wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
primitive p_mysql ocf:heartbeat:mysql \<br>
params binary="/usr/sbin/mysqld" config="/etc/mysql/my.cnf"<br>
replication_user="slaveuser" replication_passwd="slavepw"<br>
test_passwd="root" pid="/var/run/mysqld/mysqld.<u></u>pid"<br>
socket="/var/run/mysqld/<u></u>mysqld.sock" \<br>
params additional_parameters="--skip-<u></u>slave-start" \<br>
op start interval="0" timeout="120" \<br>
op stop interval="0" timeout="120" \<br>
op promote interval="0" timeout="120" \<br>
op demote interval="0" timeout="120" \<br>
op monitor interval="30" timeout="30" OCF_CHECK_LEVEL="1"<br>
ms ms_mysql p_mysql \<br>
meta notify="true" master-max="2" clone-max="2" target-role="Started"<br>
property $id="cib-bootstrap-options" \<br>
dc-version="1.0.8-<u></u>042548a451fce8400660f6031f4da6<u></u>f0223dd5dd" \<br>
cluster-infrastructure="<u></u>Heartbeat" \<br>
stonith-enabled="false" \<br>
no-quorum-policy="ignore" \<br>
last-lrm-refresh="1319301867"<br>
</blockquote>
<br></div>
master-max should be set to 1 if you're using a master-slave mysql<br>
setup.<br>
<br>
you can leave most replication related configuration out of your<br>
mysql config files. except for the server-id i think.<div class="im"><br>
<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
When I start ms_sql, I'm getting the following:<br>
<br>
Failed actions:<br>
p_mysql:0_start_0 (node=vsaas-test-sql-1, call=73, rc=1,<br>
status=complete): unknown error<br>
p_mysql:1_start_0 (node=vsaas-test-sql-2, call=63, rc=1,<br>
status=complete): unknown error<br>
</blockquote>
<br></div>
do all of the above files/paths exist?<br>
my configuration looks this:<br>
<br>
primitive wdb-mysql ocf:heartbeat:mysql \<br>
op monitor interval="30" timeout="30" \<br>
op monitor interval="300" timeout="30" OCF_CHECK_LEVEL="10" \<br>
op monitor interval="301" role="Master" timeout="30" OCF_CHECK_LEVEL="10" \<br>
op monitor interval="31" role="Slave" timeout="30" OCF_CHECK_LEVEL="10" \<br>
op monitor interval="15" role="Slave" timeout="30" \<br>
op monitor interval="10" role="Master" timeout="30" \<div class="im"><br>
op start interval="0" timeout="120" \<br>
op stop interval="0" timeout="120" \<br></div>
params config="/etc/mysql/my.cnf" datadir="/data/db/mysql/data/" socket="/var/run/mysqld/<u></u>mysqld.sock" binary="/usr/sbin/mysqld" additional_parameters="--<u></u>basedir=/usr --skip-external-locking --log-bin=/data/db/mysql/log/<u></u>mysql-bin.log --relay-log=mysqld-relay-bin " pid="/var/run/mysqld/mysqld.<u></u>pid" test_table="nagiostest.test_<u></u>table" test_user="nagios" test_passwd="xxxx" replication_user="ruser" replication_passwd="rpass"<br>
<br>
which version of the mysql ra/which resource agent release do you use?<br>
<br>
and please provide the log files! otherwise, its hard to correctly<br>
diagnose the problem.<br>
<br>
cheers,<br>
raoul<br>
<br>
______________________________<u></u>_________________<br>
Pacemaker mailing list: <a href="mailto:Pacemaker@oss.clusterlabs.org" target="_blank">Pacemaker@oss.clusterlabs.org</a><br>
<a href="http://oss.clusterlabs.org/mailman/listinfo/pacemaker" target="_blank">http://oss.clusterlabs.org/<u></u>mailman/listinfo/pacemaker</a><br>
<br>
Project Home: <a href="http://www.clusterlabs.org" target="_blank">http://www.clusterlabs.org</a><br>
Getting started: <a href="http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf" target="_blank">http://www.clusterlabs.org/<u></u>doc/Cluster_from_Scratch.pdf</a><br>
Bugs: <a href="http://developerbugs.linux-foundation.org/enter_bug.cgi?product=Pacemaker" target="_blank">http://developerbugs.linux-<u></u>foundation.org/enter_bug.cgi?<u></u>product=Pacemaker</a><br>
</blockquote></div><br>