Debian Codegraph @

mysql-test/suite/group_replication/r/gr_recovery_ssl_variables.result

raw
1 include/group_replication.inc
2 Warnings:
3 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
4 Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
5 [connection server1]
6 include/start_and_bootstrap_group_replication.inc
7 [connection server2]
8 #
9 # Make a copy of existing SSL options before modifying them.
10 #
11 set session sql_log_bin=0;
12 call mtr.add_suppression("There was an error when connecting to the donor*");
13 call mtr.add_suppression("For details please check performance_schema.replication_connection_status table and error log messages of Replica I/O for channel group_replication_recovery.");
14 call mtr.add_suppression("Maximum number of retries when*");
15 call mtr.add_suppression("Fatal error during the incremental recovery process of Group Replication. The server will leave the group.");
16 call mtr.add_suppression("Skipping leave operation: concurrent attempt to leave the group is on-going.");
17 call mtr.add_suppression("The server was automatically set into read only mode after an error was detected.");
18 set session sql_log_bin=1;
19 #
20 # Set group_replication_recovery_use_ssl & group_replication_recovery_ssl_verify_server_cert
21 #
22 SET GLOBAL group_replication_recovery_retry_count = 1;
23 SET GLOBAL group_replication_recovery_use_ssl = 1;
24 SET GLOBAL group_replication_recovery_ssl_verify_server_cert = 1;
25 #
26 # Verify that none of the above SSL options are already set
27 # These options are only set when distributed recovery starts
28 #
29 Master_SSL_Allowed = 'No such row'
30 Master_SSL_Verify_Server_Cert = 'No such row'
31 #
32 # See when SSL is required that Recovery cannot advance when not properly configured
33 #
34 include/start_group_replication.inc
35 #
36 # Verify that SSL options are shown in SHOW SLAVE STATUS output
37 #
38 Master_SSL_Allowed = 'Yes'
39 Master_SSL_Verify_Server_Cert = 'Yes'
40 include/stop_group_replication.inc
41 #
42 # Reset SSL variables for recovery channel
43 #
44 SET GLOBAL group_replication_recovery_use_ssl = default;
45 SET GLOBAL group_replication_recovery_ssl_verify_server_cert = default;
46 #
47 # Verify that group replication member state is online.
48 #
49 include/start_group_replication.inc
50 #
51 # Verify that Master_SSL_Allowed and Master_SSL_Verify_Server_Cert are set to default.
52 #
53 Master_SSL_Allowed = 'No'
54 Master_SSL_Verify_Server_Cert = 'No'
55 #
56 # Clean up
57 #
58 SET @@GLOBAL.group_replication_recovery_use_ssl= 0;
59 SET @@GLOBAL.group_replication_recovery_ssl_verify_server_cert= 0;
60 SET @@GLOBAL.group_replication_recovery_retry_count= 10;
61 include/group_replication_end.inc