Debian Codegraph @

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

raw
1 --source include/have_innodb.inc
2 --let $rpl_topology=1->2
3 --source include/rpl_init.inc
4
5 --echo *** Test connecting with empty GTID state to start from very beginning of binlog ***
6 --connection server_2
7 --source include/stop_slave.inc
8 RESET MASTER;
9 RESET SLAVE;
10 SHOW VARIABLES LIKE 'gtid_binlog_pos';
11 SHOW VARIABLES LIKE 'gtid_current_pos';
12 SHOW VARIABLES LIKE 'gtid_slave_pos';
13 SHOW VARIABLES LIKE 'gtid_binlog_state';
14
15 --connection server_1
16 RESET MASTER;
17 FLUSH LOGS;
18 CREATE TABLE t1 (a INT PRIMARY KEY) ENGINE=InnoDB;
19 SET @@SESSION.gtid_domain_id=1;
20 INSERT INTO t1 VALUES(1);
21
22 SET @@SESSION.gtid_domain_id=99999;
23 INSERT INTO t1 VALUES(3);
24
25 SET @@SESSION.gtid_domain_id=10;
26 INSERT INTO t1 VALUES(4);
27
28 SET @@SESSION.gtid_domain_id=100;
29 INSERT INTO t1 VALUES(5);
30
31 SET @@SESSION.gtid_domain_id=2147483648; # 0x80000000
32 INSERT INTO t1 VALUES(6);
33
34 SET @@SESSION.gtid_domain_id=4294967295; # 0xFFFFFFFF
35 INSERT INTO t1 VALUES(7);
36
37 SHOW VARIABLES LIKE 'gtid_binlog_pos';
38 SHOW VARIABLES LIKE 'gtid_current_pos';
39 SHOW VARIABLES LIKE 'gtid_slave_pos';
40 SHOW VARIABLES LIKE 'gtid_binlog_state';
41 --save_master_pos
42
43 --connection server_2
44 SHOW VARIABLES LIKE 'gtid_binlog_pos';
45 SHOW VARIABLES LIKE 'gtid_current_pos';
46 SHOW VARIABLES LIKE 'gtid_slave_pos';
47 SHOW VARIABLES LIKE 'gtid_binlog_state';
48 --replace_result $MASTER_MYPORT MASTER_PORT
49 eval CHANGE MASTER TO master_host = '127.0.0.1', master_port = $MASTER_MYPORT,
50 MASTER_USE_GTID=SLAVE_POS;
51 --source include/start_slave.inc
52 --sync_with_master
53 SHOW VARIABLES LIKE 'gtid_binlog_pos';
54 SHOW VARIABLES LIKE 'gtid_current_pos';
55 SHOW VARIABLES LIKE 'gtid_slave_pos';
56 SHOW VARIABLES LIKE 'gtid_binlog_state';
57 SELECT * FROM t1;
58
59 SET @@SESSION.gtid_domain_id=1000;
60 INSERT INTO t1 VALUES(8);
61
62 SET @@SESSION.gtid_domain_id=89;
63 INSERT INTO t1 VALUES(9);
64
65 SET @@SESSION.gtid_domain_id=10100000;
66 INSERT INTO t1 VALUES(10);
67
68 SHOW VARIABLES LIKE 'gtid_binlog_pos';
69 SHOW VARIABLES LIKE 'gtid_current_pos';
70 SHOW VARIABLES LIKE 'gtid_slave_pos';
71 SHOW VARIABLES LIKE 'gtid_binlog_state';
72
73 # Clean up.
74 --connection server_1
75 DROP TABLE t1;
76
77 --source include/rpl_end.inc