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