Relay log generated on the slave: [root@ovaistariq-test node1]# mysqlbinlog data/mysql_sandbox23390-relay-bin.000008 /*!40019 SET @@session.max_insert_delayed_threads=0*/; /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/; DELIMITER /*!*/; # at 4 #131115 10:42:18 server id 101 end_log_pos 107 Start: binlog v 4, server v 5.5.34-rel32.0-log created 131115 10:42:18 BINLOG ' euyFUg9lAAAAZwAAAGsAAAAAAAQANS41LjM0LXJlbDMyLjAtbG9nAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAEzgNAAgAEgAEBAQEEgAAVAAEGggAAAAICAgCAA== '/*!*/; # at 107 #700101 1:00:00 server id 1 end_log_pos 0 Rotate to mysql-bin.000004 pos: 4 # at 150 #131115 17:37:14 server id 1 end_log_pos 107 Start: binlog v 4, server v 5.5.34-rel32.0-log created 131115 17:37:14 at startup ROLLBACK/*!*/; BINLOG ' uk2GUg8BAAAAZwAAAGsAAAAAAAQANS41LjM0LXJlbDMyLjAtbG9nAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAC6TYZSEzgNAAgAEgAEBAQEEgAAVAAEGggAAAAICAgCAA== '/*!*/; # at 253 #131115 17:37:40 server id 1 end_log_pos 197 Query thread_id=2 exec_time=0 error_code=0 use test/*!*/; SET TIMESTAMP=1384533460/*!*/; SET @@session.pseudo_thread_id=2/*!*/; SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1/*!*/; SET @@session.sql_mode=0/*!*/; 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=8/*!*/; SET @@session.lc_time_names=0/*!*/; SET @@session.collation_database=DEFAULT/*!*/; truncate table log_messages /*!*/; # at 343 #131115 17:39:29 server id 1 end_log_pos 273 Query thread_id=3 exec_time=0 error_code=0 SET TIMESTAMP=1384533569/*!*/; /*!\C latin1 *//*!*/; SET @@session.character_set_client=8,@@session.collation_connection=8,@@session.collation_server=8/*!*/; SET @@session.time_zone='SYSTEM'/*!*/; BEGIN /*!*/; # at 419 #131115 17:39:29 server id 1 end_log_pos 658 Query thread_id=3 exec_time=0 error_code=0 SET TIMESTAMP=1384533569/*!*/; INSERT INTO test.log_messages (time_stamp, message, url, hash) VALUES(CURRENT_TIMESTAMP, 'test_msg_1', 'test_url_1', '0bee89b07a248e27c83fc3d5951213c1');INSERT DELAYED INTO test.log_messages (time_stamp, message, url, hash) VALUES(CURRENT_TIMESTAMP, 'test_msg_2', 'test_url_2', 'b6273b589df2dfdbd8fe35b1011e3183') /*!*/; # at 804 #131115 17:39:29 server id 1 end_log_pos 735 Query thread_id=3 exec_time=0 error_code=0 SET TIMESTAMP=1384533569/*!*/; COMMIT /*!*/; # at 881 #131115 17:39:29 server id 1 end_log_pos 811 Query thread_id=3 exec_time=0 error_code=0 SET TIMESTAMP=1384533569/*!*/; BEGIN /*!*/; # at 957 #131115 17:39:29 server id 1 end_log_pos 1035 Query thread_id=3 exec_time=0 error_code=0 SET TIMESTAMP=1384533569/*!*/; INSERT INTO test.log_messages (time_stamp, message, url, hash) VALUES(CURRENT_TIMESTAMP, 'test_msg_2', 'test_url_2', 'b6273b589df2dfdbd8fe35b1011e3183') /*!*/; # at 1181 #131115 17:39:29 server id 1 end_log_pos 1112 Query thread_id=3 exec_time=0 error_code=0 SET TIMESTAMP=1384533569/*!*/; COMMIT /*!*/; # at 1258 #131115 17:45:08 server id 101 end_log_pos 1277 Stop DELIMITER ; # End of log file ROLLBACK /* added by mysqlbinlog */; /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;