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
|
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]
# 1. Bootstrap M1.
[connection server1]
include/start_and_bootstrap_group_replication.inc
# 2. Set parameters for server 2 for start gr.
[connection server2]
RESET SLAVE ALL FOR CHANNEL 'group_replication_recovery';
Warnings:
Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
SET @saved_group_replication_group_seeds = @@GLOBAL.group_replication_group_seeds;
SET @saved_group_replication_local_address = @@GLOBAL.group_replication_local_address;
SET GLOBAL group_replication_group_name= "GROUP_REPLICATION_GROUP_NAME";
SET @debug_save= @@GLOBAL.DEBUG;
# 3. Check parallel UNINSTALL with START GR.
SET @@GLOBAL.DEBUG='+d,group_replication_wait_on_start';
SET @@GLOBAL.DEBUG='+d,group_replication_hold_stop_before_leave_the_group';
START GROUP_REPLICATION USER='root' , PASSWORD='';;
[connection server_2_1]
SET DEBUG_SYNC='now wait_for signal.start_waiting';
UNINSTALL PLUGIN group_replication;;
[connection server_2]
SET DEBUG_SYNC='now signal signal.start_continue';
SET DEBUG_SYNC='now signal signal.resume_stop_before_leave_the_group';
[connection server2]
[connection server_2_1]
Warnings:
Warning 1620 Plugin is busy and will be uninstalled on shutdown
[connection server2]
include/assert.inc [group_replication plugin is uninstalled]
# 4. START GR without credentials it should fail.
# Credentials deleted by UNINSTALL.
SET @@GLOBAL.DEBUG= @debug_save;
SET DEBUG_SYNC = "reset";
SET GLOBAL super_read_only= FALSE;
include/install_group_replication_plugin.inc
SET @saved_group_replication_recovery_reconnect_interval = @@GLOBAL.group_replication_recovery_reconnect_interval;
SET @saved_gr_recovery_retry_count = @@GLOBAL.group_replication_recovery_retry_count;
SET @@GLOBAL.group_replication_group_seeds = @saved_group_replication_group_seeds;
SET @@GLOBAL.group_replication_local_address = @saved_group_replication_local_address;
SET GLOBAL group_replication_recovery_reconnect_interval= 1;
SET GLOBAL group_replication_recovery_retry_count= 2;
SET GLOBAL group_replication_group_name= "GROUP_REPLICATION_GROUP_NAME";
START GROUP_REPLICATION;
include/gr_wait_for_member_state.inc
include/stop_group_replication.inc
SET @@GLOBAL.group_replication_recovery_reconnect_interval = @saved_group_replication_recovery_reconnect_interval;
SET @@GLOBAL.group_replication_recovery_retry_count = @saved_gr_recovery_retry_count;
# 5. Check parallel START GR with UNINSTALL.
SET @@GLOBAL.DEBUG='+d,group_replication_hold_stop_before_leave_the_group';
UNINSTALL PLUGIN group_replication;;
[connection server_2_1]
START GROUP_REPLICATION USER='root' , PASSWORD='';
SET DEBUG_SYNC='now signal signal.resume_stop_before_leave_the_group';
[connection server2]
include/assert.inc [group_replication plugin is uninstalled]
# 6. Cleanup.
SET DEBUG_SYNC = "reset";
SET @@GLOBAL.DEBUG= @debug_save;
SET GLOBAL super_read_only= FALSE;
include/install_group_replication_plugin.inc
SET SESSION sql_log_bin = 0;
call mtr.add_suppression("Group Replication plugin is not installed.");
call mtr.add_suppression("Replica I/O for channel 'group_replication_recovery': Fatal error: Invalid .* username when attempting to connect to the source server.*");
call mtr.add_suppression("There was an error when connecting to the donor server. Please check that group_replication_recovery channel credentials and all MEMBER_HOST column values of performance_schema.replication_group_members table are correct and DNS resolvable.");
call mtr.add_suppression("For details please check performance_schema.replication_connection_status table and error log messages of Replica I/O for channel group_replication_recovery.");
call mtr.add_suppression("There was an error when connecting to the donor server. Please check that group_replication_recovery channel credentials and all MEMBER_HOST column values of performance_schema.replication_group_members table are correct and DNS resolvable.");
call mtr.add_suppression("Maximum number of retries when trying to connect to a donor reached. Aborting group replication incremental recovery.");
call mtr.add_suppression("Fatal error during the incremental recovery process of Group Replication. The server will leave the group.");
call mtr.add_suppression("Error while starting the group replication incremental recovery receiver/applier threads");
call mtr.add_suppression("The server was automatically set into read only mode after an error was detected.");
call mtr.add_suppression("Skipping leave operation: concurrent attempt to leave the group is on-going.");
call mtr.add_suppression("The server was automatically set into read only mode after an error was detected.");
call mtr.add_suppression("Plugin 'group_replication' has ref_count=1 after deinitialization.");
SET SESSION sql_log_bin = 1;
CHANGE REPLICATION SOURCE TO SOURCE_USER='root' FOR CHANNEL 'group_replication_recovery';
Warnings:
Note 1759 Sending passwords in plain text without SSL/TLS is extremely insecure.
Note 1760 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.
include/group_replication_end.inc
|
