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
|
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. Server1 bootstrap group
include/start_and_bootstrap_group_replication.inc
# 3. Start server 2 that will block on recovery
[connection server2]
set session sql_log_bin=0;
call mtr.add_suppression("Error while executing a group configuration operation: A member is joining the group, wait for it to be ONLINE.");
set session sql_log_bin=1;
SET @@GLOBAL.DEBUG='+d,recovery_thread_wait_before_finish';
include/start_group_replication.inc
# 4. Execute action switch to single primary that will fail due a server
# is blocked on recovery
[connection server1]
set session sql_log_bin=0;
call mtr.add_suppression("The function 'group_replication_switch_to_single_primary_mode' failed. A member is joining the group.*");
set session sql_log_bin=1;
SELECT group_replication_switch_to_single_primary_mode("MEMBER1_UUID");
ERROR HY000: Can't initialize function 'group_replication_switch_to_single_primary_mode'; A member is joining the group, wait for it to be ONLINE.
# 5. Resume recovery on server2
[connection server2]
SET DEBUG_SYNC= "now WAIT_FOR signal.recovery_thread_wait_before_finish_reached";
SET @@GLOBAL.DEBUG='-d,recovery_thread_wait_before_finish';
SET DEBUG_SYNC= "now SIGNAL signal.recovery_end";
include/gr_wait_for_member_state.inc
SET DEBUG_SYNC= 'RESET';
# 6. Cleanup
include/group_replication_end.inc
|
