Debian Codegraph @

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

raw
1 #######################################################################################
2 # Desc : In a group, do majority crash which doesn't includes primary member.
3 # Test the setup.
4 # WL9426 : MySQL NG: Single Primary Mode in Group Replication
5 # Test :
6 # 0. This test requires 3 servers
7 # 1. Create a group replication setup with 3 members
8 # 2. Store all the group replication variable values which is
9 # required to start the server for both the secondary servers
10 # 3. Crash the two secondary servers and block the group by causing majority loss
11 # 4. Bring back the server and set all the required group replication variables
12 # 5. Unblock the group by setting group_replication_force_members variable on
13 # primary server
14 # 6. Check and make sure server1 is unblocked and remains as primary
15 # 7. Perform some insert operations on the primary
16 # 8. Bring back the servers in to group replication setup
17 # 9. Wait for data to recover and validate the data and cleanup
18 #######################################################################################
19 # This test does crashes servers, thence we skip it on valgrind.
20 --source include/not_valgrind.inc
21 --source include/big_test.inc
22 --source include/force_restart.inc
23 --source include/have_group_replication_plugin.inc
24 --let $rpl_server_count= 3
25 --let $rpl_skip_group_replication_start= 1
26 --let $rpl_group_replication_single_primary_mode=1
27 --source include/group_replication.inc
28
29 # Start group replication on all the servers
30
31 --source include/start_and_bootstrap_group_replication.inc
32 --let $member1_uuid= query_get_value(SELECT @@SERVER_UUID, @@SERVER_UUID, 1)
33
34 # Make sure server1 has been given the role of primary
35 --let $server1_uuid= `SELECT @@server_uuid`
36 --let $group_replication_expected_uuid= $server1_uuid
37 --source include/gr_wait_primary_member_uuid.inc
38
39 --let $rpl_connection_name= server2
40 --source include/rpl_connection.inc
41
42 --source include/start_group_replication.inc
43 --let $member2_uuid= query_get_value(SELECT @@SERVER_UUID, @@SERVER_UUID, 1)
44 # save this, since it will be used to recover the server later on
45 --let $local_address_server2= `SELECT @@GLOBAL.group_replication_local_address`
46 --let $group_seeds_server2= `SELECT @@GLOBAL.group_replication_group_seeds`
47
48 --let $rpl_connection_name= server3
49 --source include/rpl_connection.inc
50
51 --source include/start_group_replication.inc
52 --let $member3_uuid= query_get_value(SELECT @@SERVER_UUID, @@SERVER_UUID, 1)
53 # save this, since it will be used to recover the server later on
54 --let $local_address_server3= `SELECT @@GLOBAL.group_replication_local_address`
55 --let $group_seeds_server3= `SELECT @@GLOBAL.group_replication_group_seeds`
56
57 # Crash the two secondary servers out of 3 to cause a majority loss
58 --echo # Crash two secondary members to cause majority loss.
59 # We do kill the servers almost simultaneously, only restarting them
60 # after both have crashed.
61 # Since the servers loose its GCS configuration them will not rejoin
62 # the group.
63
64 --let $rpl_connection_name= server2
65 --source include/rpl_connection.inc
66 --source include/kill_mysqld.inc
67 --let $server2_expect_file_name= $_expect_file_name
68
69 --let $rpl_connection_name= server3
70 --source include/rpl_connection.inc
71 --source include/kill_and_restart_mysqld.inc
72
73
74 # reset the group_replication_id var
75 --let $group_replication_member_id= $member1_uuid
76
77 # Start server 2 now after server 3 was killed.
78 --let $rpl_connection_name= server2
79 --source include/rpl_connection.inc
80 --let $_expect_file_name= $server2_expect_file_name
81 --source include/start_mysqld.inc
82
83 --let $rpl_server_number= 2
84 --source include/rpl_reconnect.inc
85
86 --let $rpl_server_number= 3
87 --source include/rpl_reconnect.inc
88
89 --let $rpl_connection_name= server2
90 --source include/rpl_connection.inc
91 --replace_result $group_seeds_server2 GROUP_SEEDS_SERVER2
92 --eval SET @@global.group_replication_group_seeds="$group_seeds_server2"
93 --replace_result $local_address_server2 LOCAL_ADDRESS_SERVER2
94 --eval SET @@global.group_replication_local_address="$local_address_server2"
95 --replace_result $group_replication_group_name GROUP_REPLICATION_GROUP_NAME
96 --eval SET @@global.group_replication_group_name="$group_replication_group_name"
97 --eval SET @@global.group_replication_enforce_update_everywhere_checks=OFF
98 --eval SET @@global.group_replication_single_primary_mode=ON
99
100 --let $rpl_connection_name= server_3
101 --source include/rpl_connection.inc
102 --replace_result $group_seeds_server3 GROUP_SEEDS_SERVER3
103 --eval SET @@global.group_replication_group_seeds="$group_seeds_server3"
104 --replace_result $local_address_server3 LOCAL_ADDRESS_SERVER3
105 --eval SET @@global.group_replication_local_address="$local_address_server3"
106 --replace_result $group_replication_group_name GROUP_REPLICATION_GROUP_NAME
107 --eval SET @@global.group_replication_group_name="$group_replication_group_name"
108 --eval SET @@global.group_replication_enforce_update_everywhere_checks=OFF
109 --eval SET @@global.group_replication_single_primary_mode=ON
110
111 --let $rpl_connection_name= server1
112 --source include/rpl_connection.inc
113
114 # Make sure server 2 and server 3 are in UNREACHABLE state
115 --echo # Wait for the member state for server3 to be unreachable
116 --let $group_replication_member_state= UNREACHABLE
117 --let $group_replication_member_id= $member3_uuid
118 --source include/gr_wait_for_member_state.inc
119
120 --echo # Wait for the member state for server2 to be unreachable
121 --let $group_replication_member_state= UNREACHABLE
122 --let $group_replication_member_id= $member2_uuid
123 --source include/gr_wait_for_member_state.inc
124
125 # Unblock the group which is caused by majority loss using
126 # group_replication_force_members variable
127 --echo # Connect to primary and unblock the group.
128 --let $local_address_server1= `SELECT @@GLOBAL.group_replication_local_address`
129 --replace_result $local_address_server1 GROUP_REPLICATION_LOCAL_ADDR
130 --eval SET GLOBAL group_replication_force_members= "$local_address_server1"
131
132 # Check for the primary member after the group is unblocked
133 --let $server1_uuid= `SELECT @@server_uuid`
134 --let $group_replication_expected_uuid= $server1_uuid
135 --source include/gr_wait_primary_member_uuid.inc
136
137 --let $wait_condition=SELECT COUNT(*)=1 FROM performance_schema.replication_group_members where MEMBER_STATE="ONLINE"
138 --source include/wait_condition.inc
139
140 CREATE TABLE test.t1 ( a int primary key);
141 INSERT INTO test.t1 VALUES (1);
142
143 # Start group replication again in server 2 and server 3
144 --let $rpl_connection_name= server2
145 --source include/rpl_connection.inc
146 --source include/start_group_replication.inc
147
148 --let $rpl_connection_name= server3
149 --source include/rpl_connection.inc
150 --source include/start_group_replication.inc
151
152 --let $wait_condition=SELECT COUNT(*)=3 FROM performance_schema.replication_group_members where MEMBER_STATE="ONLINE"
153 --source include/wait_condition.inc
154
155 --let $group_replication_expected_uuid= $server1_uuid
156 --source include/gr_wait_primary_member_uuid.inc
157
158 # Connect to primary and cleanup
159 --let $rpl_connection_name= server1
160 --source include/rpl_connection.inc
161 DROP TABLE test.t1;
162
163 --source include/group_replication_end.inc
164