Debian Codegraph @

mysql-test/suite/group_replication/r/gr_acf_start_failover_channels_on_bootstrap.result

raw
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 # 1. Configure server2 to be a asynchronous replica of server1,
8 # configuring a failover channel to server1.
9 [connection server1]
10 [connection server2]
11 SELECT asynchronous_connection_failover_add_source('ch1', '127.0.0.1', SERVER_MYPORT_1, '', 50);;
12 asynchronous_connection_failover_add_source('ch1', '127.0.0.1', SERVER_MYPORT_1, '', 50)
13 The UDF asynchronous_connection_failover_add_source() executed successfully.
14 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=1 FOR CHANNEL 'ch1';
15 Warnings:
16 Note 1759 Sending passwords in plain text without SSL/TLS is extremely insecure.
17 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.
18
19 ############################################################
20 # 2. Bootstrap a group on server2.
21 # Since `mysql_start_failover_channels_if_primary` member
22 # action is enabled, channel 'ch1' will be started.
23 [connection server2]
24 include/assert.inc [The action mysql_start_failover_channels_if_primary must be enabled]
25 include/start_and_bootstrap_group_replication.inc
26 include/gr_assert_primary_member.inc
27 include/wait_for_slave_to_start.inc [FOR CHANNEL 'ch1']
28 include/assert_grep.inc [The member action "mysql_start_failover_channels_if_primary" for event "AFTER_PRIMARY_ELECTION" with priority "10" will be run.]
29 include/assert.inc ['SOURCE_CONNECTION_AUTO_FAILOVER must be enabled on ch1']
30 include/assert.inc [Verify channel ch1 IO_THREAD is ON]
31 include/assert.inc [Verify channel ch1 SQL_THREAD is ON]
32 include/assert.inc [Verify replica_monitor thread is running]
33 ############################################################
34 # 3. Clean up.
35 [connection server2]
36 include/stop_group_replication.inc
37 include/rpl_reset_slave.inc
38 include/group_replication_end.inc