Debian Codegraph @

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

raw
1 include/rpl_init.inc [topology=1->2]
2 *** Test connecting with empty GTID state to start from very beginning of binlog ***
3 connection server_2;
4 include/stop_slave.inc
5 RESET MASTER;
6 RESET SLAVE;
7 SHOW VARIABLES LIKE 'gtid_binlog_pos';
8 Variable_name Value
9 gtid_binlog_pos
10 SHOW VARIABLES LIKE 'gtid_current_pos';
11 Variable_name Value
12 gtid_current_pos
13 SHOW VARIABLES LIKE 'gtid_slave_pos';
14 Variable_name Value
15 gtid_slave_pos
16 SHOW VARIABLES LIKE 'gtid_binlog_state';
17 Variable_name Value
18 gtid_binlog_state
19 connection server_1;
20 RESET MASTER;
21 FLUSH LOGS;
22 CREATE TABLE t1 (a INT PRIMARY KEY) ENGINE=InnoDB;
23 SET @@SESSION.gtid_domain_id=1;
24 INSERT INTO t1 VALUES(1);
25 SET @@SESSION.gtid_domain_id=99999;
26 INSERT INTO t1 VALUES(3);
27 SET @@SESSION.gtid_domain_id=10;
28 INSERT INTO t1 VALUES(4);
29 SET @@SESSION.gtid_domain_id=100;
30 INSERT INTO t1 VALUES(5);
31 SET @@SESSION.gtid_domain_id=2147483648;
32 INSERT INTO t1 VALUES(6);
33 SET @@SESSION.gtid_domain_id=4294967295;
34 INSERT INTO t1 VALUES(7);
35 SHOW VARIABLES LIKE 'gtid_binlog_pos';
36 Variable_name Value
37 gtid_binlog_pos 0-1-1,1-1-1,10-1-1,100-1-1,99999-1-1,2147483648-1-1,4294967295-1-1
38 SHOW VARIABLES LIKE 'gtid_current_pos';
39 Variable_name Value
40 gtid_current_pos 0-1-1,1-1-1,10-1-1,100-1-1,99999-1-1,2147483648-1-1,4294967295-1-1
41 SHOW VARIABLES LIKE 'gtid_slave_pos';
42 Variable_name Value
43 gtid_slave_pos
44 SHOW VARIABLES LIKE 'gtid_binlog_state';
45 Variable_name Value
46 gtid_binlog_state 0-1-1,1-1-1,10-1-1,100-1-1,99999-1-1,2147483648-1-1,4294967295-1-1
47 connection server_2;
48 SHOW VARIABLES LIKE 'gtid_binlog_pos';
49 Variable_name Value
50 gtid_binlog_pos
51 SHOW VARIABLES LIKE 'gtid_current_pos';
52 Variable_name Value
53 gtid_current_pos
54 SHOW VARIABLES LIKE 'gtid_slave_pos';
55 Variable_name Value
56 gtid_slave_pos
57 SHOW VARIABLES LIKE 'gtid_binlog_state';
58 Variable_name Value
59 gtid_binlog_state
60 CHANGE MASTER TO master_host = '127.0.0.1', master_port = MASTER_PORT,
61 MASTER_USE_GTID=SLAVE_POS;
62 include/start_slave.inc
63 SHOW VARIABLES LIKE 'gtid_binlog_pos';
64 Variable_name Value
65 gtid_binlog_pos 0-1-1,1-1-1,10-1-1,100-1-1,99999-1-1,2147483648-1-1,4294967295-1-1
66 SHOW VARIABLES LIKE 'gtid_current_pos';
67 Variable_name Value
68 gtid_current_pos 0-1-1,1-1-1,10-1-1,100-1-1,99999-1-1,2147483648-1-1,4294967295-1-1
69 SHOW VARIABLES LIKE 'gtid_slave_pos';
70 Variable_name Value
71 gtid_slave_pos 0-1-1,1-1-1,10-1-1,100-1-1,99999-1-1,2147483648-1-1,4294967295-1-1
72 SHOW VARIABLES LIKE 'gtid_binlog_state';
73 Variable_name Value
74 gtid_binlog_state 0-1-1,1-1-1,10-1-1,100-1-1,99999-1-1,2147483648-1-1,4294967295-1-1
75 SELECT * FROM t1;
76 a
77 1
78 3
79 4
80 5
81 6
82 7
83 SET @@SESSION.gtid_domain_id=1000;
84 INSERT INTO t1 VALUES(8);
85 SET @@SESSION.gtid_domain_id=89;
86 INSERT INTO t1 VALUES(9);
87 SET @@SESSION.gtid_domain_id=10100000;
88 INSERT INTO t1 VALUES(10);
89 SHOW VARIABLES LIKE 'gtid_binlog_pos';
90 Variable_name Value
91 gtid_binlog_pos 0-1-1,1-1-1,10-1-1,89-2-1,100-1-1,1000-2-1,99999-1-1,10100000-2-1,2147483648-1-1,4294967295-1-1
92 SHOW VARIABLES LIKE 'gtid_current_pos';
93 Variable_name Value
94 gtid_current_pos 0-1-1,1-1-1,10-1-1,89-2-1,100-1-1,1000-2-1,99999-1-1,10100000-2-1,2147483648-1-1,4294967295-1-1
95 SHOW VARIABLES LIKE 'gtid_slave_pos';
96 Variable_name Value
97 gtid_slave_pos 0-1-1,1-1-1,10-1-1,100-1-1,99999-1-1,2147483648-1-1,4294967295-1-1
98 SHOW VARIABLES LIKE 'gtid_binlog_state';
99 Variable_name Value
100 gtid_binlog_state 0-1-1,1-1-1,10-1-1,89-2-1,100-1-1,1000-2-1,99999-1-1,10100000-2-1,2147483648-1-1,4294967295-1-1
101 connection server_1;
102 DROP TABLE t1;
103 include/rpl_end.inc