Debian Codegraph @

mysql-test/suite/multi_source/show_slave_auth_info.result

raw
1 # Setup
2 connect master1,127.0.0.1,root,,,$SERVER_MYPORT_1;
3 connect master2,127.0.0.1,root,,,$SERVER_MYPORT_2;
4 connect slave1,127.0.0.1,root,,,$SERVER_MYPORT_3;
5 connect slave2,127.0.0.1,root,,,$SERVER_MYPORT_4;
6 connection slave2;
7 CHANGE MASTER TO master_host='127.0.0.1', master_user='root', master_port=SERVER_MYPORT_1, master_ssl_verify_server_cert=0;
8 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;
9 START ALL SLAVES;
10 connection slave1;
11 CHANGE MASTER TO master_host='127.0.0.1', master_user='root', master_port=SERVER_MYPORT_1, master_ssl_verify_server_cert=0;
12 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;
13 START ALL SLAVES;
14 # Test
15 connection master2;
16 SHOW SLAVE HOSTS;
17 Server_id Host Port Master_id
18 3 localhost SERVER_MYPORT_3 2
19 4 localhost SERVER_MYPORT_4 2
20 connection master1;
21 SHOW SLAVE HOSTS;
22 Server_id Host User Password Port Master_id
23 3 localhost SERVER_MYPORT_3 1
24 4 localhost my_user my_password SERVER_MYPORT_4 1
25 SHOW REPLICA HOSTS;
26 Server_id Host User Password Port Master_id
27 3 localhost SERVER_MYPORT_3 1
28 4 localhost my_user my_password SERVER_MYPORT_4 1
29 # Cleanup
30 connection slave2;
31 STOP ALL SLAVES;
32 include/wait_for_slave_to_stop.inc
33 SET @@SESSION.default_master_connection= 'control sample';
34 include/wait_for_slave_to_stop.inc
35 RESET SLAVE ALL;
36 connection slave1;
37 STOP ALL SLAVES;
38 include/wait_for_slave_to_stop.inc
39 SET @@SESSION.default_master_connection= 'control sample';
40 include/wait_for_slave_to_stop.inc
41 RESET SLAVE ALL;
42 disconnect master1;
43 disconnect master2;
44 disconnect slave1;
45 disconnect slave2;