Debian Codegraph @

mysql-test/suite/group_replication/r/gr_persisted_variables_without_plugin.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. Persist configuration on server1. Uninstall plugin.
9 [connection server1]
10 SET PERSIST group_replication_group_name= "GROUP_REPLICATION_GROUP_NAME";
11 SET PERSIST group_replication_group_seeds= @@GLOBAL.group_replication_group_seeds;
12 SET PERSIST group_replication_local_address= @@GLOBAL.group_replication_local_address;
13 SET PERSIST group_replication_start_on_boot= ON;
14 SET PERSIST group_replication_bootstrap_group= ON;
15 include/assert.inc ['Expect 6 persisted variables.']
16 include/uninstall_group_replication_plugin.inc
17
18 ############################################################
19 # 2. Restart server1 without plugin-load, it must NOT
20 # bootstrap the group. Verify warnings are generated.
21 SET SESSION sql_log_bin= 0;
22 call mtr.add_suppression("unknown variable 'loose_group_replication");
23 SET SESSION sql_log_bin= 1;
24 # restart: --plugin-load=
25 include/rpl_reconnect.inc
26
27 include/assert.inc ['There must be NO variable shown as persisted in variables_info table.']
28
29 Occurrences of 'unknown variable 'loose_group_replication_' in the input file: 6
30
31 ############################################################
32 # 3. Install plugin and verify that variable_source is shown
33 # as PERSISTED and group is bootstrapped.
34 include/install_group_replication_plugin.inc
35 include/gr_wait_for_member_state.inc
36 include/assert.inc ['Expect 6 persisted variables shown as PERSISTED in variables_info table.']
37 include/assert.inc ['Expect 6 persisted variables with matching persisted and global values.']
38 include/uninstall_group_replication_plugin.inc
39
40 ############################################################
41 # 4. Restart server again with plugin-load. Verify group is
42 # bootstrapped.
43 # restart
44 include/rpl_reconnect.inc
45 include/gr_wait_for_member_state.inc
46 include/assert.inc ['Expect 6 persisted variables shown as PERSISTED in variables_info table.']
47 include/assert.inc ['Expect 6 persisted variables with matching persisted and global values.']
48
49 ############################################################
50 # 5. Clean up.
51 [connection server1]
52 RESET PERSIST;
53 SET GLOBAL group_replication_start_on_boot= OFF;
54 SET GLOBAL group_replication_bootstrap_group= OFF;
55 include/assert.inc ['There must be 0 persisted variables.']
56 include/group_replication_end.inc
57 Warnings:
58 Warning 3615 Variable group_replication_ip_allowlist does not exist in persisted config file