Debian Codegraph @

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

raw
1 include/group_replication.inc [rpl_server_count=3]
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 # Setup a new group with two servers.
8 # Check that server 2 receives a view event and writes another one
9 #
10 server1
11 include/start_and_bootstrap_group_replication.inc
12 CREATE TABLE t1 (c1 INT NOT NULL PRIMARY KEY) ENGINE=InnoDB;
13 server2
14 include/start_group_replication.inc
15 include/assert_binlog_events.inc [Gtid # Query/BEGIN # View_change # Query/COMMIT # !Gtid_transaction # Gtid # Query/BEGIN # View_change # Query/COMMIT]
16 #
17 # Make server 2 leave and enter generating one more view change event
18 # Check that only one view change transaction is written to the binlog
19 #
20 server2
21 include/stop_group_replication.inc
22 include/assert_binlog_events.inc [Gtid # Query/BEGIN # View_change # Query/COMMIT # !Gtid_transaction # Gtid # Query/BEGIN # View_change # Query/COMMIT]
23 include/start_group_replication.inc
24 include/assert_binlog_events.inc [Gtid # Query/BEGIN # View_change # Query/COMMIT # !Gtid_transaction # Gtid # Query/BEGIN # View_change # Query/COMMIT # Gtid # Query/BEGIN # View_change # Query/COMMIT]
25 #
26 # Make server 3 join and leave while server 2 was away
27 # Server 2 should receive 1 view change transaction from recovery and
28 # write another
29 #
30 server2
31 include/stop_group_replication.inc
32 server3
33 include/start_group_replication.inc
34 include/stop_group_replication.inc
35 server2
36 include/start_group_replication.inc
37 include/assert_binlog_events.inc [Gtid # Query/BEGIN # View_change # Query/COMMIT # !Gtid_transaction # Gtid # Query/BEGIN # View_change # Query/COMMIT # Gtid # Query/BEGIN # View_change # Query/COMMIT # Gtid # Query/BEGIN # View_change # Query/COMMIT # Gtid # Query/BEGIN # View_change # Query/COMMIT]
38 #
39 # Cleaning up
40 #
41 server3
42 include/start_group_replication.inc
43 DROP TABLE t1;
44 include/group_replication_end.inc