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
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
|
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. Before start Group Replication channels are not present
# on common replication P_S tables.
include/assert.inc ['There is no Group Replication applier channel on performance_schema.replication_connection_configuration table']
include/assert.inc ['There is no Group Replication applier channel on performance_schema.replication_connection_status table']
include/assert.inc ['There is no Group Replication applier channel on performance_schema.replication_applier_configuration table']
include/assert.inc ['There is no Group Replication applier channel on performance_schema.replication_applier_status table']
include/assert.inc ['There is no Group Replication applier channel on performance_schema.replication_applier_status_by_coordinator table']
include/assert.inc ['There is no Group Replication applier channel on performance_schema.replication_applier_status_by_worker table']
############################################################
# 2. After start Group Replication channels are present
# on common replication P_S tables.
include/start_and_bootstrap_group_replication.inc
include/start_group_replication.inc
include/assert.inc ['There is a Group Replication applier channel on performance_schema.replication_connection_configuration table']
include/assert.inc ['There is a Group Replication applier channel on performance_schema.replication_connection_status table']
include/assert.inc ['There is a Group Replication applier channel on performance_schema.replication_applier_configuration table']
include/assert.inc ['There is a Group Replication applier channel on performance_schema.replication_applier_status table']
include/assert.inc ['There is no Group Replication applier channel on performance_schema.replication_applier_status_by_coordinator table']
include/assert.inc ['There is a Group Replication applier channel on performance_schema.replication_applier_status_by_worker table']
############################################################
# 3. Group Replication running channels sample output
# on common replication P_S tables.
CREATE TABLE t1 (c1 INT NOT NULL PRIMARY KEY) ENGINE=InnoDB;
INSERT INTO t1 VALUES (1);
include/rpl_sync.inc
#group_replication_recovery channel configuration
SELECT * FROM performance_schema.replication_connection_configuration WHERE channel_name LIKE "group_replication_recovery";
CHANNEL_NAME group_replication_recovery
HOST <NULL>
PORT 0
USER root
NETWORK_INTERFACE
AUTO_POSITION 1
SSL_ALLOWED NO
SSL_CA_FILE CA
SSL_CA_PATH
SSL_CERTIFICATE CERT
SSL_CIPHER
SSL_KEY KEY
SSL_VERIFY_SERVER_CERTIFICATE NO
SSL_CRL_FILE
SSL_CRL_PATH
CONNECTION_RETRY_INTERVAL 60
CONNECTION_RETRY_COUNT 1
HEARTBEAT_INTERVAL 30.000
TLS_VERSION TLSv1.2,TLSv1.3
PUBLIC_KEY_PATH
GET_PUBLIC_KEY NO
NETWORK_NAMESPACE
COMPRESSION_ALGORITHM uncompressed
ZSTD_COMPRESSION_LEVEL 3
TLS_CIPHERSUITES NULL
SOURCE_CONNECTION_AUTO_FAILOVER 0
GTID_ONLY 1
#group_replication_applier channel configuration
SELECT * FROM performance_schema.replication_connection_configuration WHERE channel_name LIKE "group_replication_applier";
CHANNEL_NAME group_replication_applier
HOST <NULL>
PORT 0
USER
NETWORK_INTERFACE
AUTO_POSITION 1
SSL_ALLOWED NO
SSL_CA_FILE
SSL_CA_PATH
SSL_CERTIFICATE
SSL_CIPHER
SSL_KEY
SSL_VERIFY_SERVER_CERTIFICATE NO
SSL_CRL_FILE
SSL_CRL_PATH
CONNECTION_RETRY_INTERVAL 60
CONNECTION_RETRY_COUNT 10
HEARTBEAT_INTERVAL 30.000
TLS_VERSION
PUBLIC_KEY_PATH
GET_PUBLIC_KEY NO
NETWORK_NAMESPACE
COMPRESSION_ALGORITHM uncompressed
ZSTD_COMPRESSION_LEVEL 3
TLS_CIPHERSUITES NULL
SOURCE_CONNECTION_AUTO_FAILOVER 0
GTID_ONLY 1
SELECT * FROM performance_schema.replication_connection_status WHERE channel_name = "group_replication_applier";
CHANNEL_NAME group_replication_applier
GROUP_NAME 8a94f357-aab4-11df-86ab-c80aa9429444
SOURCE_UUID 8a94f357-aab4-11df-86ab-c80aa9429444
THREAD_ID NULL
SERVICE_STATE ON
COUNT_RECEIVED_HEARTBEATS 0
LAST_HEARTBEAT_TIMESTAMP 0000-00-00 00:00:00.000000
RECEIVED_TRANSACTION_SET 8a94f357-aab4-11df-86ab-c80aa9429444:2-4
LAST_ERROR_NUMBER 0
LAST_ERROR_MESSAGE
LAST_ERROR_TIMESTAMP 0000-00-00 00:00:00.000000
LAST_QUEUED_TRANSACTION 8a94f357-aab4-11df-86ab-c80aa9429444:4
LAST_QUEUED_TRANSACTION_ORIGINAL_COMMIT_TIMESTAMP [ORIGINAL_COMMIT_TIMESTAMP]
LAST_QUEUED_TRANSACTION_IMMEDIATE_COMMIT_TIMESTAMP [IMMEDIATE_COMMIT_TIMESTAMP]
LAST_QUEUED_TRANSACTION_START_QUEUE_TIMESTAMP [START_QUEUE_TIMESTAMP]
LAST_QUEUED_TRANSACTION_END_QUEUE_TIMESTAMP [END_QUEUE_TIMESTAMP]
QUEUEING_TRANSACTION
QUEUEING_TRANSACTION_ORIGINAL_COMMIT_TIMESTAMP 0000-00-00 00:00:00.000000
QUEUEING_TRANSACTION_IMMEDIATE_COMMIT_TIMESTAMP 0000-00-00 00:00:00.000000
QUEUEING_TRANSACTION_START_QUEUE_TIMESTAMP 0000-00-00 00:00:00.000000
SELECT * FROM performance_schema.replication_applier_configuration WHERE channel_name = "group_replication_applier";
CHANNEL_NAME group_replication_applier
DESIRED_DELAY 0
PRIVILEGE_CHECKS_USER NULL
REQUIRE_ROW_FORMAT YES
REQUIRE_TABLE_PRIMARY_KEY_CHECK STREAM
ASSIGN_GTIDS_TO_ANONYMOUS_TRANSACTIONS_TYPE OFF
ASSIGN_GTIDS_TO_ANONYMOUS_TRANSACTIONS_VALUE NULL
SELECT * FROM performance_schema.replication_applier_status WHERE channel_name = "group_replication_applier";
CHANNEL_NAME group_replication_applier
SERVICE_STATE ON
REMAINING_DELAY NULL
COUNT_TRANSACTIONS_RETRIES 0
SELECT * FROM performance_schema.replication_applier_status_by_coordinator WHERE channel_name = "group_replication_applier";
CHANNEL_NAME group_replication_applier
THREAD_ID [THREAD_ID]
SERVICE_STATE ON
LAST_ERROR_NUMBER 0
LAST_ERROR_MESSAGE
LAST_ERROR_TIMESTAMP 0000-00-00 00:00:00.000000
LAST_PROCESSED_TRANSACTION [LAST_PROCESSED_TRANSACTION]
LAST_PROCESSED_TRANSACTION_ORIGINAL_COMMIT_TIMESTAMP [ORIGINAL_COMMIT_TIMESTAMP]
LAST_PROCESSED_TRANSACTION_IMMEDIATE_COMMIT_TIMESTAMP [IMMEDIATE_COMMIT_TIMESTAMP]
LAST_PROCESSED_TRANSACTION_START_BUFFER_TIMESTAMP [START_BUFFER_TIMESTAMP]
LAST_PROCESSED_TRANSACTION_END_BUFFER_TIMESTAMP [END_BUFFER_TIMESTAMP]
PROCESSING_TRANSACTION
PROCESSING_TRANSACTION_ORIGINAL_COMMIT_TIMESTAMP 0000-00-00 00:00:00.000000
PROCESSING_TRANSACTION_IMMEDIATE_COMMIT_TIMESTAMP 0000-00-00 00:00:00.000000
PROCESSING_TRANSACTION_START_BUFFER_TIMESTAMP 0000-00-00 00:00:00.000000
SELECT * FROM performance_schema.replication_applier_status_by_worker WHERE channel_name = "group_replication_applier";
CHANNEL_NAME group_replication_applier
WORKER_ID 1
THREAD_ID [THREAD_ID]
SERVICE_STATE ON
LAST_ERROR_NUMBER 0
LAST_ERROR_MESSAGE
LAST_ERROR_TIMESTAMP 0000-00-00 00:00:00.000000
LAST_APPLIED_TRANSACTION 8a94f357-aab4-11df-86ab-c80aa9429444:4
LAST_APPLIED_TRANSACTION_ORIGINAL_COMMIT_TIMESTAMP [ORIGINAL_COMMIT_TIMESTAMP]
LAST_APPLIED_TRANSACTION_IMMEDIATE_COMMIT_TIMESTAMP [IMMEDIATE_COMMIT_TIMESTAMP]
LAST_APPLIED_TRANSACTION_START_APPLY_TIMESTAMP [START_APPLY_TIMESTAMP]
LAST_APPLIED_TRANSACTION_END_APPLY_TIMESTAMP [END_APPLY_TIMESTAMP]
APPLYING_TRANSACTION
APPLYING_TRANSACTION_ORIGINAL_COMMIT_TIMESTAMP 0000-00-00 00:00:00.000000
APPLYING_TRANSACTION_IMMEDIATE_COMMIT_TIMESTAMP 0000-00-00 00:00:00.000000
APPLYING_TRANSACTION_START_APPLY_TIMESTAMP 0000-00-00 00:00:00.000000
LAST_APPLIED_TRANSACTION_RETRIES_COUNT 0
LAST_APPLIED_TRANSACTION_LAST_TRANSIENT_ERROR_NUMBER 0
LAST_APPLIED_TRANSACTION_LAST_TRANSIENT_ERROR_MESSAGE
LAST_APPLIED_TRANSACTION_LAST_TRANSIENT_ERROR_TIMESTAMP 0000-00-00 00:00:00.000000
APPLYING_TRANSACTION_RETRIES_COUNT 0
APPLYING_TRANSACTION_LAST_TRANSIENT_ERROR_NUMBER 0
APPLYING_TRANSACTION_LAST_TRANSIENT_ERROR_MESSAGE
APPLYING_TRANSACTION_LAST_TRANSIENT_ERROR_TIMESTAMP 0000-00-00 00:00:00.000000
############################################################
# 4. Clean up data.
DROP TABLE t1;
include/rpl_sync.inc
############################################################
# 5. Stop Group Replication, channels must continue to be
# present on common replication P_S tables.
include/stop_group_replication.inc
include/stop_group_replication.inc
include/assert.inc ['There is still a Group Replication applier channel on performance_schema.replication_connection_configuration table']
include/assert.inc ['There is still a Group Replication applier channel on performance_schema.replication_connection_status table']
include/assert.inc ['There is still a Group Replication applier channel on performance_schema.replication_applier_configuration table']
include/assert.inc ['There is still a Group Replication applier channel on performance_schema.replication_applier_status table']
include/assert.inc ['There is still no Group Replication applier channel on performance_schema.replication_applier_status_by_coordinator table']
include/assert.inc ['There is still a Group Replication applier channel on performance_schema.replication_applier_status_by_worker table']
############################################################
# 6. Group Replication stopped channels sample output
# on common replication P_S tables.
#group_replication_recovery channel configuration
SELECT * FROM performance_schema.replication_connection_configuration WHERE channel_name LIKE "group_replication_recovery";
CHANNEL_NAME group_replication_recovery
HOST <NULL>
PORT 0
USER root
NETWORK_INTERFACE
AUTO_POSITION 1
SSL_ALLOWED NO
SSL_CA_FILE CA
SSL_CA_PATH
SSL_CERTIFICATE CERT
SSL_CIPHER
SSL_KEY KEY
SSL_VERIFY_SERVER_CERTIFICATE NO
SSL_CRL_FILE
SSL_CRL_PATH
CONNECTION_RETRY_INTERVAL 60
CONNECTION_RETRY_COUNT 1
HEARTBEAT_INTERVAL 30.000
TLS_VERSION TLSv1.2,TLSv1.3
PUBLIC_KEY_PATH
GET_PUBLIC_KEY NO
NETWORK_NAMESPACE
COMPRESSION_ALGORITHM uncompressed
ZSTD_COMPRESSION_LEVEL 3
TLS_CIPHERSUITES NULL
SOURCE_CONNECTION_AUTO_FAILOVER 0
GTID_ONLY 1
#group_replication_applier channel configuration
SELECT * FROM performance_schema.replication_connection_configuration WHERE channel_name LIKE "group_replication_applier";
CHANNEL_NAME group_replication_applier
HOST <NULL>
PORT 0
USER
NETWORK_INTERFACE
AUTO_POSITION 1
SSL_ALLOWED NO
SSL_CA_FILE
SSL_CA_PATH
SSL_CERTIFICATE
SSL_CIPHER
SSL_KEY
SSL_VERIFY_SERVER_CERTIFICATE NO
SSL_CRL_FILE
SSL_CRL_PATH
CONNECTION_RETRY_INTERVAL 60
CONNECTION_RETRY_COUNT 10
HEARTBEAT_INTERVAL 30.000
TLS_VERSION
PUBLIC_KEY_PATH
GET_PUBLIC_KEY NO
NETWORK_NAMESPACE
COMPRESSION_ALGORITHM uncompressed
ZSTD_COMPRESSION_LEVEL 3
TLS_CIPHERSUITES NULL
SOURCE_CONNECTION_AUTO_FAILOVER 0
GTID_ONLY 1
SELECT * FROM performance_schema.replication_connection_status WHERE channel_name = "group_replication_applier";
CHANNEL_NAME group_replication_applier
GROUP_NAME 8a94f357-aab4-11df-86ab-c80aa9429444
SOURCE_UUID 8a94f357-aab4-11df-86ab-c80aa9429444
THREAD_ID NULL
SERVICE_STATE OFF
COUNT_RECEIVED_HEARTBEATS 0
LAST_HEARTBEAT_TIMESTAMP 0000-00-00 00:00:00.000000
RECEIVED_TRANSACTION_SET 8a94f357-aab4-11df-86ab-c80aa9429444:2-5
LAST_ERROR_NUMBER 0
LAST_ERROR_MESSAGE
LAST_ERROR_TIMESTAMP 0000-00-00 00:00:00.000000
LAST_QUEUED_TRANSACTION 8a94f357-aab4-11df-86ab-c80aa9429444:5
LAST_QUEUED_TRANSACTION_ORIGINAL_COMMIT_TIMESTAMP [ORIGINAL_COMMIT_TIMESTAMP]
LAST_QUEUED_TRANSACTION_IMMEDIATE_COMMIT_TIMESTAMP [IMMEDIATE_COMMIT_TIMESTAMP]
LAST_QUEUED_TRANSACTION_START_QUEUE_TIMESTAMP [START_QUEUE_TIMESTAMP]
LAST_QUEUED_TRANSACTION_END_QUEUE_TIMESTAMP [END_QUEUE_TIMESTAMP]
QUEUEING_TRANSACTION
QUEUEING_TRANSACTION_ORIGINAL_COMMIT_TIMESTAMP 0000-00-00 00:00:00.000000
QUEUEING_TRANSACTION_IMMEDIATE_COMMIT_TIMESTAMP 0000-00-00 00:00:00.000000
QUEUEING_TRANSACTION_START_QUEUE_TIMESTAMP 0000-00-00 00:00:00.000000
SELECT * FROM performance_schema.replication_applier_configuration WHERE channel_name = "group_replication_applier";
CHANNEL_NAME group_replication_applier
DESIRED_DELAY 0
PRIVILEGE_CHECKS_USER NULL
REQUIRE_ROW_FORMAT YES
REQUIRE_TABLE_PRIMARY_KEY_CHECK STREAM
ASSIGN_GTIDS_TO_ANONYMOUS_TRANSACTIONS_TYPE OFF
ASSIGN_GTIDS_TO_ANONYMOUS_TRANSACTIONS_VALUE NULL
SELECT * FROM performance_schema.replication_applier_status WHERE channel_name = "group_replication_applier";
CHANNEL_NAME group_replication_applier
SERVICE_STATE OFF
REMAINING_DELAY NULL
COUNT_TRANSACTIONS_RETRIES 0
SELECT * FROM performance_schema.replication_applier_status_by_coordinator WHERE channel_name = "group_replication_applier";
CHANNEL_NAME group_replication_applier
THREAD_ID [THREAD_ID]
SERVICE_STATE OFF
LAST_ERROR_NUMBER 0
LAST_ERROR_MESSAGE
LAST_ERROR_TIMESTAMP 0000-00-00 00:00:00.000000
LAST_PROCESSED_TRANSACTION [LAST_PROCESSED_TRANSACTION]
LAST_PROCESSED_TRANSACTION_ORIGINAL_COMMIT_TIMESTAMP [ORIGINAL_COMMIT_TIMESTAMP]
LAST_PROCESSED_TRANSACTION_IMMEDIATE_COMMIT_TIMESTAMP [IMMEDIATE_COMMIT_TIMESTAMP]
LAST_PROCESSED_TRANSACTION_START_BUFFER_TIMESTAMP [START_BUFFER_TIMESTAMP]
LAST_PROCESSED_TRANSACTION_END_BUFFER_TIMESTAMP [END_BUFFER_TIMESTAMP]
PROCESSING_TRANSACTION
PROCESSING_TRANSACTION_ORIGINAL_COMMIT_TIMESTAMP 0000-00-00 00:00:00.000000
PROCESSING_TRANSACTION_IMMEDIATE_COMMIT_TIMESTAMP 0000-00-00 00:00:00.000000
PROCESSING_TRANSACTION_START_BUFFER_TIMESTAMP 0000-00-00 00:00:00.000000
SELECT * FROM performance_schema.replication_applier_status_by_worker WHERE channel_name = "group_replication_applier";
CHANNEL_NAME group_replication_applier
WORKER_ID 1
THREAD_ID NULL
SERVICE_STATE OFF
LAST_ERROR_NUMBER 0
LAST_ERROR_MESSAGE
LAST_ERROR_TIMESTAMP 0000-00-00 00:00:00.000000
LAST_APPLIED_TRANSACTION 8a94f357-aab4-11df-86ab-c80aa9429444:5
LAST_APPLIED_TRANSACTION_ORIGINAL_COMMIT_TIMESTAMP [ORIGINAL_COMMIT_TIMESTAMP]
LAST_APPLIED_TRANSACTION_IMMEDIATE_COMMIT_TIMESTAMP [IMMEDIATE_COMMIT_TIMESTAMP]
LAST_APPLIED_TRANSACTION_START_APPLY_TIMESTAMP [START_APPLY_TIMESTAMP]
LAST_APPLIED_TRANSACTION_END_APPLY_TIMESTAMP [END_APPLY_TIMESTAMP]
APPLYING_TRANSACTION
APPLYING_TRANSACTION_ORIGINAL_COMMIT_TIMESTAMP 0000-00-00 00:00:00.000000
APPLYING_TRANSACTION_IMMEDIATE_COMMIT_TIMESTAMP 0000-00-00 00:00:00.000000
APPLYING_TRANSACTION_START_APPLY_TIMESTAMP 0000-00-00 00:00:00.000000
LAST_APPLIED_TRANSACTION_RETRIES_COUNT 0
LAST_APPLIED_TRANSACTION_LAST_TRANSIENT_ERROR_NUMBER 0
LAST_APPLIED_TRANSACTION_LAST_TRANSIENT_ERROR_MESSAGE
LAST_APPLIED_TRANSACTION_LAST_TRANSIENT_ERROR_TIMESTAMP 0000-00-00 00:00:00.000000
APPLYING_TRANSACTION_RETRIES_COUNT 0
APPLYING_TRANSACTION_LAST_TRANSIENT_ERROR_NUMBER 0
APPLYING_TRANSACTION_LAST_TRANSIENT_ERROR_MESSAGE
APPLYING_TRANSACTION_LAST_TRANSIENT_ERROR_TIMESTAMP 0000-00-00 00:00:00.000000
############################################################
# 7. Group Replication channel must not be present on common
# replication P_S tables after a RESET ALL command.
RESET SLAVE ALL FOR CHANNEL "group_replication_applier";
Warnings:
Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
include/assert.inc ['There is no Group Replication applier channel on performance_schema.replication_connection_configuration table']
include/assert.inc ['There is no Group Replication applier channel on performance_schema.replication_connection_status table']
include/assert.inc ['There is no Group Replication applier channel on performance_schema.replication_applier_configuration table']
include/assert.inc ['There is no Group Replication applier channel on performance_schema.replication_applier_status table']
include/assert.inc ['There is no Group Replication applier channel on performance_schema.replication_applier_status_by_coordinator table']
include/assert.inc ['There is no Group Replication applier channel on performance_schema.replication_applier_status_by_worker table']
############################################################
# 8. Test end.
include/group_replication_end.inc
|
