mysql read replica process watcher

crontab for mysql read replica process watcher

* * * * * /bin/sh /path/to/script/rreplica-watcher.sh 2>/dev/null >/dev/null
0 2 * * * /bin/sh /path/to/script/rreplica-collate.sh 2>/dev/null >/dev/null

rreplica-collate.sh

MYPATH='/path/to/script/'
TZOFFSET='+8hours'

OUTFILE="$MYPATH"rreplica-collated-$(date +\%Y-%m-%d_%H-%M-%S -d"$TZOFFSET").txt

find "$MYPATH"rreplica-watcher*txt -type f -print -exec cat {} \; \
	> "$OUTFILE"
find "$MYPATH"rreplica-watcher*txt -type f -delete
find "$MYPATH"rreplica-collate*txt -mtime +7 -type f -delete

rreplica-watcher.sh

MYPATH='/path/to/script/'
TZOFFSET='+8hours'
DBHOST='localhost'
DBUSER='mysql_user'
DBPORT='3306'
DBPASS='PASSWORD'

find "$MYPATH"rreplica-watcher*txt -type f -size -1000c -delete
mysql -e'show full processlist' -u${DBUSER} -p${DBPASS} -P${DBPORT} -h${DBHOST} \
	> "$MYPATH"rreplica-watcher-$(date +\%Y-%m-%d_%H-%M-%S -d"$TZOFFSET").txt