14
14
CREATE TABLE t1 (a INT, b LONG);
15
15
INSERT INTO t1 VALUES (1,1), (2,2);
16
16
INSERT INTO t1 VALUES (3,UUID()), (4,UUID());
17
show binlog events from <binlog_start>;
18
18
Log_name Pos Event_type Server_id End_log_pos Info
19
master-bin.000001 # Format_desc 1 # Server ver: VERSION, Binlog ver: 4
20
master-bin.000001 # Query 1 # use `test`; CREATE TABLE t1 (a INT, b LONG)
21
master-bin.000001 # Query 1 # use `test`; INSERT INTO t1 VALUES (1,1), (2,2)
22
master-bin.000001 # Query 1 # BEGIN
23
master-bin.000001 # Table_map 1 # table_id: # (test.t1)
24
master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F
25
master-bin.000001 # Query 1 # COMMIT
19
master-bin.000001 # Query # # use `test`; CREATE TABLE t1 (a INT, b LONG)
20
master-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES (1,1), (2,2)
21
master-bin.000001 # Query # # BEGIN
22
master-bin.000001 # Table_map # # table_id: # (test.t1)
23
master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
24
master-bin.000001 # Query # # COMMIT
31
Master_Port MASTER_PORT
33
Master_Log_File master-bin.000001
34
Read_Master_Log_Pos 594
37
Relay_Master_Log_File master-bin.000001
43
Replicate_Ignore_Table
44
Replicate_Wild_Do_Table
45
Replicate_Wild_Ignore_Table
49
Exec_Master_Log_Pos 594
60
Seconds_Behind_Master #
61
Master_SSL_Verify_Server_Cert #
26
show binlog events from <binlog_start>;
67
27
Log_name Pos Event_type Server_id End_log_pos Info
68
slave-bin.000001 # Format_desc 2 # Server ver: VERSION, Binlog ver: 4
69
slave-bin.000001 # Query 1 # use `test`; CREATE TABLE t1 (a INT, b LONG)
70
slave-bin.000001 # Query 1 # use `test`; INSERT INTO t1 VALUES (1,1), (2,2)
71
slave-bin.000001 # Query 1 # BEGIN
72
slave-bin.000001 # Table_map 1 # table_id: # (test.t1)
73
slave-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F
74
slave-bin.000001 # Query 1 # COMMIT
28
slave-bin.000001 # Query # # use `test`; CREATE TABLE t1 (a INT, b LONG)
29
slave-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES (1,1), (2,2)
30
slave-bin.000001 # Query # # BEGIN
31
slave-bin.000001 # Table_map # # table_id: # (test.t1)
32
slave-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
33
slave-bin.000001 # Query # # COMMIT
75
34
DROP TABLE IF EXISTS t1;
76
35
SET @@global.binlog_format= @old_binlog_format;