[root@slave1 ~]# mysqlbinlog /data/3306/mysql-bin/mysql-bin.000011
/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/;
/*!40019 SET @@session.max_insert_delayed_threads=0*/;
/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
DELIMITER /*!*/;
# at 4
#160314 18:34:51 server id 3 end_log_pos 120 CRC32 0xfd6a32fe Start: binlog v 4, server v 5.6.27-log created 160314 18:34:51 at startup
# Warning: this binlog is either in use or was not closed properly.
ROLLBACK/*!*/;
BINLOG '
y5PmVg8DAAAAdAAAAHgAAAABAAQANS42LjI3LWxvZwAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAADLk+ZWEzgNAAgAEgAEBAQEEgAAXAAEGggAAAAICAgCAAAACgoKGRkAAf4y
av0=
'/*!*/;
# at 120
#160314 21:03:56 server id 3 end_log_pos 208 CRC32 0x12f2847a Query thread_id=4 exec_time=0 error_code=0
SET TIMESTAMP=1457960636/*!*/;
SET @@session.pseudo_thread_id=4/*!*/;
SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1/*!*/;
SET @@session.sql_mode=1075838976/*!*/;
SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
/*!\C utf8 *//*!*/;
SET @@session.character_set_client=33,@@session.collation_connection=33,@@session.collation_server=33/*!*/;
SET @@session.lc_time_names=0/*!*/;
SET @@session.collation_database=DEFAULT/*!*/;
create database t1
/*!*/;
# at 208
#160314 21:08:36 server id 3 end_log_pos 333 CRC32 0x806b0266 Query thread_id=4 exec_time=0 error_code=0
use `t1`/*!*/;
SET TIMESTAMP=1457960916/*!*/;
create table tt1(id int,name varchar(20),birthday date)
/*!*/;
# at 333
#160314 21:10:05 server id 3 end_log_pos 408 CRC32 0xc4950130 Query thread_id=4 exec_time=0 error_code=0
SET TIMESTAMP=1457961005/*!*/;
BEGIN
/*!*/;
# at 408
#160314 21:10:05 server id 3 end_log_pos 543 CRC32 0xab0bc88f Query thread_id=4 exec_time=0 error_code=0
SET TIMESTAMP=1457961005/*!*/;
insert into tt1(id,name,birthday) values('1','demi','1991-10-12')
/*!*/;
# at 543
#160314 21:10:05 server id 3 end_log_pos 574 CRC32 0xacd9a973 Xid = 27
COMMIT/*!*/;
# at 574
#160314 21:10:40 server id 3 end_log_pos 649 CRC32 0xb6e8ef83 Query thread_id=4 exec_time=0 error_code=0
SET TIMESTAMP=1457961040/*!*/;
BEGIN
/*!*/;
# at 649
#160314 21:10:40 server id 3 end_log_pos 784 CRC32 0xef33bae2 Query thread_id=4 exec_time=0 error_code=0
SET TIMESTAMP=1457961040/*!*/;
insert into tt1(id,name,birthday) values('2','hoai','1992-02-20')
/*!*/;
# at 784
#160314 21:10:40 server id 3 end_log_pos 815 CRC32 0xc1ec540f Xid = 29
COMMIT/*!*/;
# at 815
#160314 21:11:00 server id 3 end_log_pos 890 CRC32 0xb4e3c45e Query thread_id=4 exec_time=0 error_code=0
SET TIMESTAMP=1457961060/*!*/;
BEGIN
/*!*/;
# at 890
#160314 21:11:00 server id 3 end_log_pos 1025 CRC32 0xf8584b1d Query thread_id=4 exec_time=0 error_code=0
SET TIMESTAMP=1457961060/*!*/;
insert into tt1(id,name,birthday) values('3','wiss','1991-07-14')
/*!*/;
# at 1025
#160314 21:11:00 server id 3 end_log_pos 1056 CRC32 0xe75877f8 Xid = 30
COMMIT/*!*/;
# at 1056
#160314 21:11:33 server id 3 end_log_pos 1131 CRC32 0x12b7b345 Query thread_id=4 exec_time=0 error_code=0
SET TIMESTAMP=1457961093/*!*/;
BEGIN
/*!*/;
# at 1131
#160314 21:11:33 server id 3 end_log_pos 1266 CRC32 0xab6f89cc Query thread_id=4 exec_time=0 error_code=0
SET TIMESTAMP=1457961093/*!*/;
insert into tt1(id,name,birthday) values('4','kime','1993-06-18')
/*!*/;
# at 1266
#160314 21:11:33 server id 3 end_log_pos 1297 CRC32 0x2e4dbdb4 Xid = 31
COMMIT/*!*/;
# at 1297
#160314 21:14:04 server id 3 end_log_pos 1372 CRC32 0x571a3dda Query thread_id=4 exec_time=0 error_code=0
SET TIMESTAMP=1457961244/*!*/;
BEGIN
/*!*/;
# at 1372
#160314 21:14:04 server id 3 end_log_pos 1489 CRC32 0xaee0efb9 Query thread_id=4 exec_time=0 error_code=0
SET TIMESTAMP=1457961244/*!*/;
update tt1 set birthday='1991-06-28' where id=4
/*!*/;
# at 1489
#160314 21:14:04 server id 3 end_log_pos 1520 CRC32 0xa7faed24 Xid = 33
COMMIT/*!*/;
DELIMITER ;
# End of log file
ROLLBACK /* added by mysqlbinlog */;
/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/;