Debian Codegraph @

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

raw
1 include/group_replication.inc
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 ############################################################
8 # 1. Create a table on the group.
9 CREATE TABLE t1 (c1 INT NOT NULL PRIMARY KEY) ENGINE=InnoDB;
10 include/rpl_sync.inc
11
12 ############################################################
13 # 2. Execute some transactions on both members.
14 # Transactions executed on member 1 will be on member 2
15 # applier channel received_transaction_set, and the dual
16 # for member 2 transactions.
17 include/rpl_sync.inc
18
19 ############################################################
20 # 3. Assert that both members have holes on its applier
21 # channel received_transaction_set.
22 # The holes are expected and despite them members data is
23 # equal.
24 [connection server1]
25 include/assert.inc [The value of received_transaction_set must have holes]
26 [connection server2]
27 include/assert.inc [The value of received_transaction_set must have holes]
28 include/diff_tables.inc [server1:test.t1, server2:test.t1]
29
30 ############################################################
31 # 4. Wait for stable set propagation and certification info
32 # garbage collection. When that happens, the holes on
33 # applier channel will be filled.
34 [connection server1]
35
36 ############################################################
37 # 5. Assert that both members dot not have holes on their
38 # applier channel received_transaction_set.
39 [connection server1]
40 include/assert.inc [The value of received_transaction_set must not have holes]
41 [connection server2]
42 include/assert.inc [The value of received_transaction_set must not have holes]
43
44 ############################################################
45 # 6. Clean up.
46 DROP TABLE t1;
47 include/group_replication_end.inc