richardking · February 19, 2014 22:19
diff --git a/gistfile1.txt b/gistfile1.txt
 #!/bin/bash

 while true
 do
  for i in $(grep prod_br_db_slave ~/.ssh/config | sed 's/Host //') ; do sec=$(ssh $i 'mysql -e "show slave status \G" | grep Sec ' | sed "s/Seconds_Behind_Master://"); echo $i; if test $sec -gt 30 ; then echo 'sent email!'; echo $i "delayed" $sec | mail -s 'delay!' [email protected] ; fi & done
 done
	#!/bin/bash

	while true
	do
	for i in $(grep prod_br_db_slave ~/.ssh/config \| sed 's/Host //') ; do sec=$(ssh $i 'mysql -e "show slave status \G" \| grep Sec ' \| sed "s/Seconds_Behind_Master://"); echo $i; if test $sec -gt 30 ; then echo 'sent email!'; echo $i "delayed" $sec \| mail -s 'delay!' [email protected] ; fi & done
	done
No results found