WWW.DBVERSITY.COM
WWW.DBVERSITY.COM
Menu
  • Home
  • About us
  • Discussions
  • Login / Register
Welcome to the world of Database Technologies
Browse: Home » [MySQL]: Replication monitoring alert script.

[MySQL]: Replication monitoring alert script

August 5, 2015 · by dbversity · in MySQL

[ root @ dbversity : ~ ] cat Slave_status.sh #!/bin/bash LOGFILE=slavestatus.log mkdir -p /binlogs/cronjobs/Error_Log yum -y -q mail ## ======================================================= **********SLAVE STATUS************* ======================================================================= array=(10.x.xx.xx) for i in “${array[@]}” do #mysql -h$i -umonitor -p’password’ -e”show slave status\G” > /binlogs/cronjobs/Error_Log/$i_Slave_Status.txt 2>/binlogs/cronjobs/Error_Log/$i_Slave_Status.txt mysql…

Categories

Categories

Copyright © 2025 WWW.DBVERSITY.COM

Powered by WordPress and Origin