Debian Codegraph @

mysql-test/suite/group_replication/r/gr_restore_super_read_only.result

raw
1 include/group_replication.inc
2 Warnings:
3 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
4 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.
5 [connection server1]
6
7 # 0. The test requires two servers: M1 and M2.
8 #############################################################
9 include/start_and_bootstrap_group_replication.inc
10
11 # 1. Validate that independent of READ_ONLY and
12 # SUPER_READ_ONLY state, they will be set to OFF after
13 # start
14 #############################################################
15
16 # 1.1. Set READ_ONLY=ON and start group replication, then
17 # READ_ONLY and SUPER_READ_ONLY should be OFF
18 #############################################################
19 SET GLOBAL read_only= 1;
20 include/start_group_replication.inc
21 # The server's super_read_only mode should be 0 here.
22 include/assert.inc [The super_read_only mode should be 0 here.]
23 # The server's read_only mode should be 0 here.
24 include/assert.inc [The read_only mode should be 0 here.]
25
26 # 1.2. Stop group replication and READ_ONLY and
27 # SUPER_READ_ONLY should be ON
28 #############################################################
29 include/stop_group_replication.inc
30
31 # 1.3. Set SUPER_READ_ONLY=ON and start group replication,
32 # then READ_ONLY and SUPER_READ_ONLY should be OFF
33 #############################################################
34 SET GLOBAL super_read_only= 1;
35 include/start_group_replication.inc
36 # The server's super_read_only mode should be 0 here.
37 include/assert.inc [The super_read_only mode should be 0 here.]
38 # The server's read_only mode should be 0 here.
39 include/assert.inc [The read_only mode should be 0 here.]
40
41 # 1.4. Stop group replication and READ_ONLY and
42 # SUPER_READ_ONLY should be ON
43 #############################################################
44 include/stop_group_replication.inc
45
46 # 2. Validate that independent of READ_ONLY and
47 # SUPER_READ_ONLY state, they will be set to ON after
48 # shutdown
49 #############################################################
50
51 # 2.1. Start group replication, set READ_ONLY=ON and after
52 # STOP GROUP_REPLICATION will put READ_ONLY and
53 # SUPER_READ_ONLY to ON
54 #############################################################
55 include/start_group_replication.inc
56 SET GLOBAL read_only= 1;
57 include/stop_group_replication.inc
58
59 # 2.2. Start group replication, set SUPER_READ_ONLY=ON and
60 # after STOP GROUP_REPLICATION will put READ_ONLY and
61 # SUPER_READ_ONLY to ON
62 #############################################################
63 include/start_group_replication.inc
64 SET GLOBAL super_read_only= 1;
65 include/stop_group_replication.inc
66 include/group_replication_end.inc