Debian Codegraph @

mysql-test/suite/binlog_encryption/rpl_parallel_mode.result

raw
1 *** MDEV-6676 - test syntax of @@slave_parallel_mode ***
2 include/master-slave.inc
3 [connection master]
4 connection server_2;
5 include/stop_slave.inc
6 SET @old_parallel_threads=@@GLOBAL.slave_parallel_threads;
7 SET @old_parallel_mode=@@GLOBAL.slave_parallel_mode;
8 SET GLOBAL slave_parallel_threads=10;
9 CHANGE MASTER TO master_use_gtid=slave_pos;
10 include/start_slave.inc
11 connection server_1;
12 ALTER TABLE mysql.gtid_slave_pos ENGINE=InnoDB;
13 CREATE TABLE t2 (a int PRIMARY KEY) ENGINE=InnoDB;
14 connection server_2;
15 Parallel_Mode = 'optimistic'
16 include/stop_slave.inc
17 SET GLOBAL slave_parallel_mode='aggressive';
18 Parallel_Mode = 'aggressive'
19 SET GLOBAL slave_parallel_mode='conservative';
20 Parallel_Mode = 'conservative'
21 *** MDEV-6676 - test that empty parallel_mode does not replicate in parallel ***
22 connection server_1;
23 INSERT INTO t2 VALUES (1040);
24 include/save_master_gtid.inc
25 connection server_2;
26 SET GLOBAL slave_parallel_mode='none';
27 SET @old_dbug= @@GLOBAL.debug_dbug;
28 SET GLOBAL debug_dbug="+d,slave_crash_if_parallel_apply";
29 include/start_slave.inc
30 include/sync_with_master_gtid.inc
31 SELECT * FROM t2 WHERE a >= 1040 ORDER BY a;
32 a
33 1040
34 include/stop_slave.inc
35 SET GLOBAL debug_dbug=@old_dbug;
36 *** MDEV-6676 - test disabling domain-based parallel replication ***
37 connection server_1;
38 SET gtid_domain_id = 1;
39 INSERT INTO t2 VALUES (1041);
40 INSERT INTO t2 VALUES (1042);
41 INSERT INTO t2 VALUES (1043);
42 INSERT INTO t2 VALUES (1044);
43 INSERT INTO t2 VALUES (1045);
44 INSERT INTO t2 VALUES (1046);
45 DELETE FROM t2 WHERE a >= 1041;
46 SET gtid_domain_id = 2;
47 INSERT INTO t2 VALUES (1041);
48 INSERT INTO t2 VALUES (1042);
49 INSERT INTO t2 VALUES (1043);
50 INSERT INTO t2 VALUES (1044);
51 INSERT INTO t2 VALUES (1045);
52 INSERT INTO t2 VALUES (1046);
53 SET gtid_domain_id = 0;
54 include/save_master_gtid.inc
55 connection server_2;
56 SET GLOBAL slave_parallel_mode=minimal;
57 include/start_slave.inc
58 include/sync_with_master_gtid.inc
59 SELECT * FROM t2 WHERE a >= 1040 ORDER BY a;
60 a
61 1040
62 1041
63 1042
64 1043
65 1044
66 1045
67 1046
68 include/stop_slave.inc
69 SET GLOBAL debug_dbug=@old_dbug;
70 SET GLOBAL slave_parallel_threads=@old_parallel_threads;
71 SET GLOBAL slave_parallel_mode=@old_parallel_mode;
72 include/start_slave.inc
73 connection server_1;
74 DROP TABLE t2;
75 include/rpl_end.inc