145 lines
11 KiB
Plaintext
145 lines
11 KiB
Plaintext
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 master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information.
|
|
[connection server1]
|
|
|
|
############################################################
|
|
# 1. verify that performance schema keys are available in instrument
|
|
# table immediately after plugin installation
|
|
# (before starting the GR).
|
|
SELECT * FROM performance_schema.setup_instruments WHERE NAME LIKE '%group_rpl%' AND NAME NOT LIKE 'wait/synch/%/group_rpl/GCS_%' AND NAME NOT LIKE '%GCS_XCom::xcom_cache%';
|
|
NAME ENABLED TIMED PROPERTIES VOLATILITY DOCUMENTATION
|
|
wait/synch/mutex/group_rpl/LOCK_applier_module_run YES YES singleton 0 NULL
|
|
wait/synch/mutex/group_rpl/LOCK_applier_module_suspend YES YES singleton 0 NULL
|
|
wait/synch/mutex/group_rpl/LOCK_autorejoin_module YES YES singleton 0 NULL
|
|
wait/synch/mutex/group_rpl/LOCK_certifier_broadcast_run YES YES singleton 0 NULL
|
|
wait/synch/mutex/group_rpl/LOCK_certifier_broadcast_dispatcher_run YES YES singleton 0 NULL
|
|
wait/synch/mutex/group_rpl/LOCK_certification_info YES YES singleton 0 NULL
|
|
wait/synch/mutex/group_rpl/LOCK_certification_members YES YES singleton 0 NULL
|
|
wait/synch/mutex/group_rpl/LOCK_channel_observation_list YES YES singleton 0 NULL
|
|
wait/synch/mutex/group_rpl/LOCK_channel_observation_removal YES YES singleton 0 NULL
|
|
wait/synch/mutex/group_rpl/LOCK_clone_donor_list YES YES singleton 0 NULL
|
|
wait/synch/mutex/group_rpl/LOCK_clone_handler_run YES YES singleton 0 NULL
|
|
wait/synch/mutex/group_rpl/LOCK_clone_query YES YES singleton 0 NULL
|
|
wait/synch/mutex/group_rpl/LOCK_clone_read_mode YES YES singleton 0 NULL
|
|
wait/synch/mutex/group_rpl/LOCK_count_down_latch YES YES singleton 0 NULL
|
|
wait/synch/mutex/group_rpl/LOCK_delayed_init_run YES YES singleton 0 NULL
|
|
wait/synch/mutex/group_rpl/LOCK_delayed_init_server_ready YES YES singleton 0 NULL
|
|
wait/synch/mutex/group_rpl/LOCK_force_members_running YES YES singleton 0 NULL
|
|
wait/synch/mutex/group_rpl/key_GR_LOCK_group_action_coordinator_process YES YES singleton 0 NULL
|
|
wait/synch/mutex/group_rpl/key_GR_LOCK_group_action_coordinator_thread YES YES singleton 0 NULL
|
|
wait/synch/mutex/group_rpl/key_GR_LOCK_group_action_coordinator_thread_end YES YES singleton 0 NULL
|
|
wait/synch/mutex/group_rpl/LOCK_group_info_manager YES YES singleton 0 NULL
|
|
wait/synch/mutex/group_rpl/key_GR_LOCK_group_part_handler_abort YES YES singleton 0 NULL
|
|
wait/synch/mutex/group_rpl/key_GR_LOCK_group_part_handler_run YES YES singleton 0 NULL
|
|
wait/synch/mutex/group_rpl/LOCK_multi_primary_action_notification YES YES singleton 0 NULL
|
|
wait/synch/mutex/group_rpl/LOCK_pipeline_continuation YES YES singleton 0 NULL
|
|
wait/synch/mutex/group_rpl/LOCK_pipeline_stats_flow_control YES YES singleton 0 NULL
|
|
wait/synch/mutex/group_rpl/LOCK_pipeline_stats_transactions_waiting_apply YES YES singleton 0 NULL
|
|
wait/synch/mutex/group_rpl/LOCK_plugin_modules_termination YES YES singleton 0 NULL
|
|
wait/synch/mutex/group_rpl/LOCK_plugin_online YES YES singleton 0 NULL
|
|
wait/synch/mutex/group_rpl/LOCK_plugin_running YES YES singleton 0 NULL
|
|
wait/synch/mutex/group_rpl/LOCK_primary_election_action_phase YES YES singleton 0 NULL
|
|
wait/synch/mutex/group_rpl/LOCK_primary_election_action_notification YES YES singleton 0 NULL
|
|
wait/synch/mutex/group_rpl/LOCK_primary_election_primary_process_run YES YES singleton 0 NULL
|
|
wait/synch/mutex/group_rpl/LOCK_primary_election_running_flag YES YES singleton 0 NULL
|
|
wait/synch/mutex/group_rpl/LOCK_primary_election_secondary_process_run YES YES singleton 0 NULL
|
|
wait/synch/mutex/group_rpl/LOCK_primary_election_validation_notification YES YES singleton 0 NULL
|
|
wait/synch/mutex/group_rpl/LOCK_primary_promotion_policy YES YES singleton 0 NULL
|
|
wait/synch/mutex/group_rpl/LOCK_recovery YES YES singleton 0 NULL
|
|
wait/synch/mutex/group_rpl/LOCK_recovery_donor_selection YES YES singleton 0 NULL
|
|
wait/synch/mutex/group_rpl/LOCK_recovery_module_run YES YES singleton 0 NULL
|
|
wait/synch/mutex/group_rpl/LOCK_server_ongoing_transaction_handler YES YES singleton 0 NULL
|
|
wait/synch/mutex/group_rpl/LOCK_message_service_run YES YES singleton 0 NULL
|
|
wait/synch/mutex/group_rpl/LOCK_session_thread_method_exec YES YES singleton 0 NULL
|
|
wait/synch/mutex/group_rpl/LOCK_session_thread_run YES YES singleton 0 NULL
|
|
wait/synch/mutex/group_rpl/LOCK_stage_monitor_handler YES YES singleton 0 NULL
|
|
wait/synch/mutex/group_rpl/LOCK_synchronized_queue YES YES singleton 0 NULL
|
|
wait/synch/mutex/group_rpl/LOCK_transaction_unblocking YES YES singleton 0 NULL
|
|
wait/synch/mutex/group_rpl/LOCK_group_member_info_manager_update_lock YES YES singleton 0 NULL
|
|
wait/synch/mutex/group_rpl/LOCK_group_member_info_update_lock YES YES singleton 0 NULL
|
|
wait/synch/mutex/group_rpl/LOCK_view_modification_wait YES YES singleton 0 NULL
|
|
wait/synch/mutex/group_rpl/LOCK_wait_ticket YES YES singleton 0 NULL
|
|
wait/synch/mutex/group_rpl/LOCK_write_lock_protection YES YES singleton 0 NULL
|
|
wait/synch/rwlock/group_rpl/RWLOCK_certifier_stable_gtid_set YES YES singleton 0 NULL
|
|
wait/synch/rwlock/group_rpl/RWLOCK_channel_observation_list YES YES singleton 0 NULL
|
|
wait/synch/rwlock/group_rpl/RWLOCK_gcs_operations YES YES singleton 0 NULL
|
|
wait/synch/rwlock/group_rpl/RWLOCK_gcs_operations_finalize_ongoing YES YES singleton 0 NULL
|
|
wait/synch/rwlock/group_rpl/RWLOCK_gcs_operations_view_change_observers YES YES singleton 0 NULL
|
|
wait/synch/rwlock/group_rpl/RWLOCK_group_event_observation_list YES YES singleton 0 NULL
|
|
wait/synch/rwlock/group_rpl/RWLOCK_io_cache_unused_list YES YES singleton 0 NULL
|
|
wait/synch/rwlock/group_rpl/RWLOCK_plugin_stop YES YES singleton 0 NULL
|
|
wait/synch/rwlock/group_rpl/RWLOCK_transaction_observation_list YES YES singleton 0 NULL
|
|
wait/synch/rwlock/group_rpl/RWLOCK_transaction_consistency_manager_map YES YES singleton 0 NULL
|
|
wait/synch/rwlock/group_rpl/RWLOCK_transaction_consistency_manager_prepared_transactions_on_my_applier YES YES singleton 0 NULL
|
|
wait/synch/cond/group_rpl/COND_applier_module_run YES YES singleton 0 NULL
|
|
wait/synch/cond/group_rpl/COND_applier_module_suspend YES YES singleton 0 NULL
|
|
wait/synch/cond/group_rpl/COND_applier_module_wait YES YES singleton 0 NULL
|
|
wait/synch/cond/group_rpl/COND_certifier_broadcast_run YES YES singleton 0 NULL
|
|
wait/synch/cond/group_rpl/COND_certifier_broadcast_dispatcher_run YES YES singleton 0 NULL
|
|
wait/synch/cond/group_rpl/COND_clone_handler_run YES YES singleton 0 NULL
|
|
wait/synch/cond/group_rpl/COND_delayed_init_run YES YES singleton 0 NULL
|
|
wait/synch/cond/group_rpl/COND_delayed_init_server_ready YES YES singleton 0 NULL
|
|
wait/synch/cond/group_rpl/COND_group_action_coordinator_process YES YES singleton 0 NULL
|
|
wait/synch/cond/group_rpl/COND_group_action_coordinator_thread YES YES singleton 0 NULL
|
|
wait/synch/cond/group_rpl/COND_group_action_coordinator_thread_end YES YES singleton 0 NULL
|
|
wait/synch/cond/group_rpl/COND_group_part_handler_run YES YES singleton 0 NULL
|
|
wait/synch/cond/group_rpl/COND_group_part_handler_abort YES YES singleton 0 NULL
|
|
wait/synch/cond/group_rpl/COND_message_service_run YES YES singleton 0 NULL
|
|
wait/synch/cond/group_rpl/COND_multi_primary_action_notification YES YES singleton 0 NULL
|
|
wait/synch/cond/group_rpl/COND_view_modification_wait YES YES singleton 0 NULL
|
|
wait/synch/cond/group_rpl/COND_pipeline_continuation YES YES singleton 0 NULL
|
|
wait/synch/cond/group_rpl/COND_synchronized_queue YES YES singleton 0 NULL
|
|
wait/synch/cond/group_rpl/COND_count_down_latch YES YES singleton 0 NULL
|
|
wait/synch/cond/group_rpl/COND_wait_ticket YES YES singleton 0 NULL
|
|
wait/synch/cond/group_rpl/COND_recovery_module_run YES YES singleton 0 NULL
|
|
wait/synch/cond/group_rpl/COND_recovery YES YES singleton 0 NULL
|
|
wait/synch/cond/group_rpl/COND_session_thread_method_exec YES YES singleton 0 NULL
|
|
wait/synch/cond/group_rpl/COND_session_thread_run YES YES singleton 0 NULL
|
|
wait/synch/cond/group_rpl/COND_pipeline_stats_flow_control YES YES singleton 0 NULL
|
|
wait/synch/cond/group_rpl/COND_primary_election_action_notification YES YES singleton 0 NULL
|
|
wait/synch/cond/group_rpl/COND_primary_election_primary_process_run YES YES singleton 0 NULL
|
|
wait/synch/cond/group_rpl/COND_primary_election_secondary_process_run YES YES singleton 0 NULL
|
|
wait/synch/cond/group_rpl/COND_primary_election_validation_notification YES YES singleton 0 NULL
|
|
wait/synch/cond/group_rpl/COND_write_lock_protection YES YES singleton 0 NULL
|
|
wait/synch/cond/group_rpl/COND_plugin_online YES YES singleton 0 NULL
|
|
wait/synch/cond/group_rpl/COND_primary_promotion_policy YES YES singleton 0 NULL
|
|
wait/synch/cond/group_rpl/COND_autorejoin_module YES YES singleton 0 NULL
|
|
stage/group_rpl/Undergoing auto-rejoin procedure YES YES progress 0 NULL
|
|
stage/group_rpl/Multi-primary Switch: waiting for pending transactions to finish YES YES progress 0 NULL
|
|
stage/group_rpl/Multi-primary Switch: waiting on another member step completion YES YES progress 0 NULL
|
|
stage/group_rpl/Multi-primary Switch: applying buffered transactions YES YES progress 0 NULL
|
|
stage/group_rpl/Multi-primary Switch: waiting for operation to complete on all members YES YES progress 0 NULL
|
|
stage/group_rpl/Primary Election: applying buffered transactions YES YES progress 0 NULL
|
|
stage/group_rpl/Primary Election: waiting on current primary transaction execution YES YES progress 0 NULL
|
|
stage/group_rpl/Primary Election: waiting for members to enable super_read_only YES YES progress 0 NULL
|
|
stage/group_rpl/Primary Election: stabilizing transactions from former primaries YES YES progress 0 NULL
|
|
stage/group_rpl/Primary Switch: checking current primary pre-conditions YES YES progress 0 NULL
|
|
stage/group_rpl/Primary Switch: waiting for pending transactions to finish YES YES progress 0 NULL
|
|
stage/group_rpl/Primary Switch: executing Primary election YES YES progress 0 NULL
|
|
stage/group_rpl/Primary Switch: waiting on another member step completion YES YES progress 0 NULL
|
|
stage/group_rpl/Primary Switch: waiting for operation to complete on all members YES YES progress 0 NULL
|
|
stage/group_rpl/Single-primary Switch: checking group pre-conditions YES YES progress 0 NULL
|
|
stage/group_rpl/Single-primary Switch: executing Primary election YES YES progress 0 NULL
|
|
stage/group_rpl/Single-primary Switch: waiting for operation to complete on all members YES YES progress 0 NULL
|
|
stage/group_rpl/Group Replication Module: Executing YES YES 0 NULL
|
|
stage/group_rpl/Group Replication Module: Suspending YES YES 0 NULL
|
|
stage/group_rpl/Group Replication Recovery: Connecting to donor YES YES 0 NULL
|
|
stage/group_rpl/Group Replication Recovery: Transferring state from donor YES YES 0 NULL
|
|
stage/group_rpl/Group Replication Cloning process: Preparing YES YES progress 0 NULL
|
|
stage/group_rpl/Group Replication Cloning process: Executing YES YES progress 0 NULL
|
|
|
|
############################################################
|
|
# 2. Start the GR
|
|
include/start_and_bootstrap_group_replication.inc
|
|
|
|
############################################################
|
|
# 3. Verify that there are no extra psi keys that were added
|
|
# after starting the GR
|
|
include/assert.inc ['There should be no extra psi keys added after starting the GR']
|
|
|
|
############################################################
|
|
# 4. Test end.
|
|
include/group_replication_end.inc
|