Debian Codegraph @

mysql-test/suite/rpl_gtid/t/rpl_source_terminology.test

raw
1 --let $rpl_skip_start_slave=1
2 --source include/master-slave.inc
3 --source include/have_binlog_format_row.inc
4 --source include/have_slave_repository_type_table.inc
5
6 #
7 # ==== Purpose ====
8 #
9 # The following test cases checks that the new terminology used in the
10 # statements that configure the replica side w.r.t. the source.
11 #
12 # ==== Requirements ====
13 #
14 # CHANGE REPLICATION SOURCE shall execute 100% the same actions that
15 # CHANGE MASTER does.
16 #
17 # CHANGE MASTER and CHANGE REPLICATION SOURCE shall accept aliases
18 # for all their parameters having MASTER in their names. The alias
19 # shall have MASTER replaced by SOURCE.
20 #
21 # ==== Implementation ====
22 #
23 # Issue CHANGE REPLICATION SOURCE TO for all the new statement
24 # aliases and check that the configuration parameter was
25 # effectively changed.
26 #
27 # ==== References ====
28 #
29 # WL#14189: Replace old terms in CHANGE MASTER TO and START SLAVE params
30 #
31
32 --source include/rpl_connection_slave.inc
33
34 --let $get_source_public_key=1
35 --let $auto_position=1
36 --let $bind="eth4n"
37 --let $compression_algorithm="zstd"
38 --let $connect_retry=10000
39 --let $delay=101010
40 --let $heartbeat_period=2
41 --let $host="127.0.0.1"
42 --let $log_file="binlog.000001"
43 --let $log_pos=200
44 --let $password="secret"
45 --let $port=3306
46 --let $public_key_path="/path/to/source/key"
47 --let $retry_count=101
48 --let $server_id = 123
49 --let $ssl=1
50 --let $ssl_ca="ca"
51 --let $ssl_capath="/path/to/ca"
52 --let $ssl_cipher="cipher_foo"
53 --let $ssl_cert="cert"
54 --let $ssl_crl="crl_list"
55 --let $ssl_crlpath="/path/to/crl"
56 --let $ssl_key="key"
57 --let $ssl_verify_server_cert=1
58 --let $tls_ciphersuites="foo"
59 --let $tls_version="TLSv1.2"
60 --let $user="luis"
61 --let $zstd_compression_level=14
62
63 RESET REPLICA ALL;
64
65 --eval CHANGE REPLICATION SOURCE TO SOURCE_HOST=$host
66 --let $read = query_get_value(SHOW REPLICA STATUS, Source_Host, 1)
67 --let $assert_cond= "$read" = $host
68 --let $assert_text="Assert that the host was set correctly"
69 --source include/assert.inc
70
71 --eval CHANGE REPLICATION SOURCE TO SOURCE_AUTO_POSITION=0
72 --let $read = query_get_value(SHOW REPLICA STATUS, Auto_Position, 1)
73 --let $assert_cond= $read = 0
74 --let $assert_text="Assert that auto position set correctly"
75 --source include/assert.inc
76
77 --eval CHANGE REPLICATION SOURCE TO GET_SOURCE_PUBLIC_KEY=$get_source_public_key
78 --let $read = query_get_value(SHOW REPLICA STATUS, Get_Source_public_key, 1)
79 --let $assert_cond= $read = $get_source_public_key
80 --let $assert_text="Assert that the 'get public key' was set correctly"
81 --source include/assert.inc
82
83 --eval CHANGE REPLICATION SOURCE TO SOURCE_BIND=$bind
84 --let $read = query_get_value(SHOW REPLICA STATUS, Source_Bind, 1)
85 --let $assert_cond= "$read" = $bind
86 --let $assert_text="Assert that the bind was set correctly"
87 --source include/assert.inc
88
89 --eval CHANGE REPLICATION SOURCE TO SOURCE_COMPRESSION_ALGORITHMS=$compression_algorithm
90 --let $read = `SELECT Master_compression_algorithm FROM mysql.slave_master_info`
91 --let $assert_cond= "$read" = $compression_algorithm
92 --let $assert_text="Assert that the connect retry was set correctly"
93 --source include/assert.inc
94
95 --eval CHANGE REPLICATION SOURCE TO SOURCE_CONNECT_RETRY=$connect_retry
96 --let $read = query_get_value(SHOW REPLICA STATUS, Connect_Retry, 1)
97 --let $assert_cond= $read = $connect_retry
98 --let $assert_text="Assert that the connect retry was set correctly"
99 --source include/assert.inc
100
101 --eval CHANGE REPLICATION SOURCE TO SOURCE_DELAY=$delay
102 --let $read = query_get_value(SHOW REPLICA STATUS, SQL_Delay, 1)
103 --let $assert_cond= $read = $delay
104 --let $assert_text="Assert that the delay was set correctly"
105 --source include/assert.inc
106
107 --eval CHANGE REPLICATION SOURCE TO SOURCE_HEARTBEAT_PERIOD=$heartbeat_period
108 --let $read = `SELECT Heartbeat FROM mysql.slave_master_info`
109 --let $assert_cond= $read = $heartbeat_period
110 --let $assert_text="Assert that the heartbeat period was set correctly"
111 --source include/assert.inc
112
113 --eval CHANGE REPLICATION SOURCE TO SOURCE_LOG_FILE=$log_file
114 --let $read = query_get_value(SHOW REPLICA STATUS, Source_Log_File, 1)
115 --let $assert_cond= "$read" = $log_file
116 --let $assert_text="Assert that the log file was set correctly"
117 --source include/assert.inc
118
119 --eval CHANGE REPLICATION SOURCE TO SOURCE_LOG_POS=$log_pos
120 --let $read = query_get_value(SHOW REPLICA STATUS, Read_Source_Log_Pos, 1)
121 --let $assert_cond= $read = $log_pos
122 --let $assert_text="Assert that the log position was set correctly"
123 --source include/assert.inc
124
125 --eval CHANGE REPLICATION SOURCE TO SOURCE_PASSWORD=$password
126 --let $read = `SELECT User_Password FROM mysql.slave_master_info`
127 --let $assert_cond= "$read" = $password
128 --let $assert_text="Assert that the password was set correctly"
129 --source include/assert.inc
130
131 --eval CHANGE REPLICATION SOURCE TO SOURCE_PORT=$port
132 --let $read = query_get_value(SHOW REPLICA STATUS, Source_Port, 1)
133 --let $assert_cond=$read = $port
134 --let $assert_text="Assert that the port was set correctly"
135 --source include/assert.inc
136
137 --eval CHANGE REPLICATION SOURCE TO SOURCE_PUBLIC_KEY_PATH=$public_key_path
138 --let $read = query_get_value(SHOW REPLICA STATUS, Source_public_key_path, 1)
139 --let $assert_cond= "$read" = $public_key_path
140 --let $assert_text="Assert that the source public key path was set correctly"
141 --source include/assert.inc
142
143 --eval CHANGE REPLICATION SOURCE TO SOURCE_RETRY_COUNT=$retry_count
144 --let $read = query_get_value(SHOW REPLICA STATUS, Source_Retry_Count, 1)
145 --let $assert_cond= $read = $retry_count
146 --let $assert_text="Assert that the retry count was set correctly"
147 --source include/assert.inc
148
149 --eval CHANGE REPLICATION SOURCE TO SOURCE_SSL=$ssl
150 --let $expected=No
151 if ($ssl == 1) {
152 --let $expected=Yes
153 }
154 --let $read = query_get_value(SHOW REPLICA STATUS, Source_SSL_Allowed, 1)
155 --let $assert_cond= "$read" = "$expected"
156 --let $assert_text="Assert that the SSL was set correctly"
157 --source include/assert.inc
158
159 --eval CHANGE REPLICATION SOURCE TO SOURCE_SSL_CA=$ssl_ca
160 --let $read = query_get_value(SHOW REPLICA STATUS, Source_SSL_CA_File, 1)
161 --let $assert_cond= "$read" = $ssl_ca
162 --let $assert_text="Assert that the SSL CA file was set correctly"
163 --source include/assert.inc
164
165 --eval CHANGE REPLICATION SOURCE TO SOURCE_SSL_CAPATH=$ssl_capath
166 --let $read = query_get_value(SHOW REPLICA STATUS, Source_SSL_CA_Path, 1)
167 --let $assert_cond= "$read" = $ssl_capath
168 --let $assert_text="Assert that the SSL CA path was set correctly"
169 --source include/assert.inc
170
171 --eval CHANGE REPLICATION SOURCE TO SOURCE_SSL_CIPHER=$ssl_cipher
172 --let $read = query_get_value(SHOW REPLICA STATUS, Source_SSL_Cipher, 1)
173 --let $assert_cond= "$read" = $ssl_cipher
174 --let $assert_text="Assert that the SSL cipher was set correctly"
175 --source include/assert.inc
176
177 --eval CHANGE REPLICATION SOURCE TO SOURCE_SSL_CERT=$ssl_cert
178 --let $read = query_get_value(SHOW REPLICA STATUS, Source_SSL_Cert, 1)
179 --let $assert_cond= "$read" = $ssl_cert
180 --let $assert_text="Assert that the SSL cert was set correctly"
181 --source include/assert.inc
182
183 --eval CHANGE REPLICATION SOURCE TO SOURCE_SSL_CRL=$ssl_crl
184 --let $read = query_get_value(SHOW REPLICA STATUS, Source_SSL_Crl, 1)
185 --let $assert_cond= "$read" = $ssl_crl
186 --let $assert_text="Assert that the SSL CRL was set correctly"
187 --source include/assert.inc
188
189 --eval CHANGE REPLICATION SOURCE TO SOURCE_SSL_CRLPATH=$ssl_crlpath
190 --let $read = query_get_value(SHOW REPLICA STATUS, Source_SSL_Crlpath, 1)
191 --let $assert_cond= "$read" = $ssl_crlpath
192 --let $assert_text="Assert that the SSL CRL path was set correctly"
193 --source include/assert.inc
194
195 --eval CHANGE REPLICATION SOURCE TO SOURCE_SSL_KEY=$ssl_key
196 --let $read = query_get_value(SHOW REPLICA STATUS, Source_SSL_Key, 1)
197 --let $assert_cond= "$read" = $ssl_key
198 --let $assert_text="Assert that the SSL key was set correctly"
199 --source include/assert.inc
200
201 --eval CHANGE REPLICATION SOURCE TO SOURCE_SSL_VERIFY_SERVER_CERT=$ssl_verify_server_cert
202 --let $expected=No
203 if ($ssl_verify_server_cert == 1) {
204 --let $expected=Yes
205 }
206 --let $read = query_get_value(SHOW REPLICA STATUS, Source_SSL_Verify_Server_Cert, 1)
207 --let $assert_cond= "$read" = "$expected"
208 --let $assert_text="Assert that the SSL verify server cert was set correctly"
209 --source include/assert.inc
210
211 --eval CHANGE REPLICATION SOURCE TO SOURCE_TLS_CIPHERSUITES=$tls_ciphersuites
212 --let $read = `SELECT tls_ciphersuites FROM mysql.slave_master_info`
213 --let $assert_cond= "$read" = $tls_ciphersuites
214 --let $assert_text="Assert that the TLS Ciphersuites was set correctly"
215 --source include/assert.inc
216
217 --eval CHANGE REPLICATION SOURCE TO SOURCE_TLS_VERSION=$tls_version
218 --let $read = query_get_value(SHOW REPLICA STATUS, Source_TLS_Version, 1)
219 --let $assert_cond= "$read" = $tls_version
220 --let $assert_text="Assert that the TLS version was set correctly"
221 --source include/assert.inc
222
223 --eval CHANGE REPLICATION SOURCE TO SOURCE_USER=$user
224 --let $read = query_get_value(SHOW REPLICA STATUS, Source_User, 1)
225 --let $assert_cond= "$read" = $user
226 --let $assert_text="Assert that the user was set correctly"
227 --source include/assert.inc
228
229 --eval CHANGE REPLICATION SOURCE TO SOURCE_ZSTD_COMPRESSION_LEVEL=$zstd_compression_level
230 --let $read = `SELECT master_zstd_compression_level FROM mysql.slave_master_info`
231 --let $assert_cond= $read = $zstd_compression_level
232 --let $assert_text="Assert that the ZSTD compression level was set correctly"
233 --source include/assert.inc
234
235 --eval CHANGE REPLICATION SOURCE TO SOURCE_AUTO_POSITION=$auto_position
236 --let $read = query_get_value(SHOW REPLICA STATUS, Auto_Position, 1)
237 --let $assert_cond= $read = $auto_position
238 --let $assert_text="Assert that auto position set correctly"
239 --source include/assert.inc
240
241 RESET REPLICA ALL;
242
243 #
244 # Assert that the warnings are emitted as expected
245 #
246
247 # three warnings shall be emitted
248 --eval CHANGE MASTER TO MASTER_HOST=$host, MASTER_USER=$user
249
250 # check that each individual field emits a warning
251 --eval CHANGE REPLICATION SOURCE TO MASTER_HOST=$host
252 --eval CHANGE REPLICATION SOURCE TO MASTER_AUTO_POSITION=0
253 --eval CHANGE REPLICATION SOURCE TO GET_MASTER_PUBLIC_KEY=$get_source_public_key
254 --eval CHANGE REPLICATION SOURCE TO MASTER_BIND=$bind
255 --eval CHANGE REPLICATION SOURCE TO MASTER_COMPRESSION_ALGORITHMS=$compression_algorithm
256 --eval CHANGE REPLICATION SOURCE TO MASTER_CONNECT_RETRY=$connect_retry
257 --eval CHANGE REPLICATION SOURCE TO MASTER_DELAY=$delay
258 --eval CHANGE REPLICATION SOURCE TO MASTER_HEARTBEAT_PERIOD=$heartbeat_period
259 --eval CHANGE REPLICATION SOURCE TO MASTER_LOG_FILE=$log_file
260 --eval CHANGE REPLICATION SOURCE TO MASTER_LOG_POS=$log_pos
261 --eval CHANGE REPLICATION SOURCE TO MASTER_PASSWORD=$password
262 --eval CHANGE REPLICATION SOURCE TO MASTER_PORT=$port
263 --eval CHANGE REPLICATION SOURCE TO MASTER_PUBLIC_KEY_PATH=$public_key_path
264 --eval CHANGE REPLICATION SOURCE TO MASTER_RETRY_COUNT=$retry_count
265 --eval CHANGE REPLICATION SOURCE TO MASTER_SSL=$ssl
266 --eval CHANGE REPLICATION SOURCE TO MASTER_SSL_CA=$ssl_ca
267 --eval CHANGE REPLICATION SOURCE TO MASTER_SSL_CAPATH=$ssl_capath
268 --eval CHANGE REPLICATION SOURCE TO MASTER_SSL_CIPHER=$ssl_cipher
269 --eval CHANGE REPLICATION SOURCE TO MASTER_SSL_CERT=$ssl_cert
270 --eval CHANGE REPLICATION SOURCE TO MASTER_SSL_CRL=$ssl_crl
271 --eval CHANGE REPLICATION SOURCE TO MASTER_SSL_CRLPATH=$ssl_crlpath
272 --eval CHANGE REPLICATION SOURCE TO MASTER_SSL_KEY=$ssl_key
273 --eval CHANGE REPLICATION SOURCE TO MASTER_SSL_VERIFY_SERVER_CERT=$ssl_verify_server_cert
274 --eval CHANGE REPLICATION SOURCE TO MASTER_TLS_CIPHERSUITES=$tls_ciphersuites
275 --eval CHANGE REPLICATION SOURCE TO MASTER_TLS_VERSION=$tls_version
276 --eval CHANGE REPLICATION SOURCE TO MASTER_USER=$user
277 --eval CHANGE REPLICATION SOURCE TO MASTER_ZSTD_COMPRESSION_LEVEL=$zstd_compression_level
278 --eval CHANGE REPLICATION SOURCE TO MASTER_AUTO_POSITION=$auto_position
279
280 RESET REPLICA ALL;
281
282 --replace_result $MASTER_MYPORT SOURCE_PORT
283 --eval CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_PORT=$MASTER_MYPORT,SOURCE_USER='root'
284
285 --source include/start_slave.inc
286 --source include/rpl_connection_master.inc
287
288 #
289 # End of WL#14189 test cases section
290 #
291
292 --source include/rpl_end.inc