Debian Codegraph @

mysql-test/suite/rpl/r/rpl_dual_pos_advance.result

raw
1 include/rpl_init.inc [topology=1->2->1]
2 connection server_2;
3 create table t1 (n int);
4 connection server_1;
5 include/stop_slave.inc
6 create table t2 (n int);
7 connection server_2;
8 show tables;
9 Tables_in_test
10 t1
11 t2
12 create table t3 (n int) engine=innodb;
13 set @a=1;
14 insert into t3 values(@a);
15 begin;
16 insert into t3 values(2);
17 insert into t3 values(3);
18 commit;
19 insert into t3 values(4);
20 connection server_1;
21 start slave until master_log_file="MASTER_LOG_FILE",master_log_pos=MASTER_LOG_POS;
22 Warnings:
23 Note 1278 It is recommended to use --skip-slave-start when doing step-by-step replication with START SLAVE UNTIL; otherwise, you will get problems if you get an unexpected slave's mariadbd restart
24 include/wait_for_slave_sql_to_stop.inc
25 show tables;
26 Tables_in_test
27 t1
28 t2
29 start slave until master_log_file="MASTER_LOG_FILE",master_log_pos=MASTER_LOG_POS;
30 Warnings:
31 Note 1278 It is recommended to use --skip-slave-start when doing step-by-step replication with START SLAVE UNTIL; otherwise, you will get problems if you get an unexpected slave's mariadbd restart
32 include/wait_for_slave_sql_to_stop.inc
33 select * from t3;
34 n
35 1
36 start slave until master_log_file="MASTER_LOG_FILE",master_log_pos=MASTER_LOG_POS;
37 Warnings:
38 Note 1278 It is recommended to use --skip-slave-start when doing step-by-step replication with START SLAVE UNTIL; otherwise, you will get problems if you get an unexpected slave's mariadbd restart
39 include/wait_for_slave_sql_to_stop.inc
40 select * from t3;
41 n
42 1
43 2
44 3
45 include/start_slave.inc
46 connection server_1;
47 create table t4 (n int);
48 create table t5 (n int);
49 create table t6 (n int);
50 connection server_2;
51 connection server_1;
52 show tables;
53 Tables_in_test
54 t1
55 t2
56 t3
57 t4
58 t5
59 t6
60 drop table t1, t2, t3, t4, t5, t6;
61 include/rpl_end.inc