[root@DBASE01 ~]# crontab -l
45 14,21 * * * /root/dbstatus.sh
[root@DBASE01 ~]# cat dbstatus.sh
#!/bin/bash
#/usr/bin/mysql -uroot -p1Lumbini2# -e "show slave status\G;" > /root/status.txt
/usr/bin/mysql -e "show slave status\G;" > /root/status.txt
i=0
if grep "Slave_IO_Running: Yes" /root/status.txt
then
((i=i+1))
fi
if grep "Slave_SQL_Running: Yes" /root/status.txt
then
((i=i+1))
fi
##########
if [ $i -ne 2 ]
then
/bin/cat /root/status.txt | mail -s "Mysqlslave replication status for AusIT" alerts@nepallink.net
else
: ##colons
fi
Note: make sure the file /root/status.txt have write permission
45 14,21 * * * /root/dbstatus.sh
[root@DBASE01 ~]# cat dbstatus.sh
#!/bin/bash
#/usr/bin/mysql -uroot -p1Lumbini2# -e "show slave status\G;" > /root/status.txt
/usr/bin/mysql -e "show slave status\G;" > /root/status.txt
i=0
if grep "Slave_IO_Running: Yes" /root/status.txt
then
((i=i+1))
fi
if grep "Slave_SQL_Running: Yes" /root/status.txt
then
((i=i+1))
fi
##########
if [ $i -ne 2 ]
then
/bin/cat /root/status.txt | mail -s "Mysqlslave replication status for AusIT" alerts@nepallink.net
else
: ##colons
fi
Note: make sure the file /root/status.txt have write permission
No comments:
Post a Comment