Architecture:
650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M01/4D/E4/wKioL1RcK4CQT_KhAABVrSCFybE955.jpg "title=" Qq20141107101438.jpg "alt=" Wkiol1rck4cqt_khaabvrscfybe955.jpg "/>
Slave
#!/bin/bash#datatime= ' date -d "Yesterday" +%f ' backtime= ' date + "%Y-%m-%d %H:%M:%S" ' Backup_dir= '/data/dbback ' mysql_user= ' root ' mysql_password= ' 123456 ' dbname= ' fa ' ftp_host= ' 192.168.0.20 ' ftp_user= backerftp_userpass=backerftp_port=10011[ ! -d $BACKUP _dir/$DATATIME ] && mkdir $BACKUP _dir/$DATATIMEmysqldump -u $MYSQL _user -p${mysql_password} -- master-data=2 --lock-all-tables --flush-logs --default-character-set=utf8 -r $DBNAME | gzip -9 > $BACKUP _dir/$DATATIME/$DBNAME ${datatime}_full.sql.gz 2> /tmp/ back_error.txtif [ $? -ne 0 ];then echo "$BACKTIME mysql slave ${dbname}_full error!" >> /tmp/back_error.txt mail -s "$ dbname full back error !! " [email protected] < /tmp/back_error.txtelse cd $BACKUP _ dir/$DATATIME/ md5sum $DBNAME ${datatime}_full.sql.gz > $DBNAME ${datatime}_full.md5.txt echo "$BACKTIME back Mysql slave ${DBNAME}_full ok " >/tmp/back_log.txt mail -s "mysql data back ok !!" [email protected] < /tmp/back_log.txtfifind $BACKUP _dir/ -type d - Mtime +32 -exec rm -rf {} \; >/dev/null 2>&1lftp -p $FTP _port $FTP _host -u $FTP _user, $FTP _userpass <<eofmkdir $DATATIMECD $DATATIMEput $BACKUP _dir/$DATATIME/$DBNAME ${datatime}_full.sql.gzput $BACKUP _dir/$DATATIME/$ Dbname${datatime}_full.md5.txtexiteofexIt 0
This article is from the "technical Side dish" blog, please make sure to keep this source http://390892467.blog.51cto.com/2006821/1573919
MySQL Data backup script