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
|
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. Verify that the entries corresponding to the
# instrumented GCS threads are not in the threads
# table immediately after plugin installation
# (before starting the GR).
SELECT * FROM performance_schema.threads WHERE NAME LIKE '%THD_Gcs_%';
THREAD_ID NAME TYPE PROCESSLIST_ID PROCESSLIST_USER PROCESSLIST_HOST PROCESSLIST_DB PROCESSLIST_COMMAND PROCESSLIST_TIME PROCESSLIST_STATE PROCESSLIST_INFO PARENT_THREAD_ID ROLE INSTRUMENTED HISTORY CONNECTION_TYPE THREAD_OS_ID RESOURCE_GROUP EXECUTION_ENGINE CONTROLLED_MEMORY MAX_CONTROLLED_MEMORY TOTAL_MEMORY MAX_TOTAL_MEMORY TELEMETRY_ACTIVE
include/assert.inc ['There should be no GCS instrumented threads entries in the threads table before starting the GR']
############################################################
# 2. Start the GR
include/start_and_bootstrap_group_replication.inc
############################################################
# 3. Verify that the entries corresponding to the
# instrumented GCS threads are in the threads table
# after starting the GR.
include/assert.inc ['There should be 4 GCS instrumented thread entries in the threads table after starting the GR']
############################################################
# 4. Stop the GR
include/stop_group_replication.inc
############################################################
# 5. Verify that no entries corresponding to the
# instrumented GCS threads remain in the threads table
# after stopping the GR.
SELECT * FROM performance_schema.threads WHERE NAME LIKE '%THD_Gcs_%';
THREAD_ID NAME TYPE PROCESSLIST_ID PROCESSLIST_USER PROCESSLIST_HOST PROCESSLIST_DB PROCESSLIST_COMMAND PROCESSLIST_TIME PROCESSLIST_STATE PROCESSLIST_INFO PARENT_THREAD_ID ROLE INSTRUMENTED HISTORY CONNECTION_TYPE THREAD_OS_ID RESOURCE_GROUP EXECUTION_ENGINE CONTROLLED_MEMORY MAX_CONTROLLED_MEMORY TOTAL_MEMORY MAX_TOTAL_MEMORY TELEMETRY_ACTIVE
include/assert.inc ['There should be no extra psi keys added after starting the GR']
############################################################
# 6. Test end.
include/group_replication_end.inc
|
