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
60
61
62
63
64
65
66
|
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]
# 0. The test requires two servers: M1 and M2.
#############################################################
include/start_and_bootstrap_group_replication.inc
# 1. Validate that independent of READ_ONLY and
# SUPER_READ_ONLY state, they will be set to OFF after
# start
#############################################################
# 1.1. Set READ_ONLY=ON and start group replication, then
# READ_ONLY and SUPER_READ_ONLY should be OFF
#############################################################
SET GLOBAL read_only= 1;
include/start_group_replication.inc
# The server's super_read_only mode should be 0 here.
include/assert.inc [The super_read_only mode should be 0 here.]
# The server's read_only mode should be 0 here.
include/assert.inc [The read_only mode should be 0 here.]
# 1.2. Stop group replication and READ_ONLY and
# SUPER_READ_ONLY should be ON
#############################################################
include/stop_group_replication.inc
# 1.3. Set SUPER_READ_ONLY=ON and start group replication,
# then READ_ONLY and SUPER_READ_ONLY should be OFF
#############################################################
SET GLOBAL super_read_only= 1;
include/start_group_replication.inc
# The server's super_read_only mode should be 0 here.
include/assert.inc [The super_read_only mode should be 0 here.]
# The server's read_only mode should be 0 here.
include/assert.inc [The read_only mode should be 0 here.]
# 1.4. Stop group replication and READ_ONLY and
# SUPER_READ_ONLY should be ON
#############################################################
include/stop_group_replication.inc
# 2. Validate that independent of READ_ONLY and
# SUPER_READ_ONLY state, they will be set to ON after
# shutdown
#############################################################
# 2.1. Start group replication, set READ_ONLY=ON and after
# STOP GROUP_REPLICATION will put READ_ONLY and
# SUPER_READ_ONLY to ON
#############################################################
include/start_group_replication.inc
SET GLOBAL read_only= 1;
include/stop_group_replication.inc
# 2.2. Start group replication, set SUPER_READ_ONLY=ON and
# after STOP GROUP_REPLICATION will put READ_ONLY and
# SUPER_READ_ONLY to ON
#############################################################
include/start_group_replication.inc
SET GLOBAL super_read_only= 1;
include/stop_group_replication.inc
include/group_replication_end.inc
|
