Debian Codegraph @

mysql-test/suite/group_replication/t/gr_primary_mode_group_operations_21_1.test

raw
1 ###############################################################################
2 # This test verifies that group actions can be executed from any member and
3 # it applies to the group successfully.
4 #
5 # Test:
6 # 0. This test requires three servers
7 # 1. Fetch server uuid of all the members.
8 # 2. Execute group action switch to primary mode on server2 to set
9 # server3 as primary.
10 # 3. Verify that secondaries: server1, server2 and primary: server3.
11 # 4. Execute action on a secondary server1 to make another secondary
12 # server2 as primary.
13 # 5. Verify that secondaries: server1, server3 and primary: server2.
14 # 6. Execute action on a primary server2 to make a secondary server3
15 # as primary.
16 # 7. Verify that secondaries: server1, server2 and primary: server3.
17 # 8. Execute action on a secondary server1 to make itself as primary.
18 # 9. Verify that secondaries: server2, server3 and primary: server1.
19 # 10. Clean up.
20 ###############################################################################
21
22 --source include/have_group_replication_plugin.inc
23 --let $rpl_server_count= 3
24 --source include/group_replication.inc
25
26 --echo
27 --echo # 1. Fetch server uuid of all the members.
28
29 --let $server1_uuid= query_get_value(SELECT @@SERVER_UUID, @@SERVER_UUID, 1)
30
31 --let $rpl_connection_name= server3
32 --source include/rpl_connection.inc
33 --let $server3_uuid= query_get_value(SELECT @@SERVER_UUID, @@SERVER_UUID, 1)
34
35 --let $rpl_connection_name= server2
36 --source include/rpl_connection.inc
37 --let $server2_uuid= query_get_value(SELECT @@SERVER_UUID, @@SERVER_UUID, 1)
38
39 --echo
40 --echo # 2. Execute group action switch to primary mode on server2 to set
41 --echo # server3 as primary.
42
43 --replace_result $server3_uuid MEMBER3_UUID
44 --eval SELECT group_replication_switch_to_single_primary_mode("$server3_uuid")
45
46 --echo
47 --echo # 3. Verify that secondaries: server1, server2 and primary: server3.
48
49 --source include/gr_assert_secondary_member.inc
50
51 --let $rpl_connection_name= server1
52 --source include/rpl_connection.inc
53 --source include/gr_assert_secondary_member.inc
54
55 --let $rpl_connection_name= server3
56 --source include/rpl_connection.inc
57 --source include/gr_assert_primary_member.inc
58
59 --echo
60 --echo # 4. Execute action on a secondary server1 to make another secondary
61 --echo # server2 as primary.
62
63 --let $rpl_connection_name= server1
64 --source include/rpl_connection.inc
65 --replace_result $server2_uuid MEMBER2_UUID
66 --eval SELECT group_replication_set_as_primary("$server2_uuid")
67
68 --echo
69 --echo # 5. Verify that secondaries: server1, server3 and primary: server2.
70
71 --source include/gr_assert_secondary_member.inc
72
73 --let $rpl_connection_name= server3
74 --source include/rpl_connection.inc
75 --source include/gr_assert_secondary_member.inc
76
77 --let $rpl_connection_name= server2
78 --source include/rpl_connection.inc
79 --source include/gr_assert_primary_member.inc
80
81 --echo
82 --echo # 6. Execute action on a primary server2 to make a secondary server3
83 --echo # as primary.
84
85 --replace_result $server3_uuid MEMBER3_UUID
86 --eval SELECT group_replication_set_as_primary("$server3_uuid")
87
88 --echo
89 --echo # 7. Verify that secondaries: server1, server2 and primary: server3.
90
91 --source include/gr_assert_secondary_member.inc
92
93 --let $rpl_connection_name= server1
94 --source include/rpl_connection.inc
95 --source include/gr_assert_secondary_member.inc
96
97 --let $rpl_connection_name= server3
98 --source include/rpl_connection.inc
99 --source include/gr_assert_primary_member.inc
100
101 --echo
102 --echo # 8. Execute action on a secondary server1 to make itself as primary.
103
104 --let $rpl_connection_name= server1
105 --source include/rpl_connection.inc
106 --replace_result $server1_uuid MEMBER1_UUID
107 --eval SELECT group_replication_set_as_primary("$server1_uuid")
108
109 --echo
110 --echo # 9. Verify that secondaries: server2, server3 and primary: server1.
111
112 --source include/gr_assert_primary_member.inc
113
114 --let $rpl_connection_name= server3
115 --source include/rpl_connection.inc
116 --source include/gr_assert_secondary_member.inc
117
118 --let $rpl_connection_name= server2
119 --source include/rpl_connection.inc
120 --source include/gr_assert_secondary_member.inc
121
122 --echo
123 --echo # 10. Clean up.
124
125 --let $rpl_group_replication_single_primary_mode=1
126 --let $rpl_group_replication_reset_persistent_vars=1
127 --source include/group_replication_end.inc