On 2011-10-07 10:34, raki wrote:
Hi Andrew
Hi Andrew
We had installed Heartbeat/Pacemaker on two Unix(Centos 5.0.2 Machines)
The RPM's we had used for installing Heartbeat ad Pacemaker are
heartbeat-3.0.3-2.3.el5.i386.rpm
pacemaker-1.0.9.1-1.15.el5.i386.rpm
Please find the crm(cluster resource manager) order and co-location we
had used.
colocation Httpd-with-Mysql inf: HttpdVIP MS_Mysql:Master
colocation Httpd-with-ip inf: HttpdVIP Httpd
colocation Mysql-with-Tomcat inf: Tomcat1 MS_Mysql:Master
colocation Tomcat-with-HttpdVIP inf: Tomcat1 HttpdVIP
order Httdp-after-HttpdVIP inf: HttpdVIP Httpd
order Httdp-after-tomcat1 inf: Httpd Tomcat1
order MYSQL-after-HttpdVIP inf: MS_Mysql HttpdVIP
we had two nodes running HA processes (cluster with two nodes)
In on of our test scenario we tried to restart the node where
Mysql-Master is running, based on the above configuration the Ha
processes restarts and other node Mysql processes takes over the Master
responsibility
And we saw the Mysql replication stops working and in the Slave status
we found this error duplicate entry for the key values.
Please help us regarding this.
Error Description 'Duplicate entry '2083' for key 1' on query. Default
database: 'MSF_DB'.
Please try the latest revision of this ra and get back to me if this
problem is still existing.
https://github.com/raoulbhatia/resource-agents/raw/master/heartbeat/mysql
thanks,
raoul
--
____________________________________________________________________
DI (FH) Raoul Bhatia M.Sc. email. r.bha...@ipax.at
Technischer Leiter
IPAX - Aloy Bhatia Hava OEG web. http://www.ipax.at
Barawitzkagasse 10/2/2/11 email. off...@ipax.at
1190 Wien tel. +43 1 3670030
FN 277995t HG Wien fax. +43 1 3670030 15
____________________________________________________________________
_______________________________________________
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
