| 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. Restart the server with start on boot enabled |
| 9 |
# restart:--group_replication_local_address=GROUP_REPLICATION_LOCAL_ADDRESS --group_replication_group_seeds=GROUP_REPLICATION_GROUP_SEEDS --group_replication_start_on_boot=1 --group-replication-group-name=GROUP_REPLICATION_GROUP_NAME --performance-schema-instrument='memory/group_rpl/%=OFF' |
| 10 |
include/rpl_reconnect.inc |
| 11 |
include/gr_wait_for_member_state.inc |
| 12 |
|
| 13 |
############################################################ |
| 14 |
# 2. Verify following for all Group Replication Event Names: |
| 15 |
# i. Event name is disabled on mysql server start. |
| 16 |
# ii. Event name can be enabled by updating ENABLED column |
| 17 |
# of setup_instruments table. |
| 18 |
include/assert.inc ['There should be 1 entry corresponding to the memory/group_rpl/write_set_encoded in the setup_instruments table for ENABLED=NO'] |
| 19 |
UPDATE performance_schema.setup_instruments SET ENABLED='YES' WHERE NAME LIKE "memory/group_rpl/write_set_encoded";; |
| 20 |
include/assert.inc ['There should be 1 entry corresponding to the memory/group_rpl/write_set_encoded in the setup_instruments table for ENABLED=YES'] |
| 21 |
UPDATE performance_schema.setup_instruments SET ENABLED='NO' WHERE NAME LIKE "memory/group_rpl/write_set_encoded";; |
| 22 |
include/assert.inc ['There should be 1 entry corresponding to the memory/group_rpl/Gcs_message_data::m_buffer in the setup_instruments table for ENABLED=NO'] |
| 23 |
UPDATE performance_schema.setup_instruments SET ENABLED='YES' WHERE NAME LIKE "memory/group_rpl/Gcs_message_data::m_buffer";; |
| 24 |
include/assert.inc ['There should be 1 entry corresponding to the memory/group_rpl/Gcs_message_data::m_buffer in the setup_instruments table for ENABLED=YES'] |
| 25 |
UPDATE performance_schema.setup_instruments SET ENABLED='NO' WHERE NAME LIKE "memory/group_rpl/Gcs_message_data::m_buffer";; |
| 26 |
include/assert.inc ['There should be 1 entry corresponding to the memory/group_rpl/certification_data in the setup_instruments table for ENABLED=NO'] |
| 27 |
UPDATE performance_schema.setup_instruments SET ENABLED='YES' WHERE NAME LIKE "memory/group_rpl/certification_data";; |
| 28 |
include/assert.inc ['There should be 1 entry corresponding to the memory/group_rpl/certification_data in the setup_instruments table for ENABLED=YES'] |
| 29 |
UPDATE performance_schema.setup_instruments SET ENABLED='NO' WHERE NAME LIKE "memory/group_rpl/certification_data";; |
| 30 |
include/assert.inc ['There should be 1 entry corresponding to the memory/group_rpl/certification_data_gc in the setup_instruments table for ENABLED=NO'] |
| 31 |
UPDATE performance_schema.setup_instruments SET ENABLED='YES' WHERE NAME LIKE "memory/group_rpl/certification_data_gc";; |
| 32 |
include/assert.inc ['There should be 1 entry corresponding to the memory/group_rpl/certification_data_gc in the setup_instruments table for ENABLED=YES'] |
| 33 |
UPDATE performance_schema.setup_instruments SET ENABLED='NO' WHERE NAME LIKE "memory/group_rpl/certification_data_gc";; |
| 34 |
include/assert.inc ['There should be 1 entry corresponding to the memory/group_rpl/certification_info in the setup_instruments table for ENABLED=NO'] |
| 35 |
UPDATE performance_schema.setup_instruments SET ENABLED='YES' WHERE NAME LIKE "memory/group_rpl/certification_info";; |
| 36 |
include/assert.inc ['There should be 1 entry corresponding to the memory/group_rpl/certification_info in the setup_instruments table for ENABLED=YES'] |
| 37 |
UPDATE performance_schema.setup_instruments SET ENABLED='NO' WHERE NAME LIKE "memory/group_rpl/certification_info";; |
| 38 |
include/assert.inc ['There should be 1 entry corresponding to the memory/group_rpl/transaction_data in the setup_instruments table for ENABLED=NO'] |
| 39 |
UPDATE performance_schema.setup_instruments SET ENABLED='YES' WHERE NAME LIKE "memory/group_rpl/transaction_data";; |
| 40 |
include/assert.inc ['There should be 1 entry corresponding to the memory/group_rpl/transaction_data in the setup_instruments table for ENABLED=YES'] |
| 41 |
UPDATE performance_schema.setup_instruments SET ENABLED='NO' WHERE NAME LIKE "memory/group_rpl/transaction_data";; |
| 42 |
include/assert.inc ['There should be 1 entry corresponding to the memory/group_rpl/message_service_received_message in the setup_instruments table for ENABLED=NO'] |
| 43 |
UPDATE performance_schema.setup_instruments SET ENABLED='YES' WHERE NAME LIKE "memory/group_rpl/message_service_received_message";; |
| 44 |
include/assert.inc ['There should be 1 entry corresponding to the memory/group_rpl/message_service_received_message in the setup_instruments table for ENABLED=YES'] |
| 45 |
UPDATE performance_schema.setup_instruments SET ENABLED='NO' WHERE NAME LIKE "memory/group_rpl/message_service_received_message";; |
| 46 |
include/assert.inc ['There should be 1 entry corresponding to the memory/group_rpl/sql_service_command_data in the setup_instruments table for ENABLED=NO'] |
| 47 |
UPDATE performance_schema.setup_instruments SET ENABLED='YES' WHERE NAME LIKE "memory/group_rpl/sql_service_command_data";; |
| 48 |
include/assert.inc ['There should be 1 entry corresponding to the memory/group_rpl/sql_service_command_data in the setup_instruments table for ENABLED=YES'] |
| 49 |
UPDATE performance_schema.setup_instruments SET ENABLED='NO' WHERE NAME LIKE "memory/group_rpl/sql_service_command_data";; |
| 50 |
include/assert.inc ['There should be 1 entry corresponding to the memory/group_rpl/mysql_thread_queued_task in the setup_instruments table for ENABLED=NO'] |
| 51 |
UPDATE performance_schema.setup_instruments SET ENABLED='YES' WHERE NAME LIKE "memory/group_rpl/mysql_thread_queued_task";; |
| 52 |
include/assert.inc ['There should be 1 entry corresponding to the memory/group_rpl/mysql_thread_queued_task in the setup_instruments table for ENABLED=YES'] |
| 53 |
UPDATE performance_schema.setup_instruments SET ENABLED='NO' WHERE NAME LIKE "memory/group_rpl/mysql_thread_queued_task";; |
| 54 |
include/assert.inc ['There should be 1 entry corresponding to the memory/group_rpl/message_service_queue in the setup_instruments table for ENABLED=NO'] |
| 55 |
UPDATE performance_schema.setup_instruments SET ENABLED='YES' WHERE NAME LIKE "memory/group_rpl/message_service_queue";; |
| 56 |
include/assert.inc ['There should be 1 entry corresponding to the memory/group_rpl/message_service_queue in the setup_instruments table for ENABLED=YES'] |
| 57 |
UPDATE performance_schema.setup_instruments SET ENABLED='NO' WHERE NAME LIKE "memory/group_rpl/message_service_queue";; |
| 58 |
include/assert.inc ['There should be 1 entry corresponding to the memory/group_rpl/consistent_members_that_must_prepare_transaction in the setup_instruments table for ENABLED=NO'] |
| 59 |
UPDATE performance_schema.setup_instruments SET ENABLED='YES' WHERE NAME LIKE "memory/group_rpl/consistent_members_that_must_prepare_transaction";; |
| 60 |
include/assert.inc ['There should be 1 entry corresponding to the memory/group_rpl/consistent_members_that_must_prepare_transaction in the setup_instruments table for ENABLED=YES'] |
| 61 |
UPDATE performance_schema.setup_instruments SET ENABLED='NO' WHERE NAME LIKE "memory/group_rpl/consistent_members_that_must_prepare_transaction";; |
| 62 |
include/assert.inc ['There should be 1 entry corresponding to the memory/group_rpl/consistent_transactions in the setup_instruments table for ENABLED=NO'] |
| 63 |
UPDATE performance_schema.setup_instruments SET ENABLED='YES' WHERE NAME LIKE "memory/group_rpl/consistent_transactions";; |
| 64 |
include/assert.inc ['There should be 1 entry corresponding to the memory/group_rpl/consistent_transactions in the setup_instruments table for ENABLED=YES'] |
| 65 |
UPDATE performance_schema.setup_instruments SET ENABLED='NO' WHERE NAME LIKE "memory/group_rpl/consistent_transactions";; |
| 66 |
include/assert.inc ['There should be 1 entry corresponding to the memory/group_rpl/consistent_transactions_prepared in the setup_instruments table for ENABLED=NO'] |
| 67 |
UPDATE performance_schema.setup_instruments SET ENABLED='YES' WHERE NAME LIKE "memory/group_rpl/consistent_transactions_prepared";; |
| 68 |
include/assert.inc ['There should be 1 entry corresponding to the memory/group_rpl/consistent_transactions_prepared in the setup_instruments table for ENABLED=YES'] |
| 69 |
UPDATE performance_schema.setup_instruments SET ENABLED='NO' WHERE NAME LIKE "memory/group_rpl/consistent_transactions_prepared";; |
| 70 |
include/assert.inc ['There should be 1 entry corresponding to the memory/group_rpl/consistent_transactions_waiting in the setup_instruments table for ENABLED=NO'] |
| 71 |
UPDATE performance_schema.setup_instruments SET ENABLED='YES' WHERE NAME LIKE "memory/group_rpl/consistent_transactions_waiting";; |
| 72 |
include/assert.inc ['There should be 1 entry corresponding to the memory/group_rpl/consistent_transactions_waiting in the setup_instruments table for ENABLED=YES'] |
| 73 |
UPDATE performance_schema.setup_instruments SET ENABLED='NO' WHERE NAME LIKE "memory/group_rpl/consistent_transactions_waiting";; |
| 74 |
include/assert.inc ['There should be 1 entry corresponding to the memory/group_rpl/consistent_transactions_delayed_view_change in the setup_instruments table for ENABLED=NO'] |
| 75 |
UPDATE performance_schema.setup_instruments SET ENABLED='YES' WHERE NAME LIKE "memory/group_rpl/consistent_transactions_delayed_view_change";; |
| 76 |
include/assert.inc ['There should be 1 entry corresponding to the memory/group_rpl/consistent_transactions_delayed_view_change in the setup_instruments table for ENABLED=YES'] |
| 77 |
UPDATE performance_schema.setup_instruments SET ENABLED='NO' WHERE NAME LIKE "memory/group_rpl/consistent_transactions_delayed_view_change";; |
| 78 |
|
| 79 |
############################################################ |
| 80 |
# 3. Cleanup |
| 81 |
include/group_replication_end.inc |