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-042548a451fce8400660f6031f4da6f0223dd5dd" \
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
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
