Debian Codegraph @

mysql-test/suite/rpl/r/rpl_semi_sync_ssl_stop.result

raw
1 # Skip starting the slave because we manually start with SSL later
2 include/master-slave.inc
3 [connection master]
4 #
5 # Setup
6 connection master;
7 CREATE USER replssl@localhost;
8 GRANT REPLICATION SLAVE on *.* to replssl@localhost REQUIRE SSL;
9 set @orig_master_enabled= @@GLOBAL.rpl_semi_sync_master_enabled;
10 SET @@GLOBAL.rpl_semi_sync_master_enabled= 1;
11 connection slave;
12 CHANGE MASTER TO
13 master_user='replssl',
14 master_password='',
15 master_ssl=1,
16 master_ssl_ca='MYSQL_TEST_DIR/std_data/cacert.pem',
17 master_ssl_cert='MYSQL_TEST_DIR/std_data/client-cert.pem',
18 master_ssl_key='MYSQL_TEST_DIR/std_data/client-key.pem';
19 set @orig_slave_enabled= @@GLOBAL.rpl_semi_sync_slave_enabled;
20 SET @@GLOBAL.rpl_semi_sync_slave_enabled= 1;
21 include/start_slave.inc
22 connection master;
23 # Verify Semi-Sync is active
24 SHOW STATUS LIKE 'Rpl_semi_sync_master_clients';
25 Variable_name Value
26 Rpl_semi_sync_master_clients 1
27 # Create some table so slave can be seen as up-to-date and working
28 connection master;
29 CREATE TABLE t1 (a INT);
30 connection slave;
31 # Disconnect the slave and wait until the master's dump thread is gone
32 connection slave;
33 STOP SLAVE;
34 connection master;
35 # MDEV-36663: Verifying dump thread connection is killed..
36 # ..done
37 # Cleanup
38 connection master;
39 SET @@GLOBAL.rpl_semi_sync_master_enabled= @orig_master_enabled;
40 DROP USER replssl@localhost;
41 DROP TABLE t1;
42 connection slave;
43 SET @@GLOBAL.rpl_semi_sync_slave_enabled= @orig_slave_enabled;
44 CHANGE MASTER TO
45 master_user='root',
46 master_ssl=1,
47 master_ssl_ca='',
48 master_ssl_cert='',
49 master_ssl_key='';
50 connection slave;
51 include/start_slave.inc
52 include/rpl_end.inc
53 # End of rpl_semi_sync_ssl_stop.inc