Debian Codegraph @

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

raw
1 include/group_replication.inc [rpl_server_count=4]
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 # 1. Bootstrap M1 and start GR on M2.
8 # Set higher member weight on M3 and start GR with higher patch version.
9
10 [connection server1]
11 SET @debug1_save= @@GLOBAL.DEBUG;
12 include/start_and_bootstrap_group_replication.inc
13 [connection server2]
14 include/start_group_replication.inc
15 [connection server3]
16 SET @member_weight3_save= @@GLOBAL.group_replication_member_weight;
17 SET GLOBAL group_replication_member_weight= 90;
18 SET @debug3_save= @@GLOBAL.DEBUG;
19 SET @@GLOBAL.DEBUG= 'd,group_replication_compatibility_higher_patch_version';
20 SET SESSION sql_log_bin = 0;
21 call mtr.add_suppression("Member version is read compatible with the group.");
22 SET SESSION sql_log_bin = 1;
23 include/start_group_replication.inc
24
25 # 2. Stop GR on M1.
26 # M2 becomes primary due to lower version rule.
27
28 [connection server1]
29 include/stop_group_replication.inc
30 include/gr_assert_spm_consistency.inc
31
32 # 3. Set higher member weight on M1 and start GR on M1 and M4.
33 # Stop GR primary member M2.
34 # M1 becomes primary due to lower version and higher member weight.
35
36 [connection server1]
37 SET @member_weight1_save= @@GLOBAL.group_replication_member_weight;
38 SET GLOBAL group_replication_member_weight= 60;
39 include/start_group_replication.inc
40 [connection server4]
41 include/start_group_replication.inc
42 [connection server2]
43 include/stop_group_replication.inc
44 include/gr_assert_spm_consistency.inc
45
46 # 4. Start GR on M2.
47 # Stop GR primary member M1.
48 # Lowest server_uuid between M2 or M4 becomes primary.
49 # Server_uuid is considered among same version and member weight.
50
51 [connection server2]
52 include/start_group_replication.inc
53 [connection server1]
54 include/stop_group_replication.inc
55 [connection server2]
56 include/gr_assert_spm_consistency.inc
57
58 # 5. Cleanup.
59
60 [connection server4]
61 include/stop_group_replication.inc
62 [connection server1]
63 SET @@GLOBAL.DEBUG= @debug1_save;
64 SET @@GLOBAL.group_replication_member_weight = @member_weight1_save;
65 [connection server2]
66 include/stop_group_replication.inc
67 [connection server3]
68 include/stop_group_replication.inc
69 SET @@GLOBAL.group_replication_member_weight = @member_weight3_save;
70 SET @@GLOBAL.DEBUG= @debug3_save;
71 include/group_replication_end.inc