Debian Codegraph @

mysql-test/suite/group_replication/t/gr_acf_receiver_member_join.test

raw
1 ###############################################################################
2 # Validate that, on single-primary mode:
3 # * the replication failover channels configuration of the member that
4 # bootstraps a group, becomes the group configuration.
5 # * a member that joins the group, overrides its configuration with the
6 # one of the group.
7 #
8 # Test:
9 # 0. This test requires two servers
10 # 1. Add a single server and managed sources to failover
11 # channel 'ch1' to server1.
12 # 2. Bootstrap the group on server1, all failover configuration
13 # will be preserved.
14 # 3. Join server2 to the group, it will replace its failover
15 # configuration.
16 # 4. Clean up
17 ###############################################################################
18 --source include/have_group_replication_plugin.inc
19 --let $rpl_skip_group_replication_start= 1
20 --let $rpl_group_replication_single_primary_mode=1
21 --source include/group_replication.inc
22
23
24 --echo
25 --echo ############################################################
26 --echo # 1. Add a single server and managed sources to failover
27 --echo # channel 'ch1' to server1.
28 --let $rpl_connection_name= server1
29 --source include/rpl_connection.inc
30
31 CHANGE REPLICATION SOURCE TO SOURCE_HOST='10.0.0.1', SOURCE_USER='root', SOURCE_AUTO_POSITION=1, SOURCE_CONNECTION_AUTO_FAILOVER=1, SOURCE_PORT=3306, SOURCE_CONNECT_RETRY=1, SOURCE_RETRY_COUNT=1 FOR CHANNEL 'ch1';
32 SELECT asynchronous_connection_failover_add_source('ch1', '10.0.0.1', 3306, '', 50);
33 SELECT asynchronous_connection_failover_add_managed('ch1', 'GroupReplication', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa', '10.0.0.2', 3306, '', 90, 70);
34
35 --let $assert_text= 'There are 2 rows in performance_schema.replication_asynchronous_connection_failover'
36 --let $assert_cond= [SELECT COUNT(*) count FROM performance_schema.replication_asynchronous_connection_failover, count, 1] = 2
37 --source include/assert.inc
38
39 --let $assert_text= 'The version of replication_asynchronous_connection_failover must be 2'
40 --let $assert_cond= [SELECT version FROM performance_schema.replication_group_configuration_version WHERE name=\'replication_asynchronous_connection_failover\', version, 1] = 2
41 --source include/assert.inc
42
43 --let $assert_text= 'There is 1 row in performance_schema.replication_asynchronous_connection_failover_managed'
44 --let $assert_cond= [SELECT COUNT(*) count FROM performance_schema.replication_asynchronous_connection_failover_managed, count, 1] = 1
45 --source include/assert.inc
46
47 --let $assert_text= 'The version of replication_asynchronous_connection_failover_managed must be 1'
48 --let $assert_cond= [SELECT version FROM performance_schema.replication_group_configuration_version WHERE name=\'replication_asynchronous_connection_failover_managed\', version, 1] = 1
49 --source include/assert.inc
50
51 --let $assert_text= 'SOURCE_CONNECTION_AUTO_FAILOVER must be enabled on ch1'
52 --let $assert_cond= [SELECT COUNT(*) AS count FROM performance_schema.replication_connection_configuration WHERE CHANNEL_NAME="ch1" AND SOURCE_CONNECTION_AUTO_FAILOVER=1, count, 1] = 1
53 --source include/assert.inc
54
55 --let $assert_text= 'SOURCE_CONNECTION_AUTO_FAILOVER=1 must be persisted on ch1'
56 --let $assert_cond= [SELECT COUNT(*) AS count FROM mysql.slave_master_info WHERE CHANNEL_NAME="ch1" AND SOURCE_CONNECTION_AUTO_FAILOVER=1, count, 1] = 1
57 --source include/assert.inc
58
59 SELECT * FROM performance_schema.replication_asynchronous_connection_failover;
60
61 SELECT * FROM performance_schema.replication_asynchronous_connection_failover_managed;
62
63 SELECT * FROM performance_schema.replication_group_configuration_version WHERE name LIKE 'replication_asynchronous_connection_failover%';
64
65
66 --echo
67 --echo ############################################################
68 --echo # 2. Bootstrap the group on server1, all failover configuration
69 --echo # will be preserved.
70 --let $rpl_connection_name= server1
71 --source include/rpl_connection.inc
72
73 # Do not automatically start failover channels.
74 SELECT group_replication_disable_member_action("mysql_start_failover_channels_if_primary", "AFTER_PRIMARY_ELECTION");
75
76 --source include/start_and_bootstrap_group_replication.inc
77
78 --let $assert_text= The action mysql_start_failover_channels_if_primary must be disabled
79 --let $assert_cond= [SELECT enabled FROM performance_schema.replication_group_member_actions WHERE name=\'mysql_start_failover_channels_if_primary\' AND event=\'AFTER_PRIMARY_ELECTION\', enabled, 1] = 0
80 --source include/assert.inc
81
82 --let $assert_text= 'There are 2 rows in performance_schema.replication_asynchronous_connection_failover'
83 --let $assert_cond= [SELECT COUNT(*) count FROM performance_schema.replication_asynchronous_connection_failover, count, 1] = 2
84 --source include/assert.inc
85
86 --let $assert_text= 'The version of replication_asynchronous_connection_failover must be 2'
87 --let $assert_cond= [SELECT version FROM performance_schema.replication_group_configuration_version WHERE name=\'replication_asynchronous_connection_failover\', version, 1] = 2
88 --source include/assert.inc
89
90 --let $assert_text= 'There is 1 row in performance_schema.replication_asynchronous_connection_failover_managed'
91 --let $assert_cond= [SELECT COUNT(*) count FROM performance_schema.replication_asynchronous_connection_failover_managed, count, 1] = 1
92 --source include/assert.inc
93
94 --let $assert_text= 'The version of replication_asynchronous_connection_failover_managed must be 1'
95 --let $assert_cond= [SELECT version FROM performance_schema.replication_group_configuration_version WHERE name=\'replication_asynchronous_connection_failover_managed\', version, 1] = 1
96 --source include/assert.inc
97
98 --let $assert_text= 'SOURCE_CONNECTION_AUTO_FAILOVER must be enabled on ch1'
99 --let $assert_cond= [SELECT COUNT(*) AS count FROM performance_schema.replication_connection_configuration WHERE CHANNEL_NAME="ch1" AND SOURCE_CONNECTION_AUTO_FAILOVER=1, count, 1] = 1
100 --source include/assert.inc
101
102 --let $assert_text= 'SOURCE_CONNECTION_AUTO_FAILOVER=1 must be persisted on ch1'
103 --let $assert_cond= [SELECT COUNT(*) AS count FROM mysql.slave_master_info WHERE CHANNEL_NAME="ch1" AND SOURCE_CONNECTION_AUTO_FAILOVER=1, count, 1] = 1
104 --source include/assert.inc
105
106 SELECT * FROM performance_schema.replication_asynchronous_connection_failover;
107
108 SELECT * FROM performance_schema.replication_asynchronous_connection_failover_managed;
109
110 SELECT * FROM performance_schema.replication_group_configuration_version WHERE name LIKE 'replication_asynchronous_connection_failover%';
111
112
113 --echo
114 --echo ############################################################
115 --echo # 3. Join server2 to the group, it will replace its failover
116 --echo # configuration.
117 --let $rpl_connection_name= server2
118 --source include/rpl_connection.inc
119
120 CHANGE REPLICATION SOURCE TO SOURCE_HOST='10.0.0.1', SOURCE_USER='root', SOURCE_AUTO_POSITION=1, SOURCE_CONNECTION_AUTO_FAILOVER=0, SOURCE_PORT=3306, SOURCE_CONNECT_RETRY=1, SOURCE_RETRY_COUNT=1 FOR CHANNEL 'ch1';
121 SELECT asynchronous_connection_failover_add_source('ch9', '10.0.0.19', 3306, '', 50);
122 SELECT asynchronous_connection_failover_add_source('ch9', '10.0.0.20', 3306, '', 50);
123 SELECT asynchronous_connection_failover_add_managed('ch9', 'GroupReplication', 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa', '10.0.0.29', 3306, '', 90, 70);
124
125 --let $assert_text= 'SOURCE_CONNECTION_AUTO_FAILOVER=0 must be persisted on ch1'
126 --let $assert_cond= [SELECT COUNT(*) AS count FROM mysql.slave_master_info WHERE CHANNEL_NAME="ch1" AND SOURCE_CONNECTION_AUTO_FAILOVER=0, count, 1] = 1
127 --source include/assert.inc
128
129 --source include/start_group_replication.inc
130
131 --let $assert_text= The action mysql_start_failover_channels_if_primary must be disabled
132 --let $assert_cond= [SELECT enabled FROM performance_schema.replication_group_member_actions WHERE name=\'mysql_start_failover_channels_if_primary\' AND event=\'AFTER_PRIMARY_ELECTION\', enabled, 1] = 0
133 --source include/assert.inc
134
135 --let $assert_text= 'There are 2 rows in performance_schema.replication_asynchronous_connection_failover'
136 --let $assert_cond= [SELECT COUNT(*) count FROM performance_schema.replication_asynchronous_connection_failover, count, 1] = 2
137 --source include/assert.inc
138
139 --let $assert_text= 'The version of replication_asynchronous_connection_failover must be 2'
140 --let $assert_cond= [SELECT version FROM performance_schema.replication_group_configuration_version WHERE name=\'replication_asynchronous_connection_failover\', version, 1] = 2
141 --source include/assert.inc
142
143 --let $assert_text= 'There is 1 row in performance_schema.replication_asynchronous_connection_failover_managed'
144 --let $assert_cond= [SELECT COUNT(*) count FROM performance_schema.replication_asynchronous_connection_failover_managed, count, 1] = 1
145 --source include/assert.inc
146
147 --let $assert_text= 'The version of replication_asynchronous_connection_failover_managed must be 1'
148 --let $assert_cond= [SELECT version FROM performance_schema.replication_group_configuration_version WHERE name=\'replication_asynchronous_connection_failover_managed\', version, 1] = 1
149 --source include/assert.inc
150
151 --let $assert_text= 'SOURCE_CONNECTION_AUTO_FAILOVER must be enabled for ch1'
152 --let $assert_cond= [SELECT COUNT(*) AS count FROM performance_schema.replication_connection_configuration WHERE CHANNEL_NAME="ch1" AND SOURCE_CONNECTION_AUTO_FAILOVER=1, count, 1] = 1
153 --source include/assert.inc
154
155 SELECT * FROM performance_schema.replication_asynchronous_connection_failover;
156
157 SELECT * FROM performance_schema.replication_asynchronous_connection_failover_managed;
158
159 SELECT * FROM performance_schema.replication_group_configuration_version WHERE name LIKE 'replication_asynchronous_connection_failover%';
160
161 --let $assert_text= 'SOURCE_CONNECTION_AUTO_FAILOVER must be enabled on ch1'
162 --let $assert_cond= [SELECT COUNT(*) AS count FROM performance_schema.replication_connection_configuration WHERE CHANNEL_NAME="ch1" AND SOURCE_CONNECTION_AUTO_FAILOVER=1, count, 1] = 1
163 --source include/assert.inc
164
165 --let $assert_text= 'SOURCE_CONNECTION_AUTO_FAILOVER=1 must be persisted on ch1'
166 --let $assert_cond= [SELECT COUNT(*) AS count FROM mysql.slave_master_info WHERE CHANNEL_NAME="ch1" AND SOURCE_CONNECTION_AUTO_FAILOVER=1, count, 1] = 1
167 --source include/assert.inc
168
169 --echo
170 --echo ############################################################
171 --echo # 4. Clean up.
172 --let $rpl_connection_name= server1
173 --source include/rpl_connection.inc
174 --let $rpl_channel_name='ch1'
175 --let $rpl_multi_source= 1
176 --let $rpl_reset_slave_all= 1
177 --source include/rpl_reset_slave.inc
178 --let $rpl_channel_name=
179 --let $rpl_multi_source=
180
181 --let $rpl_connection_name= server2
182 --source include/rpl_connection.inc
183 --let $rpl_channel_name='ch1'
184 --let $rpl_multi_source= 1
185 --let $rpl_reset_slave_all= 1
186 --source include/rpl_reset_slave.inc
187 --let $rpl_channel_name=
188 --let $rpl_multi_source=
189
190 --source include/group_replication_end.inc