| 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 |