Debian Codegraph @

mysql-test/suite/group_replication/r/gr_acf_receiver_status_reset.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 ############################################################
8 # 1. Deploy a group in single-primary mode on server1
9 # configure a failover channel 'ch1'.
10 [connection server1]
11 include/start_and_bootstrap_group_replication.inc
12 CHANGE REPLICATION SOURCE TO SOURCE_HOST='10.0.0.1', SOURCE_USER='root', SOURCE_AUTO_POSITION=1, SOURCE_CONNECTION_AUTO_FAILOVER=1, SOURCE_PORT=3306, SOURCE_CONNECT_RETRY=1, SOURCE_RETRY_COUNT=1 FOR CHANNEL 'ch1';
13 Warnings:
14 Note 1759 Sending passwords in plain text without SSL/TLS is extremely insecure.
15 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.
16
17 ############################################################
18 # 2. Leave the group and only then reset the failover
19 # channel 'ch1'.
20 [connection server1]
21 include/stop_group_replication.inc
22 include/rpl_reset_slave.inc
23
24 ############################################################
25 # 3. Deploy again a group in single-primary mode on server1.
26 [connection server1]
27 include/start_and_bootstrap_group_replication.inc
28
29 ############################################################
30 # 4. Join server2 to the group.
31 # server2 successful join will validate that past ch1
32 # failover status is properly clean on server.
33 [connection server2]
34 include/start_group_replication.inc
35 ############################################################
36 # 5. Clean up.
37 include/group_replication_end.inc