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