Debian Codegraph @

mysql-test/suite/group_replication/t/gr_parallel_applier_indexes_empty_transactions.test

raw
1 ################################################################################
2 # Validate that empty transactions are applied in parallel in
3 # `group_replication_applier` channel.
4 #
5 # Test:
6 # 0. The test requires two servers: M1 and M2.
7 # 1. Execute DDL, DML and empty transactions.
8 # 2. Validate applier indexes on server2
9 # `group_replication_applier` channel.
10 # 3. Clean up.
11 ################################################################################
12 --source include/have_group_replication_plugin.inc
13 --source include/group_replication.inc
14
15
16 --echo
17 --echo ############################################################
18 --echo # 1. Execute DDL, DML and empty transactions.
19 --let $rpl_connection_name= server1
20 --source include/rpl_connection.inc
21 # on server2 `group_replication_applier` channel: DDL
22 # server_id=1, last_committed=1, sequence_number=2
23 CREATE TABLE t1 (c1 INT NOT NULL PRIMARY KEY);
24
25 # on server2 `group_replication_applier` channel: empty transaction
26 # server_id=1, last_committed=2, sequence_number=3
27 SET GTID_NEXT= 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1';
28 BEGIN;
29 COMMIT;
30 SET GTID_NEXT= 'AUTOMATIC';
31
32 # on server2 `group_replication_applier` channel: empty transaction
33 # server_id=1, last_committed=2, sequence_number=4
34 SET GTID_NEXT= 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:2';
35 BEGIN;
36 COMMIT;
37 SET GTID_NEXT= 'AUTOMATIC';
38
39 # on server2 `group_replication_applier` channel: DML
40 # server_id=1, last_committed=2, sequence_number=5
41 INSERT INTO t1 VALUES (1);
42
43 # on server2 `group_replication_applier` channel: empty transaction
44 # server_id=1, last_committed=2, sequence_number=6
45 SET GTID_NEXT= 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:3';
46 BEGIN;
47 COMMIT;
48 SET GTID_NEXT= 'AUTOMATIC';
49
50 # on server2 `group_replication_applier` channel: DDL
51 # server_id=1, last_committed=6, sequence_number=7
52 DROP TABLE t1;
53
54 # on server2 `group_replication_applier` channel: empty transaction
55 # server_id=1, last_committed=7, sequence_number=8
56 SET GTID_NEXT= 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:4';
57 BEGIN;
58 COMMIT;
59 SET GTID_NEXT= 'AUTOMATIC';
60
61 # on server2 `group_replication_applier` channel: empty transaction
62 # server_id=1, last_committed=7, sequence_number=9
63 SET GTID_NEXT= 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:5';
64 BEGIN;
65 COMMIT;
66 SET GTID_NEXT= 'AUTOMATIC';
67
68 --source include/rpl_sync.inc
69
70
71 --echo
72 --echo ############################################################
73 --echo # 2. Validate applier indexes on server2
74 --echo # `group_replication_applier` channel.
75 --let $rpl_connection_name= server2
76 --source include/rpl_connection.inc
77 --let $binlog_file= server-relay-log-group_replication_applier.000002
78 --let $logical_timestamps= 0 0;0 0;1 2;2 3;2 4;2 5;2 6;6 7;7 8;7 9
79 --source include/assert_logical_timestamps.inc
80
81
82 --echo
83 --echo ############################################################
84 --echo # 3. Clean up.
85 --source include/group_replication_end.inc