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
45
46
47
48
49
50
51
52
53
54
|
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. Restart server1 with --group_replication_bootstrap_group=1,
# while setting a debug sync point just before bootstrap the
# group. This will mimic a start timeout due to all seeds be
# unreachable.
[connection server1]
SET @@GLOBAL.DEBUG= @debug_save;
# restart:--group_replication_group_name=GROUP_REPLICATION_GROUP_NAME --group_replication_local_address=GROUP_REPLICATION_LOCAL_ADDRESS --group_replication_group_seeds=GROUP_REPLICATION_GROUP_SEEDS --group_replication_bootstrap_group=1 --group_replication_start_on_boot=1 --loose-debug=+d,group_replication_before_joining_the_group
include/rpl_reconnect.inc
############################################################
# 2. While the start procedure is blocked on the sync point,
# do set the plugin options that do require exclusive access
# to plugin internal state, those set operations will be
# disallowed.
include/assert.inc [The super_read_only mode must be 1]
include/assert.inc [The delayed initialization thread is running after boot]
SET GLOBAL group_replication_recovery_get_public_key= ON;
ERROR HY000: This option cannot be set while START or STOP GROUP_REPLICATION is ongoing.
SET GLOBAL group_replication_recovery_use_ssl= ON;
ERROR HY000: This option cannot be set while START or STOP GROUP_REPLICATION is ongoing.
SET GLOBAL group_replication_recovery_ssl_verify_server_cert= ON;
ERROR HY000: This option cannot be set while START or STOP GROUP_REPLICATION is ongoing.
SET GLOBAL group_replication_recovery_complete_at= "transactions_applied";
ERROR HY000: This option cannot be set while START or STOP GROUP_REPLICATION is ongoing.
SET GLOBAL group_replication_group_name= "aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaab";
ERROR HY000: This option cannot be set while START or STOP GROUP_REPLICATION is ongoing.
SET GLOBAL group_replication_recovery_retry_count= 1;
ERROR HY000: This option cannot be set while START or STOP GROUP_REPLICATION is ongoing.
SET GLOBAL group_replication_recovery_reconnect_interval= 1;
ERROR HY000: This option cannot be set while START or STOP GROUP_REPLICATION is ongoing.
SET GLOBAL group_replication_unreachable_majority_timeout= 1;
ERROR HY000: This option cannot be set while START or STOP GROUP_REPLICATION is ongoing.
SET GLOBAL group_replication_components_stop_timeout= 2;
ERROR HY000: This option cannot be set while START or STOP GROUP_REPLICATION is ongoing.
SET GLOBAL group_replication_member_weight= 1;
ERROR HY000: This option cannot be set while START or STOP GROUP_REPLICATION is ongoing.
############################################################
# 3. Unblock the start procedure, the server will change to
# ONLINE state.
SET DEBUG_SYNC= "now SIGNAL signal.continue_group_join";
include/gr_wait_for_member_state.inc
############################################################
# 4. Clean up.
SET @@GLOBAL.DEBUG= @debug_save;
include/group_replication_end.inc
|
