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
|
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]
SET sql_log_bin = 0;
call mtr.add_suppression("Unblocking the group replication thread waiting for applier to start, as the start group replication was killed.");
call mtr.add_suppression("Unable to initialize the Group Replication applier module.");
call mtr.add_suppression("Failed to setup the group replication applier thread.");
call mtr.add_suppression("Error while starting the group replication applier thread");
call mtr.add_suppression("Failed to stop the group replication applier thread.");
call mtr.add_suppression("Info table is not ready to be used.*");
call mtr.add_suppression("Error writing relay log configuration.");
call mtr.add_suppression("Error writing source configuration");
call mtr.add_suppression("Error reading source configuration");
call mtr.add_suppression("The group replication applier thread has received KILL request.");
call mtr.add_suppression("Fatal error during execution on the Applier process of Group Replication. The server will now leave the group.");
call mtr.add_suppression("Unable to confirm whether the server has left the group or not. Check performance_schema.replication_group_members to check group membership information.");
call mtr.add_suppression("The server was automatically set into read only mode after an error was detected.");
SET sql_log_bin = 1;
# 1. START GROUP_REPLICATION on server1.
# Also set group_replication_applier_thread_init_wait
# dbug_sync point to make applier thread wait.
SET @debug_save= @@GLOBAL.DEBUG;
SET @@GLOBAL.DEBUG= '+d,group_replication_applier_thread_init_wait';
SET GLOBAL group_replication_group_name= "GROUP_REPLICATION_GROUP_NAME";
SET GLOBAL group_replication_bootstrap_group=ON;
START GROUP_REPLICATION;
# 2. Wait until applier thread reaches the
# group_replication_applier_thread_init_wait debug sync point.
[connection server_1]
# 3. KILL START GROUP_REPLICATION query and connection,
# to simulate CTRL-C/Z'ED `START GROUP_REPLICATION`.
KILL QUERY CONNECTION_ID;
KILL CONNECTION_ID;
# 4. Reap the killed command and reset debug point.
[connection server1]
ERROR HY000: Lost connection to MySQL server during query
include/rpl_reconnect.inc
# 5. Restart Group Replication on server1
SET DEBUG_SYNC= "now SIGNAL signal.gr_applier_init_signal";
SET @@GLOBAL.DEBUG= @debug_save;
START GROUP_REPLICATION;
include/gr_wait_for_member_state.inc
# 6. Clean Up
include/group_replication_end.inc
|
