Debian Codegraph @

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

raw
1 include/have_replication_observers_example_plugin.inc
2 include/group_replication.inc
3 Warnings:
4 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
5 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.
6 [connection server1]
7
8 # 1. Load plugin replication observers example on server1
9 include/install_replication_observers_example.inc
10
11 # 2. Execute UDF that will transmit tag and message over GR send
12 # service. Only server 1 registered service.
13 SELECT group_replication_service_message_send("tag", "Server1 sent a message");
14 group_replication_service_message_send("tag", "Server1 sent a message")
15 The tag and message was sent to the group.
16
17 # 3. Verify both servers are ONLINE
18 include/assert.inc [Verify both servers are online]
19
20 # 4. Load plugin replication observers example on server2
21 [connection server2]
22 include/install_replication_observers_example.inc
23
24 # 5. On server 2 execute UDF that will transmit tag and message over GR
25 # send service
26 SELECT group_replication_service_message_send("tag", "Server2 sent a message");
27 group_replication_service_message_send("tag", "Server2 sent a message")
28 The tag and message was sent to the group.
29
30 # 6. To decrease failure rate on assert_grep we do a transaction with
31 # AFTER consistency to add some rounds on GCS communication and stop GR on
32 # server1, which will make it wait for the delivery of new view, and
33 # that will happen only after delivery of service message. This will
34 # give some time to server to receive and write it to error log.
35 SET @@SESSION.group_replication_consistency= 'AFTER';
36 CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY , b INT);
37 DROP TABLE test.t1;
38 include/stop_group_replication.inc
39
40 # 7. Assert server1 received two messages
41 [connection server1]
42 include/assert_grep.inc [Server 1 received two messages]
43
44 # 8. Assert server2 one messages transmitted by GR message delivery
45 [connection server2]
46 include/assert_grep.inc [Server 2 received message from itself.]
47
48 # 9. Cleanup
49 include/start_group_replication.inc
50 include/uninstall_replication_observers_example.inc
51 [connection server1]
52 include/uninstall_replication_observers_example.inc
53 include/group_replication_end.inc