| 1 |
include/group_replication.inc |
| 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 server1] |
| 6 |
|
| 7 |
############################################################ |
| 8 |
# 1. Try to reset asynchronous reconnection configuration on |
| 9 |
# a server running GR. |
| 10 |
# It will not be allowed. |
| 11 |
[connection server1] |
| 12 |
include/start_and_bootstrap_group_replication.inc |
| 13 |
SELECT asynchronous_connection_failover_reset(); |
| 14 |
ERROR HY000: Can't initialize function 'asynchronous_connection_failover_reset'; Can't execute the given operation while Group Replication is running. |
| 15 |
|
| 16 |
############################################################ |
| 17 |
# 2. Try to reset asynchronous reconnection configuration on |
| 18 |
# a server not running GR. |
| 19 |
# It will be allowed. |
| 20 |
[connection server2] |
| 21 |
include/start_group_replication.inc |
| 22 |
[connection server3] |
| 23 |
SELECT asynchronous_connection_failover_add_managed('ch1_3', 'GroupReplication', 'FAILOVER_GROUP_NAME', '127.0.0.1', SERVER_MYPORT_2, '', 80, 60); |
| 24 |
asynchronous_connection_failover_add_managed('ch1_3', 'GroupReplication', 'FAILOVER_GROUP_NAME', '127.0.0.1', SERVER_MYPORT_2, '', 80, 60) |
| 25 |
The UDF asynchronous_connection_failover_add_managed() executed successfully. |
| 26 |
include/assert.inc ['There is one row in performance_schema.replication_asynchronous_connection_failover_managed'] |
| 27 |
include/assert.inc ['The version of replication_asynchronous_connection_failover_managed must be 1'] |
| 28 |
include/assert.inc ['There is one row in performance_schema.replication_asynchronous_connection_failover'] |
| 29 |
include/assert.inc ['The version of replication_asynchronous_connection_failover must be 1'] |
| 30 |
CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_USER='root', SOURCE_AUTO_POSITION=1, SOURCE_CONNECTION_AUTO_FAILOVER=1, SOURCE_PORT=SERVER_1_PORT, SOURCE_CONNECT_RETRY=1, SOURCE_RETRY_COUNT=2 FOR CHANNEL 'ch1_3'; |
| 31 |
Warnings: |
| 32 |
Note 1759 Sending passwords in plain text without SSL/TLS is extremely insecure. |
| 33 |
Note 1760 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. |
| 34 |
include/start_slave.inc [FOR CHANNEL 'ch1_3'] |
| 35 |
include/assert.inc ['The version of replication_asynchronous_connection_failover must be 2 or greater'] |
| 36 |
include/stop_slave.inc [FOR CHANNEL 'ch1_3'] |
| 37 |
SELECT asynchronous_connection_failover_reset(); |
| 38 |
asynchronous_connection_failover_reset() |
| 39 |
The UDF asynchronous_connection_failover_reset() executed successfully. |
| 40 |
include/assert.inc ['There is no row in performance_schema.replication_asynchronous_connection_failover_managed'] |
| 41 |
include/assert.inc ['There is no version of replication_asynchronous_connection_failover_managed'] |
| 42 |
include/assert.inc ['There is no row in performance_schema.replication_asynchronous_connection_failover'] |
| 43 |
include/assert.inc ['There is no version of replication_asynchronous_connection_failover'] |
| 44 |
|
| 45 |
############################################################ |
| 46 |
# 3. Clean up. |
| 47 |
[connection server3] |
| 48 |
include/rpl_reset_slave.inc |
| 49 |
include/group_replication_end.inc |