Debian Codegraph @

mysql-test/suite/group_replication/r/gr_suspect_member_expelled.result

raw
1 include/group_replication.inc [rpl_server_count=3]
2 Warnings:
3 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
4 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.
5 [connection server1]
6 #
7 # Set group_replication_member_expel_timeout to 15 seconds
8 [connection server1]
9 SET GLOBAL group_replication_member_expel_timeout = 15;
10 SELECT @@GLOBAL.group_replication_member_expel_timeout;
11 @@GLOBAL.group_replication_member_expel_timeout
12 15
13 [connection server2]
14 SET GLOBAL group_replication_member_expel_timeout = 15;
15 SELECT @@GLOBAL.group_replication_member_expel_timeout;
16 @@GLOBAL.group_replication_member_expel_timeout
17 15
18 [connection server3]
19 SET GLOBAL group_replication_member_expel_timeout = 15;
20 SELECT @@GLOBAL.group_replication_member_expel_timeout;
21 @@GLOBAL.group_replication_member_expel_timeout
22 15
23 #
24 # Crash server 3
25 # Kill and restart:--group_replication_local_address=GROUP_REPLICATION_LOCAL_ADDRESS --group_replication_group_seeds=GROUP_REPLICATION_GROUP_SEEDS --group_replication_group_name=GROUP_REPLICATION_GROUP_NAME
26 # Restarting server 3
27 include/rpl_reconnect.inc
28 #
29 # Check that all members are still in the group on servers 1 and 2,
30 # which should be ONLINE. Server 3 should still be in the group but
31 # UNREACHABLE
32 [connection server1]
33 [connection server2]
34 #
35 # Check that server 3 has been removed from the group by servers 1 and 2
36 [connection server1]
37 [connection server2]
38 #
39 # Restarting GR on server3
40 [connection server3]
41 include/start_group_replication.inc
42 #
43 # Check that all 3 members are alive and online again in the group
44 [connection server1]
45 [connection server2]
46 [connection server3]
47 include/group_replication_end.inc