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
|
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 one server.
#########################################################################
[connection server1]
SET @exit_state_action_saved = @@GLOBAL.group_replication_exit_state_action;
#########################################################################
# 1) Check the default value. It should be READ_ONLY.
#########################################################################
SET @@GLOBAL.group_replication_exit_state_action = default;
include/assert.inc [The default of group_replication_exit_state_action should be READ_ONLY]
#########################################################################
# 2) Set the sysvar to the possible valid values.
#########################################################################
SET GLOBAL group_replication_exit_state_action = "OFFLINE_MODE";
include/assert.inc [The value of group_replication_exit_state_action should be OFFLINE_MODE]
SET GLOBAL group_replication_exit_state_action = "ABORT_SERVER";
include/assert.inc [The value of group_replication_exit_state_action should be ABORT_SERVER]
SET GLOBAL group_replication_exit_state_action = "READ_ONLY";
include/assert.inc [The value of group_replication_exit_state_action should be READ_ONLY]
#########################################################################
# 3) Set the sysvar to invalid values. There should be an error and the
# value of the sysvar should not be altered.
#########################################################################
SET GLOBAL group_replication_exit_state_action = 42;
ERROR 42000: Variable 'group_replication_exit_state_action' can't be set to the value of '42'
SET GLOBAL group_replication_exit_state_action = on;
ERROR 42000: Variable 'group_replication_exit_state_action' can't be set to the value of 'ON'
SET GLOBAL group_replication_exit_state_action = "abort";
ERROR 42000: Variable 'group_replication_exit_state_action' can't be set to the value of 'abort'
include/assert.inc [The value of group_replication_exit_state_action should be READ_ONLY]
#########################################################################
# 4) Cleanup.
#########################################################################
SET GLOBAL group_replication_exit_state_action = @exit_state_action_saved;
include/group_replication_end.inc
|
