Debian Codegraph @

mysql-test/suite/rpl/t/rpl_parallel_multi_domain_xa.test

raw
1 # Similar to rpl_parallel_optimistic_xa to verify XA
2 # parallel execution with multiple gtid domain.
3 # References:
4 # MDEV-33668 Adapt parallel slave's round-robin scheduling to XA events
5
6 --source include/have_innodb.inc
7 --source include/have_perfschema.inc
8 --source include/master-slave.inc
9
10 # Tests' global declarations
11 --let $trx = _trx_
12 --let $slave_timeout= -1
13
14 call mtr.add_suppression("Deadlock found when trying to get lock; try restarting transaction");
15 call mtr.add_suppression("WSREP: handlerton rollback failed");
16
17 --connection master
18 ALTER TABLE mysql.gtid_slave_pos ENGINE=InnoDB;
19 --save_master_pos
20
21 # Prepare to restart slave into optimistic parallel mode
22 --connection slave
23 --sync_with_master
24 --source include/stop_slave.inc
25 # This test runs huge number of transactions independently in parallel that
26 # all conflict on a single row. This requires a large number of retries, as a
27 # transaction can repeatedly conflict/deadlock with a large number of other
28 # transactions (in a different domain) one by one.
29 SET @old_transaction_retries = @@GLOBAL.slave_transaction_retries;
30 SET @@global.slave_transaction_retries = 1000;
31 SET @old_parallel_threads = @@GLOBAL.slave_parallel_threads;
32 SET @old_slave_domain_parallel_threads = @@GLOBAL.slave_domain_parallel_threads;
33 SET @@global.slave_parallel_threads = 5;
34 SET @@global.slave_domain_parallel_threads = 3;
35 SET @old_parallel_mode = @@GLOBAL.slave_parallel_mode;
36
37 CHANGE MASTER TO master_use_gtid=slave_pos;
38
39 --connection master
40 CREATE TABLE t1 (a int PRIMARY KEY, b INT) ENGINE=InnoDB;
41 INSERT INTO t1 VALUES (1, 0);
42 --source include/save_master_gtid.inc
43
44 --connection slave
45 --source include/start_slave.inc
46 --source include/sync_with_master_gtid.inc
47 --source include/stop_slave.inc
48
49 --let $mode = 2
50 # mode = 2 is optimistic
51 SET @@global.slave_parallel_mode ='optimistic';
52 while ($mode)
53 {
54 --connection master
55 #
56 # create XA events alternating gtid domains to run them in parallel on slave.
57 #
58 --let $domain_num = 3
59 --let $trx_num = 777
60 --let $i = $trx_num
61 --let $conn = master
62 --disable_query_log
63 while($i > 0)
64 {
65 --let $domain_id = `SELECT $i % $domain_num`
66 --eval set @@gtid_domain_id = $domain_id
67 # 'decision' to commit 0, or rollback 1
68 --let $decision = `SELECT $i % 2`
69 --eval XA START '$conn$trx$i'
70 --eval UPDATE t1 SET b = 1 - 2 * $decision WHERE a = 1
71 --eval XA END '$conn$trx$i'
72 --eval XA PREPARE '$conn$trx$i'
73 --let $term = COMMIT
74 if ($decision)
75 {
76 --let $term = ROLLBACK
77 }
78 --eval XA $term '$conn$trx$i'
79
80 --dec $i
81 }
82 --enable_query_log
83 --source include/save_master_gtid.inc
84
85 --connection slave
86 if (`select $mode = 1`)
87 {
88 SET @@global.slave_parallel_mode ='conservative';
89 }
90 --source include/start_slave.inc
91 --source include/sync_with_master_gtid.inc
92 --source include/stop_slave.inc
93
94 --dec $mode
95 }
96
97
98 # Generations test.
99 # Create few ranges of XAP groups length of greater than
100 # 3 * slave_parallel_threads + 1
101 # terminated upon each range.
102 --let $iter = 3
103 --let $generation_len = @@global.slave_parallel_threads
104 --let $domain_num = 3
105 --disable_query_log
106 --connection master
107 while ($iter)
108 {
109 --let $k = `select 3 * 3 * $generation_len`
110 --let $_k = $k
111 while ($k)
112 {
113 --source include/count_sessions.inc
114 --connect(con$k,localhost,root,,)
115 #
116 # create XA events alternating gtid domains to run them in parallel on slave.
117 #
118 --let $domain_id = `SELECT $k % $domain_num`
119 --eval set @@gtid_domain_id = $domain_id
120 --eval XA START '$trx$k'
121 --eval INSERT INTO t1 VALUES ($k + 1, $iter)
122 --eval XA END '$trx$k'
123 --eval XA PREPARE '$trx$k'
124
125 --disconnect con$k
126 --connection master
127 --source include/wait_until_count_sessions.inc
128
129 --dec $k
130 }
131
132 --connection master
133 --let $k = $_k
134 while ($k)
135 {
136 --let $term = COMMIT
137 --let $decision = `SELECT $k % 2`
138 if ($decision)
139 {
140 --let $term = ROLLBACK
141 }
142 --eval XA $term '$trx$k'
143 }
144 --dec $iter
145 }
146 --enable_query_log
147 --source include/save_master_gtid.inc
148
149 --connection slave
150 SET @@global.slave_parallel_mode = 'optimistic';
151 --source include/start_slave.inc
152 --source include/sync_with_master_gtid.inc
153
154
155 #
156 # Overall consistency check
157 #
158 --let $diff_tables= master:t1, slave:t1
159 --source include/diff_tables.inc
160
161
162 #
163 # Clean up.
164 #
165 --connection slave
166 --source include/stop_slave.inc
167 SET @@global.slave_parallel_mode = @old_parallel_mode;
168 SET @@global.slave_parallel_threads = @old_parallel_threads;
169 SET @@global.slave_domain_parallel_threads = @old_slave_domain_parallel_threads;
170 SET @@global.slave_transaction_retries = @old_transaction_retries;
171 --source include/start_slave.inc
172
173 --connection master
174 DROP TABLE t1;
175 --source include/save_master_gtid.inc
176
177 --connection slave
178 --source include/sync_with_master_gtid.inc
179
180 --connection master
181 --source include/rpl_end.inc