Debian Codegraph @

mysql-test/suite/rpl_gtid/r/rpl_async_conn_auto_failover_highest_weight.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. Verify Asynchronous Replication Connection Failover is initially
8 # disabled. Also verify Asynchronous Replication is initially
9 # connected to server_1.
10 #
11 [connection server_2]
12 include/assert.inc ['Asynchronous Replication Connection Failover is disabled']
13 #
14 # 2. Enable Asynchronous Replication Connection Failover and set retry
15 # count and retry time to 1 and verify its enabled in
16 # performance_schema.replication_connection_configuration.
17 #
18 [connection server_2]
19 include/stop_slave.inc
20 CHANGE REPLICATION SOURCE TO SOURCE_CONNECT_RETRY=1, SOURCE_RETRY_COUNT=1, SOURCE_CONNECTION_AUTO_FAILOVER=1;
21 include/start_slave.inc
22 include/assert.inc ['Asynchronous Replication Connection Failover is enabled']
23 #
24 # 3. Add two asynchronous connection failover servers including
25 # server 1 to which it is currently connected. Verify that they are
26 # inserted successfully in
27 # performance_schema.replication_asynchronous_connection_failover.
28 #
29 [connection server_2]
30 SELECT asynchronous_connection_failover_add_source('', '127.0.0.1', SERVER_MYPORT_1, '', 70);;
31 asynchronous_connection_failover_add_source('', '127.0.0.1', SERVER_MYPORT_1, '', 70)
32 The UDF asynchronous_connection_failover_add_source() executed successfully.
33 SELECT asynchronous_connection_failover_add_source('', '127.0.0.1', SERVER_MYPORT_3, '', 50);;
34 asynchronous_connection_failover_add_source('', '127.0.0.1', SERVER_MYPORT_3, '', 50)
35 The UDF asynchronous_connection_failover_add_source() executed successfully.
36 include/assert.inc ['There are two rows in performance_schema.replication_asynchronous_connection_failover']
37 #
38 # 4. Stop server 1.
39 #
40 include/rpl_stop_server.inc [server_number=1]
41 #
42 # 5. Verify connection is not attempted with server-1 when it is offline.
43 # Verify connection failover to server-3.
44 #
45 [connection server_2]
46 include/assert.inc ['Asynch connection failover is not attempted with off single-server.']
47 #
48 # 6. Start server-1 again.
49 # Verify connection is fail over to server-1 when it is online.
50 #
51 include/rpl_start_server.inc [server_number=1]
52 include/rpl_reconnect.inc
53 [connection server_2]
54 #
55 # 7. Clean up
56 #
57 [connection server_2]
58 include/stop_slave.inc
59 include/rpl_reset_slave.inc
60 SELECT asynchronous_connection_failover_delete_source('', '127.0.0.1', SERVER_MYPORT_1, '');;
61 asynchronous_connection_failover_delete_source('', '127.0.0.1', SERVER_MYPORT_1, '')
62 The UDF asynchronous_connection_failover_delete_source() executed successfully.
63 SELECT asynchronous_connection_failover_delete_source('', '127.0.0.1', SERVER_MYPORT_3, '');;
64 asynchronous_connection_failover_delete_source('', '127.0.0.1', SERVER_MYPORT_3, '')
65 The UDF asynchronous_connection_failover_delete_source() executed successfully.
66 include/rpl_end.inc