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