Debian Codegraph @

mysql-test/suite/rpl/include/start_alter_concurrent.inc

raw
1 #
2 # ==== Purpose ====
3 #
4 # Run concurrent split alter on given storage engine
5 # With concurrent 10 connections
6 #
7 # ==== Usage ====
8 #
9 # --let $alter_engine= Engine Name (myisam , innodb ...)
10 # --let $alter_algorithm= ...
11 # --let $alter_online = [][ONLINE]
12 # --let $domain_1=
13 # --let $domain_2=
14 # --let $M_port= //Master port
15 # --let $S_port= //Slave port
16 # --let $sync_slave= // 0/1 whether to sync slave with master or not
17 #
18
19
20 --connection master_node
21 set global debug_dbug="+d,start_alter_delay_master";
22
23 --let $i= 1
24 while($i < 11)
25 {
26 if($i == 1 && $domain_1)
27 {
28 --eval set gtid_domain_id= $domain_1;
29 }
30 if($i == 6 && $domain_2)
31 {
32 --eval set gtid_domain_id= $domain_2;
33 }
34 --eval create table t$i( a int primary key, b int) engine=$alter_engine
35 --eval insert into t$i values(1,1),(2,2)
36 --inc $i
37 }
38
39
40 if ($sync_slave)
41 {
42 --echo # Sync slave
43 --source include/save_master_gtid.inc
44 --connection slave_node
45 --source include/sync_with_master_gtid.inc
46 --connection master_node
47 }
48
49 --let $i= 1
50 while($i < 21)
51 {
52 if($i == 1 || $i == 11)
53 {
54 if($domain_1)
55 {
56 --eval set global gtid_domain_id= $domain_1;
57 }
58 }
59 if($i == 6 || $i == 16)
60 {
61 if($domain_2)
62 {
63 --eval set global gtid_domain_id= $domain_2;
64 }
65 }
66 connect(con$i,127.0.0.1,root,,$db_name, $M_port);
67 --inc $i
68 }
69
70 --let $i= 1
71 while($i < 11)
72 {
73 --connection con$i
74 --send_eval alter $alter_online table t$i add column c int, force, algorithm=$alter_algorithm
75 --inc $i
76 }
77
78 --connection master_node
79 set DEBUG_SYNC= "now signal alter_cont";
80
81 --let $i= 1
82 while($i < 11)
83 {
84 --connection con$i
85 --reap
86 --inc $i
87 }
88 --connection master_node
89 set DEBUG_SYNC= 'RESET';
90
91 if ($sync_slave)
92 {
93 --echo # Sync slave
94 --source include/save_master_gtid.inc
95 --connection slave_node
96 --source include/sync_with_master_gtid.inc
97 --connection master_node
98 }
99
100
101 --echo # Concurrent DML
102 --let $i= 1
103 while($i < 11)
104 {
105 --connection con$i
106 --send_eval alter table t$i add column d int, force, algorithm=$alter_algorithm
107 --inc $i
108 }
109
110 if ($alter_algorithm == "inplace")
111 {
112 --sleep 1
113 --let $i= 11
114 --let $j= 1
115 while($i < 21)
116 {
117 --connection con$i
118 --send_eval insert into t$j values(5,5,5);
119 --inc $i
120 --inc $j
121 }
122
123 --let $i= 11
124 while($i < 21)
125 {
126 --connection con$i
127 --reap
128 --inc $i
129 }
130
131 if ($sync_slave)
132 {
133 --echo # Sync slave
134 --source include/save_master_gtid.inc
135 --connection slave_node
136 --source include/sync_with_master_gtid.inc
137 --connection master_node
138 }
139 }
140 --connection master_node
141 set DEBUG_SYNC= "now signal alter_cont";
142 --let $i= 1
143 while($i < 11)
144 {
145 --connection con$i
146 --reap
147 --inc $i
148 }
149 --connection master_node
150 set DEBUG_SYNC= 'RESET';
151
152 if ($sync_slave)
153 {
154 --echo # Sync slave
155 --source include/save_master_gtid.inc
156 --connection slave_node
157 --source include/sync_with_master_gtid.inc
158 --connection master_node
159 }
160
161
162 --echo # Rollback tests
163 --let $i= 1
164 while($i < 11)
165 {
166 --connection con$i
167 --eval insert into t$i values(3,2,1,1)
168 --send_eval alter table t$i change b b int unique, force, algorithm=$alter_algorithm
169 --inc $i
170 }
171 --connection master_node
172 set DEBUG_SYNC= "now signal alter_cont";
173
174
175 --let $i= 1
176 while ($i < 11)
177 {
178 --connection con$i
179 --error ER_DUP_ENTRY
180 --reap
181 --inc $i
182 }
183 --connection master_node
184 set DEBUG_SYNC= 'RESET';
185
186
187 if ($sync_slave)
188 {
189 --echo # Sync slave
190 --source include/save_master_gtid.inc
191 --connection slave_node
192 --source include/sync_with_master_gtid.inc
193 --connection master_node
194 }
195
196 if ($sync_slave)
197 {
198 --enable_query_log
199 --echo # diff_table of master and slave , we will do only in the case when
200 --echo # sync_slave is on
201 --let $i= 1
202 while($i < 11)
203 {
204 --let $diff_tables= master_node:t$i, slave_node:t$i
205 source include/diff_tables.inc;
206 --inc $i
207 }
208 --disable_query_log
209 }
210
211 --connection master_node
212 drop table t1,t2,t3,t4,t5,t6,t7,t8,t9,t10;
213
214 if ($sync_slave)
215 {
216 --echo # Sync slave
217 --source include/save_master_gtid.inc
218 --connection slave_node
219 --source include/sync_with_master_gtid.inc
220 --connection master_node
221 }
222
223 --let $i= 1
224 while ($i < 21)
225 {
226 --disconnect con$i
227 --inc $i
228 }
229 --connection master_node
230 SET GLOBAL debug_dbug= "";