1
2--source include/have_group_replication_plugin.inc
3--source include/group_replication.inc
4
5--connection server1
6--echo server1
7
8--echo ################## FR8: GR do not follow SSL changes
9
10--echo # Save the defaults
11SET @orig_ssl_ca= @@global.ssl_ca;
12SET @orig_ssl_cert= @@global.ssl_cert;
13SET @orig_ssl_key= @@global.ssl_key;
14SET @orig_group_replication_recovery_ssl_ca= @@global.group_replication_recovery_ssl_ca;
15SET @orig_group_replication_recovery_ssl_cert= @@global.group_replication_recovery_ssl_cert;
16SET @orig_group_replication_recovery_ssl_key= @@global.group_replication_recovery_ssl_key;
17
18--echo # setting new values for ssl_cert, ssl_key and ssl_ca
19--replace_result "$MYSQL_TEST_DIR" MYSQL_TEST_DIR
20eval SET GLOBAL ssl_cert = "$MYSQL_TEST_DIR/std_data/server-cert-sha512.pem";
21--replace_result "$MYSQL_TEST_DIR" MYSQL_TEST_DIR
22eval SET GLOBAL ssl_key = "$MYSQL_TEST_DIR/std_data/server-key-sha512.pem";
23--replace_result "$MYSQL_TEST_DIR" MYSQL_TEST_DIR
24eval SET GLOBAL ssl_ca = "$MYSQL_TEST_DIR/std_data/ca-sha512.pem";
25ALTER INSTANCE RELOAD TLS;
26
27--echo # Check that GR variables are not altered
28--vertical_results
29SELECT @@global.group_replication_recovery_ssl_ca = @orig_group_replication_recovery_ssl_ca,
30       @@global.group_replication_recovery_ssl_cert = @orig_group_replication_recovery_ssl_cert,
31       @@global.group_replication_recovery_ssl_key = @orig_group_replication_recovery_ssl_key;
32
33--echo # cleanup
34SET GLOBAL ssl_cert = @orig_ssl_cert;
35SET GLOBAL ssl_key = @orig_ssl_key;
36SET GLOBAL ssl_ca = @orig_ssl_ca;
37ALTER INSTANCE RELOAD TLS;
38
39--source include/group_replication_end.inc
40