| 1 |
include/group_replication.inc |
| 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. Verify that no entries corresponding to the |
| 9 |
# instrumented GCS mutexes and conds are in the |
| 10 |
# setup_instruments table, as well as no corresponding |
| 11 |
# instances are in the mutex_instances or cond_instances |
| 12 |
# tables immediately after plugin installation (before |
| 13 |
# starting the GR). |
| 14 |
include/assert.inc ['There should be no GCS instrumented mutex entries in the mutex_instances table before starting the GR'] |
| 15 |
include/assert.inc ['There should be no GCS instrumented cond entries in the cond_instances table before starting the GR'] |
| 16 |
|
| 17 |
############################################################ |
| 18 |
# 2. Start the GR |
| 19 |
include/start_and_bootstrap_group_replication.inc |
| 20 |
|
| 21 |
############################################################ |
| 22 |
# 3. Verify that the entries corresponding to the |
| 23 |
# instrumented GCS mutexes and conds are in the |
| 24 |
# setup_instruments table, and that the corresponding |
| 25 |
# instances are in the mutex_instances and |
| 26 |
# cond_instances tables after starting the GR. |
| 27 |
include/assert.inc ['There should be 21 GCS instrumented mutex and cond entries in the setup_instruments table after starting the GR'] |
| 28 |
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; |
| 29 |
NAME ENABLED TIMED PROPERTIES FLAGS VOLATILITY DOCUMENTATION |
| 30 |
wait/synch/cond/group_rpl/GCS_Gcs_async_buffer::m_free_buffer_cond YES YES singleton NULL 0 NULL |
| 31 |
wait/synch/cond/group_rpl/GCS_Gcs_async_buffer::m_wait_for_events_cond YES YES singleton NULL 0 NULL |
| 32 |
wait/synch/cond/group_rpl/GCS_Gcs_suspicions_manager::m_suspicions_cond YES YES singleton NULL 0 NULL |
| 33 |
wait/synch/cond/group_rpl/GCS_Gcs_xcom_engine::m_wait_for_notification_cond YES YES singleton NULL 0 NULL |
| 34 |
wait/synch/cond/group_rpl/GCS_Gcs_xcom_interface::m_wait_for_ssl_init_cond YES YES singleton NULL 0 NULL |
| 35 |
wait/synch/cond/group_rpl/GCS_Gcs_xcom_proxy_impl::m_cond_xcom_comms_status YES YES singleton NULL 0 NULL |
| 36 |
wait/synch/cond/group_rpl/GCS_Gcs_xcom_proxy_impl::m_cond_xcom_exit YES YES singleton NULL 0 NULL |
| 37 |
wait/synch/cond/group_rpl/GCS_Gcs_xcom_proxy_impl::m_cond_xcom_ready YES YES singleton NULL 0 NULL |
| 38 |
wait/synch/cond/group_rpl/GCS_Gcs_xcom_view_change_control::m_wait_for_view_cond YES YES singleton NULL 0 NULL |
| 39 |
wait/synch/mutex/group_rpl/GCS_Gcs_async_buffer::m_free_buffer_mutex YES YES singleton NULL 0 NULL |
| 40 |
wait/synch/mutex/group_rpl/GCS_Gcs_suspicions_manager::m_suspicions_mutex YES YES singleton NULL 0 NULL |
| 41 |
wait/synch/mutex/group_rpl/GCS_Gcs_suspicions_manager::m_suspicions_parameters_mutex YES YES singleton NULL 0 NULL |
| 42 |
wait/synch/mutex/group_rpl/GCS_Gcs_xcom_engine::m_wait_for_notification_mutex YES YES singleton NULL 0 NULL |
| 43 |
wait/synch/mutex/group_rpl/GCS_Gcs_xcom_group_management::m_nodes_mutex YES YES singleton NULL 0 NULL |
| 44 |
wait/synch/mutex/group_rpl/GCS_Gcs_xcom_interface::m_wait_for_ssl_init_mutex YES YES singleton NULL 0 NULL |
| 45 |
wait/synch/mutex/group_rpl/GCS_Gcs_xcom_proxy_impl::m_lock_xcom_comms_status YES YES singleton NULL 0 NULL |
| 46 |
wait/synch/mutex/group_rpl/GCS_Gcs_xcom_proxy_impl::m_lock_xcom_exit YES YES singleton NULL 0 NULL |
| 47 |
wait/synch/mutex/group_rpl/GCS_Gcs_xcom_proxy_impl::m_lock_xcom_ready YES YES singleton NULL 0 NULL |
| 48 |
wait/synch/mutex/group_rpl/GCS_Gcs_xcom_view_change_control::m_current_view_mutex YES YES singleton NULL 0 NULL |
| 49 |
wait/synch/mutex/group_rpl/GCS_Gcs_xcom_view_change_control::m_joining_leaving_mutex YES YES singleton NULL 0 NULL |
| 50 |
wait/synch/mutex/group_rpl/GCS_Gcs_xcom_view_change_control::m_wait_for_view_mutex YES YES singleton NULL 0 NULL |
| 51 |
include/assert.inc ['There should be 9 GCS instrumented cond entries in the cond_instances table after starting the GR'] |
| 52 |
SELECT NAME FROM performance_schema.cond_instances WHERE NAME LIKE "wait/synch/cond/group_rpl/GCS_%" ORDER BY NAME; |
| 53 |
NAME |
| 54 |
wait/synch/cond/group_rpl/GCS_Gcs_async_buffer::m_free_buffer_cond |
| 55 |
wait/synch/cond/group_rpl/GCS_Gcs_async_buffer::m_wait_for_events_cond |
| 56 |
wait/synch/cond/group_rpl/GCS_Gcs_suspicions_manager::m_suspicions_cond |
| 57 |
wait/synch/cond/group_rpl/GCS_Gcs_xcom_engine::m_wait_for_notification_cond |
| 58 |
wait/synch/cond/group_rpl/GCS_Gcs_xcom_interface::m_wait_for_ssl_init_cond |
| 59 |
wait/synch/cond/group_rpl/GCS_Gcs_xcom_proxy_impl::m_cond_xcom_comms_status |
| 60 |
wait/synch/cond/group_rpl/GCS_Gcs_xcom_proxy_impl::m_cond_xcom_exit |
| 61 |
wait/synch/cond/group_rpl/GCS_Gcs_xcom_proxy_impl::m_cond_xcom_ready |
| 62 |
wait/synch/cond/group_rpl/GCS_Gcs_xcom_view_change_control::m_wait_for_view_cond |
| 63 |
include/assert.inc ['There should be 12 GCS instrumented mutex entries in the mutex_instances table after starting the GR'] |
| 64 |
SELECT NAME FROM performance_schema.mutex_instances WHERE NAME LIKE "wait/synch/mutex/group_rpl/GCS_%" ORDER BY NAME; |
| 65 |
NAME |
| 66 |
wait/synch/mutex/group_rpl/GCS_Gcs_async_buffer::m_free_buffer_mutex |
| 67 |
wait/synch/mutex/group_rpl/GCS_Gcs_suspicions_manager::m_suspicions_mutex |
| 68 |
wait/synch/mutex/group_rpl/GCS_Gcs_suspicions_manager::m_suspicions_parameters_mutex |
| 69 |
wait/synch/mutex/group_rpl/GCS_Gcs_xcom_engine::m_wait_for_notification_mutex |
| 70 |
wait/synch/mutex/group_rpl/GCS_Gcs_xcom_group_management::m_nodes_mutex |
| 71 |
wait/synch/mutex/group_rpl/GCS_Gcs_xcom_interface::m_wait_for_ssl_init_mutex |
| 72 |
wait/synch/mutex/group_rpl/GCS_Gcs_xcom_proxy_impl::m_lock_xcom_comms_status |
| 73 |
wait/synch/mutex/group_rpl/GCS_Gcs_xcom_proxy_impl::m_lock_xcom_exit |
| 74 |
wait/synch/mutex/group_rpl/GCS_Gcs_xcom_proxy_impl::m_lock_xcom_ready |
| 75 |
wait/synch/mutex/group_rpl/GCS_Gcs_xcom_view_change_control::m_current_view_mutex |
| 76 |
wait/synch/mutex/group_rpl/GCS_Gcs_xcom_view_change_control::m_joining_leaving_mutex |
| 77 |
wait/synch/mutex/group_rpl/GCS_Gcs_xcom_view_change_control::m_wait_for_view_mutex |
| 78 |
|
| 79 |
############################################################ |
| 80 |
# 4. Stop the GR |
| 81 |
include/stop_group_replication.inc |
| 82 |
|
| 83 |
############################################################ |
| 84 |
# 5. Verify that the entries corresponding to the |
| 85 |
# instrumented GCS mutexes and conds remain in the |
| 86 |
# setup_instruments table, and that no corresponding |
| 87 |
# instances remain in the mutex_instances and |
| 88 |
# cond_instances tables after stopping the GR. |
| 89 |
include/assert.inc ['There should be the same 21 GCS instrumented mutex and cond entries in the setup_instruments table after stopping the GR'] |
| 90 |
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; |
| 91 |
NAME ENABLED TIMED PROPERTIES FLAGS VOLATILITY DOCUMENTATION |
| 92 |
wait/synch/cond/group_rpl/GCS_Gcs_async_buffer::m_free_buffer_cond YES YES singleton NULL 0 NULL |
| 93 |
wait/synch/cond/group_rpl/GCS_Gcs_async_buffer::m_wait_for_events_cond YES YES singleton NULL 0 NULL |
| 94 |
wait/synch/cond/group_rpl/GCS_Gcs_suspicions_manager::m_suspicions_cond YES YES singleton NULL 0 NULL |
| 95 |
wait/synch/cond/group_rpl/GCS_Gcs_xcom_engine::m_wait_for_notification_cond YES YES singleton NULL 0 NULL |
| 96 |
wait/synch/cond/group_rpl/GCS_Gcs_xcom_interface::m_wait_for_ssl_init_cond YES YES singleton NULL 0 NULL |
| 97 |
wait/synch/cond/group_rpl/GCS_Gcs_xcom_proxy_impl::m_cond_xcom_comms_status YES YES singleton NULL 0 NULL |
| 98 |
wait/synch/cond/group_rpl/GCS_Gcs_xcom_proxy_impl::m_cond_xcom_exit YES YES singleton NULL 0 NULL |
| 99 |
wait/synch/cond/group_rpl/GCS_Gcs_xcom_proxy_impl::m_cond_xcom_ready YES YES singleton NULL 0 NULL |
| 100 |
wait/synch/cond/group_rpl/GCS_Gcs_xcom_view_change_control::m_wait_for_view_cond YES YES singleton NULL 0 NULL |
| 101 |
wait/synch/mutex/group_rpl/GCS_Gcs_async_buffer::m_free_buffer_mutex YES YES singleton NULL 0 NULL |
| 102 |
wait/synch/mutex/group_rpl/GCS_Gcs_suspicions_manager::m_suspicions_mutex YES YES singleton NULL 0 NULL |
| 103 |
wait/synch/mutex/group_rpl/GCS_Gcs_suspicions_manager::m_suspicions_parameters_mutex YES YES singleton NULL 0 NULL |
| 104 |
wait/synch/mutex/group_rpl/GCS_Gcs_xcom_engine::m_wait_for_notification_mutex YES YES singleton NULL 0 NULL |
| 105 |
wait/synch/mutex/group_rpl/GCS_Gcs_xcom_group_management::m_nodes_mutex YES YES singleton NULL 0 NULL |
| 106 |
wait/synch/mutex/group_rpl/GCS_Gcs_xcom_interface::m_wait_for_ssl_init_mutex YES YES singleton NULL 0 NULL |
| 107 |
wait/synch/mutex/group_rpl/GCS_Gcs_xcom_proxy_impl::m_lock_xcom_comms_status YES YES singleton NULL 0 NULL |
| 108 |
wait/synch/mutex/group_rpl/GCS_Gcs_xcom_proxy_impl::m_lock_xcom_exit YES YES singleton NULL 0 NULL |
| 109 |
wait/synch/mutex/group_rpl/GCS_Gcs_xcom_proxy_impl::m_lock_xcom_ready YES YES singleton NULL 0 NULL |
| 110 |
wait/synch/mutex/group_rpl/GCS_Gcs_xcom_view_change_control::m_current_view_mutex YES YES singleton NULL 0 NULL |
| 111 |
wait/synch/mutex/group_rpl/GCS_Gcs_xcom_view_change_control::m_joining_leaving_mutex YES YES singleton NULL 0 NULL |
| 112 |
wait/synch/mutex/group_rpl/GCS_Gcs_xcom_view_change_control::m_wait_for_view_mutex YES YES singleton NULL 0 NULL |
| 113 |
include/assert.inc ['There should be no GCS instrumented mutex entries in the mutex_instances table after stopping the GR'] |
| 114 |
include/assert.inc ['There should be no GCS instrumented cond entries in the cond_instances table after stopping the GR'] |
| 115 |
|
| 116 |
############################################################ |
| 117 |
# 6. Test end. |
| 118 |
include/group_replication_end.inc |