背景:索引导致的slave服务器不正常
1.)show slave status\G; //查看slave的状态。
查看对应的binlog的position的位置,定位故障点。
2. 分析binlog日志(密码隐去)
/usr/local/mysql/bin/mysqlbinlog -uxxxx -p'zzzzz' -S /data/mysqldata/3306/mysql.sock -vv --start-position='234390367' ./mysql-bin.000569 >/root/mysql123.sql
分析binlog出问题的语句:
# Warning: this binlog is either in use or was not closed properly.(可以分析到binlog没有正常的使用,其他的slave都正常使用了,这台没有)
BINLOG '
zoB+UA/q7gQAZwAAAGsAAAABAAQANS41LjIwLWxvZwAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAEzgNAAgAEgAEBAQEEgAAVAAEGggAAAAICAgCAA==
'/*!*/;
# at 234390367
#121019 15:50:30 server id 323306 end_log_pos 234390510 Query thread_id=56829810 exec_time=2 error_code=0
use apps/*!*/;
SET TIMESTAMP=1350633030/*!*/;
SET &