Debian Codegraph @

mysql-test/suite/group_replication/t/gr_full_group_shutdown.test

raw
1 ################################################################################
2 # Multi Master full group shutdown
3 #
4 # This test aims to validate that if all members in the group go down and up
5 # again, Distributed Recovery will work and all member will contain the same
6 # data in the end, regardless of operations that happened in between.
7 #
8 # Test:
9 # 0. The test requires three servers: M1, M2 and M3.
10 # 1. Bootstrap group with M1. Add some data for recovery.
11 # 2. Add two more members M2 and M3.
12 # 3. After recovery all members must see 3 members.
13 # 4. After recovery all members must have the data present in the donor.
14 # 5. Shut down all members until 0. Stop M3.
15 # 6. Add some data in M2. Stop M2.
16 # 7. Add some data to future recoveries in M1. Stop M1.
17 # 8. Bring up the group back to life. At the end, all data must be in all three
18 # members.
19 # 9. Bootstrap group with M1. Start M2. Start M3.
20 # 10. After recovery all members must see 3 members.
21 # 11. After recovery all members must have the data present in the donor.
22 # 12. Clean up.
23 ################################################################################
24
25 --source include/big_test.inc
26 --let $group_replication_group_name= 48530170-7407-11e4-82f8-0800200c9a66
27 --source include/have_group_replication_plugin.inc
28 --let $rpl_skip_group_replication_start= 1
29 --let $rpl_server_count= 3
30 --source include/group_replication.inc
31
32 --echo #
33 --echo # Setup a new group
34 --echo #
35
36 --connection server1
37 --echo server1
38 --source include/start_and_bootstrap_group_replication.inc
39
40 --echo # Add some data for recovery
41
42 CREATE TABLE t1 (c1 INT NOT NULL PRIMARY KEY) ENGINE=InnoDB;
43 BEGIN;
44 INSERT INTO t1 VALUES (1);
45 INSERT INTO t1 VALUES (2);
46 COMMIT;
47 INSERT INTO t1 VALUES (3);
48
49 --echo #
50 --echo # 1) Create a 3 member group and verify that it is functional
51 --echo #
52
53 --echo #Add 2 more members
54 --connection server2
55 --echo server2
56 --source include/start_group_replication.inc
57
58 --connection server3
59 --echo server3
60 --source include/start_group_replication.inc
61
62 --echo #After recovery all members must see 3 other members
63 --let $server_count=3
64 while ($server_count)
65 {
66 --connection server$server_count
67 --let $group_replication_number_of_members= 3
68 --source include/gr_wait_for_number_of_members.inc
69
70 --dec $server_count
71 }
72
73 --echo #After recovery all members must have the data present in the donor.
74 --let $server_count=3
75 while ($server_count)
76 {
77 --connection server$server_count
78 --let $assert_text= On all members, the table should exist and have 3 elements
79 --let $assert_cond= [select count(*) from t1] = 3;
80 --source include/assert.inc
81 --dec $server_count
82 }
83
84 --echo #
85 --echo # 2) Shut down all members until 0. Add some data in the process.
86 --echo #
87
88 --echo #Stop the member 3
89 --connection server3
90 --echo server3
91
92 --source include/stop_group_replication.inc
93
94 --echo #Add some data to future recoveries and ensure that every member has it
95 --connection server2
96 --echo server2
97 INSERT INTO t1 VALUES (4);
98 INSERT INTO t1 VALUES (5);
99
100 --source include/rpl_sync.inc
101
102 --echo #Stop the member 2
103 --source include/stop_group_replication.inc
104
105 --echo #Add some data to future recoveries
106 --connection server1
107 --echo server1
108
109 INSERT INTO t1 VALUES (6);
110 INSERT INTO t1 VALUES (7);
111
112 --echo #Stop the member 1
113 --source include/stop_group_replication.inc
114
115 --echo #
116 --echo # 3) Bring up the group back to life. At the end, all data must be in
117 --echo # all three members.
118 --echo #
119
120 --connection server1
121 --echo server1
122 --source include/start_and_bootstrap_group_replication.inc
123
124 --connection server2
125 --echo server2
126 --source include/start_group_replication.inc
127
128 --connection server3
129 --echo server3
130 --source include/start_group_replication.inc
131
132 --echo #After recovery all members must see 3 other members
133 --let $server_count=3
134 while ($server_count)
135 {
136 --connection server$server_count
137 --let $group_replication_number_of_members= 3
138 --source include/gr_wait_for_number_of_members.inc
139
140 --dec $server_count
141 }
142
143 --echo #After recovery all members must have the data present in the donor.
144 --let $server_count=3
145 while ($server_count)
146 {
147 --connection server$server_count
148 --let $assert_text= On all members, the table should exist and have 7 elements
149 --let $assert_cond= [select count(*) from t1] = 7;
150 --source include/assert.inc
151 --dec $server_count
152 }
153
154 --echo #
155 --echo # Cleaning up
156 --echo #
157
158 DROP TABLE t1;
159
160 --source include/group_replication_end.inc