Debian Codegraph @

mysql-test/suite/rpl_gtid/r/rpl_async_conn_failover_restart.result

raw
1 include/master-slave.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 master]
6 #
7 # 1. Insert data on server1 and verify that its synced to the server 2.
8 #
9 [connection server_1]
10 CREATE TABLE t1 (a INT) ENGINE = InnoDB;
11 INSERT INTO t1 VALUES (1);
12 include/rpl_sync.inc
13 [connection server_2]
14 include/assert.inc ['There is one row on replica']
15 #
16 # 2. Verify Asynchronous Replication Connection Failover is initially
17 # disabled. Also verify Asynchronous Replication is initially
18 # connected to server 1.
19 #
20 include/assert.inc ['Asynchronous Replication Connection Failover is disabled']
21 #
22 # 3. Enable Asynchronous Replication Connection Failover and set retry
23 # count and retry time to 2 and verify its enabled in
24 # performance_schema.replication_connection_configuration.
25 #
26 # Adding debug point 'async_conn_failover_disable_weight_check' to @@GLOBAL.debug
27 include/stop_slave.inc
28 CHANGE REPLICATION SOURCE TO SOURCE_CONNECT_RETRY=1, SOURCE_RETRY_COUNT=2, SOURCE_CONNECTION_AUTO_FAILOVER=1;
29 include/start_slave.inc
30 include/assert.inc ['Asynchronous Replication Connection Failover is enabled']
31 #
32 # 4. Add asynchronous connection failover server. Verify that they are
33 # inserted successfully in
34 # performance_schema.replication_asynchronous_connection_failover.
35 #
36 SELECT asynchronous_connection_failover_add_source('', '127.0.0.1', SERVER_MYPORT_3, '', 50);;
37 asynchronous_connection_failover_add_source('', '127.0.0.1', SERVER_MYPORT_3, '', 50)
38 The UDF asynchronous_connection_failover_add_source() executed successfully.
39 include/assert.inc ['There are three rows in performance_schema.replication_asynchronous_connection_failover']
40 #
41 # 5. Initialize rpl_async_conn_failover_crash dbug sync point and stop
42 # server 1. The initialized dbug sync point will crash server 2.
43 # Reconnect to server 2 and start replica on it.
44 #
45 include/rpl_start_server.inc [server_number=2]
46 # Adding debug point 'async_conn_failover_crash' to @@GLOBAL.debug
47 include/rpl_stop_server.inc [server_number=1]
48 include/rpl_reconnect.inc
49 include/start_slave.inc
50 #
51 # 6. Verify that asynchronous replication channel gets connected to
52 # server 3 and also verify that asynchronous replication tries
53 # connecting to server 1 two (retry_count=2) times.
54 #
55 include/assert_grep.inc [Assert that the IO thread tried five times connecting to server_1]
56 #
57 # 7. Clean up
58 #
59 [connection server_2]
60 include/stop_slave.inc
61 include/rpl_reset_slave.inc
62 SELECT asynchronous_connection_failover_delete_source('', '127.0.0.1', SERVER_MYPORT_3, '');;
63 asynchronous_connection_failover_delete_source('', '127.0.0.1', SERVER_MYPORT_3, '')
64 The UDF asynchronous_connection_failover_delete_source() executed successfully.
65 DROP TABLE t1;
66 [connection server_1]
67 include/rpl_start_server.inc [server_number=1]
68 DROP TABLE t1;
69 include/rpl_end.inc