MySQL 5.5 Slave节点备份脚本（mysqldump）

拼搏现实的明天。 2024-04-17 23:53 69阅读 0赞

\[root@localhost script\]\# vim slave\_full\_backup\_by\_mysqldump.sh  
 \#!/bin/sh  
 show\_slave\_status()\{   
 echo -e "---- master.info: ----" >> $LOG\_FILE  
 cat $\{MAIN\_PATH\}/master.info | sed -n '2,3p' >> $LOG\_FILE  
 echo -e "---- show slave status: ----" >> $LOG\_FILE  
 echo "show slave status\\G" | $MYSQL\_CMD | egrep "Slave\_IO\_Running|Slave\_SQL\_Running|Master\_Log\_File|Read\_Master\_Log\_Pos|Exec\_Master\_Log\_Pos|Relay\_Log\_File|Relay\_Log\_Pos" >> $LOG\_FILE  
 echo -e "" >> $LOG\_FILE  
 \}  
  
 HOST\_PORT=5505  
 MAIN\_PATH=/mysql\_data/5505  
 DATA\_PATH=/backup/  
 DATA\_FILE=$\{DATA\_PATH\}/mysqldump\_dbfullbak\_\`date +%F\`.sql.gz  
 LOG\_FILE=$\{DATA\_PATH\}/mysqldump\_dbfullbak\_\`date +%F\`.log  
 MYSQL\_PATH=/data/bin  
 MYSQL\_USER=system  
 MYSQL\_PASS=Mysql\#2015  
 MYSQL\_CMD="$\{MYSQL\_PATH\}/mysql -u$\{MYSQL\_USER\} -p$\{MYSQL\_PASS\} -S /var/lib/mysql/mysql.sock "  
 MYSQL\_DUMP="$\{MYSQL\_PATH\}/mysqldump -u$\{MYSQL\_USER\} -p$\{MYSQL\_PASS\} -S /var/lib/mysql/mysql.sock -A -R --single-transaction -l --default-character-set=utf8"  
  
 echo > $LOG\_FILE  
 echo -e "==== Jobs started at \`date +%F' '%T' '%w\` ====\\n" >> $\{LOG\_FILE\}  
  
 echo -e "\*\*\*\* started position: ====" >> $LOG\_FILE  
 echo "stop slave SQL\_THREAD;" | $MYSQL\_CMD  
 show\_slave\_status  
  
 echo -e "\*\*\*\* Executed command:$\{MYSQL\_DUMP\} | gzip > $\{DATA\_FILE\}" >> $\{LOG\_FILE\}  
 $\{MYSQL\_DUMP\} | gzip -> $\{DATA\_FILE\}  
 echo -e "\*\*\*\* Executed finished at \`date +%F' '%T' '%w\` ====" >> $\{LOG\_FILE\}  
 echo -e "\*\*\*\* Backup file size: \`du -sh $\{DATA\_PATH\}\` \*\*\*\*\\n" >> $\{LOG\_FILE\}  
  
 echo -e "\*\*\*\* recheck position ====" >> $LOG\_FILE  
 show\_slave\_status  
 echo "start slave SQL\_THREAD;" | $MYSQL\_CMD

echo -e "---- Find expired backup and delete those files ----" >> $\{LOG\_FILE\}  
 for tfile in $(/bin/find $DATA\_PATH/ -mtime +6)  
 do  
 if \[ -d $tfile \] ; then  
 rmdir $tfile  
 elif \[ -f $tfile \] ; then  
 rm -f $tfile  
 fi  
 echo -e "---- Delete file : $tfile ----" >> $\{LOG\_FILE\}  
 done  
  
 echo -e "\\n==== Jobs ended at \`date +%F' '%T' '%w\` ====\\n" >> $\{LOG\_FILE\}

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/26506993/viewspace-2091919/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/26506993/viewspace-2091919/