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
|
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. Force expel of member 2
[connection server2]
SET SESSION sql_log_bin = 0;
CREATE TABLE pid_table(pid_no INT PRIMARY KEY);
LOAD DATA LOCAL INFILE 'pid_file' INTO TABLE pid_table;
DROP TABLE pid_table;
SET SESSION sql_log_bin = 1;
# 2. Confirm member1 sees member2 as unreachable
[connection server1]
include/gr_wait_for_member_state.inc
# 3. A new view with wrong parameters will fail
SET GLOBAL group_replication_force_members= "127.0.0.1:10000";
ERROR HY000: The 'SET GLOBAL group_replication_force_members=127.0.0.1:10000' command encountered a failure. Error setting group_replication_force_members value '127.0.0.1:10000'. Please check error log for additional details.
# 4. Shutdown server to confirm server isn't locked waiting for view
SHUTDOWN;
# 5. Cleanup
include/rpl_reconnect.inc
[connection server2]
[connection server1]
set session sql_log_bin=0;
call mtr.add_suppression("The peer is trying to set up a configuration where there are members that don't belong to the current view.");
call mtr.add_suppression("Error setting group_replication_force_members value '127.0.0.1:10000' on group communication interfaces");
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.");
set session sql_log_bin=1;
[connection server2]
set session sql_log_bin=0;
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.");
set session sql_log_bin=1;
include/group_replication_end.inc
|
