Debian Codegraph @

mysql-test/suite/group_replication/r/gr_default_table_encryption.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
7 ############################################################
8 # 1. Bootstrap a group on server 1 with
9 # GLOBAL.default_table_encryption = ON
10 [connection server1]
11 SET @table_encryption_default= @@GLOBAL.default_table_encryption;
12 SET @@GLOBAL.default_table_encryption = ON;
13 include/start_and_bootstrap_group_replication.inc
14
15 ############################################################
16 # 2. Try join a member with
17 # GLOBAL.default_table_encryption = OFF
18 # to the group, it shall fail.
19 [connection server2]
20 SET SESSION sql_log_bin = 0;
21 call mtr.add_suppression("The member is configured with a default_table_encryption option value '0' different from the group '1'. The member will now exit the group.");
22 SET SESSION sql_log_bin = 1;
23 SET @table_encryption_default= @@GLOBAL.default_table_encryption;
24 SET @@GLOBAL.default_table_encryption = OFF;
25 START GROUP_REPLICATION;
26 ERROR HY000: The server is not configured properly to be an active member of the group. Please see more details on error log.
27
28 ############################################################
29 # 3. Try join a member with
30 # GLOBAL.default_table_encryption = ON
31 # to the group, it shall succeed.
32 SET @@GLOBAL.default_table_encryption = ON;
33 include/start_group_replication.inc
34
35 ############################################################
36 # 4. Try to change GLOBAL.default_table_encryption while
37 # Group Replication is running, it shall fail.
38 SET @@GLOBAL.default_table_encryption = OFF;
39 ERROR HY000: The default_table_encryption option cannot be changed when Group replication is running.
40
41 ############################################################
42 # 5. Try to change SESSION.default_table_encryption while
43 # Group Replication is running, it shall succeed.
44 SET @@SESSION.default_table_encryption = OFF;
45
46 ############################################################
47 # 6. Try to PERSIST default_table_encryption while
48 # Group Replication is running, it shall fail.
49 SET PERSIST default_table_encryption=ON;
50 ERROR HY000: The default_table_encryption option cannot be changed when Group replication is running.
51
52 ############################################################
53 # 7. Clean up.
54 [connection server1]
55 include/stop_group_replication.inc
56 SET @@GLOBAL.default_table_encryption= @table_encryption_default;
57 [connection server2]
58 include/stop_group_replication.inc
59 SET @@GLOBAL.default_table_encryption= @table_encryption_default;
60 SET @@SESSION.default_table_encryption= @table_encryption_default;
61 include/group_replication_end.inc