150510? 1:42:48 [Note] Slave SQL thread initialized, starting replication in log 'mysql-bin.000005' at position 408, relay log '/var/lib/mysql3308/mysql-relay-bin.000012' position: 553
150510? 1:42:48 [Note] Slave I/O thread: connected to master 'replication@localhost:3307',replication started in log 'mysql-bin.000005' at position 408
150510? 1:43:04 [Note] Slave SQL thread initialized, starting replication in log 'mysql-bin.000006' at position 316, relay log '/var/lib/mysql3309/mysql-relay-bin.000015' position: 461
150510? 1:43:04 [Note] Slave I/O thread: connected to master 'replication@localhost:3307',replication started in log 'mysql-bin.000006' at position 316
--------------------------------------------------------------------------------
? ? 说明：从库从停止的时间点重新补回了停止期间的所有数据。
6.进行异常测试：
? ? ? 停掉从库mysql3308和mysql3309的复制，并对主库进行日志清除操作：
--------------------------------------------------------------------------------
flush logs
delete from sky where id='2000';
purge binary logs to 'mysql-bin.000010';
--------------------------------------------------------------------------------
? ? 然后重新启动从库的复制，日志进行报错，数据丢失，主从失败。
--------------------------------------------------------------------------------
150510? 1:50:53 [ERROR] Slave I/O: Got fatal error 1236 from master when reading data from binary log: 'Could not find first log file name in binary log index file', Error_code: 1236
--------------------------------------------------------------------------------
解决方法：
? ? 只能停止从数据库,然后重新在从数据库中CHANGE MASTER TO 开始,指向正确的二进制文件及偏移量
--------------------------------------------------------------------------------
change master? to? master_log_file='mysql-bin.000001',master_log_pos=106;
--------------------------------------------------------------------------------
? ? 之后的数据会恢复正常主从同步。
--------------------------------------分割线 --------------------------------------
--------------------------------------分割线 --------------------------------------