ps -ef|grep mysqld|grep mysql|grep basedir|awk -F mysqld '{print $2}'|awk '{print $1 "=" $7}'|awk -F = '{print $2"/bin/mysql "$4 }' > tmp001 2>&1
while read Line
do
echo "[client]
port=$(echo $Line|awk '{print $2}')
host=`hostname`
user=mysqluser
password=mysqluser " > /tmp/my.password
#echo $(echo "$(echo $Line|awk '{print $1}')" --defaults-extra-file=/tmp/my.password -e \"SHOW SLAVE STATUS \\G\" )
vvv=$(echo "$(echo $Line|awk '{print $1}')" --defaults-extra-file=/tmp/my.password -e \"SHOW SLAVE STATUS \\G\" )
Slave_IO_Running=$(echo $vvv|sh|grep Slave_IO_Running|awk '{print $2}') > /tmp/01 2>&1
echo $(echo $Line|awk '{print $2}') ""`hostname`" " ${Slave_IO_Running:-NO}
done < tmp001
标签：脚本,tmp,echo,awk,监控,mysql,print,Line From： https://www.cnblogs.com/notonlydba/p/18400592