Debian Codegraph @

mysql-test/suite/group_replication/r/gr_suspect_member_resumes.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 ############################################################
8 # 1. Set group_replication_member_expel_timeout to
9 # 300 seconds.
10 [connection server1]
11 SET GLOBAL group_replication_member_expel_timeout = 300;
12 SELECT @@GLOBAL.group_replication_member_expel_timeout;
13 @@GLOBAL.group_replication_member_expel_timeout
14 300
15 [connection server2]
16 SET GLOBAL group_replication_member_expel_timeout = 300;
17 SELECT @@GLOBAL.group_replication_member_expel_timeout;
18 @@GLOBAL.group_replication_member_expel_timeout
19 300
20 [connection server3]
21 SET GLOBAL group_replication_member_expel_timeout = 300;
22 SELECT @@GLOBAL.group_replication_member_expel_timeout;
23 @@GLOBAL.group_replication_member_expel_timeout
24 300
25
26 ############################################################
27 # 2. Create a table and insert some data. Check that
28 # it is replicated to all servers.
29 [connection server1]
30 CREATE TABLE t1 (c1 INT NOT NULL PRIMARY KEY);
31 INSERT INTO t1 VALUES (1);
32 include/rpl_sync.inc
33
34 ############################################################
35 # 3. Suspend server 3 by sending signal SIGSTOP to it.
36 # This will make server 3 not answer to "I am alive"
37 # GCS messages and it will eventually be considered
38 # faulty.
39 [connection server3]
40 # Get server 3 pid.
41 SET SESSION sql_log_bin= 0;
42 CREATE TABLE pid_table(pid_no INT);
43 LOAD DATA LOCAL INFILE 'pid_file' INTO TABLE pid_table;
44 DROP TABLE pid_table;
45 SET SESSION sql_log_bin= 1;
46 # Suspending server 3...
47
48 ############################################################
49 # 4. Check that all members are still in the group on
50 # servers 1 and 2, which should both be ONLINE.
51 # Server 3 should still be in the group but UNREACHABLE.
52 [connection server1]
53 [connection server2]
54
55 ############################################################
56 # 5. Insert data into table t1 on server 2 and check that
57 # it is replicated to server 1.
58 INSERT INTO t1 VALUES (2);
59 [connection server1]
60
61 ############################################################
62 # 6. Resume server 3 by sending a signal SIGCONT to it.
63 # Server should change to ONLINE state.
64 [connection server3]
65 # Send signal SIGCONT to server 3.
66 [connection server1]
67 [connection server2]
68 [connection server3]
69
70 ############################################################
71 # 7. Check that server 3 retrieves the data inserted while
72 # it was suspended. Then, insert new data into table t1
73 # which should be replicated to servers 1 and 2.
74 [connection server3]
75 INSERT INTO t1 VALUES (3);
76 include/rpl_sync.inc
77 include/diff_tables.inc [server1:t1, server2:t1, server3:t1]
78
79 ############################################################
80 # 8. Clean up.
81 DROP TABLE t1;
82 include/group_replication_end.inc