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
|
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. Enable debug point to block server on start
SET @debug_save= @@GLOBAL.DEBUG;
SET @@GLOBAL.DEBUG= 'd,group_replication_wait_on_start';
# 2. Configure server and START Group Replication
SET GLOBAL group_replication_group_name= "GROUP_REPLICATION_GROUP_NAME";
SET GLOBAL GROUP_REPLICATION_BOOTSTRAP_GROUP=1;
START GROUP_REPLICATION;;
# 3. SET @@GLOBAL.GTID_MODE will fail due Group Replication hold lock on
# gtid_set_mode
[connection server_1]
SET DEBUG_SYNC= "now WAIT_FOR signal.start_waiting";
SET GLOBAL GTID_MODE=ON;
ERROR HY000: SET @@GLOBAL.GTID_MODE = ON is not allowed because there is a concurrent operation that disallows changes to @@GLOBAL.GTID_MODE.
# 4. Send signal to server to unlock start
SET DEBUG_SYNC= 'now SIGNAL signal.start_continue';
[connection server1]
include/gr_wait_for_member_state.inc
# 5. Cleanup
SET @@GLOBAL.DEBUG= @debug_save;
include/group_replication_end.inc
|
