Debian Codegraph @

mysql-test/suite/group_replication/r/gr_primary_mode_group_operations_15.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 # 1. server1 start group replication and server2 join
8 include/start_and_bootstrap_group_replication.inc
9 [connection server2]
10 include/start_group_replication.inc
11
12 # 2. server1 as slave connection to server3
13 [connection server1]
14 CHANGE REPLICATION SOURCE TO SOURCE_HOST='localhost', SOURCE_USER='root', SOURCE_PORT=SERVER_3_PORT for channel 'ch3_1';
15 Warnings:
16 Note 1759 Sending passwords in plain text without SSL/TLS is extremely insecure.
17 Note 1760 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.
18 include/start_slave.inc [FOR CHANNEL 'ch3_1']
19
20 # 3. Set primary election max weight on server2
21 [connection server2]
22 SET @@GLOBAL.group_replication_member_weight= 100;
23
24 # 4. Execute action to single primary mode. It shall succeed, server 1
25 # is the only with slave connections
26 SELECT group_replication_switch_to_single_primary_mode();
27 group_replication_switch_to_single_primary_mode()
28 Mode switched to single-primary successfully.
29
30 # 5. Confirm that server2 has super_read_only= 1
31
32 # 6. Server1 is the primary server on the group
33 # Servers with slave channels take priority over high weight members
34 [connection server2]
35 include/gr_assert_secondary_member.inc
36 [connection server1]
37 include/gr_assert_primary_member.inc
38
39 # 7. Cleanup
40 STOP SLAVE FOR CHANNEL 'ch3_1';
41 Warnings:
42 Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead
43 RESET SLAVE ALL FOR CHANNEL 'ch3_1';
44 Warnings:
45 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
46 [connection server2]
47 SET @@GLOBAL.group_replication_member_weight= DEFAULT;
48 include/group_replication_end.inc