--source include/have_ndb.inc --source include/have_binlog_format_mixed_or_row.inc --source suite/ndb_rpl/ndb_master-slave.inc # Test Slave initialisation of Ndb_slave_max_replicated_epoch status var --connection slave reset master; stop slave; --connection master --echo Generate something in the Masters Binlog use test; create table t1 (a int primary key, b int) engine=ndb; insert into t1 values (1,1); --connection slave --echo Initial state select * from mysql.ndb_apply_status; --source suite/ndb_rpl/t/show_slave_max_replicated_epoch.inc set @slave_server_id:= @@server_id; select @slave_server_id; --echo Default, no data, max replicated epoch will be 0. reset slave; start slave; --connection master --sync_slave_with_master --connection slave select server_id from mysql.ndb_apply_status order by server_id; --source suite/ndb_rpl/t/show_slave_max_replicated_epoch.inc --echo Default, load of own serverid from ndb_apply_status, should be 111 drop table test.t1; stop slave; reset slave; insert into mysql.ndb_apply_status values (@slave_server_id, 111, 'Fictional log', 222, 333); start slave; --connection master --sync_slave_with_master --connection slave select server_id from mysql.ndb_apply_status order by server_id; --source suite/ndb_rpl/t/show_slave_max_replicated_epoch.inc drop table test.t1; --echo Check that reset slave resets Ndb_slave_max_replicated_epoch to zero stop slave; --source suite/ndb_rpl/t/show_slave_max_replicated_epoch.inc reset slave; --source suite/ndb_rpl/t/show_slave_max_replicated_epoch.inc --echo Multiple-channel, load highest of configured serverids, should be 222 set @other_local_server_id=@slave_server_id+1; set @other_remote_server_id=@slave_server_id+2; insert into mysql.ndb_apply_status values (@slave_server_id, 111, 'Fictional log', 222, 333); insert into mysql.ndb_apply_status values (@other_local_server_id, 222, 'Fictional log', 222, 333); insert into mysql.ndb_apply_status values (@other_remote_server_id, 444, 'Fictional log', 222, 333); let $local_server_ids = `select @other_local_server_id`; --eval CHANGE REPLICATION SOURCE TO IGNORE_SERVER_IDS=($local_server_ids); start slave; --connection master --sync_slave_with_master --connection slave select server_id from mysql.ndb_apply_status order by server_id; --source suite/ndb_rpl/t/show_slave_max_replicated_epoch.inc # Clean up stop slave; CHANGE REPLICATION SOURCE TO IGNORE_SERVER_IDS= (); start slave; --connection master drop table test.t1; sync_slave_with_master; --source include/rpl_end.inc