Debian Codegraph @

mysql-test/suite/rpl/r/rpl_extra_row_data.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 Basic insert, update, delete from Master->Slave
7 DBUG code will set + check transfer of extra
8 row data in RBR
9 **** On Master ****
10 CREATE TABLE t1 (a INT);
11 Ten inserts in one transaction -> 1 epoch transaction
12 BEGIN;
13 INSERT INTO t1 VALUES (1),(2),(3),(4),(5),(6),(7),(8),(9),(10);
14 COMMIT;
15 Wait for Binlog-on-disk
16 flush logs;
17 Check that we have the expected extra row data in the Binlog
18 create table raw_data(txt varchar(1000));
19 select replace(txt, '\r', '') from raw_data where txt like '%### Extra row ndb info: data_format:%' order by txt;
20 replace(txt, '\r', '')
21 ### Extra row ndb info: data_format: 0, len: 0, data: ""
22 ### Extra row ndb info: data_format: 1, len: 1, data: 0x01
23 ### Extra row ndb info: data_format: 2, len: 2, data: 0x0202
24 ### Extra row ndb info: data_format: 3, len: 3, data: 0x030303
25 ### Extra row ndb info: data_format: 4, len: 4, data: 0x04040404
26 ### Extra row ndb info: data_format: 5, len: 5, data: 0x0505050505
27 ### Extra row ndb info: data_format: 6, len: 6, data: 0x060606060606
28 ### Extra row ndb info: data_format: 7, len: 7, data: 0x07070707070707
29 ### Extra row ndb info: data_format: 8, len: 8, data: 0x0808080808080808
30 ### Extra row ndb info: data_format: 9, len: 9, data: 0x090909090909090909
31 drop table raw_data;
32 Generate some more insert, update, delete traffic
33 INSERT INTO t1 SELECT a+10 FROM t1;
34 INSERT INTO t1 SELECT a+20 FROM t1;
35 INSERT INTO t1 SELECT a+40 FROM t1;
36 UPDATE t1 SET a = a+1;
37 UPDATE t1 SET a = a+1;
38 UPDATE t1 SET a = a+1;
39 UPDATE t1 SET a = a+1;
40 UPDATE t1 SET a = a+1;
41 DELETE FROM t1 WHERE a > 390;
42 **** On Slave ****
43 include/sync_slave_sql_with_master.inc
44 Check row count and that slave is running ok
45 SELECT count(*) from t1;
46 count(*)
47 80
48 include/check_slave_is_running.inc
49 DROP TABLE t1;
50 include/sync_slave_sql_with_master.inc
51 include/rpl_end.inc