Debian Codegraph @

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

raw
1 ###############################################################################
2 #
3 # Configuration changes can be invoked in any member despite its
4 # primary or secondary role.
5 #
6 # Test:
7 # 0. This test requires two servers
8 # 1. On multi-primary mode any member can execute action to change to
9 # single primary mode
10 # 2. On single primary mode a secondary member can execute a change of
11 # primary member
12 # 3. On single primary mode a primary member can execute a change of
13 # primary member
14 # 4. On single primary mode a secondary member can execute a change to
15 # multi primary mode
16 # 5. Cleanup
17 #
18 ###############################################################################
19
20 --source include/have_group_replication_plugin.inc
21 --source include/group_replication.inc
22
23 --echo
24 --echo # 1. On multi-primary mode any member can execute action to change to
25 --echo # single primary mode
26
27 --let $server1_uuid= query_get_value(SELECT @@SERVER_UUID, @@SERVER_UUID, 1)
28
29 --replace_result $server1_uuid MEMBER1_UUID
30 --eval SELECT group_replication_switch_to_single_primary_mode("$server1_uuid")
31
32 # UDF function returns when all members say they finish. On server2
33 # the message may not have been yet receive. Wait for no event of
34 # group_rpl on stage to continue
35
36 --let $rpl_connection_name= server2
37 --source include/rpl_connection.inc
38
39 --let $wait_condition=SELECT COUNT(*)=0 FROM performance_schema.events_stages_current WHERE event_name LIKE "stage/group_rpl%" AND event_name NOT LIKE "%stage/group_rpl/Group Replication%"
40 --source include/wait_condition.inc
41
42 --echo
43 --echo # 2. On single primary mode a secondary member can execute a change of
44 --echo # primary member
45
46 --let $server2_uuid= query_get_value(SELECT @@SERVER_UUID, @@SERVER_UUID, 1)
47
48 --replace_result $server2_uuid MEMBER2_UUID
49 --eval SELECT group_replication_set_as_primary("$server2_uuid")
50
51 --source include/gr_assert_primary_member.inc
52
53 --echo
54 --echo # 3. On single primary mode a primary member can execute a change of
55 --echo # primary member
56
57 --replace_result $server1_uuid MEMBER1_UUID
58 --eval SELECT group_replication_set_as_primary("$server1_uuid")
59
60 --let $rpl_connection_name= server1
61 --source include/rpl_connection.inc
62
63 --source include/gr_assert_primary_member.inc
64
65 --echo
66 --echo # 4. On single primary mode a secondary member can execute a change to
67 --echo # multi primary mode
68
69 --let $rpl_connection_name= server2
70 --source include/rpl_connection.inc
71
72 SELECT group_replication_switch_to_multi_primary_mode();
73
74 --echo
75 --echo # 5. Cleanup
76
77 --let $rpl_group_replication_reset_persistent_vars=1
78 --source include/group_replication_end.inc