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
55
56
57
58
59
|
include/group_replication.inc [rpl_server_count=3]
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. No members on group.
include/rpl_gr_wait_for_number_of_members.inc
include/rpl_gr_wait_for_number_of_members.inc
include/rpl_gr_wait_for_number_of_members.inc
###########################################################
# 2. One member on group.
include/start_and_bootstrap_group_replication.inc
include/rpl_gr_wait_for_number_of_members.inc
include/rpl_gr_wait_for_number_of_members.inc
include/rpl_gr_wait_for_number_of_members.inc
###########################################################
# 3. Two members on group.
include/start_group_replication.inc
include/rpl_gr_wait_for_number_of_members.inc
include/rpl_gr_wait_for_number_of_members.inc
include/rpl_gr_wait_for_number_of_members.inc
###########################################################
# 4. Three members on group.
include/start_group_replication.inc
include/rpl_gr_wait_for_number_of_members.inc
include/rpl_gr_wait_for_number_of_members.inc
include/rpl_gr_wait_for_number_of_members.inc
SELECT CHANNEL_NAME, MEMBER_ID, MEMBER_HOST, MEMBER_PORT, MEMBER_STATE FROM performance_schema.replication_group_members;
CHANNEL_NAME MEMBER_ID MEMBER_HOST MEMBER_PORT MEMBER_STATE
group_replication_applier MEMBER_ID MEMBER_HOST MEMBER_PORT ONLINE
group_replication_applier MEMBER_ID MEMBER_HOST MEMBER_PORT ONLINE
group_replication_applier MEMBER_ID MEMBER_HOST MEMBER_PORT ONLINE
###########################################################
# 5. Two members on group.
include/stop_group_replication.inc
include/rpl_gr_wait_for_number_of_members.inc
include/rpl_gr_wait_for_number_of_members.inc
include/rpl_gr_wait_for_number_of_members.inc
###########################################################
# 6. One member on group.
include/stop_group_replication.inc
include/rpl_gr_wait_for_number_of_members.inc
include/rpl_gr_wait_for_number_of_members.inc
include/rpl_gr_wait_for_number_of_members.inc
###########################################################
# 7. No members on group.
include/stop_group_replication.inc
include/rpl_gr_wait_for_number_of_members.inc
include/rpl_gr_wait_for_number_of_members.inc
include/rpl_gr_wait_for_number_of_members.inc
include/group_replication_end.inc
|
