<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></blockquote><div><br>Yes. I usually have it at 1, but was trying different settings here. <br> </div><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<br>
you can leave most replication related configuration out of your<br>
mysql config files. except for the server-id i think.</blockquote><div><br>OK. I'll try striping that stuff out of my.cnf and see how it goes.<br><br>What about in the DB? Should CHANGE MASTER TO MASTER_HOST= be set?<br>
If I set it to empty, then I can get Pacemaker to show my nodes ina master/slave configuration, but when I write to the master, changes do not get replicated to the slave. If I don't use Pacemaker and start the DB manually, replication works great when I have CHANGE MASTER TO MASTER_HOST= set properly, i.e. pointing at the other node, log file and position. When that's working, I shut down MySQL manually and then cleanup the resources and try to start with Pacemaker, but get the errors I've included here.<br>
<br></div><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;"><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></blockquote><div><br>Yes. They do. I did have a problem early where I had permission problems, but worked that out.<br> </div><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
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></blockquote><div><br>I'm on Ubuntu 10.10 and it had an older version of the mysql agent that didn't include replication. So, I grabber the latest off of github and patched up the shellfunc path like you suggested, previously. That got rid of of bunch of errors and looked promising about 8 hours ago :)<br>
</div><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<br>
and please provide the log files! otherwise, its hard to correctly<br>
diagnose the problem.<br></blockquote><div><br>Please find logs attached and let me know if you'd like to look at some others.<br><br>Thanks for all the help.<br> </div><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<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>