source ../include/master-slave.inc; connection slave; !slave stop; connection master; flush master; connection slave; flush slave; !slave start; sleep 3; connection master; use test; drop table if exists words; create table words (word char(20) not null, index(word)); load data infile '/usr/dict/words' into table words; drop table if exists foo; create table foo(n int); insert into foo values(1),(2); @foo-dump-master.master select * from foo; @sum-wlen-master.master select sum(length(word)) from words; connection slave; sleep 15; use test; @sum-wlen-slave.master select sum(length(word)) from words; @foo-dump-slave.master select * from foo;