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
|
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. Create a table t1 on the group.
[connection server1]
SET sql_log_bin=0;
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("The server was automatically set into read only mode after an error was detected.");
call mtr.add_suppression("Error writing relay log configuration.");
call mtr.add_suppression("Failed to stop the group replication applier thread.");
SET sql_log_bin=1;
CREATE TABLE test.t1 (c1 INT NOT NULL PRIMARY KEY);
include/rpl_sync.inc
############################################################
# 2. Kill the "Group replication applier module" thread on
# server1.
[connection server1]
KILL PROCESSLIST_ID;
############################################################
# 3. Commit a transaction on server2.
# Once the transaction message is delivered to server1,
# the applier module will be awaken and it will detect
# that its thread was killed, which will move the
# member to ERROR state.
[connection server2]
INSERT INTO t1 VALUES (1);
############################################################
# 4. Server1 will move to ERROR state.
[connection server1]
include/gr_wait_for_member_state.inc
include/assert_grep.inc [Assert that the expected entry is in the error log during KILL command]
############################################################
# 5. Server2 is ONLINE and alone on the group.
[connection server2]
############################################################
# 6. Clean up.
[connection server1]
include/stop_group_replication.inc
include/start_group_replication.inc
DROP TABLE t1;
include/group_replication_end.inc
|
