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
|
#
# 1. Create a group with 3 members,
# we want fourth server for async channel.
# Extract each server uuid
# Create a table on it.
#
include/group_replication.inc [rpl_server_count=4]
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]
[connection server1]
[connection server2]
[connection server3]
[connection server4]
include/stop_group_replication.inc
[connection server1]
CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_USER='root', SOURCE_PORT=SERVER_4_PORT for channel 'ch4_1';
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/start_slave.inc [FOR CHANNEL 'ch4_1']
CREATE TABLE t1 (c1 INT NOT NULL PRIMARY KEY) ENGINE=InnoDB;
include/rpl_sync.inc
#
# 2. Check group_replication_unreachable_majority_timeout boundaries
#
[connection server1]
# 2.1. Set group_replication_unreachable_majority_timeout below min value
SET @@GLOBAL.group_replication_unreachable_majority_timeout= -1;
# 2.1. Check min value of group_replication_unreachable_majority_timeout
include/assert.inc [Minimum group_replication_unreachable_majority_timeout is 0]
# 2.2. Set group_replication_unreachable_majority_timeout above max value.
SET @@GLOBAL.group_replication_unreachable_majority_timeout= 31536001;
# 2.2. Check max value of group_replication_unreachable_majority_timeout.
SET @@GLOBAL.group_replication_unreachable_majority_timeout= 11;
#
# 3. Crash server 2 and server 3
# Check they are marked as unreachable
#
[connection server2]
[connection server3]
[connection server1]
include/gr_wait_for_member_state.inc
include/gr_wait_for_member_state.inc
#
# 4. Execute a query that will block
#
INSERT INTO t1 VALUES (2);
#
# 5. After some seconds the member should go into error mode.
# It should enable super read only mode and kill pending transactions.
#
[connection server_1]
include/gr_wait_for_member_state.inc
[connection server1]
ERROR HY000: Error on observer while running replication hook 'before_commit'.
# The server's read_only mode should be enabled
include/assert.inc [The super_read_only mode should be 1.]
# 6. Confirm on server1 Slave IO and SQL threads are not running.
include/check_slave_param.inc [Slave_IO_Running]
include/check_slave_param.inc [Slave_SQL_Running]
#
# 7. Clean up.
#
include/stop_group_replication.inc
[connection server1]
DROP TABLE t1;
set session sql_log_bin=0;
call mtr.add_suppression("The member lost contact with a majority of the members in the group. Until the network is restored.*");
call mtr.add_suppression("'This member could not reach a majority of the members for more than.*");
call mtr.add_suppression("The server was automatically set into read only mode after an error was detected.");
call mtr.add_suppression("Due to a plugin error, some transactions were unable to be certified and will now rollback.");
call mtr.add_suppression("Error while waiting for conflict detection procedure to finish on session.*");
call mtr.add_suppression("Run function 'before_commit' in plugin 'group_replication' failed");
call mtr.add_suppression("Skipping leave operation: concurrent attempt to leave the group is on-going.");
call mtr.add_suppression("Timeout while waiting for the group communication engine to exit!");
call mtr.add_suppression("The member has failed to gracefully leave the group.");
call mtr.add_suppression("read failed");
set session sql_log_bin=1;
[connection server_2]
include/rpl_reconnect.inc
DROP TABLE t1;
[connection server_3]
include/rpl_reconnect.inc
DROP TABLE t1;
include/group_replication_end.inc
|
