2
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
5
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
7
SET BINLOG_FORMAT=MIXED;
8
SET GLOBAL BINLOG_FORMAT=MIXED;
9
SELECT @@GLOBAL.BINLOG_FORMAT, @@SESSION.BINLOG_FORMAT;
10
@@GLOBAL.BINLOG_FORMAT @@SESSION.BINLOG_FORMAT
13
CREATE TABLE t1 (a INT, b LONG);
14
INSERT INTO t1 VALUES (1,1), (2,2);
15
INSERT INTO t1 VALUES (3,UUID()), (4,UUID());
17
Log_name Pos Event_type Server_id End_log_pos Info
18
master-bin.000001 # Format_desc 1 # Server ver: VERSION, Binlog ver: 4
19
master-bin.000001 # Query 1 # use `test`; CREATE TABLE t1 (a INT, b LONG)
20
master-bin.000001 # Query 1 # use `test`; INSERT INTO t1 VALUES (1,1), (2,2)
21
master-bin.000001 # Query 1 # use `test`; BEGIN
22
master-bin.000001 # Table_map 1 # table_id: # (test.t1)
23
master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F
24
master-bin.000001 # Query 1 # use `test`; COMMIT
30
Master_Port MASTER_PORT
32
Master_Log_File master-bin.000001
33
Read_Master_Log_Pos 595
36
Relay_Master_Log_File master-bin.000001
42
Replicate_Ignore_Table
43
Replicate_Wild_Do_Table
44
Replicate_Wild_Ignore_Table
48
Exec_Master_Log_Pos 595
59
Seconds_Behind_Master #
60
Master_SSL_Verify_Server_Cert #
66
Log_name Pos Event_type Server_id End_log_pos Info
67
slave-bin.000001 # Format_desc 2 # Server ver: VERSION, Binlog ver: 4
68
slave-bin.000001 # Query 2 # use `test`; drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9
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 # use `test`; 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 # use `test`; COMMIT
75
DROP TABLE IF EXISTS t1;