- 论坛徽章:
- 0
|
本帖最后由 cenalulu 于 2012-12-28 11:37 编辑
如题,mysql主从复制配置好了之后,在其中一台从服务器上用以下脚本做完全备份:
#!/bin/bash
# full backup mysql
backupdir=/var/backups/mysql/full
today=$(date +%Y-%m-%d)
file="$backupdir/${today}.sql.gz"
bakuser=root
bakpasswd=1234
[ -d $backupdir ] || mkdir -p $backupdir
# stop slave
mysqladmin -u${bakuser} -p${bakpasswd} stop-slave
# dump
mysqldump -u${bakuser} -p${bakpasswd} --flush-logs --delete-master-logs --master-data=2 iwebshop|gzip -9 > $file
# start salve
mysqladmin -u${bakuser} -p${bakpasswd} start-slave
脚本执行倒是没什么问题,但查看这台从服务器新产生的binlog,出现以下信息:
/*!40019 SET @@session.max_insert_delayed_threads=0*/;
/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
DELIMITER /*!*/;
# at 4
#121225 17:09:39 server id 3 end_log_pos 106 Start: binlog v 4, server v 5.1.63-0+squeeze1-log created 121225 17:09:39
# Warning: this binlog is either in use or was not closed properly.
BINLOG '
U23ZUA8DAAAAZgAAAGoAAAABAAQANS4xLjYzLTArc3F1ZWV6ZTEtbG9nAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAEzgNAAgAEgAEBAQEEgAAUwAEGggAAAAICAgC
'/*!*/;
DELIMITER ;
# End of log file
ROLLBACK /* added by mysqlbinlog */;
/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
问题是:网站有写数据库的操作,但为什么在这台从库的binlog中却查看不到最新的DML语句呢?
|
|