1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
|
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 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.
[connection server1]
# 1. Bootstrap M1.
[connection server1]
include/start_and_bootstrap_group_replication.inc
# 2. Set parameters for server 2 for start gr.
[connection server2]
SET GLOBAL group_replication_group_name= "GROUP_REPLICATION_GROUP_NAME";
SET @debug_save= @@GLOBAL.DEBUG;
# 3. Check parallel START/STOP GR is blocked if START GR is running.
SET @@GLOBAL.DEBUG='+d,group_replication_wait_on_start';
START GROUP_REPLICATION;;
[connection server_2_1]
SET DEBUG_SYNC='now wait_for signal.start_waiting';
START GROUP_REPLICATION;
ERROR HY000: The START GROUP_REPLICATION command encountered a failure. Another instance of START/STOP GROUP_REPLICATION command is executing.
STOP GROUP_REPLICATION;
ERROR HY000: The STOP GROUP_REPLICATION command encountered a failure. Another instance of START/STOP GROUP_REPLICATION command is executing.
SET DEBUG_SYNC='now signal signal.start_continue';
[connection server2]
include/gr_wait_for_member_state.inc
# 4. Check parallel START/STOP GR is blocked if STOP GR is running.
SET @@GLOBAL.DEBUG='+d,group_replication_hold_stop_before_leave_the_group';
STOP GROUP_REPLICATION;;
[connection server_2_1]
SET DEBUG_SYNC='now wait_for signal.stopping_before_leave_the_group';
START GROUP_REPLICATION;
ERROR HY000: The START GROUP_REPLICATION command encountered a failure. Another instance of START/STOP GROUP_REPLICATION command is executing.
STOP GROUP_REPLICATION;
ERROR HY000: The STOP GROUP_REPLICATION command encountered a failure. Another instance of START/STOP GROUP_REPLICATION command is executing.
SET DEBUG_SYNC='now signal signal.resume_stop_before_leave_the_group';
[connection server2]
include/gr_wait_for_member_state.inc
# 5. Cleanup.
SET @@GLOBAL.DEBUG= @debug_save;
include/group_replication_end.inc
|
