Debian Codegraph @

mysql-test/suite/group_replication/r/gr_acf_receiver_add_delete_managed.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 [connection server2]
7 [connection server3]
8 [connection server4]
9 [connection server5]
10 #
11 # 1. Deploy a 3 members receiver group in single primary mode.
12 #
13 [connection server1]
14 SET GLOBAL GROUP_REPLICATION_GROUP_SEEDS= "LOCAL_ADDRESS_SERVER1, LOCAL_ADDRESS_SERVER2";
15 include/start_and_bootstrap_group_replication.inc
16 [connection server2]
17 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';
18 Warnings:
19 Note 1759 Sending passwords in plain text without SSL/TLS is extremely insecure.
20 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.
21 SET GLOBAL GROUP_REPLICATION_GROUP_SEEDS= "LOCAL_ADDRESS_SERVER1, LOCAL_ADDRESS_SERVER2";
22 include/start_group_replication.inc
23 #
24 # 2. Deploy a 2 members sender group in single primary mode.
25 # The third member of the group i.e. server5 will be added later
26 # to verify changes are getting synced to receiver group members.
27 #
28 [connection server3]
29 SET GLOBAL GROUP_REPLICATION_GROUP_SEEDS= "LOCAL_ADDRESS_SERVER3, LOCAL_ADDRESS_SERVER4, LOCAL_ADDRESS_SERVER5";
30 include/start_and_bootstrap_group_replication.inc
31 [connection server4]
32 SET GLOBAL GROUP_REPLICATION_GROUP_SEEDS= "LOCAL_ADDRESS_SERVER3, LOCAL_ADDRESS_SERVER4, LOCAL_ADDRESS_SERVER5";
33 include/start_group_replication.inc
34
35 # 3. Create a replication channel to replicate from server3 to
36 # server1.
37
38 [connection server1]
39 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';
40 Warnings:
41 Note 1759 Sending passwords in plain text without SSL/TLS is extremely insecure.
42 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.
43
44 # 4. Add replication connection details of managed channel ch1
45 # to replication_asynchronous_connection_failover_managed table
46 # through asynchronous_connection_failover_add_managed() UDF.
47
48 SELECT asynchronous_connection_failover_add_managed('ch1', 'GroupReplication', "GROUP_B",'127.0.0.1', SERVER_MYPORT_4, '', 80, 60);
49 asynchronous_connection_failover_add_managed('ch1', 'GroupReplication', "GROUP_B",'127.0.0.1', SERVER_MYPORT_4, '', 80, 60)
50 The UDF asynchronous_connection_failover_add_managed() executed successfully.
51
52 # 5. Start replica for channel ch1.
53
54 include/start_slave.inc [FOR CHANNEL 'ch1']
55
56 # 6. Verify replication_asynchronous_connection_failover on
57 # server1 has two rows and member action configuration version
58 # value for replication_asynchronous_connection_failover
59 # and for replication_asynchronous_connection_failover_managed.
60
61
62 # 7. Verify replication_asynchronous_connection_failover on
63 # server2 has two rows and member action configuration version
64 # value for replication_asynchronous_connection_failover
65 # and for replication_asynchronous_connection_failover_managed.
66
67 [connection server2]
68 #
69 # 8. Add another member i.e. server5 to sender group.
70 #
71 [connection server5]
72 SET GLOBAL GROUP_REPLICATION_GROUP_SEEDS= "LOCAL_ADDRESS_SERVER3, LOCAL_ADDRESS_SERVER4, LOCAL_ADDRESS_SERVER5";
73 include/start_group_replication.inc
74 include/assert.inc [There are three members in the group.]
75
76 # 9. Verify replication_asynchronous_connection_failover on
77 # server1 has three rows and member action configuration version
78 # value for replication_asynchronous_connection_failover
79 # and for replication_asynchronous_connection_failover_managed.
80
81 [connection server1]
82
83 # 10. Verify replication_asynchronous_connection_failover on
84 # server2 has three rows and member action configuration version
85 # value for replication_asynchronous_connection_failover
86 # and for replication_asynchronous_connection_failover_managed.
87
88 [connection server2]
89
90 # 11. Delete replication connection details for managed channel ch1
91 # from replication_asynchronous_connection_failover_managed
92 # and replication_asynchronous_connection_failover table
93 # through asynchronous_connection_failover_delete_managed() UDF.
94
95 [connection server1]
96 SELECT asynchronous_connection_failover_delete_managed('ch1', 'GROUP_B');
97 asynchronous_connection_failover_delete_managed('ch1', 'GROUP_B')
98 The UDF asynchronous_connection_failover_delete_managed() executed successfully.
99
100 # 12. Verify replication_asynchronous_connection_failover on
101 # server1 is empty and member action configuration version
102 # value for replication_asynchronous_connection_failover
103 # and for replication_asynchronous_connection_failover_managed.
104
105
106 # 13. Verify replication_asynchronous_connection_failover on
107 # server2 is empty and member action configuration version
108 # value for replication_asynchronous_connection_failover
109 # and for replication_asynchronous_connection_failover_managed.
110
111 [connection server2]
112 #
113 # 14. Clean up.
114 #
115 [connection server1]
116 include/stop_slave.inc [FOR CHANNEL 'ch1']
117 include/rpl_reset_slave.inc
118 [connection server5]
119 include/stop_group_replication.inc
120 [connection server4]
121 include/stop_group_replication.inc
122 [connection server3]
123 include/stop_group_replication.inc
124 [connection server2]
125 include/stop_group_replication.inc
126 include/rpl_reset_slave.inc
127 [connection server1]
128 include/stop_group_replication.inc
129 include/group_replication_end.inc