[Pacemaker] Master/Master Setup

[Michael Marrotte]

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.bhatia at 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 at 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>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.clusterlabs.org/pipermail/pacemaker/attachments/20111022/50467f5b/attachment-0003.html>