On Fri, May 6, 2011 at 7:30 AM, rakesh k <rakirocker4...@gmail.com> wrote: > Hi All > > I had configured Mysql process in Linux Ha framework. > > Please find the HA configuration for mysql process. > > primitive Mysql ocf:heartbeat:mysql \ > params binary="/usr/bin/mysqld_safe" config="/etc/my.cnf" > datadir="/var/lib/mysql" user="mysql" pid="/var/lib/mysql/mysql.pid" > socket="/var/lib/mysql/mysql.sock" test_passwd="slavepass" > test_table="test.msf_list" test_user="repl" replication_user="repl" > replication_passwd="slavepass" \ > op start interval="0" timeout="120s" \ > op stop interval="0" timeout="120s" \ > op monitor interval="10s" role="Master" timeout="8s" \ > op monitor interval="12s" timeout="8s" > primitive MysqlVIP ocf:heartbeat:IPaddr3 \ > params ip="192.168.254.217" eth_num="eth0:3" > vip_cleanup_file="/var/run/bigha.pid" \ > op start interval="0" timeout="120s" \ > op stop interval="0" timeout="60s" \ > op monitor interval="30s" \ > meta target-role="Started" > ms MS_Mysql Mysql \ > meta notify="true" target-role="Started" > location L_Master MS_Mysql \ > rule $id="L_Master-rule" $role="Master" 100: #uname eq mysql2 \ > rule $id="L_Master-rule1" $role="Master" 100: #uname eq mysql3 > > Here are my scenarios > > 1) when i started the Ha process on both the nodes , Mysql process has been > sarted > 2) The Master is pointing to mysql2 node > 3) now i stopped the HA process on node mysql2, then Master mysql has been > migrated to mysql3 > 4)The data is stored in mysql3 node > 5) Now again i stopped HA process on mysql3 node . > 6) And started HA process in Mysql2, Now here i found there is data > inconsistent at this point of time on both the nodes, where if we update the > mysql2 node and start the HA process on mysql3 node , found there is > inconsistent of data on both the nodes.
Well yeah, because they were not both running at the same time - so there was no chance to replicate the data from 3 -> 2. > > Is there is a way to dynamically change the score values of the mysql > process such that when ever both the nodes started the last mysql master > will act as a master mysql process. call crm_master with a different value. I don't know enough about mysql to say how to calculate it though - and it wont stop 2 from being promoted if 3 isn't running. > > > Looking forward for your help, thank you very much > > Regards > Rakesh > > _______________________________________________ > 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 > > _______________________________________________ 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