#!/bin/bash
DATACFG=/etc/my.cnf
DATADIR=`awk /^datadir/ $DATACFG|awk -F"=" '{print $2}'`
DATAUSER=root
DATAPASS=shiyiwen
BINHOSTNAME=`hostname`
DAY=$1

if [ ! $# == 1 ];then
echo -e "\033[32m USAGE:$0 days\033[0m"
echo -e "\033[32m Please setting days!\033[0m"
sleep 2
exit 1
fi

mysql -u$DATAUSER -p$DATAPASS -e "show master status;" > 1.txt
BINLOGFILE=`awk 'NR==2 { print $1 }' 1.txt`
rm -rf 1.txt
if [ -z $BINLOGFILE ];then
	echo "binlog disable,exiting..."
	sleep 2
	exit 1
fi

if [[ ! "$BINLOGFILE" =~ ^$BINHOSTNAME ]];then
	echo "binlogname error,exiting..."
	sleep 2
	exit 1
fi


###

find $DATADIR -name "$BINHOSTNAME-bin.*" -mtime +$DAY |awk -F"/" ' { print $5 }'>1.txt
#ls -l $DATADIR|awk '{ print $9 }'|awk '/^'$BINHOSTNAME'-bin\./{print $0}'>1.txt
for i in `cat 1.txt`
do
	if [[ "$i" != "$BINHOSTNAME-bin.index" && "$i" != "$BINLOGFILE" ]];then
		echo "rm -rf $DATADIR/$i"
		rm -rf $DATADIR/$i
	fi

done

rm -rf 1.txt