38 lines
1.3 KiB
Plaintext
38 lines
1.3 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. Start group replication on member1.
|
|
include/start_and_bootstrap_group_replication.inc
|
|
|
|
# 2. Add gr_rejoining_offline_member_proc procedure to query
|
|
# replication_group_members multiple times and stop GR on server1.
|
|
[connection server1]
|
|
CREATE PROCEDURE test.gr_rejoining_offline_member_proc(mx INT)
|
|
BEGIN
|
|
SET @x = 0;
|
|
REPEAT
|
|
SELECT COUNT(*) FROM performance_schema.replication_group_members;
|
|
SET @x = @x + 1;
|
|
UNTIL @x > mx END REPEAT;
|
|
END |
|
|
include/stop_group_replication.inc
|
|
|
|
# 3. Restart group replication on member1.
|
|
SET GLOBAL group_replication_bootstrap_group=1;
|
|
START GROUP_REPLICATION;
|
|
|
|
# 4. Query performance_schema.replication_group_members table
|
|
# multiple times while member is rejoining to test the failure.
|
|
[connection server_1]
|
|
|
|
# 5. Verify member1 is ONLINE.
|
|
[connection server1]
|
|
include/gr_wait_for_member_state.inc
|
|
|
|
# 6. Cleanup
|
|
DROP PROCEDURE gr_rejoining_offline_member_proc;
|
|
include/group_replication_end.inc
|