Debian Codegraph @

mysql-test/suite/group_replication/r/gr_kill_restart.result

raw
1 include/group_replication.inc [rpl_server_count=3]
2 Warnings:
3 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
4 Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
5 [connection server1]
6
7 ############################################################
8 # 1. Prepare all the servers for crash such that when server crashes
9 # the crashed node joins the group immediately.
10 [connection server1]
11 set session sql_log_bin=0;
12 call mtr.add_suppression("Members removed from the group*");
13 call mtr.add_suppression("Member with address*");
14 call mtr.add_suppression("\\[GCS\\]*");
15 call mtr.add_suppression("The group_replication_group_name option is mandatory");
16 call mtr.add_suppression("Unable to start Group Replication on boot");
17 set session sql_log_bin=1;
18 [connection server2]
19 set session sql_log_bin=0;
20 call mtr.add_suppression("Members removed from the group*");
21 call mtr.add_suppression("Member with address*");
22 call mtr.add_suppression("\\[GCS\\]*");
23 call mtr.add_suppression("The group_replication_group_name option is mandatory");
24 call mtr.add_suppression("Unable to start Group Replication on boot");
25 set session sql_log_bin=1;
26 [connection server3]
27 set session sql_log_bin=0;
28 call mtr.add_suppression("Members removed from the group*");
29 call mtr.add_suppression("Member with address*");
30 call mtr.add_suppression("\\[GCS\\]*");
31 call mtr.add_suppression("The group_replication_group_name option is mandatory");
32 call mtr.add_suppression("Unable to start Group Replication on boot");
33 set session sql_log_bin=1;
34
35 ############################################################
36 # 2. Start all servers.
37 [connection server1]
38 include/start_and_bootstrap_group_replication.inc
39 [connection server2]
40 include/start_group_replication.inc
41 [connection server3]
42 include/start_group_replication.inc
43
44 ############################################################
45 # 3. Kill and re-start primary server 3 times.
46 #### 3 ####
47 include/gr_find_a_primary.inc
48 [connection server1]
49 # Kill and restart
50 include/rpl_reconnect.inc
51 include/gr_wait_for_member_state.inc
52 include/rpl_gr_wait_for_number_of_members.inc
53 #### 2 ####
54 include/gr_find_a_primary.inc
55 [connection server3]
56 # Kill and restart
57 include/rpl_reconnect.inc
58 include/gr_wait_for_member_state.inc
59 include/rpl_gr_wait_for_number_of_members.inc
60 #### 1 ####
61 include/gr_find_a_primary.inc
62 [connection server1]
63 # Kill and restart
64 include/rpl_reconnect.inc
65 include/gr_wait_for_member_state.inc
66 include/rpl_gr_wait_for_number_of_members.inc
67
68 ############################################################
69 # 4. Cleanup.
70 [connection server3]
71 include/stop_group_replication.inc
72 [connection server2]
73 include/stop_group_replication.inc
74 [connection server1]
75 include/stop_group_replication.inc
76 include/group_replication_end.inc