1include/master-slave.inc 2[connection master] 3use test; 4create table t1 (a int primary key); 5insert into t1 values (1),(2),(3),(4),(5); 6update t1 set a=a*10; 7connection slave; 8use test; 9select * from t1; 10a 1110 1220 1330 1440 1550 16include/show_binlog_events.inc 17Log_name Pos Event_type Server_id End_log_pos Info 18slave-bin.000001 # Gtid # # GTID #-#-# 19slave-bin.000001 # Query # # use `test`; create table t1 (a int primary key) 20slave-bin.000001 # Gtid # # BEGIN GTID #-#-# 21slave-bin.000001 # Annotate_rows # # insert into t1 values (1),(2),(3),(4),(5) 22slave-bin.000001 # Table_map # # table_id: # (test.t1) 23slave-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F 24slave-bin.000001 # Query # # COMMIT 25slave-bin.000001 # Gtid # # BEGIN GTID #-#-# 26slave-bin.000001 # Annotate_rows # # update t1 set a=a*10 27slave-bin.000001 # Table_map # # table_id: # (test.t1) 28slave-bin.000001 # Update_rows_v1 # # table_id: # flags: STMT_END_F 29slave-bin.000001 # Query # # COMMIT 30connection master; 31drop table t1; 32include/rpl_end.inc 33