| 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 performance schema keys are available in instrument |
| 9 |
# table immediately after plugin installation |
| 10 |
# (before starting the GR). |
| 11 |
SELECT * FROM performance_schema.setup_instruments WHERE NAME LIKE '%group_rpl%' AND NAME NOT LIKE 'wait/synch/%/group_rpl/GCS_%' AND NAME NOT LIKE 'memory/group_rpl/gcs_%'; |
| 12 |
NAME ENABLED TIMED PROPERTIES FLAGS VOLATILITY DOCUMENTATION |
| 13 |
wait/synch/mutex/group_rpl/LOCK_applier_module_run YES YES singleton NULL 0 NULL |
| 14 |
wait/synch/mutex/group_rpl/LOCK_applier_module_suspend YES YES singleton NULL 0 NULL |
| 15 |
wait/synch/mutex/group_rpl/LOCK_autorejoin_module YES YES singleton NULL 0 NULL |
| 16 |
wait/synch/mutex/group_rpl/LOCK_certifier_broadcast_run YES YES singleton NULL 0 NULL |
| 17 |
wait/synch/mutex/group_rpl/LOCK_certifier_broadcast_dispatcher_run YES YES singleton NULL 0 NULL |
| 18 |
wait/synch/mutex/group_rpl/LOCK_certification_info YES YES singleton NULL 0 NULL |
| 19 |
wait/synch/mutex/group_rpl/LOCK_certification_members YES YES singleton NULL 0 NULL |
| 20 |
wait/synch/mutex/group_rpl/LOCK_channel_observation_list YES YES singleton NULL 0 NULL |
| 21 |
wait/synch/mutex/group_rpl/LOCK_channel_observation_removal YES YES singleton NULL 0 NULL |
| 22 |
wait/synch/mutex/group_rpl/LOCK_clone_donor_list YES YES singleton NULL 0 NULL |
| 23 |
wait/synch/mutex/group_rpl/LOCK_clone_handler_run YES YES singleton NULL 0 NULL |
| 24 |
wait/synch/mutex/group_rpl/LOCK_clone_query YES YES singleton NULL 0 NULL |
| 25 |
wait/synch/mutex/group_rpl/LOCK_clone_read_mode YES YES singleton NULL 0 NULL |
| 26 |
wait/synch/mutex/group_rpl/LOCK_count_down_latch YES YES singleton NULL 0 NULL |
| 27 |
wait/synch/mutex/group_rpl/LOCK_delayed_init_run YES YES singleton NULL 0 NULL |
| 28 |
wait/synch/mutex/group_rpl/LOCK_delayed_init_server_ready YES YES singleton NULL 0 NULL |
| 29 |
wait/synch/mutex/group_rpl/LOCK_force_members_running YES YES singleton NULL 0 NULL |
| 30 |
wait/synch/mutex/group_rpl/key_GR_LOCK_group_action_coordinator_process YES YES singleton NULL 0 NULL |
| 31 |
wait/synch/mutex/group_rpl/key_GR_LOCK_group_action_coordinator_thread YES YES singleton NULL 0 NULL |
| 32 |
wait/synch/mutex/group_rpl/key_GR_LOCK_group_action_coordinator_thread_end YES YES singleton NULL 0 NULL |
| 33 |
wait/synch/mutex/group_rpl/LOCK_group_info_manager YES YES singleton NULL 0 NULL |
| 34 |
wait/synch/mutex/group_rpl/key_GR_LOCK_group_part_handler_abort YES YES singleton NULL 0 NULL |
| 35 |
wait/synch/mutex/group_rpl/key_GR_LOCK_group_part_handler_run YES YES singleton NULL 0 NULL |
| 36 |
wait/synch/mutex/group_rpl/LOCK_multi_primary_action_notification YES YES singleton NULL 0 NULL |
| 37 |
wait/synch/mutex/group_rpl/LOCK_pipeline_continuation YES YES singleton NULL 0 NULL |
| 38 |
wait/synch/mutex/group_rpl/LOCK_pipeline_stats_flow_control YES YES singleton NULL 0 NULL |
| 39 |
wait/synch/mutex/group_rpl/LOCK_pipeline_stats_transactions_waiting_apply YES YES singleton NULL 0 NULL |
| 40 |
wait/synch/mutex/group_rpl/LOCK_plugin_modules_termination YES YES singleton NULL 0 NULL |
| 41 |
wait/synch/mutex/group_rpl/LOCK_plugin_applier_module_initialize_terminate YES YES singleton NULL 0 NULL |
| 42 |
wait/synch/mutex/group_rpl/LOCK_plugin_online YES YES singleton NULL 0 NULL |
| 43 |
wait/synch/mutex/group_rpl/LOCK_primary_election_action_phase YES YES singleton NULL 0 NULL |
| 44 |
wait/synch/mutex/group_rpl/LOCK_primary_election_action_notification YES YES singleton NULL 0 NULL |
| 45 |
wait/synch/mutex/group_rpl/LOCK_primary_election_primary_process_run YES YES singleton NULL 0 NULL |
| 46 |
wait/synch/mutex/group_rpl/LOCK_primary_election_running_flag YES YES singleton NULL 0 NULL |
| 47 |
wait/synch/mutex/group_rpl/LOCK_primary_election_secondary_process_run YES YES singleton NULL 0 NULL |
| 48 |
wait/synch/mutex/group_rpl/LOCK_primary_election_validation_notification YES YES singleton NULL 0 NULL |
| 49 |
wait/synch/mutex/group_rpl/LOCK_primary_promotion_policy YES YES singleton NULL 0 NULL |
| 50 |
wait/synch/mutex/group_rpl/LOCK_recovery YES YES singleton NULL 0 NULL |
| 51 |
wait/synch/mutex/group_rpl/LOCK_recovery_donor_selection YES YES singleton NULL 0 NULL |
| 52 |
wait/synch/mutex/group_rpl/LOCK_recovery_module_run YES YES singleton NULL 0 NULL |
| 53 |
wait/synch/mutex/group_rpl/LOCK_server_ongoing_transaction_handler YES YES singleton NULL 0 NULL |
| 54 |
wait/synch/mutex/group_rpl/LOCK_message_service_run YES YES singleton NULL 0 NULL |
| 55 |
wait/synch/mutex/group_rpl/LOCK_session_thread_method_exec YES YES singleton NULL 0 NULL |
| 56 |
wait/synch/mutex/group_rpl/LOCK_session_thread_run YES YES singleton NULL 0 NULL |
| 57 |
wait/synch/mutex/group_rpl/LOCK_stage_monitor_handler YES YES singleton NULL 0 NULL |
| 58 |
wait/synch/mutex/group_rpl/LOCK_synchronized_queue YES YES singleton NULL 0 NULL |
| 59 |
wait/synch/mutex/group_rpl/LOCK_transaction_monitoring YES YES singleton NULL 0 NULL |
| 60 |
wait/synch/mutex/group_rpl/LOCK_transaction_unblocking YES YES singleton NULL 0 NULL |
| 61 |
wait/synch/mutex/group_rpl/LOCK_group_member_info_manager_update_lock YES YES singleton NULL 0 NULL |
| 62 |
wait/synch/mutex/group_rpl/LOCK_group_member_info_update_lock YES YES singleton NULL 0 NULL |
| 63 |
wait/synch/mutex/group_rpl/LOCK_view_modification_wait YES YES singleton NULL 0 NULL |
| 64 |
wait/synch/mutex/group_rpl/LOCK_wait_ticket YES YES singleton NULL 0 NULL |
| 65 |
wait/synch/mutex/group_rpl/LOCK_write_lock_protection YES YES singleton NULL 0 NULL |
| 66 |
wait/synch/mutex/group_rpl/LOCK_mysql_thread_run YES YES singleton NULL 0 NULL |
| 67 |
wait/synch/mutex/group_rpl/LOCK_mysql_thread_dispatcher_run YES YES singleton NULL 0 NULL |
| 68 |
wait/synch/mutex/group_rpl/LOCK_connection_map YES YES singleton NULL 0 NULL |
| 69 |
wait/synch/mutex/group_rpl/LOCK_mysql_handler_thread_run YES YES singleton NULL 0 NULL |
| 70 |
wait/synch/mutex/group_rpl/LOCK_mysql_thread_handler_dispatcher_run YES YES singleton NULL 0 NULL |
| 71 |
wait/synch/mutex/group_rpl/LOCK_mysql_handler_thread_read_only_mode_run YES YES singleton NULL 0 NULL |
| 72 |
wait/synch/mutex/group_rpl/LOCK_mysql_thread_handler_read_only_mode_dispatcher_run YES YES singleton NULL 0 NULL |
| 73 |
wait/synch/rwlock/group_rpl/RWLOCK_certifier_stable_gtid_set YES YES singleton NULL 0 NULL |
| 74 |
wait/synch/rwlock/group_rpl/RWLOCK_channel_observation_list YES YES singleton NULL 0 NULL |
| 75 |
wait/synch/rwlock/group_rpl/RWLOCK_gcs_operations YES YES singleton NULL 0 NULL |
| 76 |
wait/synch/rwlock/group_rpl/RWLOCK_gcs_operations_view_change_observers YES YES singleton NULL 0 NULL |
| 77 |
wait/synch/rwlock/group_rpl/RWLOCK_group_event_observation_list YES YES singleton NULL 0 NULL |
| 78 |
wait/synch/rwlock/group_rpl/RWLOCK_io_cache_unused_list YES YES singleton NULL 0 NULL |
| 79 |
wait/synch/rwlock/group_rpl/RWLOCK_plugin_running YES YES singleton NULL 0 NULL |
| 80 |
wait/synch/rwlock/group_rpl/RWLOCK_plugin_stop YES YES singleton NULL 0 NULL |
| 81 |
wait/synch/rwlock/group_rpl/RWLOCK_transaction_observation_list YES YES singleton NULL 0 NULL |
| 82 |
wait/synch/rwlock/group_rpl/RWLOCK_transaction_consistency_manager_map YES YES singleton NULL 0 NULL |
| 83 |
wait/synch/rwlock/group_rpl/RWLOCK_transaction_consistency_manager_prepared_transactions_on_my_applier YES YES singleton NULL 0 NULL |
| 84 |
wait/synch/rwlock/group_rpl/RWLOCK_flow_control_module_info YES YES singleton NULL 0 NULL |
| 85 |
wait/synch/rwlock/group_rpl/RWLOCK_transaction_consistency_info_members_that_must_prepare_the_transaction YES YES singleton NULL 0 NULL |
| 86 |
wait/synch/cond/group_rpl/COND_applier_module_run YES YES singleton NULL 0 NULL |
| 87 |
wait/synch/cond/group_rpl/COND_applier_module_suspend YES YES singleton NULL 0 NULL |
| 88 |
wait/synch/cond/group_rpl/COND_applier_module_wait YES YES singleton NULL 0 NULL |
| 89 |
wait/synch/cond/group_rpl/COND_certifier_broadcast_run YES YES singleton NULL 0 NULL |
| 90 |
wait/synch/cond/group_rpl/COND_certifier_broadcast_dispatcher_run YES YES singleton NULL 0 NULL |
| 91 |
wait/synch/cond/group_rpl/COND_clone_handler_run YES YES singleton NULL 0 NULL |
| 92 |
wait/synch/cond/group_rpl/COND_delayed_init_run YES YES singleton NULL 0 NULL |
| 93 |
wait/synch/cond/group_rpl/COND_delayed_init_server_ready YES YES singleton NULL 0 NULL |
| 94 |
wait/synch/cond/group_rpl/COND_group_action_coordinator_process YES YES singleton NULL 0 NULL |
| 95 |
wait/synch/cond/group_rpl/COND_group_action_coordinator_thread YES YES singleton NULL 0 NULL |
| 96 |
wait/synch/cond/group_rpl/COND_group_action_coordinator_thread_end YES YES singleton NULL 0 NULL |
| 97 |
wait/synch/cond/group_rpl/COND_group_part_handler_run YES YES singleton NULL 0 NULL |
| 98 |
wait/synch/cond/group_rpl/COND_group_part_handler_abort YES YES singleton NULL 0 NULL |
| 99 |
wait/synch/cond/group_rpl/COND_message_service_run YES YES singleton NULL 0 NULL |
| 100 |
wait/synch/cond/group_rpl/COND_multi_primary_action_notification YES YES singleton NULL 0 NULL |
| 101 |
wait/synch/cond/group_rpl/COND_transaction_monitoring_wait YES YES singleton NULL 0 NULL |
| 102 |
wait/synch/cond/group_rpl/COND_view_modification_wait YES YES singleton NULL 0 NULL |
| 103 |
wait/synch/cond/group_rpl/COND_pipeline_continuation YES YES singleton NULL 0 NULL |
| 104 |
wait/synch/cond/group_rpl/COND_synchronized_queue YES YES singleton NULL 0 NULL |
| 105 |
wait/synch/cond/group_rpl/COND_count_down_latch YES YES singleton NULL 0 NULL |
| 106 |
wait/synch/cond/group_rpl/COND_wait_ticket YES YES singleton NULL 0 NULL |
| 107 |
wait/synch/cond/group_rpl/COND_recovery_module_run YES YES singleton NULL 0 NULL |
| 108 |
wait/synch/cond/group_rpl/COND_recovery YES YES singleton NULL 0 NULL |
| 109 |
wait/synch/cond/group_rpl/COND_session_thread_method_exec YES YES singleton NULL 0 NULL |
| 110 |
wait/synch/cond/group_rpl/COND_session_thread_run YES YES singleton NULL 0 NULL |
| 111 |
wait/synch/cond/group_rpl/COND_pipeline_stats_flow_control YES YES singleton NULL 0 NULL |
| 112 |
wait/synch/cond/group_rpl/COND_primary_election_action_notification YES YES singleton NULL 0 NULL |
| 113 |
wait/synch/cond/group_rpl/COND_primary_election_primary_process_run YES YES singleton NULL 0 NULL |
| 114 |
wait/synch/cond/group_rpl/COND_primary_election_secondary_process_run YES YES singleton NULL 0 NULL |
| 115 |
wait/synch/cond/group_rpl/COND_primary_election_validation_notification YES YES singleton NULL 0 NULL |
| 116 |
wait/synch/cond/group_rpl/COND_write_lock_protection YES YES singleton NULL 0 NULL |
| 117 |
wait/synch/cond/group_rpl/COND_plugin_online YES YES singleton NULL 0 NULL |
| 118 |
wait/synch/cond/group_rpl/COND_primary_promotion_policy YES YES singleton NULL 0 NULL |
| 119 |
wait/synch/cond/group_rpl/COND_autorejoin_module YES YES singleton NULL 0 NULL |
| 120 |
wait/synch/cond/group_rpl/COND_mysql_thread_run YES YES singleton NULL 0 NULL |
| 121 |
wait/synch/cond/group_rpl/COND_mysql_thread_dispatcher_run YES YES singleton NULL 0 NULL |
| 122 |
wait/synch/cond/group_rpl/COND_mysql_thread_handler_run YES YES singleton NULL 0 NULL |
| 123 |
wait/synch/cond/group_rpl/COND_mysql_thread_handler_dispatcher_run YES YES singleton NULL 0 NULL |
| 124 |
wait/synch/cond/group_rpl/COND_mysql_thread_handler_read_only_mode_run YES YES singleton NULL 0 NULL |
| 125 |
wait/synch/cond/group_rpl/COND_mysql_thread_handler_read_only_mode_dispatcher_run YES YES singleton NULL 0 NULL |
| 126 |
stage/group_rpl/Undergoing auto-rejoin procedure YES YES progress NULL 0 NULL |
| 127 |
stage/group_rpl/Multi-primary Switch: waiting for pending transactions to finish YES YES progress NULL 0 NULL |
| 128 |
stage/group_rpl/Multi-primary Switch: waiting on another member step completion YES YES progress NULL 0 NULL |
| 129 |
stage/group_rpl/Multi-primary Switch: applying buffered transactions YES YES progress NULL 0 NULL |
| 130 |
stage/group_rpl/Multi-primary Switch: waiting for operation to complete on all members YES YES progress NULL 0 NULL |
| 131 |
stage/group_rpl/Primary Election: applying buffered transactions YES YES progress NULL 0 NULL |
| 132 |
stage/group_rpl/Primary Election: waiting on current primary transaction execution YES YES progress NULL 0 NULL |
| 133 |
stage/group_rpl/Primary Election: waiting for members to enable super_read_only YES YES progress NULL 0 NULL |
| 134 |
stage/group_rpl/Primary Election: stabilizing transactions from former primaries YES YES progress NULL 0 NULL |
| 135 |
stage/group_rpl/Primary Switch: checking current primary pre-conditions YES YES progress NULL 0 NULL |
| 136 |
stage/group_rpl/Primary Switch: waiting for pending transactions to finish YES YES progress NULL 0 NULL |
| 137 |
stage/group_rpl/Primary Switch: executing Primary election YES YES progress NULL 0 NULL |
| 138 |
stage/group_rpl/Primary Switch: waiting on another member step completion YES YES progress NULL 0 NULL |
| 139 |
stage/group_rpl/Primary Switch: waiting for operation to complete on all members YES YES progress NULL 0 NULL |
| 140 |
stage/group_rpl/Single-primary Switch: checking group pre-conditions YES YES progress NULL 0 NULL |
| 141 |
stage/group_rpl/Single-primary Switch: executing Primary election YES YES progress NULL 0 NULL |
| 142 |
stage/group_rpl/Single-primary Switch: waiting for operation to complete on all members YES YES progress NULL 0 NULL |
| 143 |
stage/group_rpl/Group Replication Module: Executing YES YES NULL 0 NULL |
| 144 |
stage/group_rpl/Group Replication Module: Suspending YES YES NULL 0 NULL |
| 145 |
stage/group_rpl/Group Replication Recovery: Connecting to donor YES YES NULL 0 NULL |
| 146 |
stage/group_rpl/Group Replication Recovery: Transferring state from donor YES YES NULL 0 NULL |
| 147 |
stage/group_rpl/Group Replication Cloning process: Preparing YES YES progress NULL 0 NULL |
| 148 |
stage/group_rpl/Group Replication Cloning process: Executing YES YES progress NULL 0 NULL |
| 149 |
memory/group_rpl/write_set_encoded YES NULL global_statistics 0 Memory used to encode write set before getting broadcasted to group members. |
| 150 |
memory/group_rpl/certification_data YES NULL global_statistics 0 Memory gets allocated for this Event name when new incoming transaction is received for certification. |
| 151 |
memory/group_rpl/certification_data_gc YES NULL global_statistics 0 Memory used to hold the GTID_EXECUTED sent by each member for garbage collection. |
| 152 |
memory/group_rpl/certification_info YES NULL global_statistics 0 Memory used to store certification information which is used to handle conflict resolution between transactions that execute concurrently. |
| 153 |
memory/group_rpl/transaction_data YES NULL global_statistics 0 Memory gets allocated for this Event name when the incoming transaction is queued to be handled by the plugin pipeline. |
| 154 |
memory/group_rpl/sql_service_command_data YES NULL global_statistics 0 Memory gets allocated when internal sql service commands is added to queue to process in orderly manner. |
| 155 |
memory/group_rpl/mysql_thread_queued_task YES NULL global_statistics 0 Memory gets allocated when a Mysql_thread dependent task is added to queue to process in orderly manner. |
| 156 |
memory/group_rpl/message_service_queue YES NULL global_statistics 0 Memory gets allocated when messages of Group Replication: delivery message service are added to deliver them in orderly manner. |
| 157 |
memory/group_rpl/message_service_received_message YES NULL global_statistics 0 Memory used to receive messages for Group Replication: delivery message service. |
| 158 |
memory/group_rpl/group_member_info YES NULL global_statistics 0 Memory used to hold properties of a group member like hostname, port, member weight, member role (primary/secondary) |
| 159 |
memory/group_rpl/consistent_members_that_must_prepare_transaction YES NULL global_statistics 0 Memory used to hold list of members that must prepare the transaction for the Group Replication Transaction Consistency Guarantees. |
| 160 |
memory/group_rpl/consistent_transactions YES NULL global_statistics 0 Memory used to hold transaction and list of members that must prepare that transaction for the Group Replication Transaction Consistency Guarantees. |
| 161 |
memory/group_rpl/consistent_transactions_prepared YES NULL global_statistics 0 Memory used to hold list of transaction info which are prepared for the Group Replication Transaction Consistency Guarantees. |
| 162 |
memory/group_rpl/consistent_transactions_waiting YES NULL global_statistics 0 Memory used to hold list of transaction info if there are precedent prepared transactions with consistency AFTER and BEFORE_AND_AFTER to hold the transaction until the prepared are committed. |
| 163 |
memory/group_rpl/consistent_transactions_delayed_view_change YES NULL global_statistics 0 Memory used to hold list of View_change_log_event which are delayed after the prepared consistent transactions waiting for the prepare acknowledge. |
| 164 |
|
| 165 |
############################################################ |
| 166 |
# 2. Start the GR |
| 167 |
include/start_and_bootstrap_group_replication.inc |
| 168 |
|
| 169 |
############################################################ |
| 170 |
# 3. Verify that there are no extra psi keys that were added |
| 171 |
# after starting the GR |
| 172 |
include/assert.inc ['There should be no extra psi keys added after starting the GR'] |
| 173 |
|
| 174 |
############################################################ |
| 175 |
# 4. Verify that performance_schema.threads list the usual |
| 176 |
# threads after member is ONLINE. |
| 177 |
SELECT NAME, TYPE, INSTRUMENTED FROM performance_schema.threads WHERE NAME LIKE '%group_rpl%' ORDER BY NAME; |
| 178 |
NAME TYPE INSTRUMENTED |
| 179 |
thread/group_rpl/THD_applier_module_receiver FOREGROUND YES |
| 180 |
thread/group_rpl/THD_certifier_broadcast BACKGROUND YES |
| 181 |
thread/group_rpl/THD_Gcs_ext_logger_impl::m_consumer BACKGROUND YES |
| 182 |
thread/group_rpl/THD_Gcs_xcom_control::m_suspicions_processing_thread BACKGROUND YES |
| 183 |
thread/group_rpl/THD_Gcs_xcom_control::m_xcom_thread BACKGROUND YES |
| 184 |
thread/group_rpl/THD_Gcs_xcom_engine::m_engine_thread BACKGROUND YES |
| 185 |
thread/group_rpl/THD_message_service_handler BACKGROUND YES |
| 186 |
thread/group_rpl/THD_mysql_thread BACKGROUND YES |
| 187 |
thread/group_rpl/THD_mysql_thread_handler BACKGROUND YES |
| 188 |
thread/group_rpl/THD_mysql_thread_handler_read_only_mode BACKGROUND YES |
| 189 |
|
| 190 |
############################################################ |
| 191 |
# 5. Test end. |
| 192 |
include/group_replication_end.inc |