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
131
132
133
134
135
|
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]
[connection server2]
[connection server1]
# 1. Execute switch to single primary mode:
# 1.1. With extra arguments it must fail.
SELECT group_replication_switch_to_single_primary_mode("MEMBER1_UUID", "extra", "arguments");
ERROR HY000: Can't initialize function 'group_replication_switch_to_single_primary_mode'; Wrong arguments: This function either takes no arguments or a single server uuid.
# 1.2. With invalid uuid it must fail.
SELECT group_replication_switch_to_single_primary_mode("not an uuid");
ERROR HY000: Can't initialize function 'group_replication_switch_to_single_primary_mode'; Wrong arguments: The server uuid is not valid.
# 1.3. With an unknown uuid it must fail.
SELECT group_replication_switch_to_single_primary_mode("aaaaaaaa-bbbb-aaaa-aaaa-aaaaaaaaaaaa");
ERROR HY000: Can't initialize function 'group_replication_switch_to_single_primary_mode'; The requested uuid is not a member of the group.
# 1.4. With NULL it must fail.
SELECT group_replication_switch_to_single_primary_mode(NULL);
ERROR HY000: Can't initialize function 'group_replication_switch_to_single_primary_mode'; Wrong arguments: This function either takes no arguments or a single server uuid.
# 1.5. With empty string it must fail.
SELECT group_replication_set_as_primary("");
ERROR HY000: Can't initialize function 'group_replication_set_as_primary'; Wrong arguments: You need to specify a server uuid.
# 2. Change to single primary mode to test action of set as primary and
# switch to multi primary
SELECT group_replication_switch_to_single_primary_mode("MEMBER1_UUID");
group_replication_switch_to_single_primary_mode("MEMBER1_UUID")
Mode switched to single-primary successfully.
# 3. Execute action of set a new primary:
# 3.1. With extra arguments it must fail.
SELECT group_replication_set_as_primary("MEMBER1_UUID", "extra", "arguments");
ERROR HY000: Can't initialize function 'group_replication_set_as_primary'; Wrong arguments: UDF accepts maximum of 2 parameters.
# 3.2. With invalid uuid it must fail.
SELECT group_replication_set_as_primary("not an uuid");
ERROR HY000: Can't initialize function 'group_replication_set_as_primary'; Wrong arguments: The server uuid is not valid.
# 3.3. With an unknown uuid it must fail.
SELECT group_replication_set_as_primary("aaaaaaaa-bbbb-aaaa-aaaa-aaaaaaaaaaaa");
ERROR HY000: Can't initialize function 'group_replication_set_as_primary'; The requested uuid is not a member of the group.
# 3.4. With NULL it must fail.
SELECT group_replication_set_as_primary(NULL);
ERROR HY000: Can't initialize function 'group_replication_set_as_primary'; Wrong arguments: You need to specify a server uuid.
# 3.5. With empty string it must fail.
SELECT group_replication_set_as_primary("");
ERROR HY000: Can't initialize function 'group_replication_set_as_primary'; Wrong arguments: You need to specify a server uuid.
# 3.6. With blank value it must fail.
SELECT group_replication_set_as_primary();
ERROR HY000: Can't initialize function 'group_replication_set_as_primary'; Wrong arguments: You need to specify a server uuid.
# 4. Execute action to switch to multi primary mode:
# 4.1. With extra arguments it must fail.
SELECT group_replication_switch_to_multi_primary_mode("extra", "arguments");
ERROR HY000: Can't initialize function 'group_replication_switch_to_multi_primary_mode'; Wrong arguments: This function takes no arguments.
# 4.2. With invalid uuid it must fail.
SELECT group_replication_switch_to_multi_primary_mode("not an uuid");
ERROR HY000: Can't initialize function 'group_replication_switch_to_multi_primary_mode'; Wrong arguments: This function takes no arguments.
# 4.3. With an unknown uuid it must fail.
SELECT group_replication_switch_to_multi_primary_mode("aaaaaaaa-bbbb-aaaa-aaaa-aaaaaaaaaaaa");
ERROR HY000: Can't initialize function 'group_replication_switch_to_multi_primary_mode'; Wrong arguments: This function takes no arguments.
# 4.4. With NULL it must fail.
SELECT group_replication_switch_to_multi_primary_mode(NULL);
ERROR HY000: Can't initialize function 'group_replication_switch_to_multi_primary_mode'; Wrong arguments: This function takes no arguments.
# 4.5. With empty string it must fail.
SELECT group_replication_switch_to_multi_primary_mode("");
ERROR HY000: Can't initialize function 'group_replication_switch_to_multi_primary_mode'; Wrong arguments: This function takes no arguments.
# 4.6. With valid and known uuid it must fail.
SELECT group_replication_switch_to_multi_primary_mode("$server1_uuid");
ERROR HY000: Can't initialize function 'group_replication_switch_to_multi_primary_mode'; Wrong arguments: This function takes no arguments.
# 5. Change to multi primary mode to test action with output of a table.
SELECT group_replication_switch_to_multi_primary_mode();
group_replication_switch_to_multi_primary_mode()
Mode switched to multi-primary successfully.
# 6. Create a table to test the functions with SQL outputs
CREATE TABLE test.t1 (a INT PRIMARY KEY NOT NULL AUTO_INCREMENT, b CHAR(36));
# 7. Test group_replication_switch_to_single_primary_mode output (SQL parameter).
# 7.1. With invalid uuid it must fail.
SELECT group_replication_switch_to_single_primary_mode(b) FROM test.t1 WHERE a=1;
ERROR HY000: The function 'group_replication_switch_to_single_primary_mode' failed. Wrong arguments: The server uuid is not valid.
# 7.2. With an unknown uuid it must fail.
SELECT group_replication_switch_to_single_primary_mode(b) FROM test.t1 WHERE a=2;
ERROR HY000: The function 'group_replication_switch_to_single_primary_mode' failed. The requested uuid is not a member of the group.
# 7.3. With NULL it must fail.
SELECT group_replication_switch_to_single_primary_mode(b) FROM test.t1 WHERE a=3;
ERROR HY000: The function 'group_replication_switch_to_single_primary_mode' failed. Wrong arguments: You need to specify a server uuid.
# 7.4. With empty string it must fail.
SELECT group_replication_switch_to_single_primary_mode(b) FROM test.t1 WHERE a=4;
ERROR HY000: The function 'group_replication_switch_to_single_primary_mode' failed. Wrong arguments: You need to specify a server uuid.
# 7.5. Mode switched to single-primary successfully.
SELECT group_replication_switch_to_single_primary_mode(b) FROM test.t1 WHERE a=5;
group_replication_switch_to_single_primary_mode(b)
Mode switched to single-primary successfully.
# 7.6. Already in single-primary mode.
SELECT group_replication_switch_to_single_primary_mode(b) FROM test.t1 WHERE a=6;
group_replication_switch_to_single_primary_mode(b)
Already in single-primary mode. Did you mean to use group_replication_set_as_primary?
# 8.Test group_replication_switch_to_multi_primary_mode output.
SELECT group_replication_switch_to_multi_primary_mode(b) FROM test.t1 ORDER BY a LIMIT 1;
ERROR HY000: Can't initialize function 'group_replication_switch_to_multi_primary_mode'; Wrong arguments: This function takes no arguments.
# 9. Test group_replication_set_as_primary output (SQL parameter).
# 9.1. With invalid uuid it must fail.
SELECT group_replication_set_as_primary(b) FROM test.t1 WHERE a=1;
ERROR HY000: The function 'group_replication_set_as_primary' failed. Wrong arguments: The server uuid is not valid.
# 9.2. With an unknown uuid it must fail.
SELECT group_replication_set_as_primary(b) FROM test.t1 WHERE a=2;
ERROR HY000: The function 'group_replication_set_as_primary' failed. The requested uuid is not a member of the group.
# 9.3. With NULL it must fail.
SELECT group_replication_set_as_primary(b) FROM test.t1 WHERE a=3;
ERROR HY000: The function 'group_replication_set_as_primary' failed. Wrong arguments: You need to specify a server uuid.
# 9.4. With empty string it must fail.
SELECT group_replication_set_as_primary(b) FROM test.t1 WHERE a=4;
ERROR HY000: The function 'group_replication_set_as_primary' failed. Wrong arguments: You need to specify a server uuid.
# 9.5. Already the primary member
SELECT group_replication_set_as_primary(b) FROM test.t1 WHERE a=5;
group_replication_set_as_primary(b)
The requested member is already the current group primary.
# 9.6. Switch to another member
SELECT group_replication_set_as_primary(b) FROM test.t1 WHERE a=6;
group_replication_set_as_primary(b)
Primary server switched to: MEMBER2_UUID
[connection server1]
include/gr_assert_secondary_member.inc
[connection server2]
include/gr_assert_primary_member.inc
# 10. Cleanup
DROP TABLE test.t1;
include/rpl_sync.inc
include/group_replication_end.inc
|
