Debian Codegraph @

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

raw
1 ###############################################################################
2 #
3 # When changing to single primary mode with no appointed primary,
4 # if a solo member exists with running slave channels, that
5 # member shall be the elected primary.
6 #
7 # Test:
8 # 0. This test needs three servers
9 # 1. server1 start group replication and server2 join
10 # 2. server1 as slave connection to server3
11 # 3. Set primary election max weight on server2
12 # 4. Execute action to single primary mode.
13 # It shall succeed, server 1 is the only with slave connections
14 # 5. Confirm that server2 has super_read_only= 1
15 # 6. Server1 is the primary server on the group
16 # Servers with slave channels take priority over high weight members
17 # 7. Cleanup
18 #
19 ###############################################################################
20
21 --source include/have_group_replication_plugin.inc
22 --let $rpl_skip_group_replication_start= 1
23 --let $rpl_server_count= 3
24 --source include/group_replication.inc
25
26 --echo
27 --echo # 1. server1 start group replication and server2 join
28
29 --source include/start_and_bootstrap_group_replication.inc
30
31 --let $rpl_connection_name= server2
32 --source include/rpl_connection.inc
33 --source include/start_group_replication.inc
34
35 --echo
36 --echo # 2. server1 as slave connection to server3
37
38 --let $rpl_connection_name= server1
39 --source include/rpl_connection.inc
40 --replace_result $SERVER_MYPORT_3 SERVER_3_PORT
41 --eval CHANGE REPLICATION SOURCE TO SOURCE_HOST='localhost', SOURCE_USER='root', SOURCE_PORT=$SERVER_MYPORT_3 for channel 'ch3_1'
42
43 --let $rpl_channel_name='ch3_1'
44 --source include/start_slave.inc
45 --let $rpl_channel_name=
46
47 --echo
48 --echo # 3. Set primary election max weight on server2
49
50 --let $rpl_connection_name= server2
51 --source include/rpl_connection.inc
52
53 SET @@GLOBAL.group_replication_member_weight= 100;
54
55 --echo
56 --echo # 4. Execute action to single primary mode. It shall succeed, server 1
57 --echo # is the only with slave connections
58
59 SELECT group_replication_switch_to_single_primary_mode();
60
61 --echo
62 --echo # 5. Confirm that server2 has super_read_only= 1
63
64 --let $wait_condition= SELECT @@GLOBAL.super_read_only = '1'
65 --source include/wait_condition.inc
66
67 --echo
68 --echo # 6. Server1 is the primary server on the group
69 --echo # Servers with slave channels take priority over high weight members
70
71 --let $rpl_connection_name= server2
72 --source include/rpl_connection.inc
73
74 --source include/gr_assert_secondary_member.inc
75
76 --let $rpl_connection_name= server1
77 --source include/rpl_connection.inc
78
79 --source include/gr_assert_primary_member.inc
80
81 --echo
82 --echo # 7. Cleanup
83
84 STOP SLAVE FOR CHANNEL 'ch3_1';
85 RESET SLAVE ALL FOR CHANNEL 'ch3_1';
86
87 --let $rpl_connection_name= server2
88 --source include/rpl_connection.inc
89
90 SET @@GLOBAL.group_replication_member_weight= DEFAULT;
91
92 --let $rpl_group_replication_single_primary_mode=1
93 --let $rpl_group_replication_reset_persistent_vars=1
94 --source include/group_replication_end.inc