Debian Codegraph @

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

raw
1 include/rpl_init.inc [topology=1->2]
2 connection server_1;
3 SET @old_strict= @@GLOBAL.gtid_strict_mode;
4 SET GLOBAL gtid_strict_mode= 1;
5 select @@global.log_slave_updates;
6 @@global.log_slave_updates
7 0
8 CREATE TABLE t1 (a INT PRIMARY KEY, b INT);
9 INSERT INTO t1 VALUES (1, 1);
10 INSERT INTO t1 VALUES (2, 1);
11 connection server_2;
12 SET @old_strict= @@GLOBAL.gtid_strict_mode;
13 SET GLOBAL gtid_strict_mode= 1;
14 select @@global.log_slave_updates;
15 @@global.log_slave_updates
16 0
17 SELECT * FROM t1 ORDER BY a;
18 a b
19 1 1
20 2 1
21 include/stop_slave.inc
22 connection server_1;
23 CHANGE MASTER TO master_host = '127.0.0.1', master_port = SLAVE_PORT, master_ssl_verify_server_cert=0,
24 master_user = 'root', master_ssl_verify_server_cert=0;
25 START SLAVE;
26 include/wait_for_slave_to_start.inc
27 connection server_2;
28 INSERT INTO t1 VALUES (3, 2);
29 INSERT INTO t1 VALUES (4, 2);
30 include/save_master_gtid.inc
31 include/show_binlog_events.inc
32 Log_name Pos Event_type Server_id End_log_pos Info
33 slave-bin.000001 # Gtid # # BEGIN GTID #-#-#
34 slave-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES (3, 2)
35 slave-bin.000001 # Query # # COMMIT
36 slave-bin.000001 # Gtid # # BEGIN GTID #-#-#
37 slave-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES (4, 2)
38 slave-bin.000001 # Query # # COMMIT
39 connection server_1;
40 include/sync_with_master_gtid.inc
41 SELECT * FROM t1 ORDER BY a;
42 a b
43 1 1
44 2 1
45 3 2
46 4 2
47 include/stop_slave.inc
48 RESET SLAVE;
49 INSERT INTO t1 VALUES (5, 1);
50 INSERT INTO t1 VALUES (6, 1);
51 include/save_master_gtid.inc
52 connection server_2;
53 CHANGE MASTER TO master_host = '127.0.0.1', master_port = MASTER_PORT, master_ssl_verify_server_cert=0;
54 START SLAVE;
55 include/sync_with_master_gtid.inc
56 SELECT * FROM t1 ORDER BY a;
57 a b
58 1 1
59 2 1
60 3 2
61 4 2
62 5 1
63 6 1
64 SET GLOBAL gtid_strict_mode= @old_strict;
65 connection server_1;
66 SET GLOBAL gtid_strict_mode= @old_strict;
67 DROP TABLE t1;
68 include/rpl_end.inc