Debian Codegraph @

mysql-test/suite/rpl/t/rpl_delayed_slave2.test

raw
1 --source include/have_innodb.inc
2 --source include/master-slave.inc
3
4 # This test file tests delayed slave for parallel replication (and GTID).
5 # Uses a different approach from rpl_delayed_slave.test, setting @@timestamp
6 # to simulate events logged on master at different times.
7
8 --connection master
9 ALTER TABLE mysql.gtid_slave_pos ENGINE=InnoDB;
10 CREATE TABLE t1 (a INT PRIMARY KEY, b VARCHAR(100));
11 INSERT INTO t1 VALUES (1, "a");
12 --save_master_pos
13
14 --connection slave
15 --sync_with_master
16 --source include/stop_slave.inc
17 CHANGE MASTER TO master_use_gtid=slave_pos;
18 SET @old_mode= @@GLOBAL.slave_parallel_mode;
19 SET GLOBAL slave_parallel_mode=optimistic;
20 SET @old_threads= @@GLOBAL.slave_parallel_threads;
21 SET GLOBAL slave_parallel_threads=10;
22
23 --connection master
24 INSERT INTO t1 VALUES (2, "b");
25 INSERT INTO t1 VALUES (3, "b");
26 INSERT INTO t1 VALUES (4, "b");
27 --let $gtid1= `SELECT @@gtid_binlog_pos`
28 # Simulate an event a days in the future, for delayed slave to wait on.
29 SET timestamp= @@timestamp + 24*60*60;
30 INSERT INTO t1 VALUES (5, "c");
31 INSERT INTO t1 VALUES (6, "c");
32 SET timestamp= 0;
33 --let $gtid2= `SELECT @@gtid_binlog_pos`
34 --source include/save_master_gtid.inc
35
36 --connection slave
37 CHANGE MASTER TO master_delay=1;
38 --source include/start_slave.inc
39 --replace_result $gtid1 GTID1
40 # First sync halfways, to avoid timing-dependent test failures.
41 eval SELECT MASTER_GTID_WAIT('$gtid1');
42 # Try to sync up, should timeout because slave is waiting for one day.
43 --replace_result $gtid2 GTID2
44 eval SELECT MASTER_GTID_WAIT('$gtid2', 2);
45
46 # Check that we can stop slave while delaying.
47 --source include/stop_slave.inc
48 SELECT * FROM t1 ORDER BY a;
49 CHANGE MASTER TO master_delay=0;
50 --source include/start_slave.inc
51 --source include/sync_with_master_gtid.inc
52 SELECT * FROM t1 ORDER BY a;
53
54
55 --connection slave
56 --source include/stop_slave.inc
57 CHANGE MASTER TO master_use_gtid=no, master_delay=0;
58 SET GLOBAL slave_parallel_mode=@old_mode;
59 SET GLOBAL slave_parallel_threads=@old_threads;
60 --source include/start_slave.inc
61
62 --connection master
63 DROP TABLE t1;
64
65 --source include/rpl_end.inc