mysql==cluster
<?xml version="1.0"?>
<cluster config_version="43" name="web-cluster1">
<clusternodes>
<clusternode name="web01-clu" nodeid="1">
<fence>
<method name="Method">
<device name="web01-fence"/>
</method>
</fence>
</clusternode>
<clusternode name="web02-clu" nodeid="2">
<fence>
<method name="Method">
<device name="web02-fence"/>
</method>
</fence>
</clusternode>
</clusternodes>
<cman expected_votes="1" transport="udpu" two_node="1"/>
<rm>
<failoverdomains>
<failoverdomain name="faildomain1" nofailback="1" ordered="1">
<failoverdomainnode name="web01-clu"/>
<failoverdomainnode name="web02-clu"/>
</failoverdomain>
</failoverdomains>
<resources>
<ip address="172.68.63.23/24" monitor_link="0" sleeptime="10"/>
<ip address="172.68.63.24/24" monitor_link="0" sleeptime="10"/>
<lvm lv_name="LogVol01" name="ha-lvm-mysql" vg_name="vg01"/>
<lvm lv_name="LogVol01" name="ha-lvm-webapps" vg_name="vg02"/>
<ip address="172.68.63.25/24" sleeptime="10"/>
<lvm lv_name="LogVol01" name="ha-lvm-ftp" vg_name="vg03"/>
<fs device="/dev/mapper/vg03-LogVol01" force_unmount="1" fsid="55876" fstype="ext4" mountpoint="/ftp" name="fs-ftp"/>
<fs device="/dev/mapper/vg01-LogVol01" force_unmount="1" fsid="17708" fstype="ext4" mountpoint="/mysql" name="fs-mysql"/>
<fs device="/dev/mapper/vg02-LogVol01" force_unmount="1" fsid="25073" fstype="ext4" mountpoint="/webapps" name="fs-webapps"/>
<script file="/etc/rhcs_mysql.sh" name="mysql_scripts1"/>
</resources>
<service domain="faildomain1" name="sg-webapps" recovery="relocate">
<lvm ref="ha-lvm-webapps">
<fs ref="fs-webapps">
<ip ref="172.68.63.23/24"/>
</fs>
</lvm>
</service>
<service domain="faildomain1" name="sg-ftp" recovery="relocate">
<lvm ref="ha-lvm-ftp">
<fs ref="fs-ftp">
<ip ref="172.68.63.24/24"/>
</fs>
</lvm>
</service>
<service domain="faildomain1" name="sg-mysql" recovery="relocate">
<lvm ref="ha-lvm-mysql">
<fs ref="fs-mysql">
<ip ref="172.68.63.25/24">
<script ref="mysql_scripts1"/>
</ip>
</fs>
</lvm>
</service>
</rm>
<fencedevices>
<fencedevice agent="fence_idrac" ipaddr="172.68.64.195" login="root" name="web01-fence" passwd="calvin"/>
<fencedevice agent="fence_idrac" ipaddr="172.68.64.196" login="root" name="web02-fence" passwd="calvin"/>
</fencedevices>
<fence_daemon post_fail_delay="3"/>
</cluster>
=====
rhcs_mysql.sh
#!/bin/bash
MYSQL_HOME=/mysql/mysql-advanced-5.6.26
function start() {
su - mysql -c "
$MYSQL_HOME/bin/mysqld_safe &
"
}
function stop() {
su - mysql -c "
$MYSQL_HOME/bin/mysqladmin -uroot -p'Mysql_admin_25' shutdown
"
}
function status() {
chk_mysqld=`ps -ef| grep mysqld |grep -v grep | wc -l`
if [ $chk_mysqld -lt 2 ];then
echo "The MySQL database is not runing"
exit 1
else
echo "The MySQL database is runing"
return 0
fi
}
case "$1" in
"start")
echo "Startting MySQL Database ..."
start
;;
"stop")
echo "Stopping MySQL Database ..."
stop
;;
"status")
status
;;
*)
echo "Usage : `basename $0` {start | stop | status}"
exit 0
;;
esac
