| 1 |
include/group_replication.inc [rpl_server_count=2] |
| 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 |
[connection server1] |
| 7 |
SET @@SESSION.group_replication_consistency= BEFORE_ON_PRIMARY_FAILOVER; |
| 8 |
include/start_and_bootstrap_group_replication.inc |
| 9 |
|
| 10 |
# 1. Enable debug point that run an assert if command will be put on |
| 11 |
# hold |
| 12 |
[connection server1] |
| 13 |
SET @debug_save= @@GLOBAL.DEBUG; |
| 14 |
SET @@GLOBAL.DEBUG= '+d,launch_hook_trans_begin_assert_if_hold'; |
| 15 |
|
| 16 |
# 2. Validate SQL command SHOW will not block |
| 17 |
SHOW GLOBAL VARIABLES LIKE 'group_replication_consistency'; |
| 18 |
Variable_name Value |
| 19 |
group_replication_consistency EVENTUAL |
| 20 |
SHOW PROCESSLIST; |
| 21 |
SHOW STATUS; |
| 22 |
SHOW ENGINE INNODB LOGS; |
| 23 |
SHOW ENGINE INNODB STATUS; |
| 24 |
SHOW ENGINE INNODB MUTEX; |
| 25 |
SHOW MASTER STATUS; |
| 26 |
SHOW REPLICA STATUS; |
| 27 |
SHOW CHARACTER SET; |
| 28 |
SHOW COLLATION; |
| 29 |
SHOW BINARY LOGS; |
| 30 |
SHOW OPEN TABLES; |
| 31 |
SHOW REPLICAS; |
| 32 |
SHOW BINLOG EVENTS; |
| 33 |
SHOW WARNINGS; |
| 34 |
SHOW ERRORS; |
| 35 |
SHOW ENGINES; |
| 36 |
SHOW PRIVILEGES; |
| 37 |
SHOW PROCEDURE STATUS; |
| 38 |
SHOW FUNCTION STATUS; |
| 39 |
SHOW PLUGINS; |
| 40 |
SHOW EVENTS; |
| 41 |
SHOW PROFILE; |
| 42 |
SHOW PROFILES; |
| 43 |
SHOW RELAYLOG EVENTS; |
| 44 |
|
| 45 |
# 3. Validate SQL command SET will not block |
| 46 |
SET @@GLOBAL.group_replication_member_weight= DEFAULT; |
| 47 |
|
| 48 |
# 4. Validate SQL command DO will not block |
| 49 |
DO SLEEP(1); |
| 50 |
|
| 51 |
# 5. Validate SQL command EMPTY will not block |
| 52 |
|
| 53 |
# 6. Validate SQL command USE will not block |
| 54 |
USE test; |
| 55 |
|
| 56 |
# 7. Validate SQL command SELECT to performance_schema will not block |
| 57 |
SELECT COUNT(*) from performance_schema.replication_group_members; |
| 58 |
COUNT(*) |
| 59 |
1 |
| 60 |
|
| 61 |
# 8. Validate SQL command SELECT to table PROCESSLIST from database |
| 62 |
# infoschema will not block |
| 63 |
SELECT COUNT(*)=0 FROM INFORMATION_SCHEMA.PROCESSLIST WHERE STATE='debug sync point: now'; |
| 64 |
COUNT(*)=0 |
| 65 |
1 |
| 66 |
Warnings: |
| 67 |
Warning 1287 'INFORMATION_SCHEMA.PROCESSLIST' is deprecated and will be removed in a future release. Please use performance_schema.processlist instead |
| 68 |
|
| 69 |
# 9. Validate SQL command SELECT from database syschema will not block |
| 70 |
SELECT COUNT(*)=1 FROM sys.version; |
| 71 |
COUNT(*)=1 |
| 72 |
1 |
| 73 |
|
| 74 |
# 10. Validate SQL command SELECT that don't use tables will not block |
| 75 |
SELECT @@GLOBAL.GTID_EXECUTED; |
| 76 |
@@GLOBAL.GTID_EXECUTED |
| 77 |
GROUP_REPLICATION_GROUP_NAME:1 |
| 78 |
|
| 79 |
# 11. Validate SQL command RESET PERSIST will not block |
| 80 |
RESET PERSIST; |
| 81 |
|
| 82 |
# 12. Validate SQL command STOP GROUP_REPLICATION will not block |
| 83 |
STOP GROUP_REPLICATION; |
| 84 |
|
| 85 |
# 13. Reconnect server1 to group |
| 86 |
[connection server1] |
| 87 |
SET @@GLOBAL.DEBUG= '-d,launch_hook_trans_begin_assert_if_hold'; |
| 88 |
include/start_and_bootstrap_group_replication.inc |
| 89 |
|
| 90 |
# 14. Validate SQL command SHUTDOWN will not block |
| 91 |
SET @@GLOBAL.DEBUG= '+d,launch_hook_trans_begin_assert_if_hold'; |
| 92 |
SHUTDOWN; |
| 93 |
include/rpl_reconnect.inc |
| 94 |
|
| 95 |
# 15. Cleanup |
| 96 |
SET @@GLOBAL.DEBUG= '-d,launch_hook_trans_begin_assert_if_hold'; |
| 97 |
SET GLOBAL group_replication_group_name= "GROUP_NAME"; |
| 98 |
SET GLOBAL group_replication_local_address= "GROUP_LOCAL_ADDRESS2"; |
| 99 |
SET GLOBAL group_replication_group_seeds= "GROUP_SEEDS_SERVER2"; |
| 100 |
SET GLOBAL group_replication_enforce_update_everywhere_checks= FALSE;; |
| 101 |
SET GLOBAL group_replication_single_primary_mode= TRUE;; |
| 102 |
SET @@SESSION.group_replication_consistency= DEFAULT; |
| 103 |
include/group_replication_end.inc |
| 104 |
Warnings: |
| 105 |
Warning 3615 Variable group_replication_ip_allowlist does not exist in persisted config file |