Debian Codegraph @

mysql-test/suite/group_replication/r/gr_single_primary_majority_loss_1.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 include/start_and_bootstrap_group_replication.inc
7 include/gr_wait_primary_member_uuid.inc
8 [connection server2]
9 include/start_group_replication.inc
10 [connection server3]
11 include/start_group_replication.inc
12 # Crash two secondary members to cause majority loss.
13 [connection server2]
14 # Kill the server
15 [connection server3]
16 # Kill and restart
17 [connection server2]
18 # restart
19 include/rpl_reconnect.inc
20 include/rpl_reconnect.inc
21 [connection server2]
22 SET @@global.group_replication_group_seeds="GROUP_SEEDS_SERVER2";
23 SET @@global.group_replication_local_address="LOCAL_ADDRESS_SERVER2";
24 SET @@global.group_replication_group_name="GROUP_REPLICATION_GROUP_NAME";
25 SET @@global.group_replication_enforce_update_everywhere_checks=OFF;
26 SET @@global.group_replication_single_primary_mode=ON;
27 [connection server_3]
28 SET @@global.group_replication_group_seeds="GROUP_SEEDS_SERVER3";
29 SET @@global.group_replication_local_address="LOCAL_ADDRESS_SERVER3";
30 SET @@global.group_replication_group_name="GROUP_REPLICATION_GROUP_NAME";
31 SET @@global.group_replication_enforce_update_everywhere_checks=OFF;
32 SET @@global.group_replication_single_primary_mode=ON;
33 [connection server1]
34 # Wait for the member state for server3 to be unreachable
35 include/gr_wait_for_member_state.inc
36 # Wait for the member state for server2 to be unreachable
37 include/gr_wait_for_member_state.inc
38 # Connect to primary and unblock the group.
39 SET GLOBAL group_replication_force_members= "GROUP_REPLICATION_LOCAL_ADDR";
40 include/gr_wait_primary_member_uuid.inc
41 CREATE TABLE test.t1 ( a int primary key);
42 INSERT INTO test.t1 VALUES (1);
43 [connection server2]
44 include/start_group_replication.inc
45 [connection server3]
46 include/start_group_replication.inc
47 include/gr_wait_primary_member_uuid.inc
48 [connection server1]
49 DROP TABLE test.t1;
50 include/group_replication_end.inc