Debian Codegraph @

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

raw
1 include/master-slave.inc
2 [connection master]
3 # Initialize
4 connection slave;
5 ALTER TABLE mysql.gtid_slave_pos ENGINE=InnoDB;
6 # Setup data
7 connection master;
8 CREATE TABLE t1 (a int PRIMARY KEY, b INT) ENGINE=InnoDB;
9 include/save_master_gtid.inc
10 connection slave;
11 include/sync_with_master_gtid.inc
12 # 1. run some replication load that adds records to gtid_slave_pos table
13 # 2. stop slave, remove loaded data (it will be replicated), delete from
14 # gtid_slave_pos as the table is going to be restored
15 # 3. take dump from slave (master has an empty gtid_slave_pos)
16 # with --gtid and for the default value of both
17 # --dump-slave and --master-data
18 # and in loop for the two options do:
19 # 4. reset the slave state to install some initial state
20 # 5. restart slave server, restore the dump
21 # 6. check the final state which must be equal to the dump's one
22 # 7. start replication to see no error => Q.E.D.
23 # unless the test runs on a buggy version in which case set to zero.
24 # 1.
25 include/stop_slave.inc
26 delete from mysql.gtid_slave_pos;
27 connection master;
28 insert into t1 set a = 5;
29 insert into t1 set a = 4;
30 insert into t1 set a = 3;
31 insert into t1 set a = 2;
32 insert into t1 set a = 1;
33 include/save_master_gtid.inc
34 connection slave;
35 SET @@global.gtid_cleanup_batch_size = $val;
36 CHANGE MASTER TO master_use_gtid= no;
37 include/start_slave.inc
38 include/sync_with_master_gtid.inc
39 select * from mysql.gtid_slave_pos;
40 domain_id sub_id server_id seq_no
41 0 2 1 1
42 0 3 1 2
43 0 4 1 3
44 0 5 1 4
45 0 6 1 5
46 0 7 1 6
47 select @@global.gtid_slave_pos as "after initial slave got in sync";
48 after initial slave got in sync
49 0-1-6
50 # 2.
51 include/stop_slave.inc
52 # 3. A
53 include/stop_slave.inc
54 # 4.
55 set statement sql_log_bin=0 for delete from mysql.gtid_slave_pos;
56 insert into mysql.gtid_slave_pos values (99 + 2, 1, 1, 1);
57 # 5.
58 include/rpl_restart_server.inc [server_number=2]
59 SET @@global.gtid_cleanup_batch_size = $val;
60 select * from mysql.gtid_slave_pos;
61 domain_id sub_id server_id seq_no
62 101 1 1 1
63 select @@global.gtid_slave_pos as "before dump restore";
64 before dump restore
65 101-1-1
66 # 6.
67 select * from mysql.gtid_slave_pos;
68 domain_id sub_id server_id seq_no
69 0 2 1 6
70 select @@global.gtid_slave_pos as "after dump restore";
71 after dump restore
72 0-1-6
73 # 7.
74 reset slave;
75 select @@global.gtid_slave_pos;
76 @@global.gtid_slave_pos
77 0-1-6
78 change master to master_use_gtid=no;
79 connection master;
80 insert into t1 select 1+max(a),2 from t1;
81 include/save_master_gtid.inc
82 connection slave;
83 include/start_slave.inc
84 include/sync_with_master_gtid.inc
85 select * from mysql.gtid_slave_pos;
86 domain_id sub_id server_id seq_no
87 0 2 1 6
88 0 3 1 1
89 0 4 1 2
90 0 5 1 3
91 0 6 1 4
92 0 7 1 5
93 0 8 1 6
94 0 9 1 7
95 select @@global.gtid_slave_pos as "after slave got in sync";
96 after slave got in sync
97 0-1-7
98 include/stop_slave.inc
99 # 4.
100 set statement sql_log_bin=0 for delete from mysql.gtid_slave_pos;
101 insert into mysql.gtid_slave_pos values (99 + 1, 1, 1, 1);
102 # 5.
103 include/rpl_restart_server.inc [server_number=2]
104 SET @@global.gtid_cleanup_batch_size = $val;
105 select * from mysql.gtid_slave_pos;
106 domain_id sub_id server_id seq_no
107 100 1 1 1
108 select @@global.gtid_slave_pos as "before dump restore";
109 before dump restore
110 100-1-1
111 # 6.
112 select * from mysql.gtid_slave_pos;
113 domain_id sub_id server_id seq_no
114 0 2 1 6
115 select @@global.gtid_slave_pos as "after dump restore";
116 after dump restore
117 0-1-6
118 # 7.
119 reset slave;
120 select @@global.gtid_slave_pos;
121 @@global.gtid_slave_pos
122 0-1-6
123 change master to master_use_gtid=no;
124 connection master;
125 insert into t1 select 1+max(a),1 from t1;
126 include/save_master_gtid.inc
127 connection slave;
128 include/start_slave.inc
129 include/sync_with_master_gtid.inc
130 select * from mysql.gtid_slave_pos;
131 domain_id sub_id server_id seq_no
132 0 2 1 6
133 0 3 1 1
134 0 4 1 2
135 0 5 1 3
136 0 6 1 4
137 0 7 1 5
138 0 8 1 6
139 0 9 1 7
140 0 10 1 8
141 select @@global.gtid_slave_pos as "after slave got in sync";
142 after slave got in sync
143 0-1-8
144 #
145 # Cleanup
146 #
147 connection master;
148 DROP TABLE t1;
149 include/save_master_gtid.inc
150 connection slave;
151 SET @@global.gtid_cleanup_batch_size= $old_gtid_cleanup_batch_size;
152 include/sync_with_master_gtid.inc
153 include/rpl_end.inc