Debian Codegraph @

mysql-test/suite/multi_source/show_slave_auth_info.test

raw
1 # MDEV-36238: Test `--show-slave-auth-info` (and `--report-user`/`password`)
2 #
3 # `rpl.rpl_show_slave_hosts` and `rpl.rpl_slave_alias_replica`
4 # (and several others) test SHOW SLAVE HOSTS without `--show-slave-auth-info`.
5 # This test supplements them with a comparison between with and without.
6
7 # SHOW SLAVE HOSTS is agnostic of binlog formats
8 --source include/have_binlog_format_mixed.inc
9
10 --echo # Setup
11
12 # This server has `--show-slave-auth-info`.
13 --connect (master1,127.0.0.1,root,,,$SERVER_MYPORT_1)
14 # This `--show-slave-auth-info`-less server asserts that it is per-master.
15 --connect (master2,127.0.0.1,root,,,$SERVER_MYPORT_2)
16 # This is a non-reporting slave.
17 --connect (slave1,127.0.0.1,root,,,$SERVER_MYPORT_3)
18 # This is a self-reporting slave.
19 --connect (slave2,127.0.0.1,root,,,$SERVER_MYPORT_4)
20
21 --let $rpl_server_number= 2
22 while ($rpl_server_number)
23 {
24 --connection slave$rpl_server_number
25
26 --replace_result $SERVER_MYPORT_1 SERVER_MYPORT_1
27 --eval CHANGE MASTER TO master_host='127.0.0.1', master_user='root', master_port=$SERVER_MYPORT_1, master_ssl_verify_server_cert=0
28 --replace_result $SERVER_MYPORT_2 SERVER_MYPORT_2
29 --eval CHANGE MASTER 'control sample' TO master_host='127.0.0.1', master_user='root', master_port=$SERVER_MYPORT_2, master_ssl_verify_server_cert=0
30 --disable_warnings
31 START ALL SLAVES;
32 --enable_warnings
33
34 --dec $rpl_server_number
35 }
36
37 --echo # Test
38
39 --let $rpl_server_number= 2
40 while ($rpl_server_number)
41 {
42 --connection master$rpl_server_number
43
44 # Make sure the master's synced up
45 --let $show_statement= SHOW SLAVE HOSTS
46 --let $field= Server_id
47 --let $condition= =3
48 --source include/wait_show_condition.inc
49 --let $condition= =4
50 --source include/wait_show_condition.inc
51
52 --replace_result $SERVER_MYPORT_3 SERVER_MYPORT_3 $SERVER_MYPORT_4 SERVER_MYPORT_4
53 SHOW SLAVE HOSTS;
54
55 --dec $rpl_server_number
56 }
57
58 # MDEV-20601 Make REPLICA a synonym for SLAVE in SQL statements
59 --replace_result $SERVER_MYPORT_3 SERVER_MYPORT_3 $SERVER_MYPORT_4 SERVER_MYPORT_4
60 SHOW REPLICA HOSTS;
61
62 --echo # Cleanup
63
64 --let $rpl_server_number= 2
65 while ($rpl_server_number)
66 {
67 --connection slave$rpl_server_number
68
69 --disable_warnings
70 STOP ALL SLAVES;
71 --enable_warnings
72 --source include/wait_for_slave_to_stop.inc
73 SET @@SESSION.default_master_connection= 'control sample';
74 --source include/wait_for_slave_to_stop.inc
75 RESET SLAVE ALL;
76
77 --dec $rpl_server_number
78 }
79
80 --disconnect master1
81 --disconnect master2
82 --disconnect slave1
83 --disconnect slave2