Debian Codegraph @

mysql-test/suite/rpl_gtid/t/rpl_async_conn_auto_failover_highest_weight.test

raw
1 # ==== Purpose ====
2 #
3 # WL#12649: Automatic reconnection for Async replication between InnoDB Clusters
4 #
5 # It verifies that replica does does not connect to unhealthy sender
6 # during auto-failover.
7 #
8 # ==== Implementation ====
9 #
10 # 1. Verify Asynchronous Replication Connection Failover is initially
11 # disabled. Also verify Asynchronous Replication is initially
12 # connected to server_1.
13 # 2. Enable Asynchronous Replication Connection Failover and set retry
14 # count and retry time to 1 and verify its enabled in
15 # performance_schema.replication_connection_configuration.
16 # 3. Add two asynchronous connection failover servers including
17 # server 1 to which it is currently connected. Verify that they are
18 # inserted successfully in
19 # performance_schema.replication_asynchronous_connection_failover.
20 # 4. Stop server 1.
21 # 5. Verify connection is not attempted with server-1 when it is offline.
22 # Verify connection failover to server-3.
23 # 6. Start server-1 again.
24 # Verify connection is fail over to server-1 when it is online.
25 # 7. Clean up
26 #
27
28 --let $rpl_server_count=3
29 --let $use_gtids= 1
30 --source include/master-slave.inc
31
32 --echo #
33 --echo # 1. Verify Asynchronous Replication Connection Failover is initially
34 --echo # disabled. Also verify Asynchronous Replication is initially
35 --echo # connected to server_1.
36 --echo #
37
38 --let $rpl_connection_name= server_2
39 --source include/rpl_connection.inc
40
41 --let $assert_text= 'Asynchronous Replication Connection Failover is disabled'
42 --let $assert_cond= [SELECT SOURCE_CONNECTION_AUTO_FAILOVER FROM performance_schema.replication_connection_configuration, SOURCE_CONNECTION_AUTO_FAILOVER, 1] = 0
43 --source include/assert.inc
44
45 --let $wait_condition= SELECT COUNT(*) = 1 FROM performance_schema.replication_connection_configuration WHERE CHANNEL_NAME='' AND PORT=$MASTER_MYPORT
46 --source include/wait_condition.inc
47
48
49 --echo #
50 --echo # 2. Enable Asynchronous Replication Connection Failover and set retry
51 --echo # count and retry time to 1 and verify its enabled in
52 --echo # performance_schema.replication_connection_configuration.
53 --echo #
54
55 --let $rpl_connection_name= server_2
56 --source include/rpl_connection.inc
57
58 --source include/stop_slave.inc
59 CHANGE REPLICATION SOURCE TO SOURCE_CONNECT_RETRY=1, SOURCE_RETRY_COUNT=1, SOURCE_CONNECTION_AUTO_FAILOVER=1;
60 --source include/start_slave.inc
61
62 # Verify Asynchronous Replication Connection Failover is enabled.
63 --let $assert_text= 'Asynchronous Replication Connection Failover is enabled'
64 --let $assert_cond= [SELECT SOURCE_CONNECTION_AUTO_FAILOVER FROM performance_schema.replication_connection_configuration, SOURCE_CONNECTION_AUTO_FAILOVER, 1] = 1
65 --source include/assert.inc
66
67
68 --echo #
69 --echo # 3. Add two asynchronous connection failover servers including
70 --echo # server 1 to which it is currently connected. Verify that they are
71 --echo # inserted successfully in
72 --echo # performance_schema.replication_asynchronous_connection_failover.
73 --echo #
74
75 --let $rpl_connection_name= server_2
76 --source include/rpl_connection.inc
77
78 --replace_result $SERVER_MYPORT_1 SERVER_MYPORT_1
79 --eval SELECT asynchronous_connection_failover_add_source('', '127.0.0.1', $SERVER_MYPORT_1, '', 70);
80 --replace_result $SERVER_MYPORT_3 SERVER_MYPORT_3
81 --eval SELECT asynchronous_connection_failover_add_source('', '127.0.0.1', $SERVER_MYPORT_3, '', 50);
82
83 --let $assert_text= 'There are two rows in performance_schema.replication_asynchronous_connection_failover'
84 --let $assert_cond= [SELECT COUNT(*) count FROM performance_schema.replication_asynchronous_connection_failover, count, 1] = 2
85 --source include/assert.inc
86
87
88 --echo #
89 --echo # 4. Stop server 1.
90 --echo #
91
92 --let $rpl_server_number= 1
93 --source include/rpl_stop_server.inc
94
95 --echo #
96 --echo # 5. Verify connection is not attempted with server-1 when it is offline.
97 --echo # Verify connection failover to server-3.
98 --echo #
99
100 --let $rpl_connection_name= server_2
101 --source include/rpl_connection.inc
102
103 --let $wait_condition= SELECT COUNT(*) = 1 FROM performance_schema.replication_connection_configuration WHERE CHANNEL_NAME='' AND PORT=$SERVER_MYPORT_3
104 --source include/wait_condition.inc
105
106 --sleep 30
107
108 --let $assert_text= 'Asynch connection failover is not attempted with off single-server.'
109 --let $assert_cond= "[SELECT COUNT(*) as count FROM performance_schema.error_log WHERE error_code=\'MY-010584\' AND data LIKE \"%Error connecting to source \'%:$SERVER_MYPORT_1\'. This was attempt % with a delay of 1 seconds between attempts. Message:%\", count, 1]" >= 1
110 --source include/assert.inc
111
112 --echo #
113 --echo # 6. Start server-1 again.
114 --echo # Verify connection is fail over to server-1 when it is online.
115 --echo #
116
117
118 --let $rpl_server_number=1
119 --source include/rpl_start_server.inc
120
121 --let $rpl_server_number= 1
122 --source include/rpl_reconnect.inc
123
124 --let $rpl_connection_name= server_2
125 --source include/rpl_connection.inc
126
127 --let $wait_condition= SELECT COUNT(*) = 1 FROM performance_schema.replication_connection_configuration WHERE CHANNEL_NAME='' AND PORT=$SERVER_MYPORT_1
128 --source include/wait_condition.inc
129
130
131 --echo #
132 --echo # 7. Clean up
133 --echo #
134
135 --let $rpl_connection_name= server_2
136 --source include/rpl_connection.inc
137
138 --source include/stop_slave.inc
139 --let $rpl_reset_slave_all= 1
140 --source include/rpl_reset_slave.inc
141 --let $rpl_reset_slave_all=
142
143 --replace_result $SERVER_MYPORT_1 SERVER_MYPORT_1
144 --eval SELECT asynchronous_connection_failover_delete_source('', '127.0.0.1', $SERVER_MYPORT_1, '');
145 --replace_result $SERVER_MYPORT_3 SERVER_MYPORT_3
146 --eval SELECT asynchronous_connection_failover_delete_source('', '127.0.0.1', $SERVER_MYPORT_3, '');
147
148 --let $rpl_skip_sync= 1
149 --let $rpl_only_running_threads= 1
150 --source include/rpl_end.inc