[Pacemaker] Master/Master Setup

[Raoul Bhatia [IPAX]]

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