Debian Codegraph @

mysql-test/suite/rpl/r/rpl_binlog_compression_require_row_format.result

raw
1 include/master-slave.inc
2 Warnings:
3 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
4 Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
5 [connection master]
6 [connection master]
7 [connection slave]
8 include/stop_slave.inc
9 SET @@global.binlog_transaction_compression=TRUE;
10 CHANGE REPLICATION SOURCE TO REQUIRE_ROW_FORMAT = 1 FOR CHANNEL '';
11 include/start_slave.inc
12 [connection master]
13 include/rpl_reset.inc
14 [connection master]
15 SET @@session.binlog_transaction_compression=TRUE;
16 [connection slave]
17 FLUSH LOGS;
18 [connection master]
19 FLUSH LOGS;
20 CREATE TABLE t1 (c1 INT UNSIGNED PRIMARY KEY, c2 LONGTEXT);
21 BEGIN;
22 INSERT INTO t1 VALUES (10, REPEAT('a', 1000000));
23 INSERT INTO t1 VALUES (9, REPEAT('a', 1000000));
24 INSERT INTO t1 VALUES (8, REPEAT('a', 1000000));
25 INSERT INTO t1 VALUES (7, REPEAT('a', 1000000));
26 INSERT INTO t1 VALUES (6, REPEAT('a', 1000000));
27 INSERT INTO t1 VALUES (5, REPEAT('a', 1000000));
28 INSERT INTO t1 VALUES (4, REPEAT('a', 1000000));
29 INSERT INTO t1 VALUES (3, REPEAT('a', 1000000));
30 INSERT INTO t1 VALUES (2, REPEAT('a', 1000000));
31 INSERT INTO t1 VALUES (1, REPEAT('a', 1000000));
32 COMMIT;
33 BINLOG EVENTS on master []
34 include/show_binlog_events.inc
35 Log_name Pos Event_type Server_id End_log_pos Info
36 master-bin.000002 # Query # # use `test`; CREATE TABLE t1 (c1 INT UNSIGNED PRIMARY KEY, c2 LONGTEXT)
37 master-bin.000002 # Transaction_payload # # compression='ZSTD', decompressed_size=## bytes
38 master-bin.000002 # Query # # BEGIN
39 master-bin.000002 # Table_map # # table_id: # (test.t1)
40 master-bin.000002 # Write_rows # # table_id: # flags: STMT_END_F
41 master-bin.000002 # Table_map # # table_id: # (test.t1)
42 master-bin.000002 # Write_rows # # table_id: # flags: STMT_END_F
43 master-bin.000002 # Table_map # # table_id: # (test.t1)
44 master-bin.000002 # Write_rows # # table_id: # flags: STMT_END_F
45 master-bin.000002 # Table_map # # table_id: # (test.t1)
46 master-bin.000002 # Write_rows # # table_id: # flags: STMT_END_F
47 master-bin.000002 # Table_map # # table_id: # (test.t1)
48 master-bin.000002 # Write_rows # # table_id: # flags: STMT_END_F
49 master-bin.000002 # Table_map # # table_id: # (test.t1)
50 master-bin.000002 # Write_rows # # table_id: # flags: STMT_END_F
51 master-bin.000002 # Table_map # # table_id: # (test.t1)
52 master-bin.000002 # Write_rows # # table_id: # flags: STMT_END_F
53 master-bin.000002 # Table_map # # table_id: # (test.t1)
54 master-bin.000002 # Write_rows # # table_id: # flags: STMT_END_F
55 master-bin.000002 # Table_map # # table_id: # (test.t1)
56 master-bin.000002 # Write_rows # # table_id: # flags: STMT_END_F
57 master-bin.000002 # Table_map # # table_id: # (test.t1)
58 master-bin.000002 # Write_rows # # table_id: # flags: STMT_END_F
59 master-bin.000002 # Xid # # COMMIT /* XID */
60 [connection slave]
61 include/start_slave_io.inc
62 Warnings:
63 Note 3083 Replication thread(s) for channel '' are already runnning.
64 [connection master]
65 include/sync_slave_io_with_master.inc
66 RELAY LOG EVENTS for
67 include/show_relaylog_events.inc
68 Log_name Pos Event_type Server_id End_log_pos Info
69 slave-relay-bin.000006 # Rotate # # master-bin.000002;pos=POS
70 slave-relay-bin.000006 # Format_desc # # SERVER_VERSION, BINLOG_VERSION
71 slave-relay-bin.000006 # Rotate # # master-bin.000002;pos=POS
72 slave-relay-bin.000006 # Query # # use `test`; CREATE TABLE t1 (c1 INT UNSIGNED PRIMARY KEY, c2 LONGTEXT)
73 slave-relay-bin.000006 # Transaction_payload # # compression='ZSTD', decompressed_size=## bytes
74 slave-relay-bin.000006 # Query # # BEGIN
75 slave-relay-bin.000006 # Table_map # # table_id: # (test.t1)
76 slave-relay-bin.000006 # Write_rows # # table_id: # flags: STMT_END_F
77 slave-relay-bin.000006 # Table_map # # table_id: # (test.t1)
78 slave-relay-bin.000006 # Write_rows # # table_id: # flags: STMT_END_F
79 slave-relay-bin.000006 # Table_map # # table_id: # (test.t1)
80 slave-relay-bin.000006 # Write_rows # # table_id: # flags: STMT_END_F
81 slave-relay-bin.000006 # Table_map # # table_id: # (test.t1)
82 slave-relay-bin.000006 # Write_rows # # table_id: # flags: STMT_END_F
83 slave-relay-bin.000006 # Table_map # # table_id: # (test.t1)
84 slave-relay-bin.000006 # Write_rows # # table_id: # flags: STMT_END_F
85 slave-relay-bin.000006 # Table_map # # table_id: # (test.t1)
86 slave-relay-bin.000006 # Write_rows # # table_id: # flags: STMT_END_F
87 slave-relay-bin.000006 # Table_map # # table_id: # (test.t1)
88 slave-relay-bin.000006 # Write_rows # # table_id: # flags: STMT_END_F
89 slave-relay-bin.000006 # Table_map # # table_id: # (test.t1)
90 slave-relay-bin.000006 # Write_rows # # table_id: # flags: STMT_END_F
91 slave-relay-bin.000006 # Table_map # # table_id: # (test.t1)
92 slave-relay-bin.000006 # Write_rows # # table_id: # flags: STMT_END_F
93 slave-relay-bin.000006 # Table_map # # table_id: # (test.t1)
94 slave-relay-bin.000006 # Write_rows # # table_id: # flags: STMT_END_F
95 slave-relay-bin.000006 # Xid # # COMMIT /* XID */
96 include/start_slave_sql.inc
97 Warnings:
98 Note 3083 Replication thread(s) for channel '' are already runnning.
99 [connection master]
100 include/sync_slave_sql_with_master.inc
101 include/assert.inc [Assert that master and slave tables have the same content]
102 BINLOG EVENTS on slave contain compressed events
103 include/show_binlog_events.inc
104 Log_name Pos Event_type Server_id End_log_pos Info
105 slave-bin.000002 # Query # # use `test`; CREATE TABLE t1 (c1 INT UNSIGNED PRIMARY KEY, c2 LONGTEXT)
106 slave-bin.000002 # Transaction_payload # # compression='ZSTD', decompressed_size=## bytes
107 slave-bin.000002 # Query # # BEGIN
108 slave-bin.000002 # Table_map # # table_id: # (test.t1)
109 slave-bin.000002 # Write_rows # # table_id: # flags: STMT_END_F
110 slave-bin.000002 # Table_map # # table_id: # (test.t1)
111 slave-bin.000002 # Write_rows # # table_id: # flags: STMT_END_F
112 slave-bin.000002 # Table_map # # table_id: # (test.t1)
113 slave-bin.000002 # Write_rows # # table_id: # flags: STMT_END_F
114 slave-bin.000002 # Table_map # # table_id: # (test.t1)
115 slave-bin.000002 # Write_rows # # table_id: # flags: STMT_END_F
116 slave-bin.000002 # Table_map # # table_id: # (test.t1)
117 slave-bin.000002 # Write_rows # # table_id: # flags: STMT_END_F
118 slave-bin.000002 # Table_map # # table_id: # (test.t1)
119 slave-bin.000002 # Write_rows # # table_id: # flags: STMT_END_F
120 slave-bin.000002 # Table_map # # table_id: # (test.t1)
121 slave-bin.000002 # Write_rows # # table_id: # flags: STMT_END_F
122 slave-bin.000002 # Table_map # # table_id: # (test.t1)
123 slave-bin.000002 # Write_rows # # table_id: # flags: STMT_END_F
124 slave-bin.000002 # Table_map # # table_id: # (test.t1)
125 slave-bin.000002 # Write_rows # # table_id: # flags: STMT_END_F
126 slave-bin.000002 # Table_map # # table_id: # (test.t1)
127 slave-bin.000002 # Write_rows # # table_id: # flags: STMT_END_F
128 slave-bin.000002 # Xid # # COMMIT /* XID */
129 [connection master]
130 DROP TABLE t1;
131 include/sync_slave_sql_with_master.inc
132 [connection master]
133 SET @@global.binlog_transaction_compression=SAVED;
134 [connection slave]
135 SET @@global.binlog_transaction_compression=SAVED;
136 include/stop_slave.inc
137 CHANGE REPLICATION SOURCE TO REQUIRE_ROW_FORMAT=SAVED;
138 include/start_slave.inc
139 [connection master]
140 include/rpl_reset.inc
141 include/rpl_end.inc