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
48
49
50
51
52
53
54
55
56
57
|
################################################################################
# Check that it is not possible to flush Group Replication applier channel
# through FLUSH LOG command.
#
# Test:
# 0. The test requires two servers: M1 and M2.
# 1. Setup a new group with two members.
# 2. Check there are two relay logs of applier channel before the attempt to
# flush it.
# 3. Try flush relay logs on applier channel with member ONLINE. It must
# SUCCEED.
# 4. Check there is a new relay log of applier channel after the attempt
# to flush it.
# 5. Try flush relay logs on applier channel with member OFFLINE. It must
# SUCCEED.
# 6. Check there is a new relay log of applier channel after the attempt
# to flush it.
################################################################################
--source include/have_group_replication_plugin.inc
--echo #
--echo # Setup a new group with two members.
--echo #
--source include/group_replication.inc
--echo #
--echo # There are two relay logs of Group Replication applier
--echo # channel before the attempt to flush it.
--echo #
--file_exists $MYSQLTEST_VARDIR/mysqld.2/data/server-relay-log-group_replication_applier.000001
--file_exists $MYSQLTEST_VARDIR/mysqld.2/data/server-relay-log-group_replication_applier.000002
--echo #
--echo # Try flush applier channel with Group Replication working.
--echo #
--connection server2
FLUSH RELAY LOGS FOR CHANNEL "group_replication_applier";
--echo #
--echo # There is a new relay log of Group Replication applier channel after
--echo # trying to flush it.
--echo #
--file_exists $MYSQLTEST_VARDIR/mysqld.2/data/server-relay-log-group_replication_applier.000003
--echo #
--echo # Try flush applier channel with Group Replication stopped.
--echo #
--source include/stop_group_replication.inc
FLUSH LOCAL RELAY LOGS FOR CHANNEL "group_replication_applier";
--echo #
--echo # There is a new relay log of Group Replication applier channel after
--echo # trying to flush it.
--echo #
--file_exists $MYSQLTEST_VARDIR/mysqld.2/data/server-relay-log-group_replication_applier.000004
--source include/group_replication_end.inc
|
