Debian Codegraph @

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

raw
1 include/group_replication.inc [rpl_server_count=5]
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. Deploy a 3 members group in single primary mode.
8
9 [connection server1]
10 include/start_and_bootstrap_group_replication.inc
11 [connection server2]
12 CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_USER='root', SOURCE_AUTO_POSITION=1, SOURCE_PORT=SERVER_4_PORT, SOURCE_CONNECT_RETRY=1, SOURCE_RETRY_COUNT=1, SOURCE_CONNECTION_AUTO_FAILOVER=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 include/start_group_replication.inc
17 [connection server3]
18 CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_USER='root', SOURCE_AUTO_POSITION=1, SOURCE_PORT=SERVER_4_PORT, SOURCE_CONNECT_RETRY=1, SOURCE_RETRY_COUNT=1, SOURCE_CONNECTION_AUTO_FAILOVER=1 FOR CHANNEL 'ch1';
19 Warnings:
20 Note 1759 Sending passwords in plain text without SSL/TLS is extremely insecure.
21 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.
22 include/start_group_replication.inc
23
24 # 2. Create a replication channel to replicate from server4 to
25 # server1.
26
27 [connection server1]
28 CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_USER='root', SOURCE_AUTO_POSITION=1, SOURCE_PORT=SERVER_4_PORT, SOURCE_CONNECT_RETRY=1, SOURCE_RETRY_COUNT=1, SOURCE_CONNECTION_AUTO_FAILOVER=1 FOR CHANNEL 'ch1';
29 Warnings:
30 Note 1759 Sending passwords in plain text without SSL/TLS is extremely insecure.
31 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.
32
33 # 3. Add replication connection details of server4 and server5
34 # to replication_asynchronous_connection_failover table
35 # through asynchronous_connection_failover_add_source() UDF.
36
37 SELECT asynchronous_connection_failover_add_source('ch1', '127.0.0.1', SERVER_MYPORT_4, '', 50);
38 asynchronous_connection_failover_add_source('ch1', '127.0.0.1', SERVER_MYPORT_4, '', 50)
39 The UDF asynchronous_connection_failover_add_source() executed successfully.
40 SELECT asynchronous_connection_failover_add_source('ch1', '127.0.0.1', SERVER_MYPORT_5, '', 40);
41 asynchronous_connection_failover_add_source('ch1', '127.0.0.1', SERVER_MYPORT_5, '', 40)
42 The UDF asynchronous_connection_failover_add_source() executed successfully.
43
44 # 4. Start replica for channel ch1.
45
46 include/start_slave.inc [FOR CHANNEL 'ch1']
47
48 # 5. Verify replication_asynchronous_connection_failover on
49 # server1 has two rows (of server4 and server5) and member action
50 # configuration version value is 2 in
51 # replication_group_configuration_version.
52
53
54 # 6. Verify replication_asynchronous_connection_failover on
55 # server2 and server3 has two rows (of server4 and server5) and
56 # member action configuration version value is 2 in
57 # replication_group_configuration_version.
58
59 [connection server2]
60 [connection server3]
61
62 # 7. Delete replication connection details of server4 and server5
63 # from replication_asynchronous_connection_failover table
64 # through asynchronous_connection_failover_delete_source() UDF.
65
66 [connection server1]
67 SELECT asynchronous_connection_failover_delete_source('ch1', '127.0.0.1', SERVER_MYPORT_4, '');
68 asynchronous_connection_failover_delete_source('ch1', '127.0.0.1', SERVER_MYPORT_4, '')
69 The UDF asynchronous_connection_failover_delete_source() executed successfully.
70 SELECT asynchronous_connection_failover_delete_source('ch1', '127.0.0.1', SERVER_MYPORT_5, '');
71 asynchronous_connection_failover_delete_source('ch1', '127.0.0.1', SERVER_MYPORT_5, '')
72 The UDF asynchronous_connection_failover_delete_source() executed successfully.
73
74 # 8. Verify replication_asynchronous_connection_failover on
75 # server1 is empty and member action configuration version value
76 # is 4 in replication_group_configuration_version.
77
78
79 # 9. Verify replication_asynchronous_connection_failover on
80 # server2 is empty and member action configuration version value
81 # is 4 in replication_group_configuration_version.
82
83 [connection server2]
84
85 # 10. Clean up.
86
87 [connection server1]
88 include/stop_slave.inc [FOR CHANNEL 'ch1']
89 include/rpl_reset_slave.inc
90 [connection server2]
91 include/rpl_reset_slave.inc
92 [connection server3]
93 include/rpl_reset_slave.inc
94 include/group_replication_end.inc