rpl000011.test
上传用户:tsgydb
上传日期:2007-04-14
资源大小:10674k
文件大小:0k
- source include/master-slave.inc;
- connection master;
- use test;
- drop table if exists t1;
- create table t1 (n int);
- insert into t1 values(1);
- save_master_pos;
- connection slave;
- sync_with_master;
- slave stop;
- slave start;
- connection master;
- insert into t1 values(2);
- save_master_pos;
- connection slave;
- #let slave catch up
- sync_with_master;
- @r/rpl000011.result select * from t1;
- connection master;
- drop table t1;
- save_master_pos;
- connection slave;
- sync_with_master;