Debian Codegraph @

mysql-test/suite/ndb_rpl/t/ndb_rpl_init_rep_status.test

raw
1 --source include/have_ndb.inc
2 --source include/have_binlog_format_mixed_or_row.inc
3 --source suite/ndb_rpl/ndb_master-slave.inc
4
5 # Test Slave initialisation of Ndb_slave_max_replicated_epoch status var
6
7 --connection slave
8 reset master;
9 stop slave;
10
11 --connection master
12 --echo Generate something in the Masters Binlog
13 use test;
14 create table t1 (a int primary key, b int) engine=ndb;
15
16 insert into t1 values (1,1);
17
18 --connection slave
19 --echo Initial state
20 select * from mysql.ndb_apply_status;
21 --source suite/ndb_rpl/t/show_slave_max_replicated_epoch.inc
22
23 set @slave_server_id:= @@server_id;
24 select @slave_server_id;
25 --echo Default, no data, max replicated epoch will be 0.
26 reset slave;
27 start slave;
28 --connection master
29 --sync_slave_with_master
30 --connection slave
31 select server_id from mysql.ndb_apply_status order by server_id;
32 --source suite/ndb_rpl/t/show_slave_max_replicated_epoch.inc
33
34 --echo Default, load of own serverid from ndb_apply_status, should be 111
35 drop table test.t1;
36 stop slave;
37 reset slave;
38 insert into mysql.ndb_apply_status values (@slave_server_id, 111, 'Fictional log', 222, 333);
39 start slave;
40 --connection master
41 --sync_slave_with_master
42 --connection slave
43 select server_id from mysql.ndb_apply_status order by server_id;
44 --source suite/ndb_rpl/t/show_slave_max_replicated_epoch.inc
45
46 drop table test.t1;
47
48 --echo Check that reset slave resets Ndb_slave_max_replicated_epoch to zero
49 stop slave;
50 --source suite/ndb_rpl/t/show_slave_max_replicated_epoch.inc
51 reset slave;
52 --source suite/ndb_rpl/t/show_slave_max_replicated_epoch.inc
53
54 --echo Multiple-channel, load highest of configured serverids, should be 222
55 set @other_local_server_id=@slave_server_id+1;
56 set @other_remote_server_id=@slave_server_id+2;
57 insert into mysql.ndb_apply_status values (@slave_server_id, 111, 'Fictional log', 222, 333);
58 insert into mysql.ndb_apply_status values (@other_local_server_id, 222, 'Fictional log', 222, 333);
59 insert into mysql.ndb_apply_status values (@other_remote_server_id, 444, 'Fictional log', 222, 333);
60
61 let $local_server_ids = `select @other_local_server_id`;
62
63 --eval CHANGE REPLICATION SOURCE TO IGNORE_SERVER_IDS=($local_server_ids);
64 start slave;
65 --connection master
66 --sync_slave_with_master
67 --connection slave
68 select server_id from mysql.ndb_apply_status order by server_id;
69 --source suite/ndb_rpl/t/show_slave_max_replicated_epoch.inc
70
71 # Clean up
72 stop slave;
73 CHANGE REPLICATION SOURCE TO IGNORE_SERVER_IDS= ();
74 start slave;
75 --connection master
76 drop table test.t1;
77 sync_slave_with_master;
78
79 --source include/rpl_end.inc
80