Debian Codegraph @

mysql-test/suite/group_replication/r/gr_last_conflict_free_empty_after_joining.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) Configure a replication group with 2 members
9 #########################################################################
10
11 [connection server1]
12 include/start_and_bootstrap_group_replication.inc
13 [connection server2]
14 include/start_group_replication.inc
15
16 #########################################################################
17 # 2) Execute a transaction on the first member
18 #########################################################################
19
20 [connection server1]
21 CREATE TABLE t1 (a INT PRIMARY KEY);
22 include/rpl_sync.inc
23
24 #########################################################################
25 # 3) Verify that the LAST_CONFLICT_FREE_TRANSACTION field of the
26 # performance_schema.replication_group_members table has the same value
27 # between members
28 #########################################################################
29
30 [connection server2]
31 [connection server1]
32 SELECT gm.MEMBER_PORT, gms.LAST_CONFLICT_FREE_TRANSACTION
33 FROM performance_schema.replication_group_member_stats gms
34 JOIN performance_schema.replication_group_members gm
35 ON gms.MEMBER_ID=gm.MEMBER_ID
36 ORDER BY gm.MEMBER_PORT ASC;
37 MEMBER_PORT LAST_CONFLICT_FREE_TRANSACTION
38 SERVER1 c9f7fc80-034a-45c9-be2b-d738604be275:3
39 SERVER2 c9f7fc80-034a-45c9-be2b-d738604be275:3
40 [connection server2]
41 SELECT gm.MEMBER_PORT, gms.LAST_CONFLICT_FREE_TRANSACTION
42 FROM performance_schema.replication_group_member_stats gms
43 JOIN performance_schema.replication_group_members gm
44 ON gms.MEMBER_ID=gm.MEMBER_ID
45 ORDER BY gm.MEMBER_PORT ASC;
46 MEMBER_PORT LAST_CONFLICT_FREE_TRANSACTION
47 SERVER1 c9f7fc80-034a-45c9-be2b-d738604be275:3
48 SERVER2 c9f7fc80-034a-45c9-be2b-d738604be275:3
49
50 #########################################################################
51 # 4) Restart group replication on member 2
52 #########################################################################
53
54 include/stop_group_replication.inc
55 include/start_group_replication.inc
56
57 #########################################################################
58 # 5) Verify that the LAST_CONFLICT_FREE_TRANSACTION field of the second
59 # member is empty (due to restart of the plugin) on both members
60 #########################################################################
61
62 [connection server1]
63 [connection server2]
64 [connection server1]
65 SELECT gm.MEMBER_PORT, gms.LAST_CONFLICT_FREE_TRANSACTION
66 FROM performance_schema.replication_group_member_stats gms
67 JOIN performance_schema.replication_group_members gm
68 ON gms.MEMBER_ID=gm.MEMBER_ID
69 ORDER BY gm.MEMBER_PORT ASC;
70 MEMBER_PORT LAST_CONFLICT_FREE_TRANSACTION
71 SERVER1 c9f7fc80-034a-45c9-be2b-d738604be275:3
72 SERVER2
73 [connection server2]
74 SELECT gm.MEMBER_PORT, gms.LAST_CONFLICT_FREE_TRANSACTION
75 FROM performance_schema.replication_group_member_stats gms
76 JOIN performance_schema.replication_group_members gm
77 ON gms.MEMBER_ID=gm.MEMBER_ID
78 ORDER BY gm.MEMBER_PORT ASC;
79 MEMBER_PORT LAST_CONFLICT_FREE_TRANSACTION
80 SERVER1 c9f7fc80-034a-45c9-be2b-d738604be275:3
81 SERVER2
82
83 #########################################################################
84 # 6) Add a new member
85 #########################################################################
86
87 [connection server3]
88 include/start_group_replication.inc
89
90 #########################################################################
91 # 7) Verify that this new member has an empty
92 # LAST_CONFLICT_FREE_TRANSACTION on himself and in the rest of the
93 # group
94 #########################################################################
95
96 [connection server1]
97 SELECT gm.MEMBER_PORT, gms.LAST_CONFLICT_FREE_TRANSACTION
98 FROM performance_schema.replication_group_member_stats gms
99 JOIN performance_schema.replication_group_members gm
100 ON gms.MEMBER_ID=gm.MEMBER_ID
101 ORDER BY gm.MEMBER_PORT ASC;
102 MEMBER_PORT LAST_CONFLICT_FREE_TRANSACTION
103 SERVER1 c9f7fc80-034a-45c9-be2b-d738604be275:3
104 SERVER2
105 SERVER3
106 [connection server2]
107 SELECT gm.MEMBER_PORT, gms.LAST_CONFLICT_FREE_TRANSACTION
108 FROM performance_schema.replication_group_member_stats gms
109 JOIN performance_schema.replication_group_members gm
110 ON gms.MEMBER_ID=gm.MEMBER_ID
111 ORDER BY gm.MEMBER_PORT ASC;
112 MEMBER_PORT LAST_CONFLICT_FREE_TRANSACTION
113 SERVER1 c9f7fc80-034a-45c9-be2b-d738604be275:3
114 SERVER2
115 SERVER3
116 [connection server3]
117 SELECT gm.MEMBER_PORT, gms.LAST_CONFLICT_FREE_TRANSACTION
118 FROM performance_schema.replication_group_member_stats gms
119 JOIN performance_schema.replication_group_members gm
120 ON gms.MEMBER_ID=gm.MEMBER_ID
121 ORDER BY gm.MEMBER_PORT ASC;
122 MEMBER_PORT LAST_CONFLICT_FREE_TRANSACTION
123 SERVER1 c9f7fc80-034a-45c9-be2b-d738604be275:3
124 SERVER2
125 SERVER3
126
127 #########################################################################
128 # 8) Execute a new transaction
129 #########################################################################
130
131 [connection server1]
132 INSERT INTO t1 VALUES (1);
133 include/rpl_sync.inc
134
135 #########################################################################
136 # 9) Verify that everyone has a conflict free transaction executed
137 #########################################################################
138
139 [connection server1]
140 [connection server2]
141 [connection server3]
142 [connection server1]
143 SELECT gm.MEMBER_PORT, gms.LAST_CONFLICT_FREE_TRANSACTION
144 FROM performance_schema.replication_group_member_stats gms
145 JOIN performance_schema.replication_group_members gm
146 ON gms.MEMBER_ID=gm.MEMBER_ID
147 ORDER BY gm.MEMBER_PORT ASC;
148 MEMBER_PORT LAST_CONFLICT_FREE_TRANSACTION
149 SERVER1 c9f7fc80-034a-45c9-be2b-d738604be275:6
150 SERVER2 c9f7fc80-034a-45c9-be2b-d738604be275:6
151 SERVER3 c9f7fc80-034a-45c9-be2b-d738604be275:6
152 [connection server2]
153 SELECT gm.MEMBER_PORT, gms.LAST_CONFLICT_FREE_TRANSACTION
154 FROM performance_schema.replication_group_member_stats gms
155 JOIN performance_schema.replication_group_members gm
156 ON gms.MEMBER_ID=gm.MEMBER_ID
157 ORDER BY gm.MEMBER_PORT ASC;
158 MEMBER_PORT LAST_CONFLICT_FREE_TRANSACTION
159 SERVER1 c9f7fc80-034a-45c9-be2b-d738604be275:6
160 SERVER2 c9f7fc80-034a-45c9-be2b-d738604be275:6
161 SERVER3 c9f7fc80-034a-45c9-be2b-d738604be275:6
162 [connection server3]
163 SELECT gm.MEMBER_PORT, gms.LAST_CONFLICT_FREE_TRANSACTION
164 FROM performance_schema.replication_group_member_stats gms
165 JOIN performance_schema.replication_group_members gm
166 ON gms.MEMBER_ID=gm.MEMBER_ID
167 ORDER BY gm.MEMBER_PORT ASC;
168 MEMBER_PORT LAST_CONFLICT_FREE_TRANSACTION
169 SERVER1 c9f7fc80-034a-45c9-be2b-d738604be275:6
170 SERVER2 c9f7fc80-034a-45c9-be2b-d738604be275:6
171 SERVER3 c9f7fc80-034a-45c9-be2b-d738604be275:6
172
173 #########################################################################
174 # 10) Restart group replication on member 1
175 #########################################################################
176
177 [connection server1]
178 include/stop_group_replication.inc
179 include/start_group_replication.inc
180
181 #########################################################################
182 # 11) Verify that member 1 has no conflict free transaction on the group
183 #########################################################################
184
185 [connection server1]
186 [connection server2]
187 [connection server3]
188 [connection server1]
189 SELECT gm.MEMBER_PORT, gms.LAST_CONFLICT_FREE_TRANSACTION
190 FROM performance_schema.replication_group_member_stats gms
191 JOIN performance_schema.replication_group_members gm
192 ON gms.MEMBER_ID=gm.MEMBER_ID
193 ORDER BY gm.MEMBER_PORT ASC;
194 MEMBER_PORT LAST_CONFLICT_FREE_TRANSACTION
195 SERVER1
196 SERVER2 c9f7fc80-034a-45c9-be2b-d738604be275:6
197 SERVER3 c9f7fc80-034a-45c9-be2b-d738604be275:6
198 [connection server2]
199 SELECT gm.MEMBER_PORT, gms.LAST_CONFLICT_FREE_TRANSACTION
200 FROM performance_schema.replication_group_member_stats gms
201 JOIN performance_schema.replication_group_members gm
202 ON gms.MEMBER_ID=gm.MEMBER_ID
203 ORDER BY gm.MEMBER_PORT ASC;
204 MEMBER_PORT LAST_CONFLICT_FREE_TRANSACTION
205 SERVER1
206 SERVER2 c9f7fc80-034a-45c9-be2b-d738604be275:6
207 SERVER3 c9f7fc80-034a-45c9-be2b-d738604be275:6
208 [connection server3]
209 SELECT gm.MEMBER_PORT, gms.LAST_CONFLICT_FREE_TRANSACTION
210 FROM performance_schema.replication_group_member_stats gms
211 JOIN performance_schema.replication_group_members gm
212 ON gms.MEMBER_ID=gm.MEMBER_ID
213 ORDER BY gm.MEMBER_PORT ASC;
214 MEMBER_PORT LAST_CONFLICT_FREE_TRANSACTION
215 SERVER1
216 SERVER2 c9f7fc80-034a-45c9-be2b-d738604be275:6
217 SERVER3 c9f7fc80-034a-45c9-be2b-d738604be275:6
218
219 #########################################################################
220 # 12) Cleanup
221 #########################################################################
222
223 DROP TABLE t1;
224 include/rpl_sync.inc
225 include/group_replication_end.inc