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
|
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]
#
# Check the default value
#
server1
include/start_and_bootstrap_group_replication.inc
SET @configured_rec_policy= @@GLOBAL.group_replication_recovery_complete_at;
include/assert.inc [The default of the recovery complete mode should be "transactions_applied"]
#
# Change to a valid value.
#
SET GLOBAL group_replication_recovery_complete_at= "transactions_certified";
Warnings:
Warning 1681 'group_replication_recovery_complete_at' is deprecated and will be removed in a future release.
include/assert.inc [The recovery complete mode should now be "transactions_certified"]
SET GLOBAL group_replication_recovery_complete_at= @configured_rec_policy;
Warnings:
Warning 1681 'group_replication_recovery_complete_at' is deprecated and will be removed in a future release.
#
# Change to a valid alias.
#
SET GLOBAL group_replication_recovery_complete_at= 0;
Warnings:
Warning 1681 'group_replication_recovery_complete_at' is deprecated and will be removed in a future release.
include/assert.inc [The default of the recovery complete mode should be "transactions_certified"]
SET GLOBAL group_replication_recovery_complete_at= 1;
Warnings:
Warning 1681 'group_replication_recovery_complete_at' is deprecated and will be removed in a future release.
include/assert.inc [The recovery complete mode should now be "transactions_applied"]
#
# Test an invalid values.
#
SET GLOBAL group_replication_recovery_complete_at= "invalid_value";
ERROR 42000: Variable 'group_replication_recovery_complete_at' can't be set to the value of 'invalid_value'
SET GLOBAL group_replication_recovery_complete_at= 20;
ERROR 42000: Variable 'group_replication_recovery_complete_at' can't be set to the value of '20'
#
# Clean up
#
SET GLOBAL group_replication_recovery_complete_at= @configured_rec_policy;
Warnings:
Warning 1681 'group_replication_recovery_complete_at' is deprecated and will be removed in a future release.
include/group_replication_end.inc
|
