-
Notifications
You must be signed in to change notification settings - Fork 4k
/
Copy pathgr_auto_increment_increment.result
130 lines (130 loc) · 8.54 KB
/
gr_auto_increment_increment.result
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
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
include/group_replication.inc [rpl_server_count=4]
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]
include/start_and_bootstrap_group_replication.inc
include/start_group_replication.inc
include/start_group_replication.inc
#######################################################################
# 1. Check the defaults of group_replication_auto_increment_increment,
# auto_increment_increment and auto_increment_offset.
#######################################################################
include/assert.inc [The default value of group_replication_auto_increment_increment for server2 should be 7]
include/assert.inc [The default value of auto_increment_increment for server2 should be 1]
include/assert.inc [The default value of auto_increment_offset for server2 should be 1]
#######################################################################
# 2. Check that the value of group_replication_auto_increment_increment
# can be set before GR start, but its effects on
# auto_increment_increment and auto_increment_offset do not happen.
#######################################################################
SET GLOBAL GROUP_REPLICATION_AUTO_INCREMENT_INCREMENT= 3;
include/assert.inc [The value of group_replication_auto_increment_increment is set to 3]
include/assert.inc [The value of auto_increment_increment is not affected]
include/assert.inc [The value of auto_increment_offset is not affected]
include/start_group_replication.inc
#########################################################################
# 3. Check that the effects of group_replication_auto_increment_increment
# on auto_increment_increment and auto_increment_offset happen on
# starting GR.
#########################################################################
include/assert.inc [The value of group_replication_auto_increment_increment is still 3]
include/assert.inc [The value of auto_increment_increment is set to 3]
include/assert.inc [The value of auto_increment_offset is set to 2]
############################################################
# 4. When the number of members is bigger than
# the auto_increment_increment value, an error is logged.
############################################################
Matching lines are:
DATE_TIME [ERROR] [Repl] Plugin group_replication reported: 'Group contains 4 members which is greater than group_replication_auto_increment_increment value of 3. This can lead to a higher transactional abort rate.'
Occurrences of 'Group contains 4 members which is greater than group_replication_auto_increment_increment value of 3. This can lead to a higher transactional abort rate.' in the input file: 1
############################################################
# 5. When auto_increment_increment and auto_increment_offset
# not set to default value
# i.e. auto_increment_increment= 1
# auto_increment_offset= 1
# group_replication should not update their value.
############################################################
include/stop_group_replication.inc
SET GLOBAL AUTO_INCREMENT_INCREMENT= 5;
SET GLOBAL AUTO_INCREMENT_OFFSET= 5;
include/start_group_replication.inc
include/assert.inc [The value of auto_increment_increment for server2 should be 5]
include/assert.inc [The value of auto_increment_offset for server2 should be 5]
include/stop_group_replication.inc
include/assert.inc [The value of auto_increment_increment for server2 should be 5]
include/assert.inc [The value of auto_increment_offset for server2 should be 5]
############################################################
# 6. When auto_increment_increment and auto_increment_offset are equal
# to 1, then verify if plugin on start set auto_increment_increment
# variable equal to group_replication_auto_increment_increment value.
############################################################
SET GLOBAL AUTO_INCREMENT_INCREMENT= 1;
SET GLOBAL AUTO_INCREMENT_OFFSET= 1;
SET GLOBAL GROUP_REPLICATION_AUTO_INCREMENT_INCREMENT= 4;
include/start_group_replication.inc
include/assert.inc [The value of auto_increment_increment for server2 should be 4]
include/assert.inc [The value of auto_increment_offset for server2 should be 2]
############################################################
# 7. When group_replication is stopped verify that plugin reset
# auto_increment_increment and auto_increment_offset values to 1.
############################################################
include/stop_group_replication.inc
include/assert.inc [The value of auto_increment_increment for server2 should be 1]
include/assert.inc [The value of auto_increment_offset for server2 should be 1]
SET GLOBAL GROUP_REPLICATION_AUTO_INCREMENT_INCREMENT= 1;
############################################################
# 8. Verify start/stop group_replication plugin doesn't affect
# setting auto_increment_increment from
# group_replication_auto_increment_increment value.
############################################################
include/start_group_replication.inc
include/assert.inc [The value of auto_increment_increment for server2 should be 1]
include/assert.inc [The value of auto_increment_offset for server2 should be 2]
include/stop_group_replication.inc
SET GLOBAL GROUP_REPLICATION_AUTO_INCREMENT_INCREMENT= 9;
include/start_group_replication.inc
include/assert.inc [The value of auto_increment_increment for server2 should be 9]
include/assert.inc [The value of auto_increment_offset for server2 should be 2]
############################################################
# 9. Verify server restart doesn't affect setting
# auto_increment_increment from
# group_replication_auto_increment_increment value.
############################################################
include/stop_group_replication.inc
include/assert.inc [The value of auto_increment_increment for server2 should be 1]
include/assert.inc [The value of auto_increment_offset for server2 should be 1]
SET GLOBAL GROUP_REPLICATION_AUTO_INCREMENT_INCREMENT= 1;
include/start_group_replication.inc
include/assert.inc [The value of auto_increment_increment for server2 should be 1]
include/assert.inc [The value of auto_increment_offset for server2 should be 2]
# restart:--group_replication_local_address=GROUP_REPLICATION_LOCAL_ADDRESS --group_replication_group_seeds=GROUP_REPLICATION_GROUP_SEEDS
include/rpl/reconnect.inc
SET GLOBAL GROUP_REPLICATION_AUTO_INCREMENT_INCREMENT= 9;
include/start_group_replication.inc
include/assert.inc [The value of auto_increment_increment for server2 should be 9]
include/assert.inc [The value of auto_increment_offset for server2 should be 2]
############################################################
# 10. Verify group_replication_auto_increment_increment can't be set
# when group_replication plugin is running.
############################################################
SET GLOBAL GROUP_REPLICATION_AUTO_INCREMENT_INCREMENT= 9;
ERROR HY000: The group group_replication_auto_increment_increment cannot be changed when Group Replication is running
############################################################
# 11. Validate that when user tries to set invalid values a
# error is thrown.
############################################################
include/stop_group_replication.inc
SET GLOBAL GROUP_REPLICATION_AUTO_INCREMENT_INCREMENT= -1;
ERROR 42000: The value -1 is not within the range of accepted values for the option group_replication_auto_increment_increment. The value must be between 1 and 65535 inclusive.
SET GLOBAL GROUP_REPLICATION_AUTO_INCREMENT_INCREMENT= 65536;
ERROR 42000: The value 65536 is not within the range of accepted values for the option group_replication_auto_increment_increment. The value must be between 1 and 65535 inclusive.
SET GLOBAL GROUP_REPLICATION_AUTO_INCREMENT_INCREMENT= 0;
ERROR 42000: The value 0 is not within the range of accepted values for the option group_replication_auto_increment_increment. The value must be between 1 and 65535 inclusive.
SET GLOBAL GROUP_REPLICATION_AUTO_INCREMENT_INCREMENT= 'a';
ERROR 42000: Incorrect argument type to variable 'group_replication_auto_increment_increment'
############################################################
# 12. clean up and reset auto_increment variables value
############################################################
SET GLOBAL GROUP_REPLICATION_AUTO_INCREMENT_INCREMENT= 7;
include/group_replication_end.inc