Debian Codegraph @

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

raw
1 #######################################################################################
2 # WL9426 : In a group of 3 or more servers:-
3 # Just after stopping/crashing primary server, stop secondary member which is
4 # probable to become a primary. Test that one of the available secondary member
5 # becomes a primary member.
6 # Test :
7 # 0. This test requires 3 servers
8 # 1. Create a group replication setup with 3 members
9 # 2. Crash the primary member
10 # 3. Wait for that server to go down and become unreachable
11 # 4. Stop the group replication next probable primary which is secondary
12 # 5. Bring back the server and set all the required group replication variables
13 # 6. Test that the remained server which is ONLINE in the group becomes the primary.
14 # 7. Perform some insert operations on the primary
15 # 8. Bring back the servers in to group replication setup
16 # 9. Wait for data to recover and validate the data and cleanup
17 #######################################################################################
18 # Don't test this under valgrind, memory leaks will occur
19 --source include/not_valgrind.inc
20 --source include/big_test.inc
21 --source include/have_group_replication_plugin.inc
22 --let $rpl_server_count= 3
23 --let $rpl_skip_group_replication_start= 1
24 --let $rpl_group_replication_single_primary_mode=1
25 --source include/force_restart.inc
26 --source include/group_replication.inc
27
28 # Start group replication on all the servers
29 --source include/start_and_bootstrap_group_replication.inc
30 --let $member1_uuid= query_get_value(SELECT @@SERVER_UUID, @@SERVER_UUID, 1)
31 # save this, since it will be used to recover the server later on
32 --let $local_address_server1= `SELECT @@GLOBAL.group_replication_local_address`
33 --let $group_seeds_server1= `SELECT @@GLOBAL.group_replication_group_seeds`
34
35 --let $rpl_connection_name= server2
36 --source include/rpl_connection.inc
37
38 --source include/start_group_replication.inc
39
40 --let $rpl_connection_name= server3
41 --source include/rpl_connection.inc
42
43 --source include/start_group_replication.inc
44
45 --echo #
46 --echo # Crash the primary server
47 --let $rpl_connection_name= server1
48 --source include/rpl_connection.inc
49
50 # Making sure this is the primary server
51 --let $group_replication_expected_uuid= $member1_uuid
52 --source include/gr_wait_primary_member_uuid.inc
53
54 # We do kill and restart the servers.
55 --source include/kill_and_restart_mysqld.inc
56
57
58 # reset the group_replication_id var
59 --let $group_replication_member_id= $member2_uuid
60
61 --let $rpl_server_number= 1
62 --source include/rpl_reconnect.inc
63
64 # Check that only 2 member is alive in the group on server 2
65 --let $rpl_connection_name= server_2
66 --source include/rpl_connection.inc
67 --echo # wait for number of alive members to be 2
68 --let $group_replication_number_of_members= 2
69 --source include/gr_wait_for_number_of_members.inc
70
71 # Check that only 2 member is alive in the group on server 3
72 --let $rpl_connection_name= server_3
73 --source include/rpl_connection.inc
74 --echo # wait for number of alive members to be 2
75 --let $group_replication_number_of_members= 2
76 --source include/gr_wait_for_number_of_members.inc
77
78 --let $rpl_connection_name= server_1
79 --source include/rpl_connection.inc
80
81 --replace_result $group_seeds_server1 GROUP_SEEDS_SERVER1
82 --eval SET @@global.group_replication_group_seeds="$group_seeds_server1"
83 --replace_result $local_address_server1 LOCAL_ADDRESS_SERVER1
84 --eval SET @@global.group_replication_local_address="$local_address_server1"
85 --replace_result $group_replication_group_name GROUP_REPLICATION_GROUP_NAME
86 --eval SET @@global.group_replication_group_name="$group_replication_group_name"
87 --eval SET @@global.group_replication_enforce_update_everywhere_checks=0
88 --eval SET @@global.group_replication_single_primary_mode=1
89
90 # Stop the secondary member which is probable to become a primary
91 --let $rpl_connection_name= server2
92 --source include/rpl_connection.inc
93
94 --source include/stop_group_replication.inc
95
96 --let $rpl_connection_name= server3
97 --source include/rpl_connection.inc
98
99 --let $server3_uuid= `SELECT @@server_uuid`
100
101 --let $group_replication_expected_uuid= $server3_uuid
102 --source include/gr_wait_primary_member_uuid.inc
103
104 CREATE TABLE test.t1 ( a int primary key);
105 INSERT INTO test.t1 VALUES(1);
106
107 # Start group replication again in server 1 and server 2
108 --let $rpl_connection_name= server2
109 --source include/rpl_connection.inc
110
111 --source include/start_group_replication.inc
112
113 --let $rpl_connection_name= server1
114 --source include/rpl_connection.inc
115
116 --source include/start_group_replication.inc
117
118 --let $wait_condition=SELECT COUNT(*)=3 FROM performance_schema.replication_group_members where MEMBER_STATE="ONLINE"
119 --source include/wait_condition.inc
120
121 --let $group_replication_expected_uuid= $server3_uuid
122 --source include/gr_wait_primary_member_uuid.inc
123
124 # Connect to primary and cleanup
125 --let $rpl_connection_name= server3
126 --source include/rpl_connection.inc
127 DROP TABLE test.t1;
128
129 --source include/group_replication_end.inc
130