Debian Codegraph @

mysql-test/suite/group_replication/r/gr_acf_receiver_spm_to_mpm.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 ############################################################
8 # 1. Deploy a group in single-primary mode on server1 and server2.
9 [connection server1]
10 include/start_and_bootstrap_group_replication.inc
11 include/gr_assert_primary_member.inc
12 [connection server2]
13 [connection server2]
14 CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_USER='root', SOURCE_AUTO_POSITION=1, SOURCE_CONNECTION_AUTO_FAILOVER=1, SOURCE_PORT=SERVER_3_PORT, SOURCE_CONNECT_RETRY=1, SOURCE_RETRY_COUNT=1 FOR CHANNEL 'ch1';
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_group_replication.inc
19 include/gr_assert_secondary_member.inc
20
21 ############################################################
22 # 2. Configure a failover channel on server1 that replicates
23 # from server3.
24 [connection server3]
25 [connection server1]
26 CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_USER='root', SOURCE_AUTO_POSITION=1, SOURCE_CONNECTION_AUTO_FAILOVER=1, SOURCE_PORT=SERVER_3_PORT, SOURCE_CONNECT_RETRY=1, SOURCE_RETRY_COUNT=1 FOR CHANNEL 'ch1';
27 Warnings:
28 Note 1759 Sending passwords in plain text without SSL/TLS is extremely insecure.
29 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.
30 SELECT asynchronous_connection_failover_add_source('ch1', '127.0.0.1', SERVER_MYPORT_3, '', 50);;
31 asynchronous_connection_failover_add_source('ch1', '127.0.0.1', SERVER_MYPORT_3, '', 50)
32 The UDF asynchronous_connection_failover_add_source() executed successfully.
33 include/start_slave.inc [FOR CHANNEL 'ch1']
34 include/assert.inc ['There is 1 row in performance_schema.replication_asynchronous_connection_failover']
35 include/assert.inc ['The version of replication_asynchronous_connection_failover must be 1']
36 include/assert.inc ['SOURCE_CONNECTION_AUTO_FAILOVER must be enabled on ch1']
37 include/assert.inc [Verify channel ch1 IO_THREAD is ON and connected to server3]
38 include/assert.inc [Verify channel ch1 SQL_THREAD is ON]
39 include/assert.inc [Verify replica_monitor thread is running]
40
41 ############################################################
42 # 3. Assert failover channel configuration on server2.
43 [connection server2]
44 include/assert.inc ['There is 1 row in performance_schema.replication_asynchronous_connection_failover']
45 include/assert.inc ['The version of replication_asynchronous_connection_failover must be 1']
46 include/assert.inc ['SOURCE_CONNECTION_AUTO_FAILOVER must be enabled on ch1']
47 include/assert.inc [Verify channel ch1 IO_THREAD is OFF]
48 include/assert.inc [Verify channel ch1 SQL_THREAD is OFF]
49 include/assert.inc [Verify replica_monitor thread is not running]
50 SELECT * FROM performance_schema.replication_asynchronous_connection_failover;
51 CHANNEL_NAME HOST PORT NETWORK_NAMESPACE WEIGHT MANAGED_NAME
52 ch1 127.0.0.1 ##### 50
53 SELECT * FROM performance_schema.replication_group_configuration_version WHERE name LIKE 'replication_asynchronous_connection_failover';
54 name version
55 replication_asynchronous_connection_failover 1
56
57 ############################################################
58 # 4. Change to multi-primary mode.
59 # The failover channel will remain working on server1.
60 [connection server1]
61 SELECT group_replication_switch_to_multi_primary_mode();
62 group_replication_switch_to_multi_primary_mode()
63 Mode switched to multi-primary successfully.
64 include/gr_assert_multi_primary_mode.inc
65 include/check_slave_is_running.inc [FOR CHANNEL 'ch1']
66 [connection server2]
67 include/gr_assert_multi_primary_mode.inc
68
69 ############################################################
70 # 5. Add more sources to channel 'ch1' on server1
71 # and change SOURCE_CONNECTION_AUTO_FAILOVER value,
72 # they will not be propagated to server2.
73 [connection server1]
74 SELECT asynchronous_connection_failover_add_source('ch1', '127.0.0.1', SERVER_MYPORT_4, '', 50);;
75 asynchronous_connection_failover_add_source('ch1', '127.0.0.1', SERVER_MYPORT_4, '', 50)
76 The UDF asynchronous_connection_failover_add_source() executed successfully.
77 include/stop_slave.inc [FOR CHANNEL 'ch1']
78 CHANGE REPLICATION SOURCE TO SOURCE_CONNECTION_AUTO_FAILOVER=0 FOR CHANNEL 'ch1';
79 include/start_slave.inc [FOR CHANNEL 'ch1']
80 include/assert.inc ['There are 2 rows in performance_schema.replication_asynchronous_connection_failover']
81 SELECT * FROM performance_schema.replication_asynchronous_connection_failover;
82 CHANNEL_NAME HOST PORT NETWORK_NAMESPACE WEIGHT MANAGED_NAME
83 ch1 127.0.0.1 ##### 50
84 ch1 127.0.0.1 ##### 50
85 SELECT * FROM performance_schema.replication_group_configuration_version WHERE name LIKE 'replication_asynchronous_connection_failover';
86 name version
87 replication_asynchronous_connection_failover 2
88 [connection server2]
89 include/assert.inc ['There is 1 row in performance_schema.replication_asynchronous_connection_failover']
90 include/assert.inc ['The version of replication_asynchronous_connection_failover must be 1']
91 include/assert.inc ['SOURCE_CONNECTION_AUTO_FAILOVER must be enabled on ch1']
92 include/assert.inc [Verify channel ch1 IO_THREAD is OFF]
93 include/assert.inc [Verify channel ch1 SQL_THREAD is OFF]
94 include/assert.inc [Verify replica_monitor thread is not running]
95 SELECT * FROM performance_schema.replication_asynchronous_connection_failover;
96 CHANNEL_NAME HOST PORT NETWORK_NAMESPACE WEIGHT MANAGED_NAME
97 ch1 127.0.0.1 ##### 50
98 SELECT * FROM performance_schema.replication_group_configuration_version WHERE name LIKE 'replication_asynchronous_connection_failover';
99 name version
100 replication_asynchronous_connection_failover 1
101
102 ############################################################
103 # 6. server1 will leave the group, despite 'ch1' is a failover
104 # channel, since the group is on multi-primary mode, server2
105 # will not start channel 'ch1'.
106 [connection server1]
107 include/stop_group_replication.inc
108 [connection server2]
109 include/assert.inc [The action mysql_start_failover_channels_if_primary is enabled]
110 include/assert.inc ['There is 1 row in performance_schema.replication_asynchronous_connection_failover']
111 include/assert.inc ['The version of replication_asynchronous_connection_failover must be 1']
112 include/assert.inc ['SOURCE_CONNECTION_AUTO_FAILOVER must be enabled on ch1']
113 include/assert.inc [Verify channel ch1 IO_THREAD is OFF]
114 include/assert.inc [Verify channel ch1 SQL_THREAD is OFF]
115 include/assert.inc [Verify replica_monitor thread is not running]
116
117 ############################################################
118 # 7. Clean up.
119 [connection server2]
120 include/stop_group_replication.inc
121 include/rpl_reset_slave.inc
122 [connection server1]
123 include/rpl_reset_slave.inc
124 include/group_replication_end.inc