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
|
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 no entries corresponding to the
# instrumented GCS mutexes and conds are in the
# setup_instruments table, as well as no corresponding
# instances are in the mutex_instances or cond_instances
# tables immediately after plugin installation (before
# starting the GR).
include/assert.inc ['There should be no GCS instrumented mutex entries in the mutex_instances table before starting the GR']
include/assert.inc ['There should be no GCS instrumented cond entries in the cond_instances 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 mutexes and conds are in the
# setup_instruments table, and that the corresponding
# instances are in the mutex_instances and
# cond_instances tables after starting the GR.
include/assert.inc ['There should be 21 GCS instrumented mutex and cond entries in the setup_instruments table after starting the GR']
SELECT * FROM performance_schema.setup_instruments WHERE (NAME LIKE "wait/synch/mutex/group_rpl/GCS_%" OR NAME LIKE "wait/synch/cond/group_rpl/GCS_%") ORDER BY NAME;
NAME ENABLED TIMED PROPERTIES FLAGS VOLATILITY DOCUMENTATION
wait/synch/cond/group_rpl/GCS_Gcs_async_buffer::m_free_buffer_cond YES YES singleton NULL 0 NULL
wait/synch/cond/group_rpl/GCS_Gcs_async_buffer::m_wait_for_events_cond YES YES singleton NULL 0 NULL
wait/synch/cond/group_rpl/GCS_Gcs_suspicions_manager::m_suspicions_cond YES YES singleton NULL 0 NULL
wait/synch/cond/group_rpl/GCS_Gcs_xcom_engine::m_wait_for_notification_cond YES YES singleton NULL 0 NULL
wait/synch/cond/group_rpl/GCS_Gcs_xcom_interface::m_wait_for_ssl_init_cond YES YES singleton NULL 0 NULL
wait/synch/cond/group_rpl/GCS_Gcs_xcom_proxy_impl::m_cond_xcom_comms_status YES YES singleton NULL 0 NULL
wait/synch/cond/group_rpl/GCS_Gcs_xcom_proxy_impl::m_cond_xcom_exit YES YES singleton NULL 0 NULL
wait/synch/cond/group_rpl/GCS_Gcs_xcom_proxy_impl::m_cond_xcom_ready YES YES singleton NULL 0 NULL
wait/synch/cond/group_rpl/GCS_Gcs_xcom_view_change_control::m_wait_for_view_cond YES YES singleton NULL 0 NULL
wait/synch/mutex/group_rpl/GCS_Gcs_async_buffer::m_free_buffer_mutex YES YES singleton NULL 0 NULL
wait/synch/mutex/group_rpl/GCS_Gcs_suspicions_manager::m_suspicions_mutex YES YES singleton NULL 0 NULL
wait/synch/mutex/group_rpl/GCS_Gcs_suspicions_manager::m_suspicions_parameters_mutex YES YES singleton NULL 0 NULL
wait/synch/mutex/group_rpl/GCS_Gcs_xcom_engine::m_wait_for_notification_mutex YES YES singleton NULL 0 NULL
wait/synch/mutex/group_rpl/GCS_Gcs_xcom_group_management::m_nodes_mutex YES YES singleton NULL 0 NULL
wait/synch/mutex/group_rpl/GCS_Gcs_xcom_interface::m_wait_for_ssl_init_mutex YES YES singleton NULL 0 NULL
wait/synch/mutex/group_rpl/GCS_Gcs_xcom_proxy_impl::m_lock_xcom_comms_status YES YES singleton NULL 0 NULL
wait/synch/mutex/group_rpl/GCS_Gcs_xcom_proxy_impl::m_lock_xcom_exit YES YES singleton NULL 0 NULL
wait/synch/mutex/group_rpl/GCS_Gcs_xcom_proxy_impl::m_lock_xcom_ready YES YES singleton NULL 0 NULL
wait/synch/mutex/group_rpl/GCS_Gcs_xcom_view_change_control::m_current_view_mutex YES YES singleton NULL 0 NULL
wait/synch/mutex/group_rpl/GCS_Gcs_xcom_view_change_control::m_joining_leaving_mutex YES YES singleton NULL 0 NULL
wait/synch/mutex/group_rpl/GCS_Gcs_xcom_view_change_control::m_wait_for_view_mutex YES YES singleton NULL 0 NULL
include/assert.inc ['There should be 9 GCS instrumented cond entries in the cond_instances table after starting the GR']
SELECT NAME FROM performance_schema.cond_instances WHERE NAME LIKE "wait/synch/cond/group_rpl/GCS_%" ORDER BY NAME;
NAME
wait/synch/cond/group_rpl/GCS_Gcs_async_buffer::m_free_buffer_cond
wait/synch/cond/group_rpl/GCS_Gcs_async_buffer::m_wait_for_events_cond
wait/synch/cond/group_rpl/GCS_Gcs_suspicions_manager::m_suspicions_cond
wait/synch/cond/group_rpl/GCS_Gcs_xcom_engine::m_wait_for_notification_cond
wait/synch/cond/group_rpl/GCS_Gcs_xcom_interface::m_wait_for_ssl_init_cond
wait/synch/cond/group_rpl/GCS_Gcs_xcom_proxy_impl::m_cond_xcom_comms_status
wait/synch/cond/group_rpl/GCS_Gcs_xcom_proxy_impl::m_cond_xcom_exit
wait/synch/cond/group_rpl/GCS_Gcs_xcom_proxy_impl::m_cond_xcom_ready
wait/synch/cond/group_rpl/GCS_Gcs_xcom_view_change_control::m_wait_for_view_cond
include/assert.inc ['There should be 12 GCS instrumented mutex entries in the mutex_instances table after starting the GR']
SELECT NAME FROM performance_schema.mutex_instances WHERE NAME LIKE "wait/synch/mutex/group_rpl/GCS_%" ORDER BY NAME;
NAME
wait/synch/mutex/group_rpl/GCS_Gcs_async_buffer::m_free_buffer_mutex
wait/synch/mutex/group_rpl/GCS_Gcs_suspicions_manager::m_suspicions_mutex
wait/synch/mutex/group_rpl/GCS_Gcs_suspicions_manager::m_suspicions_parameters_mutex
wait/synch/mutex/group_rpl/GCS_Gcs_xcom_engine::m_wait_for_notification_mutex
wait/synch/mutex/group_rpl/GCS_Gcs_xcom_group_management::m_nodes_mutex
wait/synch/mutex/group_rpl/GCS_Gcs_xcom_interface::m_wait_for_ssl_init_mutex
wait/synch/mutex/group_rpl/GCS_Gcs_xcom_proxy_impl::m_lock_xcom_comms_status
wait/synch/mutex/group_rpl/GCS_Gcs_xcom_proxy_impl::m_lock_xcom_exit
wait/synch/mutex/group_rpl/GCS_Gcs_xcom_proxy_impl::m_lock_xcom_ready
wait/synch/mutex/group_rpl/GCS_Gcs_xcom_view_change_control::m_current_view_mutex
wait/synch/mutex/group_rpl/GCS_Gcs_xcom_view_change_control::m_joining_leaving_mutex
wait/synch/mutex/group_rpl/GCS_Gcs_xcom_view_change_control::m_wait_for_view_mutex
############################################################
# 4. Stop the GR
include/stop_group_replication.inc
############################################################
# 5. Verify that the entries corresponding to the
# instrumented GCS mutexes and conds remain in the
# setup_instruments table, and that no corresponding
# instances remain in the mutex_instances and
# cond_instances tables after stopping the GR.
include/assert.inc ['There should be the same 21 GCS instrumented mutex and cond entries in the setup_instruments table after stopping the GR']
SELECT * FROM performance_schema.setup_instruments WHERE (NAME LIKE "wait/synch/mutex/group_rpl/GCS_%" OR NAME LIKE "wait/synch/cond/group_rpl/GCS_%") ORDER BY NAME;
NAME ENABLED TIMED PROPERTIES FLAGS VOLATILITY DOCUMENTATION
wait/synch/cond/group_rpl/GCS_Gcs_async_buffer::m_free_buffer_cond YES YES singleton NULL 0 NULL
wait/synch/cond/group_rpl/GCS_Gcs_async_buffer::m_wait_for_events_cond YES YES singleton NULL 0 NULL
wait/synch/cond/group_rpl/GCS_Gcs_suspicions_manager::m_suspicions_cond YES YES singleton NULL 0 NULL
wait/synch/cond/group_rpl/GCS_Gcs_xcom_engine::m_wait_for_notification_cond YES YES singleton NULL 0 NULL
wait/synch/cond/group_rpl/GCS_Gcs_xcom_interface::m_wait_for_ssl_init_cond YES YES singleton NULL 0 NULL
wait/synch/cond/group_rpl/GCS_Gcs_xcom_proxy_impl::m_cond_xcom_comms_status YES YES singleton NULL 0 NULL
wait/synch/cond/group_rpl/GCS_Gcs_xcom_proxy_impl::m_cond_xcom_exit YES YES singleton NULL 0 NULL
wait/synch/cond/group_rpl/GCS_Gcs_xcom_proxy_impl::m_cond_xcom_ready YES YES singleton NULL 0 NULL
wait/synch/cond/group_rpl/GCS_Gcs_xcom_view_change_control::m_wait_for_view_cond YES YES singleton NULL 0 NULL
wait/synch/mutex/group_rpl/GCS_Gcs_async_buffer::m_free_buffer_mutex YES YES singleton NULL 0 NULL
wait/synch/mutex/group_rpl/GCS_Gcs_suspicions_manager::m_suspicions_mutex YES YES singleton NULL 0 NULL
wait/synch/mutex/group_rpl/GCS_Gcs_suspicions_manager::m_suspicions_parameters_mutex YES YES singleton NULL 0 NULL
wait/synch/mutex/group_rpl/GCS_Gcs_xcom_engine::m_wait_for_notification_mutex YES YES singleton NULL 0 NULL
wait/synch/mutex/group_rpl/GCS_Gcs_xcom_group_management::m_nodes_mutex YES YES singleton NULL 0 NULL
wait/synch/mutex/group_rpl/GCS_Gcs_xcom_interface::m_wait_for_ssl_init_mutex YES YES singleton NULL 0 NULL
wait/synch/mutex/group_rpl/GCS_Gcs_xcom_proxy_impl::m_lock_xcom_comms_status YES YES singleton NULL 0 NULL
wait/synch/mutex/group_rpl/GCS_Gcs_xcom_proxy_impl::m_lock_xcom_exit YES YES singleton NULL 0 NULL
wait/synch/mutex/group_rpl/GCS_Gcs_xcom_proxy_impl::m_lock_xcom_ready YES YES singleton NULL 0 NULL
wait/synch/mutex/group_rpl/GCS_Gcs_xcom_view_change_control::m_current_view_mutex YES YES singleton NULL 0 NULL
wait/synch/mutex/group_rpl/GCS_Gcs_xcom_view_change_control::m_joining_leaving_mutex YES YES singleton NULL 0 NULL
wait/synch/mutex/group_rpl/GCS_Gcs_xcom_view_change_control::m_wait_for_view_mutex YES YES singleton NULL 0 NULL
include/assert.inc ['There should be no GCS instrumented mutex entries in the mutex_instances table after stopping the GR']
include/assert.inc ['There should be no GCS instrumented cond entries in the cond_instances table after stopping the GR']
############################################################
# 6. Test end.
include/group_replication_end.inc
|
