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.
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.
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
