Debian Codegraph @

mysql-test/suite/group_replication/r/gr_persist_only_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
7 ############################################################
8 # 0. Check that there are no persisted variables.
9 [connection server1]
10 include/assert.inc ['Expect 1 persisted variables.']
11
12 ############################################################
13 # 1. Test SET PERSIST_ONLY. Verify persisted variables.
14 SET GLOBAL group_replication_group_name= "GROUP_REPLICATION_GROUP_NAME";
15 SET GLOBAL group_replication_start_on_boot= ON;
16 SET GLOBAL group_replication_bootstrap_group= ON;
17 CREATE TABLE grvars (id INT PRIMARY KEY AUTO_INCREMENT, varname VARCHAR(64), varvalue VARCHAR(256));
18 INSERT INTO grvars (varname, varvalue)
19 SELECT * FROM performance_schema.global_variables
20 WHERE VARIABLE_NAME LIKE 'group_replication%'
21 AND VARIABLE_NAME NOT LIKE 'group_replication_force_members'
22 ORDER BY VARIABLE_NAME;
23
24 SET PERSIST_ONLY group_replication_advertise_recovery_endpoints = @@GLOBAL.group_replication_advertise_recovery_endpoints;
25 SET PERSIST_ONLY group_replication_allow_local_lower_version_join = @@GLOBAL.group_replication_allow_local_lower_version_join;
26 SET PERSIST_ONLY group_replication_auto_increment_increment = @@GLOBAL.group_replication_auto_increment_increment;
27 SET PERSIST_ONLY group_replication_autorejoin_tries = @@GLOBAL.group_replication_autorejoin_tries;
28 SET PERSIST_ONLY group_replication_bootstrap_group = @@GLOBAL.group_replication_bootstrap_group;
29 SET PERSIST_ONLY group_replication_clone_threshold = @@GLOBAL.group_replication_clone_threshold;
30 SET PERSIST_ONLY group_replication_communication_debug_options = @@GLOBAL.group_replication_communication_debug_options;
31 SET PERSIST_ONLY group_replication_communication_max_message_size = @@GLOBAL.group_replication_communication_max_message_size;
32 SET PERSIST_ONLY group_replication_communication_stack = @@GLOBAL.group_replication_communication_stack;
33 SET PERSIST_ONLY group_replication_components_stop_timeout = @@GLOBAL.group_replication_components_stop_timeout;
34 SET PERSIST_ONLY group_replication_compression_threshold = @@GLOBAL.group_replication_compression_threshold;
35 SET PERSIST_ONLY group_replication_consistency = @@GLOBAL.group_replication_consistency;
36 SET PERSIST_ONLY group_replication_enforce_update_everywhere_checks = @@GLOBAL.group_replication_enforce_update_everywhere_checks;
37 SET PERSIST_ONLY group_replication_exit_state_action = @@GLOBAL.group_replication_exit_state_action;
38 SET PERSIST_ONLY group_replication_flow_control_applier_threshold = @@GLOBAL.group_replication_flow_control_applier_threshold;
39 SET PERSIST_ONLY group_replication_flow_control_certifier_threshold = @@GLOBAL.group_replication_flow_control_certifier_threshold;
40 SET PERSIST_ONLY group_replication_flow_control_hold_percent = @@GLOBAL.group_replication_flow_control_hold_percent;
41 SET PERSIST_ONLY group_replication_flow_control_max_quota = @@GLOBAL.group_replication_flow_control_max_quota;
42 SET PERSIST_ONLY group_replication_flow_control_member_quota_percent = @@GLOBAL.group_replication_flow_control_member_quota_percent;
43 SET PERSIST_ONLY group_replication_flow_control_min_quota = @@GLOBAL.group_replication_flow_control_min_quota;
44 SET PERSIST_ONLY group_replication_flow_control_min_recovery_quota = @@GLOBAL.group_replication_flow_control_min_recovery_quota;
45 SET PERSIST_ONLY group_replication_flow_control_mode = @@GLOBAL.group_replication_flow_control_mode;
46 SET PERSIST_ONLY group_replication_flow_control_period = @@GLOBAL.group_replication_flow_control_period;
47 SET PERSIST_ONLY group_replication_flow_control_release_percent = @@GLOBAL.group_replication_flow_control_release_percent;
48 SET PERSIST_ONLY group_replication_group_name = @@GLOBAL.group_replication_group_name;
49 SET PERSIST_ONLY group_replication_group_seeds = @@GLOBAL.group_replication_group_seeds;
50 SET PERSIST_ONLY group_replication_gtid_assignment_block_size = @@GLOBAL.group_replication_gtid_assignment_block_size;
51 SET PERSIST_ONLY group_replication_ip_allowlist = @@GLOBAL.group_replication_ip_allowlist;
52 SET PERSIST_ONLY group_replication_ip_whitelist = @@GLOBAL.group_replication_ip_whitelist;
53 SET PERSIST_ONLY group_replication_local_address = @@GLOBAL.group_replication_local_address;
54 SET PERSIST_ONLY group_replication_member_expel_timeout = @@GLOBAL.group_replication_member_expel_timeout;
55 SET PERSIST_ONLY group_replication_member_weight = @@GLOBAL.group_replication_member_weight;
56 SET PERSIST_ONLY group_replication_message_cache_size = @@GLOBAL.group_replication_message_cache_size;
57 SET PERSIST_ONLY group_replication_paxos_single_leader = @@GLOBAL.group_replication_paxos_single_leader;
58 SET PERSIST_ONLY group_replication_poll_spin_loops = @@GLOBAL.group_replication_poll_spin_loops;
59 SET PERSIST_ONLY group_replication_recovery_complete_at = @@GLOBAL.group_replication_recovery_complete_at;
60 SET PERSIST_ONLY group_replication_recovery_compression_algorithms = @@GLOBAL.group_replication_recovery_compression_algorithms;
61 SET PERSIST_ONLY group_replication_recovery_get_public_key = @@GLOBAL.group_replication_recovery_get_public_key;
62 SET PERSIST_ONLY group_replication_recovery_public_key_path = @@GLOBAL.group_replication_recovery_public_key_path;
63 SET PERSIST_ONLY group_replication_recovery_reconnect_interval = @@GLOBAL.group_replication_recovery_reconnect_interval;
64 SET PERSIST_ONLY group_replication_recovery_retry_count = @@GLOBAL.group_replication_recovery_retry_count;
65 SET PERSIST_ONLY group_replication_recovery_ssl_ca = @@GLOBAL.group_replication_recovery_ssl_ca;
66 SET PERSIST_ONLY group_replication_recovery_ssl_capath = @@GLOBAL.group_replication_recovery_ssl_capath;
67 SET PERSIST_ONLY group_replication_recovery_ssl_cert = @@GLOBAL.group_replication_recovery_ssl_cert;
68 SET PERSIST_ONLY group_replication_recovery_ssl_cipher = @@GLOBAL.group_replication_recovery_ssl_cipher;
69 SET PERSIST_ONLY group_replication_recovery_ssl_crl = @@GLOBAL.group_replication_recovery_ssl_crl;
70 SET PERSIST_ONLY group_replication_recovery_ssl_crlpath = @@GLOBAL.group_replication_recovery_ssl_crlpath;
71 SET PERSIST_ONLY group_replication_recovery_ssl_key = @@GLOBAL.group_replication_recovery_ssl_key;
72 SET PERSIST_ONLY group_replication_recovery_ssl_verify_server_cert = @@GLOBAL.group_replication_recovery_ssl_verify_server_cert;
73 SET PERSIST_ONLY group_replication_recovery_tls_ciphersuites = @@GLOBAL.group_replication_recovery_tls_ciphersuites;
74 SET PERSIST_ONLY group_replication_recovery_tls_version = @@GLOBAL.group_replication_recovery_tls_version;
75 SET PERSIST_ONLY group_replication_recovery_use_ssl = @@GLOBAL.group_replication_recovery_use_ssl;
76 SET PERSIST_ONLY group_replication_recovery_zstd_compression_level = @@GLOBAL.group_replication_recovery_zstd_compression_level;
77 SET PERSIST_ONLY group_replication_single_primary_mode = @@GLOBAL.group_replication_single_primary_mode;
78 SET PERSIST_ONLY group_replication_ssl_mode = @@GLOBAL.group_replication_ssl_mode;
79 SET PERSIST_ONLY group_replication_start_on_boot = @@GLOBAL.group_replication_start_on_boot;
80 SET PERSIST_ONLY group_replication_tls_source = @@GLOBAL.group_replication_tls_source;
81 SET PERSIST_ONLY group_replication_transaction_size_limit = @@GLOBAL.group_replication_transaction_size_limit;
82 SET PERSIST_ONLY group_replication_unreachable_majority_timeout = @@GLOBAL.group_replication_unreachable_majority_timeout;
83 SET PERSIST_ONLY group_replication_view_change_uuid = @@GLOBAL.group_replication_view_change_uuid;
84
85 include/assert.inc ['Expect 60 persisted variables.']
86
87 ############################################################
88 # 2. Restart server, it must bootstrap the group and preserve
89 # the persisted settings. Verify persisted configuration.
90 # restart
91 include/rpl_reconnect.inc
92 include/gr_wait_for_member_state.inc
93
94 include/assert.inc ['Expect 60 persisted variables in persisted_variables table.']
95 include/assert.inc ['Expect 59 variables which last value was set through SET PERSIST.']
96 include/assert.inc ['Expect 50 persisted variables with matching persisted and global values.']
97
98 ############################################################
99 # 3. Test RESET PERSIST IF EXISTS.
100 # Verify that there are no persisted variables.
101 RESET PERSIST IF EXISTS group_replication_advertise_recovery_endpoints;
102 RESET PERSIST IF EXISTS group_replication_allow_local_lower_version_join;
103 RESET PERSIST IF EXISTS group_replication_auto_increment_increment;
104 RESET PERSIST IF EXISTS group_replication_autorejoin_tries;
105 RESET PERSIST IF EXISTS group_replication_bootstrap_group;
106 RESET PERSIST IF EXISTS group_replication_clone_threshold;
107 RESET PERSIST IF EXISTS group_replication_communication_debug_options;
108 RESET PERSIST IF EXISTS group_replication_communication_max_message_size;
109 RESET PERSIST IF EXISTS group_replication_communication_stack;
110 RESET PERSIST IF EXISTS group_replication_components_stop_timeout;
111 RESET PERSIST IF EXISTS group_replication_compression_threshold;
112 RESET PERSIST IF EXISTS group_replication_consistency;
113 RESET PERSIST IF EXISTS group_replication_enforce_update_everywhere_checks;
114 RESET PERSIST IF EXISTS group_replication_exit_state_action;
115 RESET PERSIST IF EXISTS group_replication_flow_control_applier_threshold;
116 RESET PERSIST IF EXISTS group_replication_flow_control_certifier_threshold;
117 RESET PERSIST IF EXISTS group_replication_flow_control_hold_percent;
118 RESET PERSIST IF EXISTS group_replication_flow_control_max_quota;
119 RESET PERSIST IF EXISTS group_replication_flow_control_member_quota_percent;
120 RESET PERSIST IF EXISTS group_replication_flow_control_min_quota;
121 RESET PERSIST IF EXISTS group_replication_flow_control_min_recovery_quota;
122 RESET PERSIST IF EXISTS group_replication_flow_control_mode;
123 RESET PERSIST IF EXISTS group_replication_flow_control_period;
124 RESET PERSIST IF EXISTS group_replication_flow_control_release_percent;
125 RESET PERSIST IF EXISTS group_replication_group_name;
126 RESET PERSIST IF EXISTS group_replication_group_seeds;
127 RESET PERSIST IF EXISTS group_replication_gtid_assignment_block_size;
128 RESET PERSIST IF EXISTS group_replication_ip_allowlist;
129 RESET PERSIST IF EXISTS group_replication_ip_whitelist;
130 RESET PERSIST IF EXISTS group_replication_local_address;
131 RESET PERSIST IF EXISTS group_replication_member_expel_timeout;
132 RESET PERSIST IF EXISTS group_replication_member_weight;
133 RESET PERSIST IF EXISTS group_replication_message_cache_size;
134 RESET PERSIST IF EXISTS group_replication_paxos_single_leader;
135 RESET PERSIST IF EXISTS group_replication_poll_spin_loops;
136 RESET PERSIST IF EXISTS group_replication_recovery_complete_at;
137 RESET PERSIST IF EXISTS group_replication_recovery_compression_algorithms;
138 RESET PERSIST IF EXISTS group_replication_recovery_get_public_key;
139 RESET PERSIST IF EXISTS group_replication_recovery_public_key_path;
140 RESET PERSIST IF EXISTS group_replication_recovery_reconnect_interval;
141 RESET PERSIST IF EXISTS group_replication_recovery_retry_count;
142 RESET PERSIST IF EXISTS group_replication_recovery_ssl_ca;
143 RESET PERSIST IF EXISTS group_replication_recovery_ssl_capath;
144 RESET PERSIST IF EXISTS group_replication_recovery_ssl_cert;
145 RESET PERSIST IF EXISTS group_replication_recovery_ssl_cipher;
146 RESET PERSIST IF EXISTS group_replication_recovery_ssl_crl;
147 RESET PERSIST IF EXISTS group_replication_recovery_ssl_crlpath;
148 RESET PERSIST IF EXISTS group_replication_recovery_ssl_key;
149 RESET PERSIST IF EXISTS group_replication_recovery_ssl_verify_server_cert;
150 RESET PERSIST IF EXISTS group_replication_recovery_tls_ciphersuites;
151 RESET PERSIST IF EXISTS group_replication_recovery_tls_version;
152 RESET PERSIST IF EXISTS group_replication_recovery_use_ssl;
153 RESET PERSIST IF EXISTS group_replication_recovery_zstd_compression_level;
154 RESET PERSIST IF EXISTS group_replication_single_primary_mode;
155 RESET PERSIST IF EXISTS group_replication_ssl_mode;
156 RESET PERSIST IF EXISTS group_replication_start_on_boot;
157 RESET PERSIST IF EXISTS group_replication_tls_source;
158 RESET PERSIST IF EXISTS group_replication_transaction_size_limit;
159 RESET PERSIST IF EXISTS group_replication_unreachable_majority_timeout;
160 RESET PERSIST IF EXISTS group_replication_view_change_uuid;
161
162 include/assert.inc ['Expect 0 persisted variables.']
163
164 ############################################################
165 # 4. Clean up.
166 SET GLOBAL group_replication_start_on_boot= OFF;
167 SET GLOBAL group_replication_bootstrap_group= OFF;
168 DROP TABLE grvars;
169 include/group_replication_end.inc
170 Warnings:
171 Warning 3615 Variable group_replication_ip_allowlist does not exist in persisted config file